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
|
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]
# 1. Use debug point to decrease minor version
set session sql_log_bin=0;
call mtr.add_suppression("Error while executing a group configuration operation: The group has a member with a version that does not support group coordinated operations.");
set session sql_log_bin=1;
SET @@GLOBAL.DEBUG= '+d,group_replication_legacy_election_version';
# 2. Start server and bootstrap group
include/start_and_bootstrap_group_replication.inc
# 3. Join server2 to group
[connection server2]
set session sql_log_bin=0;
call mtr.add_suppression("The function 'group_replication_switch_to_single_primary_mode' failed. The group has a member with a version that does not support group coordinated operations.");
call mtr.add_suppression("Member version is read compatible with the group.");
set session sql_log_bin=1;
include/start_group_replication.inc
# 4. Executing switch to single primary mode will fail due to the version of
# one of the members
SELECT group_replication_switch_to_single_primary_mode();
ERROR HY000: The function 'group_replication_switch_to_single_primary_mode' failed. The group has a member with a version that does not support group coordinated operations.
SELECT group_replication_switch_to_single_primary_mode("MEMBER2_UUID");
ERROR HY000: The function 'group_replication_switch_to_single_primary_mode' failed. The group has a member with a version that does not support group coordinated operations.
# 5. Cleanup
[connection server1]
include/stop_group_replication.inc
SET @@GLOBAL.DEBUG= '-d,group_replication_legacy_election_version';
SET @@GLOBAL.DEBUG= '+d,group_replication_compatibility_restore_version';
include/start_group_replication.inc
SET @@GLOBAL.DEBUG= '-d,group_replication_compatibility_restore_version';
include/group_replication_end.inc
|
