rpl000015.test 1.19 KB
Newer Older
unknown's avatar
unknown committed
1
connect (master,localhost,root,,test,$MASTER_MYPORT,$MASTER_MYSOCK);
unknown's avatar
unknown committed
2
connect (slave,localhost,root,,test,$SLAVE_MYPORT,slave.sock);
unknown's avatar
fixed  
unknown committed
3 4 5
connection master;
reset master;
show master status;
6
save_master_pos;
unknown's avatar
fixed  
unknown committed
7 8
connection slave;
reset slave;
9
--replace_result $MASTER_MYPORT MASTER_PORT
10
--replace_column 1 # 8 # 9 # 23 # 33 #
unknown's avatar
fixed  
unknown committed
11
show slave status;
12

unknown's avatar
fixed  
unknown committed
13
change master to master_host='127.0.0.1';
14
# The following needs to be cleaned up when change master is fixed
15
--replace_result $DEFAULT_MASTER_PORT DEFAULT_MASTER_PORT
16
--replace_column 1 # 8 # 9 # 23 # 33 #
unknown's avatar
fixed  
unknown committed
17
show slave status;
18
--replace_result $MASTER_MYPORT MASTER_PORT
unknown's avatar
unknown committed
19 20
eval change master to master_host='127.0.0.1',master_user='root',
 master_password='',master_port=$MASTER_MYPORT;
21
--replace_result $MASTER_MYPORT MASTER_PORT
22
--replace_column 1 # 8 # 9 # 23 # 33 #
unknown's avatar
fixed  
unknown committed
23
show slave status;
24
start slave;
25
sync_with_master;
26
--replace_result $MASTER_MYPORT MASTER_PORT
27
--replace_column 1 # 8 # 9 # 23 # 33 #
unknown's avatar
fixed  
unknown committed
28 29
show slave status;
connection master;
30
--disable_warnings
unknown's avatar
unknown committed
31
drop table if exists t1;
32
--enable_warnings
unknown's avatar
unknown committed
33 34
create table t1 (n int);
insert into t1 values (10),(45),(90);
35
sync_slave_with_master;
unknown's avatar
unknown committed
36
select * from t1;
37
connection master;
unknown's avatar
unknown committed
38
drop table t1;
39
sync_slave_with_master;
40 41

# End of 4.1 tests