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

2016-08-31 Thread Игорь Пашев
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

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

2016-08-31 Thread 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 d

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

2016-08-31 Thread Игорь Пашев
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; _

[Maria-discuss] InnoDB plugin maturity

2016-08-31 Thread Ian Gilfillan
If you look at the list of plugin maturities, say with: SELECT plugin_name,plugin_version,plugin_maturity FROM information_schema.plugins ORDER BY plugin_name; I notice that in 10.1, InnoDB/XtraDB is listed as Gamma (changed from Beta in 10.1.13), while in 10.0, with the same version of XtraD

[Maria-discuss] New Question: MONyog Cluster Monitoring

2016-08-31 Thread AskMonty KB
Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/monyog-cluster-monitoring/ as the person asking the question may not be subscribed to the mailing list. Is it possible to see all th