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_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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp