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
|
[connection server1]
[connection server2]
[connection server1]
############################################################
# Step 1 Create a group with 2 members. Bring all ONLINE.
include/group_replication.inc [rpl_server_count=2]
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]
############################################################
# Step 2 Reconfigure write-concurrency value on group, check the new value.
SELECT group_replication_set_write_concurrency(42);
group_replication_set_write_concurrency(42)
UDF is asynchronous, check log or call group_replication_get_write_concurrency().
############################################################
# Step 3 Crash M2
[connection server2]
[connection server1]
include/gr_wait_for_member_state.inc
member2 @ server1 is marked as UNREACHABLE
############################################################
# Step 4 Unsuccessfully call to group_replication_set_write_concurrency(_) on blocked server (M1).
[connection server1]
SELECT group_replication_set_write_concurrency(42);
ERROR HY000: Can't initialize function 'group_replication_set_write_concurrency'; Member must be ONLINE and in the majority partition.
SELECT group_replication_get_write_concurrency();
ERROR HY000: Can't initialize function 'group_replication_get_write_concurrency'; Member must be ONLINE and in the majority partition.
############################################################
# Step 5 Unblock the group with the alive member (M1).
include/assert.inc [group_replication_force_members is correct]
include/rpl_gr_wait_for_number_of_members.inc
############################################################
# Step 6 Check that write_concurrency value remains same after unblocking group.
############################################################
# Step 7 Call group_replication_set_write_concurrency(_) on M1 in order to prove liveness. Assert check that "write concurrency" is modified.
SELECT group_replication_set_write_concurrency(111);
group_replication_set_write_concurrency(111)
UDF is asynchronous, check log or call group_replication_get_write_concurrency().
############################################################
# Step 8 Clean up.
[connection server2]
include/rpl_reconnect.inc
include/group_replication_end.inc
|
