[Maria-discuss] R: Re: R: Re: Switch from rsync to xtrabackup
Hi Nirbhay, thank you very much for your answer. This cluster is already in production, with few databases (for mail user authentication, radius authentication, and so on). My question is: what would will happen if I change wsrep_sst_method on one node? How the other node can be "synced" if wsrep_sst_method is different (even for a few seconds)? Thank you, regards
Hi, If it takes you a few seconds, that is okay. It is not likely that the cluster will require a SST in that brief period. You can also simply use a parallel SSH tool to execute the following on all nodes at the same time: mysql -uroot -ppassword -e 'set global wsrep_sst_method=xtrabackup' On Wed, Feb 18, 2015 at 8:11 AM, absolutely_free@libero.it < absolutely_free@libero.it> wrote:
Hi Nirbhay, thank you very much for your answer. This cluster is already in production, with few databases (for mail user authentication, radius authentication, and so on). My question is: what would will happen if I change wsrep_sst_method on one node? How the other node can be "synced" if wsrep_sst_method is different (even for a few seconds)?
Thank you, regards
_______________________________________________ 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
-
Justin Swanhart