wsrep_sst_xtrabackup scripts do not support mysqld_multi

[Eric Webster]

The wsrep_scripts for xtrabackup do not support the use of mysqld_multi. If defaults are called, it's always for the mysqld group, but mysqld_multi can have multiple GNR's on one machine with names like mysqld1, mysqld2, mysqld3, etc. XtraBackup/Innobackupex already have support for this:

    --defaults-group=GROUP-NAME
        This option specifies the group name in my.cnf which should be used.
        This is needed for mysqld_multi deployments.

I suppose this is more of a feature request really, but I didn't know how to properly report it. I apologize if this is the wrong place or method.

[mans39 (hacknowledge39)]

Hello Eric,

I agree with you, I think actually mysqld_multi isn't compatible with xtrabackup because xtrabackup didn't manage mysql group [mysqld1], [mysqld2], etc...in my.cnf.

I made a post on the Google group of Galera (https://groups.google.com/forum/#!topic/codership-team/__O3j3ySyxg) (I have a MariaDB Cluster of 3 nodes), and I would like to use xtrabackup in SST method but it doesn't work...

Bye,

[Eric Webster (sophomeric)]

It's compatible with xtrabackup and Galera, it's just not compatible with the SST scripts (at least the xtrabackup one, I have not tested the others). I posted a response to your post with my working script. When it gets approved and posted, hopefully it can help you out too.

[mans39 (hacknowledge39)]

Thank's Eric for your reply and your solution.

I will try this next day.

Regard's.

[Miguel Angel Nieto (miguelangelnieto)]

Xtrabackup supports mysqld_multi since 2.0.1. Our SST script should be able to read "--defaults-group" and pass that parameter to innobackupex.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXC-1682