5
DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7,t8,t9;
7
DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7,t8,t9;
9
DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7,t8,t9;
11
DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7,t8,t9;
14
CHANGE MASTER TO master_host='127.0.0.1',master_port=MASTER_MYPORT,master_user='root';
17
CHANGE MASTER TO master_host='127.0.0.1',master_port=SLAVE_MYPORT1,master_user='root';
1
include/rpl_init.inc [topology=1->2,4->3]
2
include/rpl_connect.inc [creating master]
3
include/rpl_connect.inc [creating master1]
4
include/rpl_connect.inc [creating slave]
5
include/rpl_connect.inc [creating slave1]
20
7
*** Check server_id of mysqld servers ***
21
8
SHOW VARIABLES LIKE "server_id";
45
32
*** Basic testing ***
46
33
Insert rows via all hosts
47
34
Check data on both clusters
48
Comparing tables master:test.t1 and slave:test.t1
35
include/diff_tables.inc [master:t1, slave:t1]
49
36
*** Transaction testing ***
54
41
Check data on both clusters
55
Comparing tables master:test.t1 and slave:test.t1
42
include/diff_tables.inc [master:t1, slave:t1]
60
47
Check data on both clusters
61
Comparing tables master:test.t1 and slave:test.t1
48
include/diff_tables.inc [master:t1, slave:t1]
63
49
DROP TABLE IF EXISTS t1;