Debian Codegraph @

mysql-test/suite/rpl/r/rpl_perfschema_order_by.result

raw
1 include/rpl_init.inc [topology=3->2,1->2]
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 Warnings:
6 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
7 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
8 [connection server_2]
9 SET @save.replica_parallel_workers= @@global.replica_parallel_workers;
10 # Test for Single Threaded Slave
11 SET GLOBAL replica_parallel_workers= 0;
12 Warnings:
13 Warning 1287 '0' is deprecated and will be removed in a future release. Please use 1 instead
14 START SLAVE;
15 Warnings:
16 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
17 # 1) Create a database on server_1.
18 [connection server_1]
19 CREATE DATABASE db1;
20 # 2) create database on server_3.
21 [connection server_3]
22 CREATE DATABASE db3;
23 # 3) sync the slave (server_2) with both masters (server_1 and server_3).
24 [connection server_1]
25 include/sync_slave_sql_with_master.inc [FOR CHANNEL 'channel_1']
26 [connection server_3]
27 include/sync_slave_sql_with_master.inc [FOR CHANNEL 'channel_3']
28 include/stop_slave.inc [FOR CHANNEL 'channel_3']
29 include/start_slave.inc [FOR CHANNEL 'channel_3']
30
31 SELECT CHANNEL_NAME FROM performance_schema.replication_applier_configuration;
32 CHANNEL_NAME
33 channel_3
34 channel_1
35 SELECT CHANNEL_NAME FROM performance_schema.replication_applier_configuration ORDER BY CHANNEL_NAME;
36 CHANNEL_NAME
37 channel_1
38 channel_3
39
40 SELECT CHANNEL_NAME FROM performance_schema.replication_applier_status;
41 CHANNEL_NAME
42 channel_3
43 channel_1
44 SELECT CHANNEL_NAME FROM performance_schema.replication_applier_status ORDER BY CHANNEL_NAME;
45 CHANNEL_NAME
46 channel_1
47 channel_3
48
49 SELECT CHANNEL_NAME, LAST_ERROR_MESSAGE FROM performance_schema.replication_connection_status;
50 CHANNEL_NAME LAST_ERROR_MESSAGE
51 channel_3
52 channel_1
53 SELECT CHANNEL_NAME, LAST_ERROR_MESSAGE FROM performance_schema.replication_connection_status ORDER BY CHANNEL_NAME;
54 CHANNEL_NAME LAST_ERROR_MESSAGE
55 channel_1
56 channel_3
57
58 SELECT CHANNEL_NAME, TLS_VERSION FROM performance_schema.replication_connection_configuration;
59 CHANNEL_NAME TLS_VERSION
60 channel_3
61 channel_1
62 SELECT CHANNEL_NAME, TLS_VERSION FROM performance_schema.replication_connection_configuration ORDER BY CHANNEL_NAME;
63 CHANNEL_NAME TLS_VERSION
64 channel_1
65 channel_3
66
67 SELECT CHANNEL_NAME, LAST_ERROR_MESSAGE FROM performance_schema.replication_applier_status_by_worker;
68 CHANNEL_NAME LAST_ERROR_MESSAGE
69 channel_3
70 channel_1
71 SELECT CHANNEL_NAME, LAST_ERROR_MESSAGE FROM performance_schema.replication_applier_status_by_worker ORDER BY CHANNEL_NAME;
72 CHANNEL_NAME LAST_ERROR_MESSAGE
73 channel_1
74 channel_3
75
76 [connection server_1]
77 DROP DATABASE db1;
78 [connection server_3]
79 DROP DATABASE db3;
80 [connection server_1]
81 include/sync_slave_sql_with_master.inc [FOR CHANNEL 'channel_1']
82 [connection server_3]
83 include/sync_slave_sql_with_master.inc [FOR CHANNEL 'channel_3']
84 # Test for Multi Threaded Slave
85 STOP SLAVE;
86 Warnings:
87 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
88 SET GLOBAL replica_parallel_workers = 2;
89 START SLAVE;
90 Warnings:
91 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
92 # 1) Create a database on server_1.
93 [connection server_1]
94 CREATE DATABASE db1;
95 # 2) create database on server_3.
96 [connection server_3]
97 CREATE DATABASE db3;
98 # 3) sync the slave (server_2) with both masters (server_1 and server_3).
99 [connection server_1]
100 include/sync_slave_sql_with_master.inc [FOR CHANNEL 'channel_1']
101 [connection server_3]
102 include/sync_slave_sql_with_master.inc [FOR CHANNEL 'channel_3']
103 include/stop_slave.inc [FOR CHANNEL 'channel_3']
104 include/start_slave.inc [FOR CHANNEL 'channel_3']
105
106 SELECT CHANNEL_NAME FROM performance_schema.replication_applier_configuration;
107 CHANNEL_NAME
108 channel_3
109 channel_1
110 SELECT CHANNEL_NAME FROM performance_schema.replication_applier_configuration ORDER BY CHANNEL_NAME;
111 CHANNEL_NAME
112 channel_1
113 channel_3
114
115 SELECT CHANNEL_NAME FROM performance_schema.replication_applier_status;
116 CHANNEL_NAME
117 channel_3
118 channel_1
119 SELECT CHANNEL_NAME FROM performance_schema.replication_applier_status ORDER BY CHANNEL_NAME;
120 CHANNEL_NAME
121 channel_1
122 channel_3
123
124 SELECT CHANNEL_NAME, LAST_ERROR_MESSAGE FROM performance_schema.replication_connection_status;
125 CHANNEL_NAME LAST_ERROR_MESSAGE
126 channel_3
127 channel_1
128 SELECT CHANNEL_NAME, LAST_ERROR_MESSAGE FROM performance_schema.replication_connection_status ORDER BY CHANNEL_NAME;
129 CHANNEL_NAME LAST_ERROR_MESSAGE
130 channel_1
131 channel_3
132
133 SELECT CHANNEL_NAME, TLS_VERSION FROM performance_schema.replication_connection_configuration;
134 CHANNEL_NAME TLS_VERSION
135 channel_3
136 channel_1
137 SELECT CHANNEL_NAME, TLS_VERSION FROM performance_schema.replication_connection_configuration ORDER BY CHANNEL_NAME;
138 CHANNEL_NAME TLS_VERSION
139 channel_1
140 channel_3
141
142 SELECT CHANNEL_NAME, LAST_ERROR_MESSAGE FROM performance_schema.replication_applier_status_by_coordinator;
143 CHANNEL_NAME LAST_ERROR_MESSAGE
144 channel_3
145 channel_1
146 SELECT CHANNEL_NAME, LAST_ERROR_MESSAGE FROM performance_schema.replication_applier_status_by_coordinator ORDER BY CHANNEL_NAME;
147 CHANNEL_NAME LAST_ERROR_MESSAGE
148 channel_1
149 channel_3
150
151 SELECT CHANNEL_NAME, LAST_ERROR_MESSAGE FROM performance_schema.replication_applier_status_by_worker;
152 CHANNEL_NAME LAST_ERROR_MESSAGE
153 channel_3
154 channel_3
155 channel_1
156 channel_1
157 SELECT CHANNEL_NAME, LAST_ERROR_MESSAGE FROM performance_schema.replication_applier_status_by_worker ORDER BY CHANNEL_NAME;
158 CHANNEL_NAME LAST_ERROR_MESSAGE
159 channel_1
160 channel_1
161 channel_3
162 channel_3
163
164 [connection server_1]
165 DROP DATABASE db1;
166 [connection server_3]
167 DROP DATABASE db3;
168 [connection server_1]
169 include/sync_slave_sql_with_master.inc [FOR CHANNEL 'channel_1']
170 [connection server_3]
171 include/sync_slave_sql_with_master.inc [FOR CHANNEL 'channel_3']
172 STOP SLAVE;
173 Warnings:
174 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
175 SET @@global.replica_parallel_workers= @save.replica_parallel_workers;
176 START SLAVE;
177 Warnings:
178 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
179 include/rpl_end.inc
180 RESET REPLICA ALL FOR CHANNEL 'channel_3';
181 RESET REPLICA ALL FOR CHANNEL 'channel_1';