rpl000016.result 2.56 KB
Newer Older
unknown's avatar
unknown committed
1
slave start;
unknown's avatar
unknown committed
2
Could not initialize master info structure, check permisions on master.info
unknown's avatar
unknown committed
3
slave start;
unknown's avatar
unknown committed
4
Could not initialize master info structure, check permisions on master.info
5
change master to master_host='127.0.0.1',master_port=MASTER_PORT,
unknown's avatar
unknown committed
6
master_user='root';
unknown's avatar
unknown committed
7
Could not initialize master info
unknown's avatar
unknown committed
8
reset slave;
9
change master to master_host='127.0.0.1',master_port=MASTER_PORT,
unknown's avatar
unknown committed
10 11 12 13 14 15 16
master_user='root';
reset master;
slave start;
drop table if exists t1;
create table t1 (s text);
insert into t1 values('Could not break slave'),('Tried hard');
show slave status;
17
Master_Host	Master_User	Master_Port	Connect_retry	Master_Log_File	Read_Master_Log_Pos	Relay_Log_File	Relay_Log_Pos	Relay_Master_Log_File	Slave_IO_Running	Slave_SQL_Running	Replicate_do_db	Replicate_ignore_db	Last_errno	Last_error	Skip_counter	Exec_master_log_pos
18
127.0.0.1	root	MASTER_PORT	60	master-bin.001	234	mysql-relay-bin.001	275	master-bin.001	Yes	Yes			0		0	234
unknown's avatar
unknown committed
19
select * from t1;
20 21 22
s
Could not break slave
Tried hard
unknown's avatar
unknown committed
23 24
flush logs;
drop table if exists t2;
unknown's avatar
unknown committed
25
create table t2(m int not null auto_increment primary key);
unknown's avatar
unknown committed
26 27 28
insert into t2 values (34),(67),(123);
flush logs;
show master logs;
29 30 31 32
Log_name
master-bin.001
master-bin.002
master-bin.003
unknown's avatar
unknown committed
33
insert into t2 values(1234);
unknown's avatar
unknown committed
34 35
set insert_id=1234;
insert into t2 values(NULL);
unknown's avatar
unknown committed
36 37 38 39 40
slave stop;
set sql_slave_skip_counter=1;
slave start;
purge master logs to 'master-bin.003';
show master logs;
41 42
Log_name
master-bin.003
unknown's avatar
unknown committed
43 44
insert into t2 values (65);
show slave status;
45
Master_Host	Master_User	Master_Port	Connect_retry	Master_Log_File	Read_Master_Log_Pos	Relay_Log_File	Relay_Log_Pos	Relay_Master_Log_File	Slave_IO_Running	Slave_SQL_Running	Replicate_do_db	Replicate_ignore_db	Last_errno	Last_error	Skip_counter	Exec_master_log_pos
46
127.0.0.1	root	MASTER_PORT	60	master-bin.003	155	mysql-relay-bin.001	793	master-bin.003	Yes	Yes			0		0	155
unknown's avatar
unknown committed
47
select * from t2;
48 49
m
34
50
65
51 52
67
123
53
1234
unknown's avatar
unknown committed
54 55 56
drop table if exists t3;
create table t3 (n int);
show master logs;
57 58 59 60
Log_name
master-bin.003
master-bin.004
master-bin.005
61
master-bin.006
unknown's avatar
unknown committed
62
show master status;
unknown's avatar
unknown committed
63
File	Position	Binlog_do_db	Binlog_ignore_db
unknown's avatar
unknown committed
64
master-bin.006	445		
unknown's avatar
unknown committed
65 66 67
slave stop;
slave start;
show slave status;
68
Master_Host	Master_User	Master_Port	Connect_retry	Master_Log_File	Read_Master_Log_Pos	Relay_Log_File	Relay_Log_Pos	Relay_Master_Log_File	Slave_IO_Running	Slave_SQL_Running	Replicate_do_db	Replicate_ignore_db	Last_errno	Last_error	Skip_counter	Exec_master_log_pos
69
127.0.0.1	root	MASTER_PORT	60	master-bin.006	445	mysql-relay-bin.004	1312	master-bin.006	Yes	Yes			0		0	445
unknown's avatar
unknown committed
70 71
lock tables t3 read;
select count(*) from t3 where n >= 4;
72 73
count(*)
100
unknown's avatar
unknown committed
74 75
unlock tables;
drop table if exists t1,t2,t3;