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 + -
显示快捷键?