[Maria-discuss] R: Re: Switch from rsync to xtrabackup
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@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... 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
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...
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
_______________________________________________ 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