| Server IP : 104.21.38.3 / Your IP : 172.69.176.30 Web Server : Apache System : Linux krdc-ubuntu-s-2vcpu-4gb-amd-blr1-01.localdomain 5.15.0-142-generic #152-Ubuntu SMP Mon May 19 10:54:31 UTC 2025 x86_64 User : www ( 1000) PHP Version : 7.4.33 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /www/server/mysql/mysql-test/suite/group_replication/t/ |
Upload File : |
############################################################
# WL#9426: Single PRIMARY Mode in Group Replication
#
# This test checks the combinations of the options
# group_replication_enforce_update_everywhere_checks
# and
# group_replication_single_primary_mode
############################################################
--source ../inc/have_group_replication_plugin.inc
--let $rpl_skip_group_replication_start= 1
--let $saved_single_primary_mode= `SELECT @@GLOBAL.group_replication_single_primary_mode`
--let $saved_enforce_update_everywhere_checks= `SELECT @@GLOBAL.group_replication_enforce_update_everywhere_checks`
# restart MySQL Server with invalid single primary mode configuration
--let $rpl_connection_name= default
--source include/rpl_connection.inc
--let $_group_replication_local_address= `SELECT @@GLOBAL.group_replication_local_address`
--let $_group_replication_group_seeds= `SELECT @@GLOBAL.group_replication_group_seeds`
--let $_group_replication_group_whitelist= `SELECT @@GLOBAL.group_replication_ip_whitelist`
--let $restart_parameters=restart: --group_replication_enforce_update_everywhere_checks=ON --group_replication_single_primary_mode=ON --group_replication_local_address=$_group_replication_local_address --group_replication_group_seeds=$_group_replication_group_seeds --group-replication-group-name=$group_replication_group_name --group_replication_ip_whitelist=$_group_replication_group_whitelist
--replace_result $_group_replication_local_address GROUP_REPLICATION_LOCAL_ADDRESS $_group_replication_group_seeds GROUP_REPLICATION_GROUP_SEEDS $group_replication_group_name GROUP_REPLICATION_GROUP_NAME $_group_replication_group_whitelist GROUP_REPLICATION_GROUP_WHITELIST
--source include/restart_mysqld.inc
## verify that 'start group_replication' should fail when MySQL Server is started with
## invalid single primary mode configuration
--source ../inc/group_replication.inc
call mtr.add_suppression("Is is not allowed to run single primary mode with 'enforce_update_everywhere_checks' enabled.");
--error ER_GROUP_REPLICATION_CONFIGURATION
START GROUP_REPLICATION;
# set single primary mode configuration to valid values
SET GLOBAL group_replication_single_primary_mode= FALSE;
SET GLOBAL group_replication_enforce_update_everywhere_checks= FALSE;
## group_replication_single_primary_mode verifications
--error ER_WRONG_VALUE_FOR_VAR
SET GLOBAL group_replication_single_primary_mode= DEFAULT;
--error ER_WRONG_VALUE_FOR_VAR
SET GLOBAL group_replication_single_primary_mode= NULL;
--error ER_WRONG_VALUE_FOR_VAR
SET GLOBAL group_replication_single_primary_mode= "AAAAAA";
--let $assert_text= 'group_replication_single_primary_mode should be set to 0'
--let $assert_cond= [SELECT @@group_replication_single_primary_mode as value, value, 1] = 0
--source include/assert.inc
SET GLOBAL group_replication_single_primary_mode= TRUE;
--let $assert_text= 'group_replication_single_primary_mode should be set to 1'
--let $assert_cond= [SELECT @@group_replication_single_primary_mode as value, value, 1] = 1
--source include/assert.inc
SET GLOBAL group_replication_single_primary_mode= FALSE;
--let $assert_text= 'group_replication_single_primary_mode should be set to 0'
--let $assert_cond= [SELECT @@group_replication_single_primary_mode as value, value, 1] = 0
--source include/assert.inc
SET GLOBAL group_replication_single_primary_mode= ON;
--let $assert_text= 'group_replication_single_primary_mode should be set to ON'
--let $assert_cond= [SELECT @@group_replication_single_primary_mode as value, value, 1] = 1
--source include/assert.inc
SET GLOBAL group_replication_single_primary_mode= OFF;
--let $assert_text= 'group_replication_single_primary_mode should be set to OFF'
--let $assert_cond= [SELECT @@group_replication_single_primary_mode as value, value, 1] = 0
--source include/assert.inc
SET GLOBAL group_replication_single_primary_mode= -1;
--let $assert_text= 'group_replication_single_primary_mode should be set to 0'
--let $assert_cond= [SELECT @@group_replication_single_primary_mode as value, value, 1] = 0
--source include/assert.inc
SET GLOBAL group_replication_single_primary_mode= 100;
--let $assert_text= 'group_replication_single_primary_mode should be set to 1'
--let $assert_cond= [SELECT @@group_replication_single_primary_mode as value, value, 1] = 1
--source include/assert.inc
# disable single primary mode regardless
SET GLOBAL group_replication_single_primary_mode= FALSE;
## group_replication_enforce_update_everywhere_checks verifications
--error ER_WRONG_VALUE_FOR_VAR
SET GLOBAL group_replication_enforce_update_everywhere_checks= NULL;
--error ER_WRONG_VALUE_FOR_VAR
SET GLOBAL group_replication_enforce_update_everywhere_checks= "AAAAAA";
--let $assert_text= 'group_replication_enforce_update_everywhere_checks should be set to 0'
--let $assert_cond= [SELECT @@group_replication_enforce_update_everywhere_checks as value, value, 1] = 0
--source include/assert.inc
--error ER_WRONG_VALUE_FOR_VAR
SET GLOBAL group_replication_enforce_update_everywhere_checks= DEFAULT;
SET GLOBAL group_replication_enforce_update_everywhere_checks= TRUE;
--let $assert_text= 'group_replication_enforce_update_everywhere_checks should be set to 1'
--let $assert_cond= [SELECT @@group_replication_enforce_update_everywhere_checks as value, value, 1] = 1
--source include/assert.inc
SET GLOBAL group_replication_enforce_update_everywhere_checks= FALSE;
--let $assert_text= 'group_replication_enforce_update_everywhere_checks should be set to 0'
--let $assert_cond= [SELECT @@group_replication_enforce_update_everywhere_checks as value, value, 1] = 0
--source include/assert.inc
SET GLOBAL group_replication_enforce_update_everywhere_checks= ON;
--let $assert_text= 'group_replication_enforce_update_everywhere_checks should be set to ON'
--let $assert_cond= [SELECT @@group_replication_enforce_update_everywhere_checks as value, value, 1] = 1
--source include/assert.inc
SET GLOBAL group_replication_enforce_update_everywhere_checks= OFF;
--let $assert_text= 'group_replication_enforce_update_everywhere_checks should be set to OFF'
--let $assert_cond= [SELECT @@group_replication_enforce_update_everywhere_checks as value, value, 1] = 0
--source include/assert.inc
SET GLOBAL group_replication_enforce_update_everywhere_checks= -1;
--let $assert_text= 'group_replication_enforce_update_everywhere_checks should be set to 0'
--let $assert_cond= [SELECT @@group_replication_enforce_update_everywhere_checks as value, value, 1] = 0
--source include/assert.inc
SET GLOBAL group_replication_enforce_update_everywhere_checks= 100;
--let $assert_text= 'group_replication_enforce_update_everywhere_checks should be set to 1'
--let $assert_cond= [SELECT @@group_replication_enforce_update_everywhere_checks as value, value, 1] = 1
--source include/assert.inc
# assert that we cannot set single primary mode when
# enforce_update_everywhere_checks is set
SET GLOBAL group_replication_enforce_update_everywhere_checks= TRUE;
--error ER_WRONG_VALUE_FOR_VAR
SET GLOBAL group_replication_single_primary_mode= TRUE;
# now disable update everywhere checks so that one is able to
# enable single primary mode
SET GLOBAL group_replication_enforce_update_everywhere_checks= FALSE;
--let $assert_text= 'group_replication_enforce_update_everywhere_checks should be set to 0'
--let $assert_cond= [SELECT @@group_replication_enforce_update_everywhere_checks as value, value, 1] = 0
--source include/assert.inc
SET GLOBAL group_replication_single_primary_mode= TRUE;
--let $assert_text= 'group_replication_single_primary_mode should be set to 1'
--let $assert_cond= [SELECT @@group_replication_single_primary_mode as value, value, 1] = 1
--source include/assert.inc
# assert that we can set to other values
SET GLOBAL group_replication_single_primary_mode= FALSE;
--let $assert_text= 'group_replication_single_primary_mode should be set to 0'
--let $assert_cond= [SELECT @@group_replication_single_primary_mode as value, value, 1] = 0
--source include/assert.inc
SET GLOBAL group_replication_single_primary_mode= -1;
--let $assert_text= 'group_replication_single_primary_mode should be set to 0'
--let $assert_cond= [SELECT @@group_replication_single_primary_mode as value, value, 1] = 0
--source include/assert.inc
SET GLOBAL group_replication_single_primary_mode= 100;
--let $assert_text= 'group_replication_single_primary_mode should be set to 1'
--let $assert_cond= [SELECT @@group_replication_single_primary_mode as value, value, 1] = 1
--source include/assert.inc
# assert that we cannot set enforce update everywhere checks
# when single primary mode is ON
SET GLOBAL group_replication_single_primary_mode= TRUE;
--error ER_WRONG_VALUE_FOR_VAR
SET GLOBAL group_replication_enforce_update_everywhere_checks= TRUE;
# set both to false
SET GLOBAL group_replication_single_primary_mode= FALSE;
--let $assert_text= 'group_replication_single_primary_mode should be set to 0'
--let $assert_cond= [SELECT @@group_replication_single_primary_mode as value, value, 1] = 0
--source include/assert.inc
SET GLOBAL group_replication_enforce_update_everywhere_checks= FALSE;
--let $assert_text= 'group_replication_enforce_update_everywhere_checks should be set to 0'
--let $assert_cond= [SELECT @@group_replication_enforce_update_everywhere_checks as value, value, 1] = 0
--source include/assert.inc
# Lets start a group with single_primary_mode ON
SET GLOBAL group_replication_single_primary_mode= TRUE;
--let $assert_text= 'group_replication_single_primary_mode should be set to 1'
--let $assert_cond= [SELECT @@group_replication_single_primary_mode as value, value, 1] = 1
--source include/assert.inc
SET GLOBAL group_replication_enforce_update_everywhere_checks= FALSE;
--let $assert_text= 'group_replication_enforce_update_everywhere_checks should be set to 0'
--let $assert_cond= [SELECT @@group_replication_enforce_update_everywhere_checks as value, value, 1] = 0
--source include/assert.inc
--echo #
--echo # START GROUP REPLICATION ON SERVER 1
--source ../inc/start_and_bootstrap_group_replication.inc
--echo # PLUGIN VARIABLES SHOULD BE READ ONLY ON SERVER 1
--error ER_GROUP_REPLICATION_RUNNING
SET GLOBAL group_replication_single_primary_mode= TRUE;
--error ER_GROUP_REPLICATION_RUNNING
SET GLOBAL group_replication_enforce_update_everywhere_checks= TRUE;
--echo #
--echo # START GROUP REPLICATION ON SERVER 2
--let $rpl_connection_name= server2
--source include/rpl_connection.inc
SET GLOBAL group_replication_enforce_update_everywhere_checks= FALSE;
--let $assert_text= 'group_replication_enforce_update_everywhere_checks should be set to 0'
--let $assert_cond= [SELECT @@group_replication_enforce_update_everywhere_checks as value, value, 1] = 0
--source include/assert.inc
SET GLOBAL group_replication_single_primary_mode= TRUE;
--let $assert_text= 'group_replication_single_primary_mode should be set to 1'
--let $assert_cond= [SELECT @@group_replication_single_primary_mode as value, value, 1] = 1
--source include/assert.inc
--source include/start_group_replication.inc
--echo # PLUGIN VARIABLES SHOULD BE READ ONLY ON SERVER 2
--error ER_GROUP_REPLICATION_RUNNING
SET GLOBAL group_replication_single_primary_mode= TRUE;
--error ER_GROUP_REPLICATION_RUNNING
SET GLOBAL group_replication_enforce_update_everywhere_checks= TRUE;
--source ../inc/group_replication_end.inc
# restore single primary mode configuration system variables
--let $rpl_connection_name= server1
--source include/rpl_connection.inc
--eval SET @@GLOBAL.group_replication_single_primary_mode= $saved_single_primary_mode
--eval SET @@GLOBAL.group_replication_enforce_update_everywhere_checks= $saved_enforce_update_everywhere_checks
--let $rpl_connection_name= server2
--source include/rpl_connection.inc
--eval SET @@GLOBAL.group_replication_single_primary_mode= $saved_single_primary_mode
--eval SET @@GLOBAL.group_replication_enforce_update_everywhere_checks= $saved_enforce_update_everywhere_checks