Comment 2 for bug 1643803

Revision history for this message
Grigorijs (grigk) wrote :

Hi

Command for full backup:
xtrabackup --defaults-file=/usr/local/etc/bkp/.my.cnf --backup --extra-lsndir=/var/mysql-backup/lsn --target-dir=/var/mysql-backup --compress --stream=xbstream | ssh bkp@backuphost "cat - > /var/mysql-backup/xtrabackup/full.xbstream"

For subsequent incremental backup(s):
xtrabackup --defaults-file=/usr/local/etc/bkp/.my.cnf --backup --extra-lsndir=/var/mysql-backup/lsn --target-dir=/var/mysql-backup --incremental-basedir=/var/mysql-backup/lsn --compress --stream=xbstream | ssh bkp@backuphost "cat - > /var/mysql-backup/xtrabackup/inc.xbstream"

PREPARE FULL BACKUP ONLY:
cat full.xbstream | xbstream -x -C /var/mysql-backup/xtrabackup/restore/mysql0
for bf in `find /var/mysql-backup/xtrabackup/restore/mysql0 -iname '*\.qp'`; do qpress -d $bf $(dirname $bf) && rm $bf; done
xtrabackup --galera-info --prepare --target-dir=/var/mysql-backup/xtrabackup/restore/mysql0

Directory listing:
$ ls -l /var/mysql-backup/xtrabackup/restore/mysql0
total 1476028
-rw-r--r-- 1 bkp bkp 426 Nov 28 08:16 backup-my.cnf
-rw-r--r-- 1 bkp bkp 1415398 Nov 28 08:16 ib_buffer_pool
-rw-r--r-- 1 bkp bkp 415236096 Nov 28 08:18 ibdata1
-rw-r----- 1 bkp bkp 536870912 Nov 28 08:18 ib_logfile0
-rw-r----- 1 bkp bkp 536870912 Nov 28 08:18 ib_logfile1
-rw-r----- 1 bkp bkp 12582912 Nov 28 08:18 ibtmp1
drwxr-x--- 2 bkp bkp 4096 Nov 28 08:16 mysql
drwxr-x--- 2 bkp bkp 12288 Nov 28 08:16 performance_schema
drwxr-x--- 2 bkp bkp 4096 Nov 28 08:16 sbtest
drwxr-x--- 2 bkp bkp 16384 Nov 28 08:18 straume
drwxr-x--- 2 bkp bkp 12288 Nov 28 08:16 sys
drwxr-x--- 2 bkp bkp 4096 Nov 28 08:16 test
-rw-r--r-- 1 bkp bkp 26 Nov 28 08:18 xtrabackup_binlog_info
-rw-r--r-- 1 bkp bkp 26 Nov 28 08:18 xtrabackup_binlog_pos_innodb
-rw-r----- 1 bkp bkp 123 Nov 28 08:18 xtrabackup_checkpoints
-rw-r--r-- 1 bkp bkp 45 Nov 28 08:18 xtrabackup_galera_info
-rw-r--r-- 1 bkp bkp 555 Nov 28 08:16 xtrabackup_info
-rw-r--r-- 1 bkp bkp 8388608 Nov 28 08:18 xtrabackup_logfile

PREPARE FULL + INCREMENTAL BACKUP:
cat full.xbstream | xbstream -x -C /var/mysql-backup/xtrabackup/restore/mysql0
for bf in `find /var/mysql-backup/xtrabackup/restore/mysql0 -iname '*\.qp'`; do qpress -d $bf $(dirname $bf) && rm $bf; done
xtrabackup --galera-info --prepare --apply-log-only --target-dir=/var/mysql-backup/xtrabackup/restore/mysql0
cat inc.xbstream | xbstream -x -C /var/mysql-backup/xtrabackup/restore/mysql1
for bf in `find /var/mysql-backup/xtrabackup/restore/mysql1 -iname '*\.qp'`; do qpress -d $bf $(dirname $bf) && rm $bf; done
xtrabackup --galera-info --prepare --target-dir=/var/mysql-backup/xtrabackup/restore/mysql0 --incremental-dir=/var/mysql-backup/xtrabackup/restore/mysql1

Directory listing:
$ ls -l /var/mysql-backup/xtrabackup/restore/mysql0
total 427436
-rw-r--r-- 1 bkp bkp 426 Nov 28 08:07 backup-my.cnf
-rw-r--r-- 1 bkp bkp 1415398 Nov 28 08:07 ib_buffer_pool
-rw-r--r-- 1 bkp bkp 415236096 Nov 28 08:08 ibdata1
-rw-r----- 1 bkp bkp 12582912 Nov 28 08:08 ibtmp1
drwxr-x--- 2 bkp bkp 4096 Nov 28 08:08 mysql
drwxr-x--- 2 bkp bkp 12288 Nov 28 08:08 performance_schema
drwxr-x--- 2 bkp bkp 4096 Nov 28 08:08 sbtest
drwxr-x--- 2 bkp bkp 16384 Nov 28 08:08 straume
drwxr-x--- 2 bkp bkp 12288 Nov 28 08:08 sys
drwxr-x--- 2 bkp bkp 4096 Nov 28 08:08 test
-rw-r--r-- 1 bkp bkp 26 Nov 28 08:08 xtrabackup_binlog_pos_innodb
-rw-r----- 1 bkp bkp 123 Nov 28 08:08 xtrabackup_checkpoints
-rw-r----- 1 bkp bkp 610 Nov 28 08:08 xtrabackup_info
-rw-r--r-- 1 bkp bkp 8388608 Nov 28 08:08 xtrabackup_logfile

Please note xtrabackup_binlog_info and xtrabackup_galera_info present after preparing full backup, but missing after preparing full+incremental