Re: [Maria-discuss] Semi-sync replication hangs when changing binlog filename.

2016-08-16 Thread Kristian Nielsen
Joseph Glanville writes: > This fixes the problem for me. How do we go about getting this into a release? I can push it. It should go into 10.1, I think (this code is not in 10.0). Thanks for testing! - Kristian. ___ Mailing list: https://launchpad

Re: [Maria-discuss] can we use load data infile from moving a database to a 4 node cluster

2016-08-16 Thread Guillaume Lefranc
unfortunately no, you can't do that. your cluster needs to be empty. Maybe have a look at mydumper/myloader that has parallel dump and restore capabilities? Regards GL On Tue, Aug 16, 2016 at 10:30 AM bbnlaccts acnts wrote: > Thanks for the help Guillaume, > Can we take a snapshot of a standalo

Re: [Maria-discuss] can we use load data infile from moving a database to a 4 node cluster

2016-08-16 Thread Guillaume Lefranc
Hi Arun, Galera requires only InnoDB tables, so the fastest way would be to take an Xtrabackup snapshot of your MariaDB 10 standalone database, restore it on one node of the Galera cluster and then turn on the 3 other nodes. Of course LOAD DATA INFILE is supported by Galera, but it would be slowe

[Maria-discuss] can we use load data infile from moving a database to a 4 node cluster

2016-08-16 Thread bbnlaccts acnts
Hi, I am planning on moving a mariadb 10 database to a 4 node galera cluster. Since the db is kind of big with around 40 gigs capacity and i am getting very less maintenance window to complete this activity. Hence planning on using load data infile on alll the big tables. Can anybody please do let

Re: [Maria-discuss] Regarding Automatic fail-over - Maxscale

2016-08-16 Thread Karthick Subramanian
Sure Guilaume. Thank you for your prompt response. I also thought that I am over doing for this two server topology with binlog router etc. I thought let the maxscale manage the replication portion as well using binlogrouter (in case we extend the topology in future). I will go thru your recommend

[Maria-discuss] replication failing to recover due to HA_ERR_KEY_NOT_FOUND

2016-08-16 Thread bbnlaccts acnts
Hi, I am trying to set up a master slave replication between 2 servers running mariadb 10 on centos 6.7 In the initial setup itself i keep getting HA_ERR_KEY_NOT_FOUND. I have tried all methodology based on my novice knowledge ro rectify but in vain. i am new to this env. Any help will be greatly a

Re: [Maria-discuss] Regarding Automatic fail-over - Maxscale

2016-08-16 Thread Guillaume Lefranc
Hello Karthick, if you have only two servers it does not make sense to use a binlog router for failover. Binlog router has been conceived for the case when you have many slaves connecting to an intermediate master. If you want to manage this with two servers, you would have to configure MaxScale

[Maria-discuss] Regarding Automatic fail-over - Maxscale

2016-08-16 Thread Karthick Subramanian
Hi All, Can anyone help me to figure out this. I am planning to use Binlogrouter for replication (single master and single slave topology). I read from google forums for maxscale that with binlog router, it'snot possible to use automatic failover. Did anyone try this. >From google forum ( https:/