maria-discuss team mailing list archive

["absolutely_free@xxxxxxxxx" <absolutely_free@xxxxxxxxx>]

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? :)

Thank you very much



----Messaggio originale----

Da: nirbhay@xxxxxxxxxxx

Data: 17/02/2015 14.22

A: "absolutely_free@xxxxxxxxx"<absolutely_free@xxxxxxxxx>

Cc: "MariaDB discuss"<maria-discuss@xxxxxxxxxxxxxxxxxxx>

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



Hi!

On Tue, Feb 17, 2015 at 6:07 AM, absolutely_free@xxxxxxxxx <absolutely_free@xxxxxxxxx> wrote:
Hi,
I am using two nodes (Debian 7.8 64bit) with MariaDB (mariadb-galera-server 5.5.41) and garbd on a third node.


Now I'm using rsync method, I would like to switch to xtrabackup to avoid "lock" issue.
Is it possible?

Yes, the lock is taken only for syncing system tables. 
Should I simply install percona package and change this configuration?

Right, the package name is "percona-xtrabackup". 
wsrep_sst_method=rsync

to 

wsrep_sst_method=xtrabackup

?
Or rather go for "xtrabackup-v2".https://mariadb.com/kb/en/mariadb/galera-cluster-system-variables/#wsrep_sst_method


SST methods other than "rsync" also require "wsrep_sst_auth" variables to be set.https://mariadb.com/kb/en/mariadb/galera-cluster-system-variables/#wsrep_sst_auth
Best,Nirbhay Thank you very much




_______________________________________________

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