Debian Codegraph @

mysql-test/suite/group_replication/t/gr_switch_primary_timeout_basic.test

raw
1 ################################################################################
2 # The test to check group_replication_set_as_primary() UDF functionality with
3 # timeout option from both primary and secondary members.
4 #
5 # Test:
6 # 0. The test requires two servers: M1 and M2.
7 # 1. Start group in single primary mode.
8 # Server1 will be primary and server 2 secondary.
9 # 2. Run UDF group_replication_set_as_primary from server2.
10 # 2.A. Promote server2 as a new primary.
11 # 2.B. Promote server1 as a new primary.
12 # 3. Run UDF group_replication_set_as_primary from server1.
13 # 3.A. Make server2 primary from server1(present primary).
14 # 3.B. Make server1 primary from server1(present secondary).
15 # 4. Cleanup.
16 ################################################################################
17
18 --source include/have_group_replication_plugin.inc
19 --let $rpl_skip_group_replication_start= 1
20 --let $rpl_group_replication_single_primary_mode=1
21 --source include/group_replication.inc
22
23 --echo
24 --echo # 1. Start group in single primary mode.
25 --echo # Server1 will be primary and server 2 secondary.
26
27 --let $server1_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
28 --source include/start_and_bootstrap_group_replication.inc
29
30 --let $rpl_connection_name= server2
31 --source include/rpl_connection.inc
32
33 --let $server2_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
34 --source include/start_group_replication.inc
35
36 --echo
37 --echo # 2. Run UDF group_replication_set_as_primary from server2.
38 --echo # 2.A. Promote server2 as a new primary.
39
40 --let $_begin= `SELECT UNIX_TIMESTAMP()`
41 --replace_result $server2_uuid SERVER2_UUID
42 --eval SELECT group_replication_set_as_primary("$server2_uuid", 600)
43
44 --let $_end= `SELECT UNIX_TIMESTAMP()`
45 --let $_delta= `SELECT $_end - $_begin`
46 --let $assert_text = Time elapsed must be less than the timeout
47 --let $assert_cond = $_delta < 600
48 --source include/assert.inc
49
50 --source include/gr_assert_primary_member.inc
51 --let $rpl_connection_name= server1
52 --source include/rpl_connection.inc
53 --source include/gr_assert_secondary_member.inc
54
55
56 --echo
57 --echo # 2.B. Promote server1 as a new primary.
58
59 --let $rpl_connection_name= server2
60 --source include/rpl_connection.inc
61
62 --let $_begin= `SELECT UNIX_TIMESTAMP()`
63 --replace_result $server1_uuid SERVER1_UUID
64 --eval SELECT group_replication_set_as_primary("$server1_uuid", 600)
65
66 --let $_end= `SELECT UNIX_TIMESTAMP()`
67 --let $_delta= `SELECT $_end - $_begin`
68 --let $assert_text = Time elapsed must be less than the timeout
69 --let $assert_cond = $_delta < 600
70 --source include/assert.inc
71
72 --source include/gr_assert_secondary_member.inc
73 --let $rpl_connection_name= server1
74 --source include/rpl_connection.inc
75 --source include/gr_assert_primary_member.inc
76
77 --echo
78 --echo # 3. Run UDF group_replication_set_as_primary from server1.
79 --echo # 3.A. Make server2 primary from server1(present primary).
80
81 --let $rpl_connection_name= server1
82 --source include/rpl_connection.inc
83
84 --let $_begin= `SELECT UNIX_TIMESTAMP()`
85 --replace_result $server2_uuid SERVER2_UUID
86 --eval SELECT group_replication_set_as_primary("$server2_uuid", 600)
87
88 --let $_end= `SELECT UNIX_TIMESTAMP()`
89 --let $_delta= `SELECT $_end - $_begin`
90 --let $assert_text = Time elapsed must be less than the timeout
91 --let $assert_cond = $_delta < 600
92 --source include/assert.inc
93
94 --source include/gr_assert_secondary_member.inc
95 --let $rpl_connection_name= server2
96 --source include/rpl_connection.inc
97 --source include/gr_assert_primary_member.inc
98
99 --echo
100 --echo # 3.B. Make server1 primary from server1(present secondary).
101
102 --let $rpl_connection_name= server1
103 --source include/rpl_connection.inc
104
105 --let $_begin= `SELECT UNIX_TIMESTAMP()`
106 --replace_result $server1_uuid SERVER1_UUID
107 --eval SELECT group_replication_set_as_primary("$server1_uuid", 600)
108
109 --let $_end= `SELECT UNIX_TIMESTAMP()`
110 --let $_delta= `SELECT $_end - $_begin`
111 --let $assert_text = Time elapsed must be less than the timeout
112 --let $assert_cond = $_delta < 600
113 --source include/assert.inc
114
115 --source include/gr_assert_primary_member.inc
116 --let $rpl_connection_name= server2
117 --source include/rpl_connection.inc
118 --source include/gr_assert_secondary_member.inc
119
120 --echo
121 --echo # 4. Cleanup.
122
123 --source include/group_replication_end.inc