############################################################ # WL#9426: Single Primary Mode in Group Replication # # This test verifies some incompatible configuration modes # servers join the group. E.g., some have primary mode off # while the group is operating in single primary mode. # ############################################################ --source include/big_test.inc --source include/have_group_replication_plugin.inc --source include/force_restart.inc --let $rpl_skip_group_replication_start= 1 --let $rpl_group_replication_single_primary_mode=1 --source include/group_replication.inc --echo --echo ## START MASTER SERVER 1 (SINGLE PRIMARY) --let $rpl_connection_name= server1 --source include/rpl_connection.inc SET GLOBAL group_replication_enforce_update_everywhere_checks= 0; SET GLOBAL group_replication_single_primary_mode= 1; --source include/start_and_bootstrap_group_replication.inc --echo --echo ## TRY TO START SERVER 2 (INVALID CONFIGURATION 1 - MULTI MASTER + NO ENFORCE CHECK) --let $rpl_connection_name= server2 --source include/rpl_connection.inc SET SQL_LOG_BIN=0; call mtr.add_suppression("The member configuration is not compatible with the group configuration. .* .member configuration option: \\[\\], group configuration option: \\[group_replication_single_primary_mode\\]."); call mtr.add_suppression("The member configuration is not compatible with the group configuration. .* .member configuration option: \\[group_replication_enforce_update_everywhere_checks\\], group configuration option: \\[group_replication_single_primary_mode\\]."); call mtr.add_suppression("The member configuration is not compatible with the group configuration. .* .member configuration option: \\[\\], group configuration option: \\[group_replication_enforce_update_everywhere_checks\\]."); call mtr.add_suppression("The member configuration is not compatible with the group configuration. .* .member configuration option: \\[group_replication_single_primary_mode\\], group configuration option: \\[group_replication_enforce_update_everywhere_checks\\]."); call mtr.add_suppression("The member configuration is not compatible with the group configuration. .* .member configuration option: \\[group_replication_enforce_update_everywhere_checks\\], group configuration option: \\[\\]."); call mtr.add_suppression("The member configuration is not compatible with the group configuration. .* .member configuration option: \\[group_replication_single_primary_mode\\], group configuration option: \\[\\]."); call mtr.add_suppression("This member joined a group on which all members do not support member actions, as such it did reset its member configuration to the default one."); call mtr.add_suppression("This member joined a group on which all members do not support replication failover channels integration on Group Replication, as such it did reset its replication failover channels configuration to the default one."); SET SQL_LOG_BIN=1; SET GLOBAL group_replication_enforce_update_everywhere_checks= 0; SET GLOBAL group_replication_single_primary_mode= 0; --replace_result $group_replication_group_name GROUP_REPLICATION_GROUP_NAME --eval SET GLOBAL group_replication_group_name= "$group_replication_group_name" --error ER_GROUP_REPLICATION_CONFIGURATION START GROUP_REPLICATION; --echo --echo ## TRY TO START SERVER 2 (INVALID CONFIGURATION 2 - MULTI MASTER + ENFORCE CHECK) --let $rpl_connection_name= server2 --source include/rpl_connection.inc SET GLOBAL group_replication_enforce_update_everywhere_checks= 1; SET GLOBAL group_replication_single_primary_mode= 0; --error ER_GROUP_REPLICATION_CONFIGURATION START GROUP_REPLICATION; --echo --echo ## RESTART MASTER SERVER 1 (MULTI MASTER + ENFORCED CHECK) --let $rpl_connection_name= server1 --source include/rpl_connection.inc --source include/stop_group_replication.inc SET GLOBAL group_replication_single_primary_mode= 0; SET GLOBAL group_replication_enforce_update_everywhere_checks= 1; --source include/start_and_bootstrap_group_replication.inc --echo --echo ## TRY TO START SERVER 2 (INVALID CONFIGURATION 3 - MULTI MASTER + NO ENFORCED CHECK) --let $rpl_connection_name= server2 --source include/rpl_connection.inc SET GLOBAL group_replication_enforce_update_everywhere_checks= 0; SET GLOBAL group_replication_single_primary_mode= 0; --error ER_GROUP_REPLICATION_CONFIGURATION START GROUP_REPLICATION; --echo --echo ## TRY TO START SERVER 2 (INVALID CONFIGURATION 4 - SINGLE MASTER + NO ENFORCED CHECK) SET GLOBAL group_replication_enforce_update_everywhere_checks= 0; SET GLOBAL group_replication_single_primary_mode= 1; --error ER_GROUP_REPLICATION_CONFIGURATION START GROUP_REPLICATION; --echo --echo ## TRY TO START SERVER 2 (VALID CONFIGURATION 5 - MULTI MASTER + ENFORCED CHECK) SET GLOBAL group_replication_single_primary_mode= 0; SET GLOBAL group_replication_enforce_update_everywhere_checks= 1; --source include/start_group_replication.inc --source include/stop_group_replication.inc --echo --echo ## RESTART MASTER SERVER 1 (MULTI MASTER + NO ENFORCED CHECK) --let $rpl_connection_name= server1 --source include/rpl_connection.inc --source include/stop_group_replication.inc SET GLOBAL group_replication_single_primary_mode= 0; SET GLOBAL group_replication_enforce_update_everywhere_checks= 0; --source include/start_and_bootstrap_group_replication.inc --echo --echo ## TRY TO START SERVER 2 (INVALID CONFIGURATION 6 - SINGLE MASTER + NO ENFORCED CHECK) --let $rpl_connection_name= server2 --source include/rpl_connection.inc SET GLOBAL group_replication_enforce_update_everywhere_checks= 0; SET GLOBAL group_replication_single_primary_mode= 1; --error ER_GROUP_REPLICATION_CONFIGURATION START GROUP_REPLICATION; --echo --echo ## TRY TO START SERVER 2 (INVALID CONFIGURATION 7 - MULTI MASTER + ENFORCE CHECK) --let $rpl_connection_name= server2 --source include/rpl_connection.inc SET GLOBAL group_replication_single_primary_mode= 0; SET GLOBAL group_replication_enforce_update_everywhere_checks= 1; --error ER_GROUP_REPLICATION_CONFIGURATION START GROUP_REPLICATION; --echo --echo ## TRY TO START SERVER 2 (VALID CONFIGURATION 8 - MULTI MASTER + NO ENFORCED CHECK) --let $rpl_connection_name= server2 --source include/rpl_connection.inc SET GLOBAL group_replication_enforce_update_everywhere_checks= 0; SET GLOBAL group_replication_single_primary_mode= 0; --source include/start_group_replication.inc --let $server_num= 2 while($server_num>0) { --let $rpl_connection_name= server$server_num --source include/rpl_connection.inc --source include/stop_group_replication.inc --dec $server_num } --source include/group_replication_end.inc