| Server IP : 172.67.216.182 / Your IP : 108.162.227.73 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. Verify lower_case_table_names cannot be set while server is
## running and start GR on server-1.
[connection server1]
SET GLOBAL lower_case_table_names= 1;
ERROR HY000: Variable 'lower_case_table_names' is a read only variable
include/start_and_bootstrap_group_replication.inc
## 2. Store variables of server-2 for restart.
[connection server2]
set session sql_log_bin=0;
call mtr.add_suppression("The member is configured with a lower_case_table_names option value .*");
call mtr.add_suppression("lower_case_table_names was set to 2, .*");
set session sql_log_bin=1;
## 3A. Test GR start with command when lower_case_table_names matches.
include/start_group_replication.inc
include/assert.inc ['Assert server-1 and server-2 are ONLINE']
## 3B. Test GR start on boot when lower_case_table_names matches.
# restart:--group_replication_start_on_boot=1 --group_replication_local_address=GROUP_REPLICATION_LOCAL_ADDRESS --group_replication_group_seeds=GROUP_REPLICATION_GROUP_SEEDS --group_replication_group_name=GROUP_REPLICATION_GROUP_NAME --lower_case_table_names=1 --group_replication_ip_whitelist=GROUP_REPLICATION_GROUP_WHITELIST
include/rpl_reconnect.inc
## 4A. Test GR does not start on boot when lower_case_table_names
## does not match.
# restart:--group_replication_start_on_boot=1 --group_replication_local_address=GROUP_REPLICATION_LOCAL_ADDRESS --group_replication_group_seeds=GROUP_REPLICATION_GROUP_SEEDS --group_replication_group_name=GROUP_REPLICATION_GROUP_NAME --lower_case_table_names=2 --group_replication_ip_whitelist=GROUP_REPLICATION_GROUP_WHITELIST
include/rpl_reconnect.inc
## 4B. Test GR does not start with command when lower_case_table_names
## does not match.
START GROUP_REPLICATION;
ERROR HY000: The server is not configured properly to be an active member of the group. Please see more details on error log.
include/assert_grep.inc [Found the expected error about lower_case_table_names]
include/assert.inc ['Assert server-2 is OFFLINE']
## 5. Cleanup.
include/group_replication_end.inc