| Server IP : 104.21.38.3 / Your IP : 172.70.208.169 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] include/install_semisync.inc [connection slave] STOP SLAVE IO_THREAD; CHANGE MASTER TO MASTER_SSL=1; START SLAVE IO_THREAD; [connection master] SET @max_binlog_size_save= @@GLOBAL.MAX_BINLOG_SIZE; SET @@GLOBAL.MAX_BINLOG_SIZE= 4096; SET GLOBAL rpl_semi_sync_master_timeout= 6000000; # # Verify it on AFTER_SYNC wait point # ============================================================== # Flush error happens before AFTER_SYNC wait point. So # [connection master] SET GLOBAL rpl_semi_sync_master_wait_point= AFTER_SYNC; # Disable diff_table test # Test tables with MyISAM engine when disabling diff_table and # simulating flush error include/sync_slave_sql_with_master.inc # Build connections to master server # Stress test that execute massive queries on every connection include/sync_slave_sql_with_master.inc # Enable diff_table test # Test tables with InnoDB engine when enableing diff_table # and simulating flush error include/sync_slave_sql_with_master.inc # Build connections to master server # Stress test that execute massive queries on every connection include/sync_slave_sql_with_master.inc # Test if the results are consistent on master and slave include/diff_tables.inc [master:t1, slave:t1] include/diff_tables.inc [master:t2, slave:t2] include/diff_tables.inc [master:t3, slave:t3] include/diff_tables.inc [master:t4, slave:t4] include/diff_tables.inc [master:t5, slave:t5] include/diff_tables.inc [master:t6, slave:t6] include/diff_tables.inc [master:t7, slave:t7] include/diff_tables.inc [master:t8, slave:t8] include/diff_tables.inc [master:t9, slave:t9] include/diff_tables.inc [master:t10, slave:t10] include/sync_slave_sql_with_master.inc # # Verify it on AFTER_COMMIT wait point # ============================================================== # [connection master] SET GLOBAL rpl_semi_sync_master_wait_point= AFTER_COMMIT; # Disable diff_table test # Test tables with MyISAM engine when disabling diff_table and # simulating flush error include/sync_slave_sql_with_master.inc # Build connections to master server # Stress test that execute massive queries on every connection include/sync_slave_sql_with_master.inc # Enable diff_table test # Test tables with InnoDB engine when enableing diff_table # and simulating flush error include/sync_slave_sql_with_master.inc # Build connections to master server # Stress test that execute massive queries on every connection include/sync_slave_sql_with_master.inc # Test if the results are consistent on master and slave include/diff_tables.inc [master:t1, slave:t1] include/diff_tables.inc [master:t2, slave:t2] include/diff_tables.inc [master:t3, slave:t3] include/diff_tables.inc [master:t4, slave:t4] include/diff_tables.inc [master:t5, slave:t5] include/diff_tables.inc [master:t6, slave:t6] include/diff_tables.inc [master:t7, slave:t7] include/diff_tables.inc [master:t8, slave:t8] include/diff_tables.inc [master:t9, slave:t9] include/diff_tables.inc [master:t10, slave:t10] include/sync_slave_sql_with_master.inc [connection master] SET @@GLOBAL.MAX_BINLOG_SIZE= @max_binlog_size_save; include/uninstall_semisync.inc [connection slave] include/stop_slave.inc CHANGE MASTER TO MASTER_SSL = 0; include/rpl_end.inc