| 1 |
connect slave,127.0.0.1,root,,,$SERVER_MYPORT_3; |
| 2 |
connect master1,127.0.0.1,root,,,$SERVER_MYPORT_1; |
| 3 |
connect master2,127.0.0.1,root,,,$SERVER_MYPORT_2; |
| 4 |
connection slave; |
| 5 |
CHANGE MASTER 'slave1' TO MASTER_PORT=MYPORT_1, MASTER_HOST='127.0.0.1', MASTER_USER='root', master_ssl_verify_server_cert=0; |
| 6 |
CHANGE MASTER 'slave2' TO MASTER_PORT=MYPORT_2, MASTER_HOST='127.0.0.1', MASTER_USER='root', master_ssl_verify_server_cert=0; |
| 7 |
START REPLICA 'slave1'; |
| 8 |
SET default_master_connection = 'slave1'; |
| 9 |
include/wait_for_slave_to_start.inc |
| 10 |
SET default_master_connection = 'slave2'; |
| 11 |
"Command: START ALL SLAVES --> START ALL REPLICAS" |
| 12 |
START ALL REPLICAS; |
| 13 |
Warnings: |
| 14 |
Note 1937 SLAVE 'slave2' started |
| 15 |
include/wait_for_slave_to_start.inc |
| 16 |
SET default_master_connection = ''; |
| 17 |
connection master1; |
| 18 |
connection slave; |
| 19 |
connection master2; |
| 20 |
connection slave; |
| 21 |
"Command: SHOW ALL STAVES STATUS --> SHOW ALL REPLICAS STATUS" |
| 22 |
SHOW ALL REPLICAS STATUS; |
| 23 |
Connection_name slave1 |
| 24 |
Slave_SQL_State Slave has read all relay log; waiting for more updates |
| 25 |
Slave_IO_State Waiting for master to send event |
| 26 |
Master_Host 127.0.0.1 |
| 27 |
Master_User root |
| 28 |
Master_Port MYPORT_1 |
| 29 |
Connect_Retry 60 |
| 30 |
Master_Log_File master-bin.000001 |
| 31 |
Read_Master_Log_Pos <read_master_log_pos> |
| 32 |
Relay_Log_File mysqld-relay-bin-slave1.000002 |
| 33 |
Relay_Log_Pos <relay_log_pos> |
| 34 |
Relay_Master_Log_File master-bin.000001 |
| 35 |
Slave_IO_Running Yes |
| 36 |
Slave_SQL_Running Yes |
| 37 |
Replicate_Do_DB |
| 38 |
Replicate_Ignore_DB |
| 39 |
Replicate_Do_Table |
| 40 |
Replicate_Ignore_Table |
| 41 |
Replicate_Wild_Do_Table |
| 42 |
Replicate_Wild_Ignore_Table |
| 43 |
Last_Errno 0 |
| 44 |
Last_Error |
| 45 |
Skip_Counter 0 |
| 46 |
Exec_Master_Log_Pos <read_master_log_pos> |
| 47 |
Relay_Log_Space <relay_log_space1> |
| 48 |
Until_Condition None |
| 49 |
Until_Log_File |
| 50 |
Until_Log_Pos 0 |
| 51 |
Master_SSL_Allowed Yes |
| 52 |
Master_SSL_CA_File |
| 53 |
Master_SSL_CA_Path |
| 54 |
Master_SSL_Cert |
| 55 |
Master_SSL_Cipher |
| 56 |
Master_SSL_Key |
| 57 |
Seconds_Behind_Master 0 |
| 58 |
Master_SSL_Verify_Server_Cert No |
| 59 |
Last_IO_Errno 0 |
| 60 |
Last_IO_Error |
| 61 |
Last_SQL_Errno 0 |
| 62 |
Last_SQL_Error |
| 63 |
Replicate_Ignore_Server_Ids |
| 64 |
Master_Server_Id 1 |
| 65 |
Master_SSL_Crl |
| 66 |
Master_SSL_Crlpath |
| 67 |
Using_Gtid Slave_Pos |
| 68 |
Gtid_IO_Pos |
| 69 |
Replicate_Do_Domain_Ids |
| 70 |
Replicate_Ignore_Domain_Ids |
| 71 |
Parallel_Mode optimistic |
| 72 |
SQL_Delay 0 |
| 73 |
SQL_Remaining_Delay NULL |
| 74 |
Slave_SQL_Running_State Slave has read all relay log; waiting for more updates |
| 75 |
Slave_DDL_Groups 0 |
| 76 |
Slave_Non_Transactional_Groups 0 |
| 77 |
Slave_Transactional_Groups 0 |
| 78 |
Replicate_Rewrite_DB |
| 79 |
Retried_transactions 0 |
| 80 |
Max_relay_log_size 1073741824 |
| 81 |
Executed_log_entries 7 |
| 82 |
Slave_received_heartbeats 0 |
| 83 |
Slave_heartbeat_period 60.000 |
| 84 |
Gtid_Slave_Pos |
| 85 |
Master_last_event_time NULL |
| 86 |
Slave_last_event_time NULL |
| 87 |
Master_Slave_time_diff NULL |
| 88 |
Connection_name slave2 |
| 89 |
Slave_SQL_State Slave has read all relay log; waiting for more updates |
| 90 |
Slave_IO_State Waiting for master to send event |
| 91 |
Master_Host 127.0.0.1 |
| 92 |
Master_User root |
| 93 |
Master_Port MYPORT_2 |
| 94 |
Connect_Retry 60 |
| 95 |
Master_Log_File master-bin.000001 |
| 96 |
Read_Master_Log_Pos <read_master_log_pos> |
| 97 |
Relay_Log_File mysqld-relay-bin-slave2.000002 |
| 98 |
Relay_Log_Pos <relay_log_pos> |
| 99 |
Relay_Master_Log_File master-bin.000001 |
| 100 |
Slave_IO_Running Yes |
| 101 |
Slave_SQL_Running Yes |
| 102 |
Replicate_Do_DB |
| 103 |
Replicate_Ignore_DB |
| 104 |
Replicate_Do_Table |
| 105 |
Replicate_Ignore_Table |
| 106 |
Replicate_Wild_Do_Table |
| 107 |
Replicate_Wild_Ignore_Table |
| 108 |
Last_Errno 0 |
| 109 |
Last_Error |
| 110 |
Skip_Counter 0 |
| 111 |
Exec_Master_Log_Pos <read_master_log_pos> |
| 112 |
Relay_Log_Space <relay_log_space1> |
| 113 |
Until_Condition None |
| 114 |
Until_Log_File |
| 115 |
Until_Log_Pos 0 |
| 116 |
Master_SSL_Allowed Yes |
| 117 |
Master_SSL_CA_File |
| 118 |
Master_SSL_CA_Path |
| 119 |
Master_SSL_Cert |
| 120 |
Master_SSL_Cipher |
| 121 |
Master_SSL_Key |
| 122 |
Seconds_Behind_Master 0 |
| 123 |
Master_SSL_Verify_Server_Cert No |
| 124 |
Last_IO_Errno 0 |
| 125 |
Last_IO_Error |
| 126 |
Last_SQL_Errno 0 |
| 127 |
Last_SQL_Error |
| 128 |
Replicate_Ignore_Server_Ids |
| 129 |
Master_Server_Id 2 |
| 130 |
Master_SSL_Crl |
| 131 |
Master_SSL_Crlpath |
| 132 |
Using_Gtid Slave_Pos |
| 133 |
Gtid_IO_Pos |
| 134 |
Replicate_Do_Domain_Ids |
| 135 |
Replicate_Ignore_Domain_Ids |
| 136 |
Parallel_Mode optimistic |
| 137 |
SQL_Delay 0 |
| 138 |
SQL_Remaining_Delay NULL |
| 139 |
Slave_SQL_Running_State Slave has read all relay log; waiting for more updates |
| 140 |
Slave_DDL_Groups 0 |
| 141 |
Slave_Non_Transactional_Groups 0 |
| 142 |
Slave_Transactional_Groups 0 |
| 143 |
Replicate_Rewrite_DB |
| 144 |
Retried_transactions 0 |
| 145 |
Max_relay_log_size 1073741824 |
| 146 |
Executed_log_entries 7 |
| 147 |
Slave_received_heartbeats 0 |
| 148 |
Slave_heartbeat_period 60.000 |
| 149 |
Gtid_Slave_Pos |
| 150 |
Master_last_event_time NULL |
| 151 |
Slave_last_event_time NULL |
| 152 |
Master_Slave_time_diff NULL |
| 153 |
"Command: STOP ALL SLAVES --> STOP ALL REPLICAS" |
| 154 |
STOP ALL REPLICAS; |
| 155 |
Warnings: |
| 156 |
Note 1938 SLAVE 'slave2' stopped |
| 157 |
Note 1938 SLAVE 'slave1' stopped |
| 158 |
include/reset_master_slave.inc |
| 159 |
disconnect slave; |
| 160 |
connection master1; |
| 161 |
include/reset_master_slave.inc |
| 162 |
disconnect master1; |
| 163 |
connection master2; |
| 164 |
include/reset_master_slave.inc |
| 165 |
disconnect master2; |