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
|
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. Install clone and keyring plugins on server1.
[connection server1]
INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
INSTALL PLUGIN keyring_file SONAME 'KEYRING_PLUGIN';
############################################################
# 2. Bootstrap server1 and add some data
include/start_and_bootstrap_group_replication.inc
CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
INSERT INTO t1 VALUES (1);
INSERT INTO t1 VALUES (2);
#######################################################################
# 3. Restart server 2 with a monitoring process (mysqld_safe) if needed
[connection server2]
include/spawn_monitoring_process.inc
############################################################
# 4. Install the clone plugin on server2.
INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
############################################################
# 5. Set server character set to latin1 (non-default)
SET @@global.character_set_server = latin5;
############################################################
# 6. On a empty server2 start group replication
# Clone will fail since the donor server character set utf8mb4 (default) is
# different from joiner character set. Recovery will fallback to incremental.
SET @group_replication_clone_threshold_saved = @@GLOBAL.group_replication_clone_threshold;
SET GLOBAL group_replication_clone_threshold= 1;
include/start_group_replication.inc
include/diff_tables.inc [server1:test.t1 ,server2:test.t1]
include/assert.inc [Clone should have failed]
include/assert_grep.inc [Clone failed]
############################################################
# 7. Cleanup
SET GLOBAL group_replication_clone_threshold= @group_replication_clone_threshold_saved;
DROP TABLE t1;
include/rpl_sync.inc
[connection server2]
include/clean_monitoring_process.inc
set session sql_log_bin=0;
call mtr.add_suppression("This member will start distributed recovery using clone. It is due to the number of missing transactions being higher than the configured threshold of 1.");
call mtr.add_suppression("Internal query: CLONE INSTANCE FROM \'root\'@\'127.0.0.1\':[0-9]+ IDENTIFIED BY \'\\*\\*\\*\\*\\*\' REQUIRE NO SSL; result in error. Error number: 3868");
call mtr.add_suppression("There was an issue when cloning from another server: Error number: 3868 Error message: Clone Configuration character_set_server: Donor value: utf8mb4 is different from Recipient value: latin5.");
call mtr.add_suppression("Due to some issue on the previous step distributed recovery is now executing: Incremental Recovery.");
set session sql_log_bin=1;
[connection server1]
UNINSTALL PLUGIN clone;
UNINSTALL PLUGIN keyring_file;
[connection server2]
UNINSTALL PLUGIN clone;
SET @@global.character_set_server = default;
include/group_replication_end.inc
|
