maria-discuss team mailing list archive
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
and different owner (definer).
As a workaround to not stop/break the replication you could run the slave
slave-skip-errors = 1304
I'm just not sure if it is the right one for duplicate procedure.
Should be according to
Error: 1304 SQLSTATE: 42000 (ER_SP_ALREADY_EXISTS)
Message: %s %s already exists