Hello, On Wed, Feb 18, 2015 at 3:40 AM, absolutely_f...@libero.it < absolutely_f...@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: nirb...@mariadb.com > Data: 17/02/2015 14.22 > A: "absolutely_f...@libero.it"<absolutely_f...@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_f...@libero.it < > absolutely_f...@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 > >
_______________________________________________ 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
