| Server IP : 172.67.216.182 / Your IP : 172.71.82.69 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] [connection server2] SET @transaction_write_set_extraction_save= @@GLOBAL.transaction_write_set_extraction; [connection server1] SET @transaction_write_set_extraction_save= @@GLOBAL.transaction_write_set_extraction; # # 1. Try to change the algorithm while Group Replication is running. # It will be disallowed. # SET GLOBAL transaction_write_set_extraction='MURMUR32'; include/assert.inc [transaction_write_set_extraction is correct] include/start_and_bootstrap_group_replication.inc SET SESSION transaction_write_set_extraction=OFF; ERROR HY000: The write set algorithm cannot be changed when Group replication is running. SET SESSION transaction_write_set_extraction='XXHASH64'; ERROR HY000: The write set algorithm cannot be changed when Group replication is running. include/assert.inc [transaction_write_set_extraction is correct] # # 2. Try to join a member with a different algorithm # It will be disallowed. # [connection server2] SET GLOBAL transaction_write_set_extraction='XXHASH64'; 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. Matching lines are: DATE_TIME [ERROR] Plugin group_replication reported: 'The member is configured with a transaction-write-set-extraction option value 'XXHASH64' different from the group 'MURMUR32'. The member will now exit the group.' Occurrences of 'The member is configured with a transaction-write-set-extraction option value' in the input file: 1 # # 3. Cleanup # [connection server1] include/stop_group_replication.inc SET GLOBAL transaction_write_set_extraction= @transaction_write_set_extraction_save; [connection server2] SET GLOBAL transaction_write_set_extraction= @transaction_write_set_extraction_save; include/group_replication_end.inc