Nondeterministic (random) or time-based actions embedded in stored procedures 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. Declaring stored functions to be DETERMINISTIC or setting the log_bin_trust_function_creators system variable to 0 will not allow random-valued operations to be invoked.
Book Description: MySQL Stored Procedure Programming covers a lot of ground. The book starts with a thorough introduction to stored procedures programming and functions, covering the fundamentals of data types, operators, and using SQL in stored procedures. » MySQL Stored Procedure » Stored Procedure Parameters Stored Procedure Parameters In this tutorial, you will learn how to write stored procedures with parameters. Mysql, sql and stored procedures from beginner to advanced free download,mysql, sql and stored procedures from beginner to advanced download,the ultimate mysql bootcamp: go from sql beginner to expert,advanced sql mysql,mysql advanced tutorial pdf,mysql stored procedure tutorial for beginners pdf,advanced mysql courses,learn sql and mysql.
Mysql Stored Proc
In addition, time-based actions cannot be reproduced on a slave because the timing of such actions in a stored procedure is not reproducible through the binary log used for replication. It records only DML events and does not factor in timing constraints.
Stored Procedures In Mysql
Finally, nontransactional 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. A workaround is for a function's DML actions to be carried out with the IGNORE keyword so that updates on the master that cause errors are ignored and updates that do not cause errors are replicated to the slave.