maria-discuss team mailing list archive

[Nirbhay Choubey <nirbhay@xxxxxxxxxxx>]

Hello,

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