The following are the limitations of copying stored procedures and functions -
- Operation type− In fact, stored procedures and functions The copying depends on the type of operation. If the operations embedded in the stored procedure are nondeterministic (random) or time-based, then it may not replicate correctly. By their very nature, randomly generated results are unpredictable and cannot be reproduced accurately, so random operations copied to a slave device will not reflect operations performed on the master device.
- Type Transaction- Non-transactional tables where errors occur during large DML operations (such as bulk inserts) may experience replication issues because the master may update from the active part of the DML but No updates will be made to the slave server because of the error that occurred.
The above is the detailed content of What are the limitations on copying stored procedures and functions?. For more information, please follow other related articles on the PHP Chinese website!
