9
8
# cluster A cluster B
11
10
# master1 <--- slave1
12
#############################################################
14
# [--let $rpl_server_count= N]
15
# [--let $rpl_skip_check_server_ids= 1]
16
# [--let $rpl_skip_reset_master_and_slave= 1]
17
# [--let $rpl_skip_change_master= 1]
18
# [--let $rpl_skip_start_slave= 1]
19
# [--let $rpl_debug= 1]
20
# [--let $slave_timeout= NUMBER]
21
# --source include/ndb_master-slave_2ch.inc
24
# $rpl_server_count, $rpl_skip_check_server_ids,
25
# $rpl_skip_reset_master_and_slave, $rpl_skip_change_master,
26
# $rpl_skip_start_slave, $rpl_debug, $slave_timeout
27
# See include/master-slave.inc
14
--source include/have_log_bin.inc
29
--let $rpl_topology= 1->2,4->3
30
--let $rpl_skip_check_server_ids= 1
31
--source include/rpl_init.inc
16
33
# Make connections to mysqlds
18
connect (master,127.0.0.1,root,,test,$MASTER_MYPORT,);
19
connect (master1,127.0.0.1,root,,test,$MASTER_MYPORT1,);
20
connect (slave,127.0.0.1,root,,test,$SLAVE_MYPORT,);
21
connect (slave1,127.0.0.1,root,,test,$SLAVE_MYPORT1,);
23
# Check that all mysqld compiled with ndb support
27
--require r/true.require
28
SELECT (support = 'YES' or support = 'DEFAULT') AS `TRUE` FROM information_schema.engines WHERE engine = 'ndbcluster';
29
--source include/ndb_not_readonly.inc
34
--require r/true.require
35
SELECT (support = 'YES' or support = 'DEFAULT') AS `TRUE` FROM information_schema.engines WHERE engine = 'ndbcluster';
36
--source include/ndb_not_readonly.inc
41
--require r/true.require
42
SELECT (support = 'YES' or support = 'DEFAULT') AS `TRUE` FROM information_schema.engines WHERE engine = 'ndbcluster';
43
--source include/ndb_not_readonly.inc
48
--require r/true.require
49
SELECT (support = 'YES' or support = 'DEFAULT') AS `TRUE` FROM information_schema.engines WHERE engine = 'ndbcluster';
50
--source include/ndb_not_readonly.inc
58
--wait_for_slave_to_stop
64
--wait_for_slave_to_stop
70
--wait_for_slave_to_stop
76
--wait_for_slave_to_stop
86
DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7,t8,t9;
95
DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7,t8,t9;
104
DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7,t8,t9;
113
DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7,t8,t9;
121
--replace_result $MASTER_MYPORT MASTER_MYPORT
122
--eval CHANGE MASTER TO master_host='127.0.0.1',master_port=$MASTER_MYPORT,master_user='root'
124
--source include/wait_for_slave_to_start.inc
128
--replace_result $SLAVE_MYPORT1 SLAVE_MYPORT1
129
--eval CHANGE MASTER TO master_host='127.0.0.1',master_port=$SLAVE_MYPORT1,master_user='root'
131
--source include/wait_for_slave_to_start.inc
35
--let $rpl_connection_name= master
36
--let $rpl_server_number= 1
37
--source include/rpl_connect.inc
39
--let $rpl_connection_name= master1
40
--let $rpl_server_number= 1
41
--source include/rpl_connect.inc
43
--let $rpl_connection_name= slave
44
--let $rpl_server_number= 2
45
--source include/rpl_connect.inc
47
--let $rpl_connection_name= slave1
48
--let $rpl_server_number= 2
49
--source include/rpl_connect.inc
52
# Check that all mysqld are compiled with ndb support
56
--connection server_$_rpl_server
57
if (`SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.ENGINES WHERE engine = 'ndbcluster' AND (support = 'YES' OR support = 'DEFAULT')`)
59
--skip Test requires NDB.
61
--source include/ndb_not_readonly.inc
134
66
# Set the default connection to 'master' (cluster A)
135
67
connection master;