← Back to team overview

maria-developers team mailing list archive

Re: Testing group commit with XtraBackup


The test is basically the same you already did for non-blocking `mysqldump
--master-data --single-transaction` used to provision a slave, but using
XtraBackup instead of mysqldump.

So the test would be similar to your existing mysqldump test. But while the
master is running, we would use non-blocking XtraBackup to take a
snapshot. This snapshot we would then restore onto a new slave. The slave
would then be configured with CHANGE MASTER TO, I believe one gets the correct binlog position to start from in the log file of XtraDB and/or slave mysqld (I need to check up on details). Then the test proceeds as the mysqldump case,
letting the slave catch up and checking that replication is ok etc.

Done, a test was created and installed in buildbot, where it passes. I am using xtradb from RPM.

Now, to do this we would need to be able to use XtraBackup. I am wondering if it wouldn't make sense to at the same time include XtraBackup into MariaDB?
XtraBackup seems to me quite mature already, and a very good product
besides. It is arguably long overdue for us to include it.

So if we include XtraBackup in mariadb-5.2-rpl (/5.3), I think this should be
possible to setup without too much trouble (I can provide specific
details/scripts for how to actually run XtraBackup and setup slave start
position, I just need to research that a bit).

Including XtraBackup means including in MariaDB a yet another piece of software that, even if it is of reasonable quality, has a different development and release cycle:

- we have 3 different innnodb directories, innodb, innodb_plugin and xtradb
- they have 3 different xtrabackup binaries, one for 5.0, one for 5.1 and one for 5.5 - they provide 5 patches to patch Innodb with. As discussed in IRC, I tried the most intuitive combination and it did not patch correctly. I did not try your renaming trick; - in launchpad, they have a bunch of trees: a trunk tree , a 1.6 tree and a windows tree, both of which have seen pushes in the last 1 week

Philip Stoev

Follow ups