| Server IP : 104.21.38.3 / Your IP : 172.71.124.222 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/r/ |
Upload File : |
include/group_replication.inc
Warnings:
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
[connection server1]
[connection server2]
SET SESSION sql_log_bin= 0;
call mtr.add_suppression("Member is not ONLINE, it is not possible to force a new group membership");
call mtr.add_suppression("group_replication_force_members must be empty on group start. Current value: '127.0.0.1:10000'");
call mtr.add_suppression("Unable to start Group Replication on boot");
call mtr.add_suppression("force_members can only be updated when Group Replication is running*");
call mtr.add_suppression("The member lost contact with a majority of the members in the group. Until the network is restored.*");
call mtr.add_suppression("\\[GCS\\] Peer address .* is not valid.");
call mtr.add_suppression("\\[GCS\\] The peers list contains invalid addresses. Please provide a list with only valid addresses.");
call mtr.add_suppression("Error setting group_replication_force_members value .* on group communication interfaces");
call mtr.add_suppression("The member resumed contact with a majority of the members in the group.*");
SET SESSION sql_log_bin= 1;
[connection server1]
SET SESSION sql_log_bin= 0;
call mtr.add_suppression("Member is OFFLINE, it is not possible to force a new group membership");
call mtr.add_suppression("force_members can only be updated when Group Replication is running*");
SET SESSION sql_log_bin= 1;
############################################################
# 1. Set empty string value to
# group_replication_force_members on a OFFLINE
# member.
SET GLOBAL group_replication_force_members= "";
include/assert.inc [group_replication_force_members is empty]
############################################################
# 2. Set group_replication_force_members on a OFFLINE
# member.
SET GLOBAL group_replication_force_members= "127.0.0.1:10000";
ERROR 42000: Variable 'group_replication_force_members' can't be set to the value of '127.0.0.1:10000'
include/assert.inc [group_replication_force_members is empty]
############################################################
# 3. Set empty string value to
# group_replication_force_members on a ONLINE
# member.
include/start_and_bootstrap_group_replication.inc
SET GLOBAL group_replication_force_members= "";
include/assert.inc [group_replication_force_members is empty]
############################################################
# 4. Set valid IP string value to
# group_replication_force_members on a ONLINE member and
# majority of group members are reachable
SET GLOBAL group_replication_force_members= "127.0.0.1:10001";
ERROR 42000: Variable 'group_replication_force_members' can't be set to the value of '127.0.0.1:10001'
include/assert.inc [group_replication_force_members is empty]
############################################################
# 5. Set empty string value to
# group_replication_force_members on a RECOVERING
# member.
STOP SLAVE SQL_THREAD FOR CHANNEL "group_replication_applier";
[connection server2]
include/start_group_replication.inc
SET GLOBAL group_replication_force_members= "";
include/assert.inc [group_replication_force_members is empty]
############################################################
# 6. Set group_replication_force_members on a RECOVERING
# member.
include/gr_wait_for_member_state.inc
SET GLOBAL group_replication_force_members= "127.0.0.1:10000";
ERROR 42000: Variable 'group_replication_force_members' can't be set to the value of '127.0.0.1:10000'
[connection server1]
START SLAVE SQL_THREAD FOR CHANNEL "group_replication_applier";
[connection server2]
include/gr_wait_for_member_state.inc
############################################################
# 7. Restart member with group_replication_force_members
# set. Group Replication start will error out.
# 2 members.
[connection server2]
# restart:--group_replication_local_address=GROUP_REPLICATION_LOCAL_ADDRESS --group_replication_group_seeds=GROUP_REPLICATION_GROUP_SEEDS --group_replication_start_on_boot=1 --group-replication-group-name=GROUP_REPLICATION_GROUP_NAME --group_replication_force_members=127.0.0.1:10000 --group_replication_ip_whitelist=GROUP_REPLICATION_GROUP_WHITELIST
include/rpl_reconnect.inc
include/assert.inc [Member 2 is OFFLINE]
############################################################
# 8. Start Group Replication while
# group_replication_force_members is set. Start
# will error out.
include/assert.inc [group_replication_force_members must be 127.0.0.1:10000]
START GROUP_REPLICATION;
ERROR HY000: The server is not configured properly to be an active member of the group. Please see more details on error log.
include/assert.inc [Member 2 is OFFLINE]
############################################################
# 9. Clear group_replication_force_members and start
# Group Replication. Group will have the 2 members.
SET GLOBAL group_replication_force_members= "";
include/assert.inc [group_replication_force_members is empty]
include/start_group_replication.inc
[connection server1]
include/rpl_gr_wait_for_number_of_members.inc
include/assert.inc [Server 1 must be present on group members]
include/assert.inc [Server 2 must be present on group members]
[connection server2]
include/rpl_gr_wait_for_number_of_members.inc
include/assert.inc [Server 1 must be present on group members]
include/assert.inc [Server 2 must be present on group members]
include/assert.inc [group_replication_force_members must be empty]
############################################################
# 10. Kill and restart a member to group loose majority.
[connection server1]
# Kill and restart:--group_replication_local_address=GROUP_REPLICATION_LOCAL_ADDRESS1 --group_replication_group_seeds=GROUP_REPLICATION_GROUP_SEEDS --group_replication_group_name=GROUP_REPLICATION_GROUP_NAME --group_replication_ip_whitelist=GROUP_REPLICATION_GROUP_WHITELIST
include/rpl_reconnect.inc
[connection server2]
include/gr_wait_for_member_state.inc
############################################################
# 11. Set invalid IP string value to
# group_replication_force_members on a ONLINE member and
# majority of group members are unreachable.
SET GLOBAL group_replication_force_members= "256.256.256.777:1234";
ERROR 42000: Variable 'group_replication_force_members' can't be set to the value of '256.256.256.777:1234'
include/assert.inc [group_replication_force_members is empty]
############################################################
# 12. Set valid IP string value to
# group_replication_force_members on a ONLINE member and
# majority of group members are unreachable
SET GLOBAL group_replication_force_members= "GROUP_REPLICATION_LOCAL_ADDRESS1";
include/assert.inc [group_replication_force_members has member2 local address]
############################################################
# 11. Clean up.
[connection server1]
include/start_group_replication.inc
include/group_replication_end.inc