[Maria-discuss] Switch from rsync to xtrabackup
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? Should I simply install percona package and change this configuration? wsrep_sst_method=rsync to wsrep_sst_method=xtrabackup ? Thank you very much
Hi! On Tue, Feb 17, 2015 at 6:07 AM, absolutely_free@libero.it < absolutely_free@libero.it> 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... 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... Best, Nirbhay
Thank you very much
_______________________________________________ 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.net/ListHelp
participants (2)
-
absolutely_free@libero.it
-
Nirbhay Choubey