| 1 |
connect slave,127.0.0.1,root,,,$SERVER_MYPORT_3; |
| 2 |
change master 'master1' to |
| 3 |
master_port=MYPORT_1, |
| 4 |
master_host='127.0.0.1', master_ssl_verify_server_cert=0, |
| 5 |
master_user='root'; |
| 6 |
start slave 'master1'; |
| 7 |
set default_master_connection = 'master1'; |
| 8 |
include/wait_for_slave_to_start.inc |
| 9 |
connect master1,127.0.0.1,root,,,$SERVER_MYPORT_1; |
| 10 |
drop table if exists t1; |
| 11 |
create table t1 (i int) engine=MyISAM; |
| 12 |
insert into t1 values (1),(2); |
| 13 |
connection slave; |
| 14 |
stop slave 'master1'; |
| 15 |
show slave 'master1' status; |
| 16 |
Slave_IO_State 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 Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno Last_Error Skip_Counter Exec_Master_Log_Pos Relay_Log_Space Until_Condition Until_Log_File Until_Log_Pos Master_SSL_Allowed Master_SSL_CA_File Master_SSL_CA_Path Master_SSL_Cert Master_SSL_Cipher Master_SSL_Key Seconds_Behind_Master Master_SSL_Verify_Server_Cert Last_IO_Errno Last_IO_Error Last_SQL_Errno Last_SQL_Error Replicate_Ignore_Server_Ids Master_Server_Id Master_SSL_Crl Master_SSL_Crlpath Using_Gtid Gtid_IO_Pos Replicate_Do_Domain_Ids Replicate_Ignore_Domain_Ids Parallel_Mode SQL_Delay SQL_Remaining_Delay Slave_SQL_Running_State Slave_DDL_Groups Slave_Non_Transactional_Groups Slave_Transactional_Groups Replicate_Rewrite_DB |
| 17 |
127.0.0.1 root MYPORT_1 60 master-bin.000001 <read_master_log_pos> mysqld-relay-bin-master1.000002 <relay_log_pos> master-bin.000001 No No 0 0 <read_master_log_pos> <relay_log_space> None 0 Yes NULL No 0 0 1 Slave_Pos 0-1-3 optimistic 0 NULL 2 1 0 |
| 18 |
mysqld-relay-bin-master1.000001 |
| 19 |
mysqld-relay-bin-master1.000002 |
| 20 |
mysqld-relay-bin-master1.index |
| 21 |
reset slave 'master1'; |
| 22 |
show slave 'master1' status; |
| 23 |
Slave_IO_State 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 Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno Last_Error Skip_Counter Exec_Master_Log_Pos Relay_Log_Space Until_Condition Until_Log_File Until_Log_Pos Master_SSL_Allowed Master_SSL_CA_File Master_SSL_CA_Path Master_SSL_Cert Master_SSL_Cipher Master_SSL_Key Seconds_Behind_Master Master_SSL_Verify_Server_Cert Last_IO_Errno Last_IO_Error Last_SQL_Errno Last_SQL_Error Replicate_Ignore_Server_Ids Master_Server_Id Master_SSL_Crl Master_SSL_Crlpath Using_Gtid Gtid_IO_Pos Replicate_Do_Domain_Ids Replicate_Ignore_Domain_Ids Parallel_Mode SQL_Delay SQL_Remaining_Delay Slave_SQL_Running_State Slave_DDL_Groups Slave_Non_Transactional_Groups Slave_Transactional_Groups Replicate_Rewrite_DB |
| 24 |
127.0.0.1 root MYPORT_1 60 4 <relay_log_pos> No No 0 0 0 <relay_log_space> None 0 Yes NULL No 0 0 1 Slave_Pos optimistic 0 NULL 2 1 0 |
| 25 |
reset slave 'master1' all; |
| 26 |
show slave 'master1' status; |
| 27 |
ERROR HY000: There is no master connection 'master1' |
| 28 |
drop table t1; |
| 29 |
include/reset_master_slave.inc |
| 30 |
disconnect slave; |
| 31 |
connection master1; |
| 32 |
drop table t1; |
| 33 |
include/reset_master_slave.inc |
| 34 |
disconnect master1; |