| Server IP : 172.67.216.182 / Your IP : 172.68.164.57 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 : |
################################################################################ # This test verifies that the CHANGE MASTER command is not logged in the binary # log. Therefore it is not replicated as well. # # Test: # 0. The test requires two servers: M1 and M2. # 1. Create a user on M1 to be used by the recovery channel. Bootstrap # GROUP on M1. Add some data for recovery. # 2. Start GR on M2 post CHANGE MASTER with valid values. Grep for # 'CHANGE MASTER' pattern in binary log data. Expect 0 count. # 3. Grep for 'CHANGE MASTER' pattern in binary log of M1. Expect 0 count. ################################################################################ --let $skip_recovery_configuration=1 --source ../inc/have_group_replication_plugin.inc --let $rpl_skip_group_replication_start= 1 --source ../inc/group_replication.inc # Start group replication on server1 --let $rpl_connection_name= server1 --source include/rpl_connection.inc --echo # Creating a connection on the first server to be used by the recovery channel SET sql_log_bin=0; CREATE USER 'manish'@'%' IDENTIFIED BY 'rpl'; GRANT REPLICATION SLAVE ON *.* TO 'manish'@'%'; FLUSH PRIVILEGES; SET sql_log_bin=1; --source ../inc/start_and_bootstrap_group_replication.inc # Add some data for recovery CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB; --let $rpl_connection_name= server2 --source include/rpl_connection.inc --echo # Second CHANGE MASTER with valid options will work fine. --disable_warnings CHANGE MASTER TO MASTER_USER='manish', MASTER_PASSWORD='rpl' FOR CHANNEL 'group_replication_recovery'; --enable_warnings --source include/start_group_replication.inc --let $MYSQLD_DATADIR= `select @@datadir;` --exec $MYSQL_BINLOG $MYSQLD_DATADIR/server-binary-log.000001 > $MYSQLTEST_VARDIR/tmp/change_master_server2.sql --echo # Asserting that CHANGE MASTER is not logged in the binary log of the server 2. --let $grep_file=$MYSQLTEST_VARDIR/tmp/change_master_server2.sql --let $grep_pattern= CHANGE MASTER --let $grep_output= print_count --source include/grep_pattern.inc --echo # Ensuring the the two members are online. --let $rpl_connection_name= server1 --source include/rpl_connection.inc --let $group_replication_number_of_members= 2 --source ../inc/gr_wait_for_number_of_members.inc --let $MYSQLD_DATADIR= `select @@datadir;` --exec $MYSQL_BINLOG $MYSQLD_DATADIR/server-binary-log.000001 > $MYSQLTEST_VARDIR/tmp/change_master_server1.sql --echo # Asserting that CHANGE MASTER is not replicated in the binary log of the server. --let $grep_file=$MYSQLTEST_VARDIR/tmp/change_master_server1.sql --let $grep_pattern= CHANGE MASTER --let $grep_output= print_count --source include/grep_pattern.inc #Cleanup --let $rpl_connection_name= server2 --source include/rpl_connection.inc RESET SLAVE ALL FOR CHANNEL 'group_replication_recovery'; --let $rpl_connection_name= server1 --source include/rpl_connection.inc --remove_file $MYSQLTEST_VARDIR/tmp/change_master_server1.sql --remove_file $MYSQLTEST_VARDIR/tmp/change_master_server2.sql DROP TABLE t1; SET sql_log_bin=0; DROP USER manish; SET sql_log_bin=1; --source ../inc/group_replication_end.inc