Debian Codegraph @

mysql-test/suite/multi_source/info_logs.result

raw
1 connect slave,127.0.0.1,root,,,$SERVER_MYPORT_3;
2 #
3 # List of files matching '*info*' pattern before starting any slaves
4 multi-master.info
5 # End of list
6 #
7 # Contents of multi-master.info
8 # EOF
9 #
10 change master 'master1' to
11 master_port=MYPORT_1,
12 master_host='127.0.0.1',
13 master_user='root', master_ssl_verify_server_cert=0,
14 master_use_gtid=no;
15 start slave 'master1';
16 set default_master_connection = 'master1';
17 include/wait_for_slave_to_start.inc
18 #
19 # List of files matching '*info*' pattern while 'master1' is running
20 master-master1.info
21 multi-master.info
22 relay.bin-master1.info
23 # End of list
24 #
25 # Contents of multi-master.info
26 master1
27 # EOF
28 #
29 change master 'MASTER 2.2' to
30 master_port=MYPORT_2,
31 master_host='127.0.0.1',
32 master_user='root', master_ssl_verify_server_cert=0,
33 master_use_gtid=no;
34 start slave 'MASTER 2.2';
35 set default_master_connection = 'MASTER 2.2';
36 include/wait_for_slave_to_start.inc
37 connect master2,127.0.0.1,root,,,$SERVER_MYPORT_2;
38 connection slave;
39 #
40 # List of files matching '*info*' pattern
41 # while 'master1' and 'MASTER 2.2' are running
42 master-master1.info
43 master-master@[email protected]
44 multi-master.info
45 relay.bin-master1.info
46 relay.bin-master@[email protected]
47 # End of list
48 #
49 # Contents of multi-master.info
50 master1
51 MASTER 2.2
52 # EOF
53 #
54 stop slave 'master1';
55 set default_master_connection = 'master1';
56 include/wait_for_slave_to_stop.inc
57 reset slave 'master1' all;
58 Warnings:
59 Note 4190 RESET SLAVE is implicitly changing the value of 'Using_Gtid' from 'No' to 'Slave_Pos'
60 #
61 # List of files matching '*info*' pattern
62 # after 'master1' was completely reset, 'MASTER 2.2' still running
63 master-master@[email protected]
64 multi-master.info
65 relay.bin-master@[email protected]
66 # End of list
67 #
68 # Contents of multi-master.info
69 MASTER 2.2
70 # EOF
71 #
72 set default_master_connection = '';
73 change master to
74 master_port=MYPORT_1,
75 master_host='127.0.0.1',
76 master_user='root', master_ssl_verify_server_cert=0,
77 master_use_gtid=no;
78 start slave;
79 include/wait_for_slave_to_start.inc
80 connect master1,127.0.0.1,root,,,$SERVER_MYPORT_1;
81 connection slave;
82 #
83 # List of files matching '*info*' pattern
84 # while 'MASTER 2.2' and '' are running
85 master-master@[email protected]
86 master.info
87 multi-master.info
88 relay.bin-master@[email protected]
89 relay.bin.info
90 # End of list
91 #
92 # Contents of multi-master.info
93 MASTER 2.2
94 # EOF
95 #
96 show all slaves status;
97 Connection_name Slave_SQL_State 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 Retried_transactions Max_relay_log_size Executed_log_entries Slave_received_heartbeats Slave_heartbeat_period Gtid_Slave_Pos Master_last_event_time Slave_last_event_time Master_Slave_time_diff
98 Slave has read all relay log; waiting for more updates Waiting for master to send event 127.0.0.1 root MYPORT_1 60 master-bin.000001 <read_master_log_pos> relay.000002 <relay_log_pos> master-bin.000001 Yes Yes 0 0 <read_master_log_pos> <relay_log_space1> None 0 Yes 0 No 0 0 1 No optimistic 0 NULL Slave has read all relay log; waiting for more updates 0 0 0 0 1073741824 7 0 60.000 NULL NULL NULL
99 MASTER 2.2 Slave has read all relay log; waiting for more updates Waiting for master to send event 127.0.0.1 root MYPORT_2 60 master-bin.000001 <read_master_log_pos> relay-master@[email protected] <relay_log_pos> master-bin.000001 Yes Yes 0 0 <read_master_log_pos> <relay_log_space2> None 0 Yes 0 No 0 0 2 No optimistic 0 NULL Slave has read all relay log; waiting for more updates 0 0 0 0 1073741824 7 0 60.000 NULL NULL NULL
100 include/wait_for_slave_to_start.inc
101 set default_master_connection = 'MASTER 2.2';
102 include/wait_for_slave_to_start.inc
103 set default_master_connection = '';
104 show all slaves status;
105 Connection_name Slave_SQL_State 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 Retried_transactions Max_relay_log_size Executed_log_entries Slave_received_heartbeats Slave_heartbeat_period Gtid_Slave_Pos Master_last_event_time Slave_last_event_time Master_Slave_time_diff
106 Slave has read all relay log; waiting for more updates Waiting for master to send event 127.0.0.1 root MYPORT_1 60 master-bin.000001 <read_master_log_pos> relay.000004 <relay_log_pos> master-bin.000001 Yes Yes 0 0 <read_master_log_pos> <relay_log_space1> None 0 Yes 0 No 0 0 1 No optimistic 0 NULL Slave has read all relay log; waiting for more updates 0 0 0 0 1073741824 6 0 60.000 NULL NULL NULL
107 MASTER 2.2 Slave has read all relay log; waiting for more updates Waiting for master to send event 127.0.0.1 root MYPORT_2 60 master-bin.000001 <read_master_log_pos> relay-master@[email protected] <relay_log_pos> master-bin.000001 Yes Yes 0 0 <read_master_log_pos> <relay_log_space2> None 0 Yes 0 No 0 0 2 No optimistic 0 NULL Slave has read all relay log; waiting for more updates 0 0 0 0 1073741824 6 0 60.000 NULL NULL NULL
108 #
109 # List of files matching '*info*' pattern
110 # after slave server restart
111 # while 'MASTER 2.2' and '' are running
112 master-master@[email protected]
113 master.info
114 multi-master.info
115 relay.bin-master@[email protected]
116 relay.bin.info
117 # End of list
118 #
119 # Contents of multi-master.info
120 MASTER 2.2
121 # EOF
122 #
123 include/reset_master_slave.inc
124 disconnect slave;
125 connection master1;
126 include/reset_master_slave.inc
127 disconnect master1;
128 connection master2;
129 include/reset_master_slave.inc
130 disconnect master2;