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
Hi
Command for full backup: 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"
xtrabackup --defaults-
For subsequent incremental backup(s): 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"
xtrabackup --defaults-
PREPARE FULL BACKUP ONLY: backup/ xtrabackup/ restore/ mysql0 backup/ xtrabackup/ restore/ mysql0 -iname '*\.qp'`; do qpress -d $bf $(dirname $bf) && rm $bf; done dir=/var/ mysql-backup/ xtrabackup/ restore/ mysql0
cat full.xbstream | xbstream -x -C /var/mysql-
for bf in `find /var/mysql-
xtrabackup --galera-info --prepare --target-
Directory listing: backup/ xtrabackup/ restore/ mysql0 binlog_ info binlog_ pos_innodb checkpoints galera_ info
$ ls -l /var/mysql-
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_
-rw-r--r-- 1 bkp bkp 26 Nov 28 08:18 xtrabackup_
-rw-r----- 1 bkp bkp 123 Nov 28 08:18 xtrabackup_
-rw-r--r-- 1 bkp bkp 45 Nov 28 08:18 xtrabackup_
-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: backup/ xtrabackup/ restore/ mysql0 backup/ xtrabackup/ restore/ mysql0 -iname '*\.qp'`; do qpress -d $bf $(dirname $bf) && rm $bf; done dir=/var/ mysql-backup/ xtrabackup/ restore/ mysql0 backup/ xtrabackup/ restore/ mysql1 backup/ xtrabackup/ restore/ mysql1 -iname '*\.qp'`; do qpress -d $bf $(dirname $bf) && rm $bf; done dir=/var/ mysql-backup/ xtrabackup/ restore/ mysql0 --incremental- dir=/var/ mysql-backup/ xtrabackup/ restore/ mysql1
cat full.xbstream | xbstream -x -C /var/mysql-
for bf in `find /var/mysql-
xtrabackup --galera-info --prepare --apply-log-only --target-
cat inc.xbstream | xbstream -x -C /var/mysql-
for bf in `find /var/mysql-
xtrabackup --galera-info --prepare --target-
Directory listing: backup/ xtrabackup/ restore/ mysql0 binlog_ pos_innodb checkpoints
$ ls -l /var/mysql-
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_
-rw-r----- 1 bkp bkp 123 Nov 28 08:08 xtrabackup_
-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