Debian Codegraph @

mysql-test/suite/multi_source/multi_source_slave_alias_replica.result

raw
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;