################################################################################ # Test to verify the value of WRITE_CONSENSUS_SINGLE_LEADER_CAPABLE in # performance_schema.replication_group_communication_information # # Test: # ==== # 1. Start GR group with 3 servers. # 2. Value of WRITE_CONSENSUS_SINGLE_LEADER_CAPABLE is 0 on all servers. # 3. Change the value of group_replication_paxos_single_leader to 1 # on all servers and restart GR. # 4. Value of WRITE_CONSENSUS_SINGLE_LEADER_CAPABLE is 1 on all servers. # 5. Switch to single-primary mode. # 6. Value of WRITE_CONSENSUS_SINGLE_LEADER_CAPABLE is 1 on all servers. # 7. Change value of group_replication_paxos_single_leader to 1 on 2 servers. # 8. Value of WRITE_CONSENSUS_SINGLE_LEADER_CAPABLE is 1 on all servers. # 9. Change communication protocol to 8.0.21. # 10. Value of WRITE_CONSENSUS_SINGLE_LEADER_CAPABLE is 0 on all servers. # 11. Switch to multi-primary mode. # 12. Value of WRITE_CONSENSUS_SINGLE_LEADER_CAPABLE is 0 on all servers. # 13. Change communication protocol to 8.0.27. # 14. Value of WRITE_CONSENSUS_SINGLE_LEADER_CAPABLE is 1 on all servers. # 15. Cleanup # ################################################################################ --source include/big_test.inc --source include/have_group_replication_plugin.inc # 1. Start GR group with 3 servers --let $rpl_server_count = 3 --source include/group_replication.inc # 2. Value of WRITE_CONSENSUS_SINGLE_LEADER_CAPABLE is 0 on all servers. --let $single_leader_capable = 0 --source include/gr_assert_write_consensus_single_leader_capable.inc # 3. Change the value of group_replication_paxos_single_leader to 1 # on all servers and restart GR. --let $rpl_connection_name= server3 --source include/rpl_connection.inc --source include/stop_group_replication.inc --let $rpl_connection_name= server2 --source include/rpl_connection.inc --source include/stop_group_replication.inc --let $rpl_connection_name= server1 --source include/rpl_connection.inc --source include/stop_group_replication.inc SET GLOBAL group_replication_paxos_single_leader = 1; --source include/start_and_bootstrap_group_replication.inc --let $rpl_connection_name= server2 --source include/rpl_connection.inc SET GLOBAL group_replication_paxos_single_leader = 1; --source include/start_group_replication.inc --let $rpl_connection_name= server3 --source include/rpl_connection.inc SET GLOBAL group_replication_paxos_single_leader = 1; --source include/start_group_replication.inc # 4. Value of WRITE_CONSENSUS_SINGLE_LEADER_CAPABLE is 1 on all servers. --let $single_leader_capable = 1 --source include/gr_assert_write_consensus_single_leader_capable.inc # 5. Switch to single-primary mode. SELECT group_replication_switch_to_single_primary_mode(); # 6. Value of WRITE_CONSENSUS_SINGLE_LEADER_CAPABLE is 1 on all servers. --let $single_leader_capable = 1 --source include/gr_assert_write_consensus_single_leader_capable.inc # 7. Change value of group_replication_paxos_single_leader to 1 on 2 servers. --let $rpl_connection_name= server2 --source include/rpl_connection.inc SET GLOBAL group_replication_paxos_single_leader = 0; --let $rpl_connection_name= server3 --source include/rpl_connection.inc SET GLOBAL group_replication_paxos_single_leader = 0; # 8. Value of WRITE_CONSENSUS_SINGLE_LEADER_CAPABLE is 1 on all servers. --let $single_leader_capable = 1 --source include/gr_assert_write_consensus_single_leader_capable.inc # 9. Change communication protocol to 8.0.21. Must change # group_replication_paxos_single_leader to OFF --let $rpl_connection_name= server3 --source include/rpl_connection.inc --source include/stop_group_replication.inc --eval SET GLOBAL group_replication_paxos_single_leader = "OFF" --let $rpl_connection_name= server2 --source include/rpl_connection.inc --source include/stop_group_replication.inc --eval SET GLOBAL group_replication_paxos_single_leader = "OFF" --let $rpl_connection_name= server1 --source include/rpl_connection.inc --source include/stop_group_replication.inc --eval SET GLOBAL group_replication_paxos_single_leader = "OFF" --source include/start_and_bootstrap_group_replication.inc --let $rpl_connection_name= server2 --source include/rpl_connection.inc --source include/start_group_replication.inc --let $rpl_connection_name= server3 --source include/rpl_connection.inc --source include/start_group_replication.inc SELECT group_replication_set_communication_protocol("8.0.21"); # 10. Value of WRITE_CONSENSUS_SINGLE_LEADER_CAPABLE is 0 on all servers. --let $single_leader_capable = 0 --source include/gr_assert_write_consensus_single_leader_capable.inc # 11. Switch to multi-primary mode. SELECT group_replication_switch_to_multi_primary_mode(); # 12. Value of WRITE_CONSENSUS_SINGLE_LEADER_CAPABLE is 0 on all servers. --let $single_leader_capable = 0 --source include/gr_assert_write_consensus_single_leader_capable.inc # 13. Change communication protocol to 8.0.27. SELECT group_replication_set_communication_protocol("8.0.27"); --let $rpl_connection_name= server3 --source include/rpl_connection.inc --source include/stop_group_replication.inc --eval SET GLOBAL group_replication_paxos_single_leader = "ON" --let $rpl_connection_name= server2 --source include/rpl_connection.inc --source include/stop_group_replication.inc --eval SET GLOBAL group_replication_paxos_single_leader = "ON" --let $rpl_connection_name= server1 --source include/rpl_connection.inc --source include/stop_group_replication.inc --eval SET GLOBAL group_replication_paxos_single_leader = "ON" --source include/start_and_bootstrap_group_replication.inc --let $rpl_connection_name= server2 --source include/rpl_connection.inc --source include/start_group_replication.inc --let $rpl_connection_name= server3 --source include/rpl_connection.inc --source include/start_group_replication.inc # 14. Value of WRITE_CONSENSUS_SINGLE_LEADER_CAPABLE is 1 on all servers. --let $single_leader_capable = 1 --source include/gr_assert_write_consensus_single_leader_capable.inc # Cleanup # Change the value to 0 in all servers and restart GR. --let $rpl_connection_name= server3 --source include/rpl_connection.inc --source include/stop_group_replication.inc SET GLOBAL group_replication_paxos_single_leader = 0; --let $rpl_connection_name= server2 --source include/rpl_connection.inc --source include/stop_group_replication.inc SET GLOBAL group_replication_paxos_single_leader = 0; --let $rpl_connection_name= server1 --source include/rpl_connection.inc --source include/stop_group_replication.inc SET GLOBAL group_replication_paxos_single_leader = 0; --let $rpl_group_replication_reset_persistent_vars= 1 --source include/group_replication_end.inc