| Server IP : 172.67.216.182 / Your IP : 172.70.208.126 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 : |
# Create channel_1 to server_1 from server_2(slave) include/rpl_init.inc [topology=1->2] 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. # # Insert data on the master # [connection server_1] CREATE TABLE t1( a int unique); # sync data to the slave [connection server_1] include/sync_slave_sql_with_master.inc # stop slave include/rpl_stop_slaves.inc SET @saved_innodb_lock_wait_timeout = @@GLOBAL.innodb_lock_wait_timeout; SET @saved_slave_transaction_retries = @@GLOBAL.slave_transaction_retries; # # Set the variables needed for this test # SET GLOBAL slave_transaction_retries=10; SET GLOBAL innodb_lock_wait_timeout=2; #start slave include/rpl_start_slaves.inc # # Lock the rows of the table t1 # BEGIN; INSERT INTO t1 VALUES(1); # # Insert the rows on the same table on master # [connection server_1] INSERT INTO t1 VALUES(1); # # On slave, check that this transaction from the master has been retried. # [connection server_2] # Release the lock. ROLLBACK; # Now sync with master on channel_1 [connection server_1] include/sync_slave_sql_with_master.inc # check that data shows the value 1 SELECT * FROM t1; a 1 #cleanup [connection server_1] DROP TABLE t1; include/sync_slave_sql_with_master.inc SET GLOBAL innodb_lock_wait_timeout = @saved_innodb_lock_wait_timeout; SET GLOBAL slave_transaction_retries = @saved_slave_transaction_retries; include/rpl_end.inc RESET SLAVE ALL FOR CHANNEL 'channel_1';