How are actions that take place inside stored procedure and functions replicated?

Actually standard actions carried out in stored procedures and functions are replicated from a master MySQL server to a slave MySQL server. Even the creation of stored procedures and functions carried out through normal DDL statements on a master MySQL server are replicated to a slave MySQL server. In this way, objects will exist on both the servers.

The actions that take place inside the stored procedure and functions are replicated because MySQL records each DDL event that occurs inside stored procedures and functions. After recording the events it is replicated to the slave MySQL server. But the actual calls made to execute stored procedures are not replicated. Following is an example in which the procedure CALL will not replicate because it is actually one on the master MySQL server.

Example

mysql> Delimiter //
mysql> CREATE PROCEDURE myproc()
    -> BEGIN
    -> DELETE FROM mytable LIMIT 1;
    -> END //

Now when we call this procedure on master MySQL server then it will not replicate.

mysql> Delimiter ;
mysql> CALL myproc();

Nancy Den

Published on 21-Feb-2018 11:02:42

• Related Questions & Answers
• What are the limitations for replicating stored procedure and functions?
• How can a MySQL stored procedure call another MySQL stored procedure inside it?
• Calling Stored Procedure inside foreach PHP Codeigniter
• How can we perform START transactions inside MySQL stored procedure?
• How can we perform COMMIT transactions inside MySQL stored procedure?
• Implement Dynamic SQL query inside a MySQL stored procedure?
• How can we perform ROLLBACK transactions inside a MySQL stored procedure?
• How can we handle a result set inside MySQL stored procedure?
• Create a table inside a MySQL stored procedure and insert a record on calling the procedure
• What are the differences between Stored procedures and functions?
• What are MySQL stored functions and how can we create them?
• What is stored procedure and how can we create MySQL stored procedures?
• How did the formation of oceans take place?
• What do you mean by Scope of variables inside MySQL stored procedure?
• Create a MySQL stored procedure that generates five random numbers?