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

Reply via email to