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
|
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. Set sql_generate_invisible_primary_key to true on member 2
[connection server1]
include/save_sysvars.inc [ "GLOBAL.sql_generate_invisible_primary_key" ]
[connection server2]
include/save_sysvars.inc [ "GLOBAL.sql_generate_invisible_primary_key" ]
SET GLOBAL sql_generate_invisible_primary_key=true;
############################################################
# 2. Create a table with no primary key
# Start both members
# Check the second server that recovered still has only 1 column on its table
[connection server1]
CREATE TABLE test.t1 (c1 INT);
include/start_and_bootstrap_group_replication.inc
[connection server2]
include/start_group_replication.inc
include/assert.inc [The table only contains one column]
############################################################
# 3. Set sql_generate_invisible_primary_key to true on server 1 and to false on server 2
# Create a table with no primary key on server 2
# Check that server 1 that replicated it still has only 1 column on its table
[connection server1]
SET GLOBAL sql_generate_invisible_primary_key=true;
[connection server2]
SET GLOBAL sql_generate_invisible_primary_key=false;
CREATE TABLE test.t2 (c1 INT);
include/rpl_sync.inc
[connection server1]
include/assert.inc [The table only contains one column]
############################################################
# 4. Cleanup
#
[connection server1]
include/restore_sysvars.inc
[connection server2]
include/restore_sysvars.inc
DROP TABLE t1;
DROP TABLE t2;
include/group_replication_end.inc
|
