| Server IP : 104.21.38.3 / Your IP : 172.68.164.135 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] # # 1. Test local recovery # Start group_replication on the first node after setting the debug # point to block recovery. Check whether transactions can be executed. # SET @debug_save= @@GLOBAL.DEBUG; # Set the debug flag to block recovery at different stages. SET @@GLOBAL.DEBUG='+d,recovery_thread_start_wait'; include/start_group_replication.inc CREATE TABLE t1 (i INT NOT NULL PRIMARY KEY); ERROR HY000: The MySQL server is running with the --super-read-only option so it cannot execute this statement SET DEBUG_SYNC= "now SIGNAL signal.recovery_continue"; # Now wait for the node to be online include/gr_wait_for_member_state.inc # Table creation should pass as the single member is now recovered. CREATE TABLE t1 (i INT NOT NULL PRIMARY KEY); SET @@GLOBAL.DEBUG= @debug_save; # # 2. Test for a joining member # Start group_replication on the second member and block state transfer # Query execution should not be allowed # STOP SLAVE SQL_THREAD FOR CHANNEL "group_replication_applier"; include/start_group_replication.inc CREATE TABLE t2 (i INT NOT NULL PRIMARY KEY); ERROR HY000: The MySQL server is running with the --super-read-only option so it cannot execute this statement START SLAVE SQL_THREAD FOR CHANNEL "group_replication_applier"; include/gr_wait_for_member_state.inc # Table creation should pass as this node has now recovered. CREATE TABLE t2 (i INT NOT NULL PRIMARY KEY); # # Cleanup # DROP TABLE t1; DROP TABLE t2; include/group_replication_end.inc