~ubuntu-branches/ubuntu/maverick/mysql-5.1/maverick-proposed

« back to all changes in this revision

Viewing changes to mysql-test/suite/rpl_ndb/t/rpl_ndb_multi.test

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 14:16:05 UTC
  • mto: This revision was merged to the branch mainline in revision 20.
  • Revision ID: package-import@ubuntu.com-20120222141605-nxlu9yzc6attylc2
Tags: upstream-5.1.61
ImportĀ upstreamĀ versionĀ 5.1.61

Show diffs side-by-side

added added

removed removed

Lines of Context:
1
1
--source include/have_multi_ndb.inc
2
2
--source include/have_binlog_format_mixed_or_row.inc
3
 
--source include/ndb_master-slave.inc
 
3
 
 
4
# We need server 3 later on in this test.
 
5
--let $rpl_server_count= 3
 
6
--source include/master-slave.inc
 
7
 
 
8
--connection master
4
9
 
5
10
# note: server2 is another "master" connected to the master cluster
6
11
 
38
43
let $the_file= `SELECT @the_file` ;
39
44
 
40
45
# now connect the slave to the _other_ "master"
41
 
connection slave;
42
 
--replace_result $MASTER_MYPORT1 <MASTER_PORT1> $the_pos MASTER_LOG_POS $the_file MASTER_LOG_FILE
43
 
eval CHANGE MASTER TO
44
 
  master_port=$MASTER_MYPORT1,
45
 
  master_log_file = '$the_file',
46
 
  master_log_pos = $the_pos ;
47
 
start slave;
 
46
--let $rpl_topology= 3->2
 
47
--let $rpl_master_log_file= 2:$the_file
 
48
--let $rpl_master_log_pos= 2:$the_pos
 
49
--source include/rpl_change_topology.inc
 
50
--connection slave
 
51
--source include/start_slave.inc
48
52
 
49
53
# insert some more values on the first master
50
54
connection master;
61
65
INSERT INTO t1 VALUES ("row5","E",5);
62
66
SELECT * FROM t1 ORDER BY c3;
63
67
sync_slave_with_master;
64
 
connection slave;
65
68
SELECT * FROM t1 ORDER BY c3;
66
69
 
67
70
--echo ==== clean up ====
69
72
DROP TABLE t1;
70
73
sync_slave_with_master;
71
74
 
72
 
STOP SLAVE;
 
75
--source include/rpl_end.inc