rpl_change_master.result

来自「视频监控网络部分的协议ddns,的模块的实现代码,请大家大胆指正.」· RESULT 代码 · 共 89 行

RESULT
89
字号
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;create table t1(n int);select * from t1;nstop slave sql_thread;insert into t1 values(1);insert into t1 values(2);stop slave;show slave status;Slave_IO_State	#Master_Host	127.0.0.1Master_User	rootMaster_Port	MASTER_MYPORTConnect_Retry	1Master_Log_File	master-bin.000001Read_Master_Log_Pos	357Relay_Log_File	#Relay_Log_Pos	#Relay_Master_Log_File	master-bin.000001Slave_IO_Running	NoSlave_SQL_Running	NoReplicate_Do_DB	Replicate_Ignore_DB	Replicate_Do_Table	Replicate_Ignore_Table	Replicate_Wild_Do_Table	Replicate_Wild_Ignore_Table	Last_Errno	0Last_Error	Skip_Counter	0Exec_Master_Log_Pos	183Relay_Log_Space	#Until_Condition	NoneUntil_Log_File	Until_Log_Pos	0Master_SSL_Allowed	NoMaster_SSL_CA_File	Master_SSL_CA_Path	Master_SSL_Cert	Master_SSL_Cipher	Master_SSL_Key	Seconds_Behind_Master	#change master to master_user='root';show slave status;Slave_IO_State	#Master_Host	127.0.0.1Master_User	rootMaster_Port	MASTER_MYPORTConnect_Retry	1Master_Log_File	master-bin.000001Read_Master_Log_Pos	183Relay_Log_File	#Relay_Log_Pos	#Relay_Master_Log_File	master-bin.000001Slave_IO_Running	NoSlave_SQL_Running	NoReplicate_Do_DB	Replicate_Ignore_DB	Replicate_Do_Table	Replicate_Ignore_Table	Replicate_Wild_Do_Table	Replicate_Wild_Ignore_Table	Last_Errno	0Last_Error	Skip_Counter	0Exec_Master_Log_Pos	183Relay_Log_Space	#Until_Condition	NoneUntil_Log_File	Until_Log_Pos	0Master_SSL_Allowed	NoMaster_SSL_CA_File	Master_SSL_CA_Path	Master_SSL_Cert	Master_SSL_Cipher	Master_SSL_Key	Seconds_Behind_Master	#start slave;select * from t1;n12drop table t1;

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?