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_...@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.i...@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 > >
_______________________________________________ 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
