Songe Songe - 1 month ago 18
MySQL Question

MySQL replication, ignore stored procedure

For tables we have:
--replicate-ignore-table=db_name.tbl_name
Is there something similar for stored procedures?

Answer

No, there is no such feature.

As a workaround you could revoke the CREATE ROUTINE privilege for replication user and set slave_skip_errors to ON (which I wouldn't recommend).