Debian Codegraph @

mysql-test/suite/group_replication/r/gr_switch_primary_timeout_basic.result

raw
1 include/group_replication.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 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.
5 [connection server1]
6
7 # 1. Start group in single primary mode.
8 # Server1 will be primary and server 2 secondary.
9 include/start_and_bootstrap_group_replication.inc
10 [connection server2]
11 include/start_group_replication.inc
12
13 # 2. Run UDF group_replication_set_as_primary from server2.
14 # 2.A. Promote server2 as a new primary.
15 SELECT group_replication_set_as_primary("SERVER2_UUID", 600);
16 group_replication_set_as_primary("SERVER2_UUID", 600)
17 Primary server switched to: SERVER2_UUID
18 include/assert.inc [Time elapsed must be less than the timeout]
19 include/gr_assert_primary_member.inc
20 [connection server1]
21 include/gr_assert_secondary_member.inc
22
23 # 2.B. Promote server1 as a new primary.
24 [connection server2]
25 SELECT group_replication_set_as_primary("SERVER1_UUID", 600);
26 group_replication_set_as_primary("SERVER1_UUID", 600)
27 Primary server switched to: SERVER1_UUID
28 include/assert.inc [Time elapsed must be less than the timeout]
29 include/gr_assert_secondary_member.inc
30 [connection server1]
31 include/gr_assert_primary_member.inc
32
33 # 3. Run UDF group_replication_set_as_primary from server1.
34 # 3.A. Make server2 primary from server1(present primary).
35 [connection server1]
36 SELECT group_replication_set_as_primary("SERVER2_UUID", 600);
37 group_replication_set_as_primary("SERVER2_UUID", 600)
38 Primary server switched to: SERVER2_UUID
39 include/assert.inc [Time elapsed must be less than the timeout]
40 include/gr_assert_secondary_member.inc
41 [connection server2]
42 include/gr_assert_primary_member.inc
43
44 # 3.B. Make server1 primary from server1(present secondary).
45 [connection server1]
46 SELECT group_replication_set_as_primary("SERVER1_UUID", 600);
47 group_replication_set_as_primary("SERVER1_UUID", 600)
48 Primary server switched to: SERVER1_UUID
49 include/assert.inc [Time elapsed must be less than the timeout]
50 include/gr_assert_primary_member.inc
51 [connection server2]
52 include/gr_assert_secondary_member.inc
53
54 # 4. Cleanup.
55 include/group_replication_end.inc