1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
|
include/group_replication.inc
Warnings:
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
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.
[connection server1]
include/assert.inc [Default slave parallel type must be LOGICAL_CLOCK]
include/assert.inc [Default slave parallel workers must be 4]
include/assert.inc [Default slave preserve commit order 1]
include/start_and_bootstrap_group_replication.inc
include/stop_group_replication.inc
SET @replica_parallel_type_saved= @@GLOBAL.REPLICA_PARALLEL_TYPE;
Warnings:
Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
SET @replica_parallel_workers_saved= @@GLOBAL.REPLICA_PARALLEL_WORKERS;
SET @slave_preserver_commit_order_saved= @@GLOBAL.REPLICA_PRESERVE_COMMIT_ORDER;
SET GLOBAL REPLICA_PRESERVE_COMMIT_ORDER= OFF;
############################################################
# 1. Test with REPLICA_PARALLEL_TYPE default value and
# parallel workers number set to 4.
STOP SLAVE SQL_THREAD FOR CHANNEL "group_replication_applier";
Warnings:
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
Note 3084 Replication thread(s) for channel 'group_replication_applier' are already stopped.
SET GLOBAL REPLICA_PARALLEL_WORKERS=4;
START SLAVE SQL_THREAD FOR CHANNEL "group_replication_applier";
ERROR HY000: START REPLICA SQL_THREAD when REPLICA_PARALLEL_WORKERS > 0 and REPLICA_PARALLEL_TYPE != LOGICAL_CLOCK or REPLICA_PRESERVE_COMMIT_ORDER != ON cannot be performed on channel 'group_replication_applier'.
############################################################
# 2. Test with REPLICA_PARALLEL_TYPE set to DATABASE and
# parallel workers number set to 4.
STOP SLAVE SQL_THREAD FOR CHANNEL "group_replication_applier";
Warnings:
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
Note 3084 Replication thread(s) for channel 'group_replication_applier' are already stopped.
SET @@GLOBAL.REPLICA_PARALLEL_TYPE= "DATABASE";
Warnings:
Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
SET GLOBAL REPLICA_PARALLEL_WORKERS= 4;
START SLAVE SQL_THREAD FOR CHANNEL "group_replication_applier";
ERROR HY000: START REPLICA SQL_THREAD when REPLICA_PARALLEL_WORKERS > 0 and REPLICA_PARALLEL_TYPE != LOGICAL_CLOCK or REPLICA_PRESERVE_COMMIT_ORDER != ON cannot be performed on channel 'group_replication_applier'.
############################################################
# 3. Test with REPLICA_PARALLEL_TYPE set to LOGICAL_CLOCK and
# parallel workers number set to 4.
STOP SLAVE SQL_THREAD FOR CHANNEL "group_replication_applier";
Warnings:
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
Note 3084 Replication thread(s) for channel 'group_replication_applier' are already stopped.
SET @@GLOBAL.REPLICA_PARALLEL_TYPE= "LOGICAL_CLOCK";
Warnings:
Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
SET GLOBAL REPLICA_PARALLEL_WORKERS= 4;
START SLAVE SQL_THREAD FOR CHANNEL "group_replication_applier";
ERROR HY000: START REPLICA SQL_THREAD when REPLICA_PARALLEL_WORKERS > 0 and REPLICA_PARALLEL_TYPE != LOGICAL_CLOCK or REPLICA_PRESERVE_COMMIT_ORDER != ON cannot be performed on channel 'group_replication_applier'.
############################################################
# 4. Test with REPLICA_PARALLEL_TYPE set to LOGICAL_CLOCK,
# parallel workers number set to 4 and
# REPLICA_PRESERVE_COMMIT_ORDER set to ON.
STOP SLAVE SQL_THREAD FOR CHANNEL "group_replication_applier";
Warnings:
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
Note 3084 Replication thread(s) for channel 'group_replication_applier' are already stopped.
SET @@GLOBAL.REPLICA_PARALLEL_TYPE= "LOGICAL_CLOCK";
Warnings:
Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
SET GLOBAL REPLICA_PARALLEL_WORKERS= 4;
SET GLOBAL REPLICA_PRESERVE_COMMIT_ORDER= ON;
START SLAVE SQL_THREAD FOR CHANNEL "group_replication_applier";
Warnings:
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
############################################################
# 5. Test with REPLICA_PARALLEL_TYPE set to LOGICAL_CLOCK and
# parallel workers number set to 0.
STOP SLAVE SQL_THREAD FOR CHANNEL "group_replication_applier";
Warnings:
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
SET @@GLOBAL.REPLICA_PARALLEL_TYPE= "LOGICAL_CLOCK";
Warnings:
Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
SET GLOBAL REPLICA_PARALLEL_WORKERS= 0;
Warnings:
Warning 1287 '0' is deprecated and will be removed in a future release. Please use 1 instead
START SLAVE SQL_THREAD FOR CHANNEL "group_replication_applier";
Warnings:
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
############################################################
# 6. Test with REPLICA_PARALLEL_TYPE default value and default
# parallel workers number.
STOP SLAVE SQL_THREAD FOR CHANNEL "group_replication_applier";
Warnings:
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
SET @@GLOBAL.REPLICA_PARALLEL_TYPE= @replica_parallel_type_saved;
Warnings:
Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
SET @@GLOBAL.REPLICA_PARALLEL_WORKERS= @replica_parallel_workers_saved;
SET @@GLOBAL.REPLICA_PRESERVE_COMMIT_ORDER= @slave_preserver_commit_order_saved;
START SLAVE SQL_THREAD FOR CHANNEL "group_replication_applier";
Warnings:
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
include/gr_stop_applier_sql_thread.inc
STOP REPLICA SQL_THREAD FOR CHANNEL "group_replication_applier";
include/group_replication_end.inc
|
