| Server IP : 104.21.38.3 / Your IP : 162.158.108.34 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] # 0. The test requires two servers: M1 and M2. ############################################################# include/start_and_bootstrap_group_replication.inc # 1. Validate that independent of READ_ONLY and # SUPER_READ_ONLY state, they will be set to OFF after # start ############################################################# # 1.1. Set READ_ONLY=ON and start group replication, then # READ_ONLY and SUPER_READ_ONLY should be OFF ############################################################# SET GLOBAL read_only= 1; include/start_group_replication.inc # The server's super_read_only mode should be 0 here. include/assert.inc [The super_read_only mode should be 0 here.] # The server's read_only mode should be 0 here. include/assert.inc [The read_only mode should be 0 here.] # 1.2. Stop group replication and READ_ONLY and # SUPER_READ_ONLY should be ON ############################################################# include/stop_group_replication.inc # 1.3. Set SUPER_READ_ONLY=ON and start group replication, # then READ_ONLY and SUPER_READ_ONLY should be OFF ############################################################# SET GLOBAL super_read_only= 1; include/start_group_replication.inc # The server's super_read_only mode should be 0 here. include/assert.inc [The super_read_only mode should be 0 here.] # The server's read_only mode should be 0 here. include/assert.inc [The read_only mode should be 0 here.] # 1.4. Stop group replication and READ_ONLY and # SUPER_READ_ONLY should be ON ############################################################# include/stop_group_replication.inc # 2. Validate that independent of READ_ONLY and # SUPER_READ_ONLY state, they will be set to ON after # shutdown ############################################################# # 2.1. Start group replication, set READ_ONLY=ON and after # STOP GROUP_REPLICATION will put READ_ONLY and # SUPER_READ_ONLY to ON ############################################################# include/start_group_replication.inc SET GLOBAL read_only= 1; include/stop_group_replication.inc # 2.2. Start group replication, set SUPER_READ_ONLY=ON and # after STOP GROUP_REPLICATION will put READ_ONLY and # SUPER_READ_ONLY to ON ############################################################# include/start_group_replication.inc SET GLOBAL super_read_only= 1; include/stop_group_replication.inc include/group_replication_end.inc