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
|
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. Start Group Replication on server1
[connection server1]
include/start_and_bootstrap_group_replication.inc
#
# 2. Save initial value of GROUP_REPLICATION_AUTO_INCREMENT_INCREMENT for server2
[connection server2]
# 3. Verify default values of group_replication_auto_increment_increment,
# auto_increment_increment and auto_increment_offset.
include/assert.inc [The default value of group_replication_auto_increment_increment should be 7]
include/assert.inc [The default value of auto_increment_increment should be 1]
include/assert.inc [The default value of auto_increment_offset should be 1]
# 4. Start group replication on server2.
include/start_group_replication.inc
# 5. Verify the values of group_replication_auto_increment_increment,
# auto_increment_increment and auto_increment_offset after starting GR.
include/assert.inc [The value of group_replication_auto_increment_increment is still 7]
include/assert.inc [The value of auto_increment_increment is set to 1]
include/assert.inc [The value of auto_increment_offset is set to 1]
# 6. Set group_replication_auto_increment_increment
# and restart group replication.
include/stop_group_replication.inc
SET GLOBAL GROUP_REPLICATION_AUTO_INCREMENT_INCREMENT= 3;
include/start_group_replication.inc
# 7. Verify the effects of group_replication_auto_increment_increment
# on auto_increment_increment on starting GR.
include/assert.inc [The value of group_replication_auto_increment_increment is still 3]
include/assert.inc [The value of auto_increment_increment is set to 1]
# 8. Verify that auto_increment_offset is still is set to default
include/assert.inc [The value of auto_increment_offset is set to 1]
# 9. Cleanup
include/stop_group_replication.inc
SET GLOBAL GROUP_REPLICATION_AUTO_INCREMENT_INCREMENT= 7;
include/group_replication_end.inc
|
