Re: [Maria-discuss] Don't replicate procedures in the mysql database

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