← Back to team overview

maria-discuss team mailing list archive

R: Re: Switch from rsync to xtrabackup


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


On Tue, Feb 17, 2015 at 6:07 AM, absolutely_free@xxxxxxxxx <absolutely_free@xxxxxxxxx> wrote:
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". 



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

Follow ups