← Back to team overview

maria-discuss team mailing list archive

Re: Don't replicate procedures in the mysql database

 

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-variables/#slave_skip_errors )


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


References