[Maria-discuss] Replication variables in my.cnf seem ignored if master connection does not exist

2015-12-14 Thread Игорь Пашев
MariaDB 10.0.22 I saw weird things a couple of times: I start clean MariaDB with theses options in the configuration file: foo.replicate_wild_do_table = foo_live.% foo.replicate_ignore_table = foo_live.schema_updates Then I execute RESET SLAVE "foo" ALL just to be sure there is no such

Re: [Maria-discuss] MariaDB Performance and Diagnostic Tools

2015-12-14 Thread Игорь Пашев
2015-12-14 22:29 GMT+03:00 FERRETTI, ANDY : > I’m looking for recommendations on MariaDB Performance Analysis tools. Something like that: Percona Toolkit and Newrelic ___ Mailing list: https://launchpad.net/~maria-discuss Post to :

Re: [Maria-discuss] Replication variables in my.cnf seem ignored if master connection does not exist

2015-12-16 Thread Игорь Пашев
; -- import dump with --master-data=1 -- start slave; 2015-12-14 15:59 GMT+03:00 Игорь Пашев <pashev.i...@gmail.com>: > MariaDB 10.0.22 > > I saw weird things a couple of times: > > I start clean MariaDB with theses options in the configuration file: > foo.replicate_w

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;

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

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

[Maria-discuss] Query the list of dynamic variables

2016-08-18 Thread Игорь Пашев
If there are way to query the list of dynamic variables, e. i. variables that can be changed globally without restarting the server? ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe :

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

2016-08-28 Thread Игорь Пашев
Hi all, I'm using multi-source replication with "white list" options only: foo.replicate_wild_do_table = foo.% foo.replicate_ignore_table = foo.beep foo.replicate_ignore_table = foo.tmp The masters are writing row-based binary logs as is (no filtering at masters). This works almost as

Re: [Maria-discuss] Minor version upgrades across a cluster

2016-10-27 Thread Игорь Пашев
2016-10-26 16:58 GMT+03:00 Craig Bailey : > We have a three node MariaDB Galera cluster on version 10.1.14 an we would > like to upgrade to 10.1.18. Our approach to this was to offline a node > upgrade it and then add it back to the cluster and allow it to do an IST to > catch

Re: [Maria-discuss] on stored procedures

2016-11-08 Thread Игорь Пашев
2016-11-07 18:43 GMT+03:00 Sergei Golubchik : > Hi, Federico! > > On Nov 07, Federico Razzoli wrote: >> Some good points from Bill Karwin: >> https://www.quora.com/What-are-the-reasons-not-to-use-or-not-use-stored-procedures/answer/Bill-Karwin > > Thanks. > > These are valid

Re: [Maria-discuss] Cross compile error

2017-05-16 Thread Игорь Пашев
I found this: https://forum.lede-project.org/t/solved-mariadb-mysql-update/2337 Marked as solved :) 2017-03-25 18:52 GMT+03:00 Lucian Cristian : > Hi > > I'm trying to cross compile (any 10.* versions) using musl and uClibc++ for > a LEDE/Openwrt system and I have problems with

Re: [Maria-discuss] MySQL Workbench Fork?

2017-05-07 Thread Игорь Пашев
2017-05-04 10:04 GMT+03:00 Bruce Carlson : > In the 21st century It's all about automation, reproducibility, declarative deployment and neural networks (of course!) :) ___ Mailing list: https://launchpad.net/~maria-discuss