| Server IP : 172.67.216.182 / Your IP : 104.23.175.30 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. Create a table on the group. CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB; include/rpl_sync.inc ############################################################ # 2. Execute some transactions on both members. # Transactions executed on member 1 will be on member 2 # applier channel received_transaction_set, and the dual # for member 2 transactions. include/rpl_sync.inc ############################################################ # 3. Assert that both members have holes on its applier # channel received_transaction_set. # The holes are expected and despite them members data is # equal. [connection server1] include/assert.inc [The value of received_transaction_set must have holes] [connection server2] include/assert.inc [The value of received_transaction_set must have holes] include/diff_tables.inc [server1:test.t1, server2:test.t1] ############################################################ # 4. Wait for stable set propagation and certification info # garbage collection. When that happens, the holes on # applier channel will be filled. [connection server1] ############################################################ # 5. Assert that both members dot not have holes on their # applier channel received_transaction_set. [connection server1] include/assert.inc [The value of received_transaction_set must not have holes] [connection server2] include/assert.inc [The value of received_transaction_set must not have holes] ############################################################ # 6. Clean up. DROP TABLE t1; include/group_replication_end.inc