You should keep those procedures in a different database, not mysql. Then you can avoid replication with replication filters: https://mariadb.com/kb/en/mariadb/selectively-skipping-replication-of-binlog-events/
But first, be sure you understand what happens when you call the procedure on the master. Federico -------------------------------------------- Lun 29/8/16, Игорь Пашев <pashev.i...@gmail.com> ha scritto: Oggetto: Re: [Maria-discuss] Don't replicate procedures in the mysql database A: "Daniel Black" <daniel.bl...@au1.ibm.com> Cc: "MariaDB discuss" <maria-discuss@lists.launchpad.net> Data: Lunedì 29 agosto 2016, 15:44 2016-08-29 1:25 GMT+03:00 Daniel Black <daniel.bl...@au1.ibm.com>: > 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). > If the slave is a failover it should have the procedure. If I wanted a failover server I would not be fiddling with replication options and channels at all. >> When I execute `CREATE PROCEDURE mysql.bar` on the master, this >> procedure appears on the slave. > > Which is what replication is meant to do. This is not consistent with creating and modifying mysql users. That's why I'm asking. > Its probably also best not to populate the mysql database with your > stored procedures. It's totally fine for maintenance procedures. See for example http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.MySQL.SQLRef.html > set session sql_log_bin=0; create procedure... This is not scalable and sometime impossible: for the SUPER privilege, at Amazon RDS, it could break other slaves. _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
