Re: [Maria-discuss] R: Re: R: Re: R: Re: Switch from rsync to xtrabackup

2015-02-18 Thread Tom Worster
it would be nice to have this info summarized in a KB article From: "absolutely_f...@libero.it" Reply-To: "absolutely_f...@libero.it" Date: Wednesday, February 18, 2015 at 12:27 PM To: Cc: maria-discuss email list Subject: [Maria-discuss] R: Re: R: Re: R: Re: Switch from rsync to xtrabac

Re: [Maria-discuss] MariaDB 10.0.16 now available

2015-02-18 Thread Nirbhay Choubey
Hi Raina, On Tue, Feb 17, 2015 at 1:04 PM, Raina Masand wrote: > Hi Nirbhay, > > Now that Galera 25.3.9 is available, we have tried swapping it in with our > MariaDB 10.0.16 cluster. Seems to work so far, but wondering whether there > are plans to vet this Galera release as the officially recomm

[Maria-discuss] R: Re: R: Re: R: Re: Switch from rsync to xtrabackup

2015-02-18 Thread absolutely_f...@libero.it
Ok, thank you all, switch to xtrabackup-v2 accomplished :) ___ 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.

Re: [Maria-discuss] R: Re: R: Re: Switch from rsync to xtrabackup

2015-02-18 Thread Justin Swanhart
Hi, If it takes you a few seconds, that is okay. It is not likely that the cluster will require a SST in that brief period. You can also simply use a parallel SSH tool to execute the following on all nodes at the same time: mysql -uroot -ppassword -e 'set global wsrep_sst_method=xtrabackup' On

[Maria-discuss] R: Re: R: Re: Switch from rsync to xtrabackup

2015-02-18 Thread absolutely_f...@libero.it
Hi Nirbhay, thank you very much for your answer. This cluster is already in production, with few databases (for mail user authentication, radius authentication, and so on). My question is: what would will happen if I change wsrep_sst_method on one node? How the other node can be "synced" if wsre

Re: [Maria-discuss] R: Re: Switch from rsync to xtrabackup

2015-02-18 Thread Nirbhay Choubey
Hello, On Wed, Feb 18, 2015 at 3:40 AM, absolutely_f...@libero.it < absolutely_f...@libero.it> wrote: > > Hi, > thank you for your reply. > What is the correct order for this step? > For example: > > 1) shutdown node 1 > 2) change config to xtrabackup-v2 on node 1 > 3) restart node 1? > 4) shutd

[Maria-discuss] Network tuning

2015-02-18 Thread absolutely_f...@libero.it
Hi all, according to this URL: http://www.fromdual.com/huge-amount-of-time-wait-connections is it recommended to change default behavior of tcp_tw_reuse and tcp_tw_recycle? I am using two MariaDB nodes with haproxy, keepalived and garbd on third node. Thank you very much ___

[Maria-discuss] R: Re: Switch from rsync to xtrabackup

2015-02-18 Thread absolutely_f...@libero.it
Hi, thank you for your reply. What is the correct order for this step? For example: 1) shutdown node 1 2) change config to xtrabackup-v2 on node 1 3) restart node 1? 4) shutdown node 2 5) change config to xtrabackup-v2 on node 2 6) restart node 2 ..and what about garbd on the third node? :) T