MySQL Forums
Forum List  »  Replication

Replication of alter via stored procedures
Posted by: Daniel Williams
Date: October 03, 2016 01:20PM

I have a stored procedure that creates an alter statement that adds 3 columns to a table.

In the sproc, the text of the alter statement is added to a variable. Then I run a PREPARE newCmd from @mysql. I then execute the newCmd and DEALLOCATE newCMD.


It works great when I run it on the master server. However, it seems like the alter command never gets to the slave.

Is there something about replication that I'm missing?

Options: ReplyQuote


Subject
Views
Written By
Posted
Replication of alter via stored procedures
915
October 03, 2016 01:20PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.