Debian Codegraph @

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

raw
1 ################################################################################
2 # Base test to verify the values of prerequisite variables for group replication
3 #
4 # Test:
5 # 0. The test requires one server.
6 # 1. Verify the GR compatible values of prerequisite variables.
7 ################################################################################
8
9 --let $transaction_write_set_extraction= aaaaaaaa-bbbb-aaaa-bbbb-aaaaaaaaaaaa
10 --source include/have_group_replication_plugin.inc
11 --let $rpl_skip_group_replication_start= 1
12 --source include/group_replication.inc
13
14 --let $rpl_connection_name= server1
15 --source include/rpl_connection.inc
16 --source include/start_and_bootstrap_group_replication.inc
17
18 --echo #
19 --echo # Check that member is up and running successfully.
20 SELECT MEMBER_STATE FROM performance_schema.replication_group_members;
21
22 --echo #
23 --echo # Verify the GR compatible values of prerequisite variables.
24 --echo # Curently there are 9 prerequisite variables.
25 --echo #
26
27 # binlog_format
28 --let $assert_text= GR compatible value of binlog_format is ROW
29 --let $assert_cond= "[SELECT @@GLOBAL.binlog_format]" = "ROW"
30 --source include/assert.inc
31
32 # enforce_gtid_consistency
33 --let $assert_text= GR compatible value of enforce_gtid_consistency is ON
34 --let $assert_cond= "[SELECT @@GLOBAL.enforce_gtid_consistency]" = "ON"
35 --source include/assert.inc
36
37 # gtid_mode
38 --let $assert_text= GR compatible value of gtid_mode is ON
39 --let $assert_cond= "[SELECT @@GLOBAL.gtid_mode]" = "ON"
40 --source include/assert.inc
41
42 # log_bin
43 --let $assert_text= GR compatible value of log_bin is 1/ON
44 --let $assert_cond= "[SELECT @@GLOBAL.log_bin]" = 1
45 --source include/assert.inc
46
47 # log_replica_updates
48 --let $assert_text= GR compatible value of log_replica_updates is 1/ON
49 --let $assert_cond= "[SELECT @@GLOBAL.log_replica_updates]" = 1
50 --source include/assert.inc
51
52 # master_info_repository
53 --let $assert_text= GR compatible value of master_info_repository is TABLE
54 --let $assert_cond= "[SELECT @@GLOBAL.master_info_repository]" = "TABLE"
55 --source include/assert.inc
56
57 # relay_log_info_repository
58 --let $assert_text= GR compatible value of relay_log_info_repository is TABLE
59 --let $assert_cond= "[SELECT @@GLOBAL.relay_log_info_repository]" = "TABLE"
60 --source include/assert.inc
61
62 # transaction_write_set_extraction
63 --let $assert_text= GR compatible values of transaction_write_set_extraction are XXHASH64 and MURMUR32
64 --let $assert_cond= "[SELECT @@GLOBAL.transaction_write_set_extraction IN (\'XXHASH64\', \'MURMUR32\')]" = 1
65 --source include/assert.inc
66
67 --source include/group_replication_end.inc