403Webshell
Server IP : 172.67.216.182  /  Your IP : 162.158.163.171
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 :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ Back ]     

Current File : /www/server/mysql/mysql-test/suite/group_replication/t/gr_perfschema_group_members_number.test
################################################################################
# WL#7331: Check that member status are properly updated when members join
# and leave group.
#
# Test:
# 0. The test requires three servers: M1, M2 and M3.
# 1. Initially, check no members on the group.
# 2. Bootstrap start M1. Check one member on the group.
# 3. Start M2. Check two members on the group.
# 4. Start M3. Check three members on the group.
# 5. Stop M1. Check two members on the group.
# 6. Stop M2. Check one member on the group.
# 7. Stop M3. Check no members on the group.
################################################################################
--let $group_replication_group_name= 8a94f357-aab4-11df-86ab-c80aa9429500
--source ../inc/have_group_replication_plugin.inc
--let $rpl_skip_group_replication_start= 1
--let $rpl_server_count= 3
--source ../inc/group_replication.inc

--echo
--echo ###########################################################
--echo # 1. No members on group.
--connection server1
--let $group_replication_number_of_members= 0
--source ../inc/gr_wait_for_number_of_members.inc

--connection server2
--let $group_replication_number_of_members= 0
--source ../inc/gr_wait_for_number_of_members.inc

--connection server3
--let $group_replication_number_of_members= 0
--source ../inc/gr_wait_for_number_of_members.inc


--echo
--echo ###########################################################
--echo # 2. One member on group.
--connection server1
--source ../inc/start_and_bootstrap_group_replication.inc

--connection server1
--let $group_replication_number_of_members= 1
--source ../inc/gr_wait_for_number_of_members.inc

--connection server2
--let $group_replication_number_of_members= 0
--source ../inc/gr_wait_for_number_of_members.inc

--connection server3
--let $group_replication_number_of_members= 0
--source ../inc/gr_wait_for_number_of_members.inc


--echo
--echo ###########################################################
--echo # 3. Two members on group.
--connection server2
--source include/start_group_replication.inc

--connection server1
--let $group_replication_number_of_members= 2
--source ../inc/gr_wait_for_number_of_members.inc

--connection server2
--let $group_replication_number_of_members= 2
--source ../inc/gr_wait_for_number_of_members.inc

--connection server3
--let $group_replication_number_of_members= 0
--source ../inc/gr_wait_for_number_of_members.inc


--echo
--echo ###########################################################
--echo # 4. Three members on group.
--connection server3
--source include/start_group_replication.inc

--connection server1
--let $group_replication_number_of_members= 3
--source ../inc/gr_wait_for_number_of_members.inc

--connection server2
--let $group_replication_number_of_members= 3
--source ../inc/gr_wait_for_number_of_members.inc

--connection server3
--let $group_replication_number_of_members= 3
--source ../inc/gr_wait_for_number_of_members.inc

--replace_column 2 MEMBER_ID 3 MEMBER_HOST 4 MEMBER_PORT
SELECT * FROM performance_schema.replication_group_members;


--echo
--echo ###########################################################
--echo # 5. Two members on group.
--connection server1
--source include/stop_group_replication.inc

--connection server1
--let $group_replication_number_of_members= 0
--source ../inc/gr_wait_for_number_of_members.inc

--connection server2
--let $group_replication_number_of_members= 2
--source ../inc/gr_wait_for_number_of_members.inc

--connection server3
--let $group_replication_number_of_members= 2
--source ../inc/gr_wait_for_number_of_members.inc


--echo
--echo ###########################################################
--echo # 6. One member on group.
--connection server2
--source include/stop_group_replication.inc

--connection server1
--let $group_replication_number_of_members= 0
--source ../inc/gr_wait_for_number_of_members.inc

--connection server2
--let $group_replication_number_of_members= 0
--source ../inc/gr_wait_for_number_of_members.inc

--connection server3
--let $group_replication_number_of_members= 1
--source ../inc/gr_wait_for_number_of_members.inc


--echo
--echo ###########################################################
--echo # 7. No members on group.
--connection server3
--source include/stop_group_replication.inc

--let $group_replication_number_of_members= 0
--connection server1
--source ../inc/gr_wait_for_number_of_members.inc

--connection server2
--let $group_replication_number_of_members= 0
--source ../inc/gr_wait_for_number_of_members.inc

--connection server3
--let $group_replication_number_of_members= 0
--source ../inc/gr_wait_for_number_of_members.inc

--source ../inc/group_replication_end.inc

Youez - 2016 - github.com/yon3zu
LinuXploit