MySQL Forums
Forum List  »  Replication

New stored procedure comments lost on replica.
Posted by: John Murtari
Date: July 14, 2022 07:15AM

Folks,

We just started using replication for a large project. MySQL 8.0, all tables are Innodb and ROW based replication.

Been running about a week, very happy to see both structure and data in perfect sync between the source and replica -- however --

A developer made some updates to a stored procedure(SP) on the source. The executable source of the SP was communicated to the replica, but any new comment fields were lost.

To clarify, when we did the original mysqldumps to bring the replica in sync, all comments were on the replica. New comments are not stored.

Did a search on Google/these forums -- didn't see an reports. I hope there is any easy solution.

Thanks!
John

Options: ReplyQuote


Subject
Views
Written By
Posted
New stored procedure comments lost on replica.
125
July 14, 2022 07:15AM


Sorry, only registered users may post in this forum.

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.