maria-discuss team mailing list archive

[Игорь Пашев <pashev.igor@xxxxxxxxx>]

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@xxxxxxxx>
написал:

> 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@xxxxxxxxx> ha scritto:
>
>  Oggetto: Re: [Maria-discuss] Don't replicate procedures in the mysql
> database
>  A: "MariaDB discuss" <maria-discuss@xxxxxxxxxxxxxxxxxxx>
>  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@xxxxxxxxxxxxxxxxxxx
>  Unsubscribe : https://launchpad.net/~maria-discuss
>  More help   : https://help.launchpad.net/ListHelp
>
>