maria-discuss team mailing list archive

[Nirbhay Choubey <nirbhay@xxxxxxxxxxx>]

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
>
>