Can not reproduce with XB 2.3.3 using PS 5.6.28 for compressed tables:
mysql> show create table sbtest1\G *************************** 1. row *************************** Table: sbtest1 Create Table: CREATE TABLE `sbtest1` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `k` int(10) unsigned NOT NULL DEFAULT '0', `c` char(120) NOT NULL DEFAULT '', `pad` char(60) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `k_1` (`k`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 1 row in set (0.00 sec)
Take Full backup:
xtrabackup --defaults-file=/etc/mysql/my.cnf --backup --datadir=/var/lib/mysql/ --target-dir=/home/backup_dir/full/ --user=root --password=12345 --no-version-check
Drop table and recreate:
mysql> show create table sbtest1\G *************************** 1. row *************************** Table: sbtest1 Create Table: CREATE TABLE `sbtest1` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `k` int(10) unsigned NOT NULL DEFAULT '0', `c` char(120) NOT NULL DEFAULT '', `pad` char(60) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `k_1` (`k`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8 1 row in set (0.00 sec)
Take incremental one:
xtrabackup --defaults-file=/etc/my.cnf --backup --target-dir=/home/backup_dir/inc/inc1 --incremental-basedir=/home/backup_dir/full --datadir=/var/lib/mysql/ --user=root --password=12345 --no-version-check
Prepare:
xtrabackup --defaults-file=/home/backup_dir/full/backup-my.cnf --prepare --apply-log-only --target-dir=/home/backup_dir/full xtrabackup --defaults-file=/home/backup_dir/full/backup-my.cnf --prepare --target-dir=/home/backup_dir/full --incremental-dir=/home/backup_dir/inc/inc1 InnoDB: Starting shutdown... InnoDB: Shutdown completed; log sequence number 4295276054 160126 17:53:58 completed OK!
Can not reproduce with XB 2.3.3 using PS 5.6.28 for compressed tables:
mysql> show create table sbtest1\G ******* ******* ****** 1. row ******* ******* ******* ******
*******
Table: sbtest1
Create Table: CREATE TABLE `sbtest1` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`k` int(10) unsigned NOT NULL DEFAULT '0',
`c` char(120) NOT NULL DEFAULT '',
`pad` char(60) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `k_1` (`k`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
1 row in set (0.00 sec)
Take Full backup:
xtrabackup --defaults- file=/etc/ mysql/my. cnf --backup --datadir= /var/lib/ mysql/ --target- dir=/home/ backup_ dir/full/ --user=root --password=12345 --no-version-check
Drop table and recreate:
mysql> show create table sbtest1\G ******* ******* ****** 1. row ******* ******* ******* ****** COMPRESSED KEY_BLOCK_SIZE=8
*******
Table: sbtest1
Create Table: CREATE TABLE `sbtest1` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`k` int(10) unsigned NOT NULL DEFAULT '0',
`c` char(120) NOT NULL DEFAULT '',
`pad` char(60) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `k_1` (`k`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=
1 row in set (0.00 sec)
Take incremental one:
xtrabackup --defaults- file=/etc/ my.cnf --backup --target- dir=/home/ backup_ dir/inc/ inc1 --incremental- basedir= /home/backup_ dir/full --datadir= /var/lib/ mysql/ --user=root --password=12345 --no-version-check
Prepare:
xtrabackup --defaults- file=/home/ backup_ dir/full/ backup- my.cnf --prepare --apply-log-only --target- dir=/home/ backup_ dir/full file=/home/ backup_ dir/full/ backup- my.cnf --prepare --target- dir=/home/ backup_ dir/full --incremental- dir=/home/ backup_ dir/inc/ inc1
xtrabackup --defaults-
InnoDB: Starting shutdown...
InnoDB: Shutdown completed; log sequence number 4295276054
160126 17:53:58 completed OK!