rpl000015.result 1.25 KB
Newer Older
unknown's avatar
unknown committed
1 2
reset master;
show master status;
3
File	Position	Binlog_do_db	Binlog_ignore_db
4
master-bin.001	79		
unknown's avatar
unknown committed
5 6
reset slave;
show slave status;
7 8
Master_Host	Master_User	Master_Port	Connect_retry	Log_File	Pos	Slave_Running	Replicate_do_db	Replicate_ignore_db	Last_errno	Last_error	Skip_counter	Last_log_seq
		0	0		0	No			0		0	0
unknown's avatar
unknown committed
9 10
change master to master_host='127.0.0.1';
show slave status;
11 12
Master_Host	Master_User	Master_Port	Connect_retry	Log_File	Pos	Slave_Running	Replicate_do_db	Replicate_ignore_db	Last_errno	Last_error	Skip_counter	Last_log_seq
127.0.0.1	test	9998	60		4	No			0		0	0
unknown's avatar
unknown committed
13
 change master to master_host='127.0.0.1',master_user='root',
unknown's avatar
unknown committed
14
master_password='',master_port=$MASTER_MYPORT;
unknown's avatar
unknown committed
15
show slave status;
16 17
Master_Host	Master_User	Master_Port	Connect_retry	Log_File	Pos	Slave_Running	Replicate_do_db	Replicate_ignore_db	Last_errno	Last_error	Skip_counter	Last_log_seq
127.0.0.1	root	9999	60		4	No			0		0	0
unknown's avatar
unknown committed
18 19
slave start;
show slave status;
20 21
Master_Host	Master_User	Master_Port	Connect_retry	Log_File	Pos	Slave_Running	Replicate_do_db	Replicate_ignore_db	Last_errno	Last_error	Skip_counter	Last_log_seq
127.0.0.1	root	9999	60	master-bin.001	79	Yes			0		0	1
unknown's avatar
unknown committed
22 23 24 25
drop table if exists t1;
create table t1 (n int);
insert into t1 values (10),(45),(90);
select * from t1;
26 27 28 29
n
10
45
90
unknown's avatar
unknown committed
30
drop table t1;