mariadb/storage/rocksdb/mysql-test/rocksdb_hotbackup/t/gtid.test
Sergei Petrunia ebfc4e6ad0 Initial commit,
copy of
commit 86587affafe77ef555f7c3839839de44f0f203f3
Author: Tian Xia <tianx@fb.com>
Date:   Tue Oct 4 10:01:52 2016 -0700

    Allow filtering of show commands through admission control
2016-10-06 17:24:09 +00:00

47 lines
1.1 KiB
Text

source suite/rocksdb_hotbackup/include/setup.inc;
--let $rpl_server_number= 2
--source include/rpl_stop_server.inc
--exec suite/rocksdb_hotbackup/include/load_data_and_run.sh 2>&1
--let $rpl_server_number= 2
--source include/rpl_start_server.inc
connection server_2;
let $num_rows = `select count(*) from db1.t1`;
let $max_id = `select id from db1.t1 order by id desc limit 1`;
if($num_rows != $max_id) {
echo Number of rows($num_rows) and last_id($max_id) does not match;
}
if($num_rows < 250000) {
echo Number of rows($num_rows) is less than 250000;
}
if($num_rows > 500000) {
echo Number of rows($num_rows) is more than 500000;
}
--source suite/rocksdb_hotbackup/include/setup_replication_gtid_and_sync.inc
connection server_2;
select count(*) from db1.t1;
connection server_1;
let $checksum1 = `checksum tables db1.t1`;
connection server_2;
let $checksum2 = `checksum tables db1.t1`;
if($checksum1 != $checksum2) {
echo Checksums ($checksum1 and $checksum2) do not match;
}
connection server_1;
drop database db1;
sync_slave_with_master;
connection server_2;
stop slave;
reset slave;
source suite/rocksdb_hotbackup/include/cleanup.inc;