Re: [Maria-discuss] Don't replicate procedures in the mysql database
![](https://secure.gravatar.com/avatar/06fb7e7f8217ef0e572a8334567b7559.jpg?s=120&d=mm&r=g)
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, Игорь Пашев
![](https://secure.gravatar.com/avatar/e50b3710f2e08f7cc154443c1d1ae979.jpg?s=120&d=mm&r=g)
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"
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, Игорь Пашев
ha scritto: Oggetto: Re: [Maria-discuss] Don't replicate procedures in the mysql database A: "MariaDB discuss"
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
participants (2)
-
Federico Razzoli
-
Игорь Пашев