Debian Codegraph @

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

raw
1 ################################################################################
2 # WL#6841 - GCS Replication: P_S table to show GCS kernel stats
3 #
4 # This test checks the basic functionality of the Group Replication
5 # P_S for replication_group_members table.
6 # DDL and DML testing for this table is addressed in other tests.
7 #
8 # Test:
9 # 0. The test requires one server: M1.
10 # 1. Checking the performance schema output for the replication_group_members
11 # table before GR start.
12 # 2. Bootstrap start M1. Validate replication_group_members table data.
13 # 3. Stop GR on M1. Validate replication_group_members table data.
14 # 4. Restart tests that the plugin is still loaded on the server restart.
15 ################################################################################
16
17 --let $group_replication_group_name= 8a84f357-aaa4-10df-85ab-c70aa9429562
18 --source include/have_group_replication_plugin.inc
19
20 --let $group_replication_channel_name= group_replication_applier
21
22 # This is a valid name being given to the group name
23 --eval SET GLOBAL group_replication_group_name= "$group_replication_group_name"
24
25 # Checking the performance Schema output for the replication_group_members table.
26 --let $channel_name= query_get_value(SELECT Channel_Name from performance_schema.replication_group_members, Channel_Name, 1)
27 --let $assert_text= The value of channel name should be $group_replication_channel_name
28 --let $assert_cond= "$channel_name" = "$group_replication_channel_name"
29 --source include/assert.inc
30
31 --let $member_id= query_get_value(SELECT Member_Id from performance_schema.replication_group_members, Member_Id, 1)
32 --let $assert_text= The value of member_id should be empty before starting group replication
33 --let $assert_cond= "$member_id" = ""
34 --source include/assert.inc
35
36 --let $member_host= query_get_value(SELECT Member_Host from performance_schema.replication_group_members, Member_Host, 1)
37 --let $assert_text= The value of member_host should be empty before starting group replication
38 --let $assert_cond= "$member_host" = ""
39 --source include/assert.inc
40
41 --let $member_port= query_get_value(SELECT Member_Port from performance_schema.replication_group_members, Member_Port, 1)
42 --let $assert_text= The value of member_port should be NULL before starting group replication
43 --let $assert_cond= "$member_port" = "NULL"
44 --source include/assert.inc
45
46 --let $member_state= query_get_value(SELECT Member_State from performance_schema.replication_group_members, Member_State, 1)
47 --let $assert_text= The value of member_state should be offline before starting group replication
48 --let $assert_cond= "$member_state" = "OFFLINE"
49 --source include/assert.inc
50
51 # Start Group Replication
52 --source include/start_and_bootstrap_group_replication.inc
53
54 --let $channel_name= query_get_value(SELECT Channel_Name from performance_schema.replication_group_members, Channel_Name, 1)
55 --let $assert_text= The value of channel name should be $group_replication_channel_name
56 --let $assert_cond= "$channel_name" = "$group_replication_channel_name"
57 --source include/assert.inc
58
59 --let $server_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
60 --let $member_id= query_get_value(SELECT Member_Id from performance_schema.replication_group_members, Member_Id, 1)
61 --let $assert_text= The value of member_id should be equal to server uuid after starting group replication
62 --let $assert_cond= "$member_id" = "$server_uuid"
63 --source include/assert.inc
64
65 --let $member_host= query_get_value(SELECT Member_Host from performance_schema.replication_group_members, Member_Host, 1)
66 --let $assert_text= The value of member_host should not be empty after starting group replication
67 --let $assert_cond= "$member_host" != ""
68 --source include/assert.inc
69
70 --let $member_port= query_get_value(SELECT Member_Port from performance_schema.replication_group_members, Member_Port, 1)
71 --let $assert_text= The value of member_port should not be NULL after starting group replication
72 --let $assert_cond= "$member_port" = "$MASTER_MYPORT"
73 --source include/assert.inc
74
75 --let $member_state= query_get_value(SELECT Member_State from performance_schema.replication_group_members, Member_State, 1)
76 --let $assert_text= The value of member_state should be online after starting group replication
77 --let $assert_cond= "$member_state" = "ONLINE"
78 --source include/assert.inc
79
80 # Stop Group Replication
81 --source include/stop_group_replication.inc
82
83 --let $channel_name= query_get_value(SELECT Channel_Name from performance_schema.replication_group_members, Channel_Name, 1)
84 --let $assert_text= The value of channel name should be $group_replication_channel_name
85 --let $assert_cond= "$channel_name" = "$group_replication_channel_name"
86 --source include/assert.inc
87
88 --let $member_state= query_get_value(SELECT Member_State from performance_schema.replication_group_members, Member_State, 1)
89 --let $assert_text= The value of member_state should be offline after stoping group replication
90 --let $assert_cond= "$member_state" = "OFFLINE"
91 --source include/assert.inc
92
93 # This restart tests that the plugin is still loaded on the server restart
94 --source include/restart_mysqld.inc
95
96 --let $member_state= query_get_value(SELECT Member_State from performance_schema.replication_group_members, Member_State, 1)
97 --let $assert_text= The value of member_state should be offline after restarting server
98 --let $assert_cond= "$member_state" = "OFFLINE"
99 --source include/assert.inc
100
101 --source include/gr_clear_configuration.inc