maria-discuss team mailing list archive

[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