There is no side effects to me :-) I want the mysql database ignored totally. Replicating views may be a problem (missing definer), but views are the problem on its own. Here is how mysql evaluates different options http://dev.mysql.com/doc/refman/5.7/en/replication-rules.html 01 сент. 2016 г. 1:27 пользователь "Federico Razzoli" <federico_raz@yahoo.it> написал:
I never used replicate_ignore_db='mysql'. But I know some people does. Did you check if it has side effects?
Federico
-------------------------------------------- Mer 31/8/16, Игорь Пашев <pashev.igor@gmail.com> ha scritto:
Oggetto: Re: [Maria-discuss] Don't replicate procedures in the mysql database A: "MariaDB discuss" <maria-discuss@lists.launchpad.net> Data: Mercoledì 31 agosto 2016, 23:39
Thanks to everyone
Here is the solution:
On the slave:
Replicate_Ignore_DB: mysql
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table: foo.%
Replicate_Wild_Ignore_Table:
On the master:
USE mysql; CREATE PROCEDURE whatever() BEGIN END;
_______________________________________________ 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