29 Aug
2016
29 Aug
'16
4:45 p.m.
A question for you is why is it important not to have it on the slave?
Because the slave already has this procedure with a slightly different implementation, and different owner (definer).
As a workaround to not stop/break the replication you could run the slave with slave-skip-errors = 1304 ( https://mariadb.com/kb/en/mariadb/replication-and-binary-log-server-system-v... ) I'm just not sure if it is the right one for duplicate procedure. Should be according to https://dev.mysql.com/doc/refman/5.6/en/error-messages-server.html Error: 1304 SQLSTATE: 42000 (ER_SP_ALREADY_EXISTS) Message: %s %s already exists rr