Hello,

On Wed, Feb 18, 2015 at 3:40 AM, absolutely_free@libero.it <absolutely_free@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) shutdown node 2
5) change config to xtrabackup-v2 on node 2
6) restart node 2

wsrep_sst_method and wsrep_sst_auth are dynamic variables, so you should be able to

change them without restarting the nodes. Subsequently, update the config files to make

these changes permanent.

Also, as the nodes work in tandem, make sure that you have same SST method set for

all the nodes.

..and what about garbd on the third node? :)

Noop

Best,

Nirbhay

Thank you very much
----Messaggio originale----
Da: nirbhay@mariadb.com
Data: 17/02/2015 14.22
A: "absolutely_free@libero.it"<absolutely_free@libero.it>
Cc: "MariaDB discuss"<maria-discuss@lists.launchpad.net>
Ogg: Re: [Maria-discuss] Switch from rsync to xtrabackup
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
_______________________________________________
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