Hello, On Wed, Feb 18, 2015 at 3:40 AM, [email protected] < [email protected]> 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: [email protected] > Data: 17/02/2015 14.22 > A: "[email protected]"<[email protected]> > Cc: "MariaDB discuss"<[email protected]> > Ogg: Re: [Maria-discuss] Switch from rsync to xtrabackup > > Hi! > > On Tue, Feb 17, 2015 at 6:07 AM, [email protected] < > [email protected]> 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 : [email protected] >> Unsubscribe : https://launchpad.net/~maria-discuss >> More help : https://help.launchpad.net/ListHelp >> >> > > > > _______________________________________________ > Mailing list: https://launchpad.net/~maria-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
