131 lines
6.2 KiB
Plaintext
131 lines
6.2 KiB
Plaintext
################################################################################
|
|
# Verify that group_replication_transaction_size_limit options do behave as expected.
|
|
# 1. Test group_replication_transaction_size_limit option.
|
|
# 2. Change group_replication_transaction_size options while
|
|
# Group Replication is running.
|
|
# 3. Clean up.
|
|
################################################################################
|
|
--source include/have_group_replication_plugin.inc
|
|
--let $rpl_skip_group_replication_start= 1
|
|
--source include/group_replication.inc
|
|
|
|
SET @group_replication_transaction_size_limit_save= @@GLOBAL.group_replication_transaction_size_limit;
|
|
--let $group_replication_transaction_size_limit_max = 2147483647
|
|
--let $group_replication_transaction_size_limit_min = 0
|
|
--let $group_replication_transaction_size_limit_default = 150000000
|
|
################################################################################
|
|
--echo
|
|
--echo ## 1. Test group_replication_transaction_size_limit option.
|
|
# Invalid values
|
|
--error ER_WRONG_TYPE_FOR_VAR
|
|
SET GLOBAL group_replication_transaction_size_limit= "";
|
|
|
|
--error ER_WRONG_TYPE_FOR_VAR
|
|
SET GLOBAL group_replication_transaction_size_limit= "ABC";
|
|
|
|
--disable_warnings
|
|
SET GLOBAL group_replication_transaction_size_limit= 2147483648;
|
|
--let $assert_text= group_replication_transaction_size_limit is max
|
|
--let $assert_cond= [SELECT @@GLOBAL.group_replication_transaction_size_limit] = $group_replication_transaction_size_limit_max
|
|
--source include/assert.inc
|
|
|
|
SET GLOBAL group_replication_transaction_size_limit= -1;
|
|
--let $assert_text= group_replication_transaction_size_limit is min
|
|
--let $assert_cond= [SELECT @@GLOBAL.group_replication_transaction_size_limit] = $group_replication_transaction_size_limit_min
|
|
--source include/assert.inc
|
|
|
|
SET GLOBAL group_replication_transaction_size_limit= 3000000000;
|
|
--let $assert_text= group_replication_transaction_size_limit is max
|
|
--let $assert_cond= [SELECT @@GLOBAL.group_replication_transaction_size_limit] = $group_replication_transaction_size_limit_max
|
|
--source include/assert.inc
|
|
|
|
SET GLOBAL group_replication_transaction_size_limit= -2;
|
|
--let $assert_text= group_replication_transaction_size_limit is min
|
|
--let $assert_cond= [SELECT @@GLOBAL.group_replication_transaction_size_limit] = $group_replication_transaction_size_limit_min
|
|
--source include/assert.inc
|
|
--enable_warnings
|
|
|
|
# Valid values
|
|
SET GLOBAL group_replication_transaction_size_limit= 1;
|
|
--let $assert_text= group_replication_transaction_size_limit is correct
|
|
--let $assert_cond= [SELECT @@GLOBAL.group_replication_transaction_size_limit] = 1
|
|
--source include/assert.inc
|
|
|
|
SET GLOBAL group_replication_transaction_size_limit= 0;
|
|
--let $assert_text= group_replication_transaction_size_limit is correct
|
|
--let $assert_cond= [SELECT @@GLOBAL.group_replication_transaction_size_limit] = 0
|
|
--source include/assert.inc
|
|
|
|
SET GLOBAL group_replication_transaction_size_limit= 1024;
|
|
--let $assert_text= group_replication_transaction_size_limit is correct
|
|
--let $assert_cond= [SELECT @@GLOBAL.group_replication_transaction_size_limit] = 1024
|
|
--source include/assert.inc
|
|
|
|
SET GLOBAL group_replication_transaction_size_limit= 2147483647;
|
|
--let $assert_text= group_replication_transaction_size_limit is correct
|
|
--let $assert_cond= [SELECT @@GLOBAL.group_replication_transaction_size_limit] = 2147483647
|
|
--source include/assert.inc
|
|
|
|
# Reset value to default for further testing
|
|
SET GLOBAL group_replication_transaction_size_limit= default;
|
|
--let $assert_text= group_replication_transaction_size_limit is correct
|
|
--let $assert_cond= [SELECT @@GLOBAL.group_replication_transaction_size_limit] = $group_replication_transaction_size_limit_default
|
|
--source include/assert.inc
|
|
################################################################################
|
|
--echo
|
|
--echo ## 2. Change group_replication_transaction_size options while
|
|
--echo ## Group Replication is running.
|
|
--source include/start_and_bootstrap_group_replication.inc
|
|
|
|
# Invalid values
|
|
--error ER_WRONG_TYPE_FOR_VAR
|
|
SET GLOBAL group_replication_transaction_size_limit= "";
|
|
|
|
--error ER_WRONG_TYPE_FOR_VAR
|
|
SET GLOBAL group_replication_transaction_size_limit= "ABC";
|
|
|
|
--disable_warnings
|
|
SET GLOBAL group_replication_transaction_size_limit= 2147483648;
|
|
--let $assert_text= group_replication_transaction_size_limit is max
|
|
--let $assert_cond= [SELECT @@GLOBAL.group_replication_transaction_size_limit] = $group_replication_transaction_size_limit_max
|
|
--source include/assert.inc
|
|
|
|
SET GLOBAL group_replication_transaction_size_limit= -1;
|
|
--let $assert_text= group_replication_transaction_size_limit is min
|
|
--let $assert_cond= [SELECT @@GLOBAL.group_replication_transaction_size_limit] = $group_replication_transaction_size_limit_min
|
|
--source include/assert.inc
|
|
|
|
SET GLOBAL group_replication_transaction_size_limit= 3000000000;
|
|
--let $assert_text= group_replication_transaction_size_limit is max
|
|
--let $assert_cond= [SELECT @@GLOBAL.group_replication_transaction_size_limit] = $group_replication_transaction_size_limit_max
|
|
--source include/assert.inc
|
|
|
|
SET GLOBAL group_replication_transaction_size_limit= -2;
|
|
--let $assert_text= group_replication_transaction_size_limit is min
|
|
--let $assert_cond= [SELECT @@GLOBAL.group_replication_transaction_size_limit] = $group_replication_transaction_size_limit_min
|
|
--source include/assert.inc
|
|
--enable_warnings
|
|
|
|
#Valid values
|
|
SET GLOBAL group_replication_transaction_size_limit= 1024;
|
|
--let $assert_text= group_replication_transaction_size_limit is correct
|
|
--let $assert_cond= [SELECT @@GLOBAL.group_replication_transaction_size_limit] = 1024
|
|
--source include/assert.inc
|
|
|
|
SET GLOBAL group_replication_transaction_size_limit= 2147483647;
|
|
--let $assert_text= group_replication_transaction_size_limit is correct
|
|
--let $assert_cond= [SELECT @@GLOBAL.group_replication_transaction_size_limit] = 2147483647
|
|
--source include/assert.inc
|
|
|
|
SET GLOBAL group_replication_transaction_size_limit= 0;
|
|
--let $assert_text= group_replication_transaction_size_limit is correct
|
|
--let $assert_cond= [SELECT @@GLOBAL.group_replication_transaction_size_limit] = 0
|
|
--source include/assert.inc
|
|
|
|
################################################################################
|
|
--echo
|
|
--echo ## 3. Clean up.
|
|
SET GLOBAL group_replication_transaction_size_limit= @group_replication_transaction_size_limit_save;
|
|
|
|
--source include/group_replication_end.inc
|