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
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