| Server IP : 172.67.216.182 / Your IP : 172.68.164.62 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 [rpl_server_count=3] 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] # # Setup a new server group # server1 include/start_and_bootstrap_group_replication.inc server2 include/start_group_replication.inc # # Stop the applier on server 2 and stop group replication on server 1 # server2 STOP SLAVE SQL_THREAD FOR CHANNEL "group_replication_applier"; server1 include/stop_group_replication.inc # # Skip the View Change Event generated when server 1 left # server2 SET @@SESSION.GTID_NEXT= "fc0d4480-abd1-11e4-bcd8-0800200c9a66:3"; BEGIN; COMMIT; SET GTID_NEXT='AUTOMATIC'; START SLAVE SQL_THREAD FOR CHANNEL "group_replication_applier"; # # Check on server 3 that one of the View Change events was skipped # server3 include/start_group_replication.inc include/assert_binlog_events.inc [Gtid # Query/BEGIN # View_change # Query/COMMIT # Gtid # Query/BEGIN # View_change # Query/COMMIT # Gtid # Query/BEGIN # Query/COMMIT # Gtid # Query/BEGIN # View_change # Query/COMMIT] include/group_replication_end.inc