1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
|
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;
|
