rpl_failsafe.result

来自「这是linux下运行的mysql软件包,可用于linux 下安装 php + m」· RESULT 代码 · 共 35 行

stop slave;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
reset master;
reset slave;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
start slave;
show variables like 'rpl_recovery_rank';
Variable_name	Value
rpl_recovery_rank	1
show status like 'Rpl_status';
Variable_name	Value
Rpl_status	AUTH_MASTER
create table t1(n int);
drop table t1;
show variables like 'rpl_recovery_rank';
Variable_name	Value
rpl_recovery_rank	2
show status like 'Rpl_status';
Variable_name	Value
Rpl_status	ACTIVE_SLAVE
start slave;
show variables like 'rpl_recovery_rank';
Variable_name	Value
rpl_recovery_rank	3
show status like 'Rpl_status';
Variable_name	Value
Rpl_status	ACTIVE_SLAVE
start slave;
show variables like 'rpl_recovery_rank';
Variable_name	Value
rpl_recovery_rank	4
show status like 'Rpl_status';
Variable_name	Value
Rpl_status	ACTIVE_SLAVE