| Server IP : 172.67.216.182 / Your IP : 172.69.166.107 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 [rpl_server_count=3]
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]
############################################################
# 0. Error suppressions.
[connection server1]
SET SESSION sql_log_bin= 0;
call mtr.add_suppression("Member was expelled from the group due to network failures, changing member status to ERROR.");
SET SESSION sql_log_bin= 1;
############################################################
# 1. Suspend server 1 by sending a signal SIGSTOP to it.
# This will make server 1 to not answer to "I am alive"
# GCS messages and it will be expelled from the group.
[connection server1]
# Get server pid.
SET SESSION sql_log_bin= 0;
CREATE TABLE pid_table(pid_no INT);
LOAD DATA LOCAL INFILE 'pid_file' INTO TABLE pid_table;
DROP TABLE pid_table;
SET SESSION sql_log_bin= 1;
# Send signal SIGSTOP to server 1.
############################################################
# 2. Wait until group expel server 1.
[connection server2]
include/rpl_gr_wait_for_number_of_members.inc
[connection server3]
include/rpl_gr_wait_for_number_of_members.inc
############################################################
# 3. Resume server 1 by sending a signal SIGCONT to it.
# Server will notice that was expelled from the group,
# will change to ERROR state and enabled super_read_only
# mode.
[connection server1]
# Send signal SIGCONT to server 1.
include/gr_wait_for_member_state.inc
include/rpl_gr_wait_for_number_of_members.inc
CREATE TABLE te (c1 INT NOT NULL PRIMARY KEY);
ERROR HY000: The MySQL server is running with the --super-read-only option so it cannot execute this statement
############################################################
# 4. Stop and start server 1, it will be back to normal.
include/stop_group_replication.inc
include/start_group_replication.inc
CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY);
INSERT INTO t1 VALUES (1);
include/rpl_sync.inc
############################################################
# 5. Check data.
include/assert.inc ['There is a value 1 in table t1']
include/diff_tables.inc [server1:test.t1, server2:test.t1, server3:test.t1]
############################################################
# 6. Clean up.
DROP TABLE t1;
include/group_replication_end.inc