| Server IP : 172.67.216.182 / Your IP : 172.70.189.158 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/src/mysql-test/suite/rpl/r/ |
Upload File : |
include/master-slave.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 master] # Adding debug point 'set_commit_parent_100' to @@GLOBAL.debug CREATE TABLE t1 (a int primary key) engine=innodb; CREATE TABLE t2 (a int primary key) engine=innodb; CREATE TABLE t3 (a int primary key) engine=innodb; CREATE TABLE t4 (a int primary key) engine=innodb; include/sync_slave_sql_with_master.inc include/stop_slave_sql.inc # Adding debug point 'crash_in_a_worker' to @@GLOBAL.debug # Removing debug point 'set_commit_parent_100' from @@GLOBAL.debug # Adding debug point 'set_commit_parent_150' to @@GLOBAL.debug INSERT INTO t1 values (0); BEGIN; INSERT INTO t2 values (1),(2),(3); UPDATE t2 SET a= a+1 WHERE a=3; COMMIT; BEGIN; INSERT INTO t3 values (1),(2),(3); UPDATE t3 SET a= a+1 WHERE a=3; COMMIT; BEGIN; INSERT INTO t4 values (1),(2),(3); UPDATE t4 SET a= a+1 WHERE a=3; COMMIT; BEGIN; INSERT INTO t1 values (1),(2),(3); UPDATE t1 SET a= a+1 WHERE a=3; COMMIT; # Removing debug point 'set_commit_parent_150' from @@GLOBAL.debug include/sync_slave_io_with_master.inc [connection slave1] BEGIN; INSERT INTO t1 (a) VALUES (4); INSERT INTO t2 (a) VALUES (4); INSERT INTO t3 (a) VALUES (4); INSERT INTO t4 (a) VALUES (4); [connection slave] START SLAVE; include/rpl_start_server.inc [server_number=2] # Reconnecting to the slave server START SLAVE UNTIL SQL_AFTER_MTS_GAPS; CREATE TABLE t5 (a int); include/wait_for_slave_sql_to_stop.inc include/start_slave.inc DROP TABLES t1, t2, t3, t4, t5; include/sync_slave_sql_with_master.inc include/rpl_end.inc