| Server IP : 104.21.38.3 / Your IP : 162.158.108.131 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 : |
SET GLOBAL group_replication_group_name= "GROUP_REPLICATION_GROUP_NAME";
#
# Test if binlog_checksum with the wrong value will fail.
#
SET GLOBAL binlog_checksum= CRC32;
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.
SET GLOBAL binlog_checksum= NONE;
#
# Test if binlog_format with the wrong value will fail.
#
SET GLOBAL binlog_format= STATEMENT;
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.
SET GLOBAL binlog_format= ROW;
SET GLOBAL transaction_write_set_extraction=OFF;
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.
SET GLOBAL transaction_write_set_extraction= WRITE_SET_EXTRACTION_ALGORITHM;
#
# Test if parallel applier is enabled and that start
# Group Replication will fail.
#
SET @slave_parallel_type_saved= @@GLOBAL.SLAVE_PARALLEL_TYPE;
SET @slave_parallel_workers_saved= @@GLOBAL.SLAVE_PARALLEL_WORKERS;
SET @@GLOBAL.SLAVE_PARALLEL_TYPE= "DATABASE";
SET GLOBAL SLAVE_PARALLEL_WORKERS= 4;
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.
SET @@GLOBAL.SLAVE_PARALLEL_TYPE= "LOGICAL_CLOCK";
SET GLOBAL SLAVE_PARALLEL_WORKERS= 4;
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.
SET @@GLOBAL.SLAVE_PARALLEL_TYPE= @slave_parallel_type_saved;
SET @@GLOBAL.SLAVE_PARALLEL_WORKERS= @slave_parallel_workers_saved;
call mtr.add_suppression("binlog_checksum should be NONE for Group Replication");
call mtr.add_suppression("Binlog format should be ROW for Group Replication");
call mtr.add_suppression("Extraction of transaction write sets requires*");
call mtr.add_suppression("In order to use parallel applier on Group Replication, parameter slave-parallel-type must be set to 'LOGICAL_CLOCK'");
call mtr.add_suppression("Group Replication requires slave-preserve-commit-order to be set to ON when using more than 1 applier threads.");