1
########################################################################
2
# Test remote tablespaces in InnoDB 5.6
3
########################################################################
7
if [ ${MYSQL_VERSION:0:3} != "5.6" ]
9
echo "Requires a 5.6 server" > $SKIPPED_REASON
10
exit $SKIPPED_EXIT_CODE
13
start_server --innodb_file_per_table
15
remote_dir=$TEST_BASEDIR/var1/remote_dir
17
$MYSQL $MYSQL_ARGS test <<EOF
18
CREATE TABLE t(id INT AUTO_INCREMENT PRIMARY KEY, c INT)
19
DATA DIRECTORY = '$remote_dir' ENGINE=InnoDB;
20
INSERT INTO t(c) VALUES (1), (2), (3), (4), (5), (6), (7), (8);
23
# Generate some log data, as we also want to test recovery of remote tablespaces
24
for ((i=0; i<12; i++))
26
$MYSQL $MYSQL_ARGS test <<EOF
27
INSERT INTO t(c) SELECT c FROM t;
31
checksum_a=`checksum_table test t`
33
innobackupex --no-timestamp $topdir/backup
37
rm -rf $mysql_datadir/*
39
innobackupex --apply-log $topdir/backup
40
innobackupex --copy-back $topdir/backup
44
checksum_b=`checksum_table test t`
46
vlog "Old checksum: $checksum_a"
47
vlog "New checksum: $checksum_b"
49
if [ "$checksum_a" != "$checksum_b" ]
51
vlog "Checksums do not match"