What are the limitations for replicating stored procedure and functions?

Followings are the limitations for replicating stored procedure and functions −

• Type of Action − Actually the replication of stored procedure and functions depends upon the type of action. If the action, embedded in stored procedures, is nondeterministic (random) or time-based then it may not replicate properly. By their very nature, randomly produced results are not predictable and cannot be exactly reproduced, and therefore, random actions replicated to a slave will not mirror those performed on a master.
• Type of transaction − non-transactional tables for which errors occur during large DML actions (such as bulk inserts) may experience replication issues in that a master may be partially updated from DML activity, but no updates are done to the slave because of the errors that occurred.

Rishi Rathor

Published on 21-Feb-2018 11:03:38

• Related Questions & Answers
• What are the prerequisites for starting writing and using MySQL stored procedure?
• What are the differences between Stored procedures and functions?
• How are actions that take place inside stored procedure and functions replicated?
• What are the special security requirements for using stored procedures and functions together with replication?
• What are the limitations of JavaScript?
• What are the limitations of Selenium?
• What are the advantages and limitations of JDBC PreparedStatement?
• What are MySQL stored functions and how can we create them?
• What is the difference between MySQL stored procedure and function?
• What are the limitations of MySQL ENUMs?
• What are the limitations of Selenium RC?
• What are importance and limitations of financial ratios?
• What are the different modes of parameters used by MySQL stored procedure?
• What is stored procedure and how can we create MySQL stored procedures?
• What are the limitations of using MySQL views?