| Server IP : 104.21.38.3 / Your IP : 172.70.147.201 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/ndb_rpl/t/ |
Upload File : |
# The include statement below is a temp one for tests that are yet to #be ported to run with InnoDB, #but needs to be kept for tests that would need MyISAM in future. --source include/force_myisam_default.inc ############################################################################### # Description: Checks if DDL and DML statements are correctly logged by # servers and slave servers according to log-slave-updates, # and independent of their settings on the particular MySQLD # acting in the slave role # # Testing scenario: Cluster 1 replicates to Cluster 2 # Key : BL = log-bin, LSU = log-slave-updates # # BL BL # cluster 1 [ srv_master srv_master1 srv_master2 ] # |----------+------------ # v v v # cluster 2 [ srv_slave srv_slave1 srv_slave2 ] # BL BL LSU # # - First replicate via srv_slave and check all nodes' Binlog contents # - Second replicate via srv_slave1 and check all nodes' Binlog contents # - Third replicate via srv_slave2 and check all nodes' Binlog contents # # Makes use of suite/ndb_rpl/t/ndb_rpl_multi_binlog_update.inc # Originally motivated by bug#45756 ############################################################################### --source include/have_ndb.inc --source include/have_log_bin.inc ############################################################################### # Configuring Environment ############################################################################### # setup _no_ replication to start with, but with all 6 servers included --let $rpl_topology= none --let $rpl_server_count= 6 --let $rpl_skip_reset_master_and_slave=1 --source include/rpl_init.inc --let $rpl_skip_reset_master_and_slave=0 --echo *** Configuring connections *** --let $rpl_connection_name= srv_master --let $rpl_server_number= 1 --source include/rpl_connect.inc --let $rpl_connection_name= srv_master1 --let $rpl_server_number= 2 --source include/rpl_connect.inc --let $rpl_connection_name= srv_master2 --let $rpl_server_number= 3 --source include/rpl_connect.inc --let $rpl_connection_name= srv_slave --let $rpl_server_number= 4 --source include/rpl_connect.inc --let $rpl_connection_name= srv_slave1 --let $rpl_server_number= 5 --source include/rpl_connect.inc --let $rpl_connection_name= srv_slave2 --let $rpl_server_number= 6 --source include/rpl_connect.inc --echo *** Waiting for each cluster to startup *** # Check schema op binlogging enabled between servers on cluster1 --let $source_server=srv_master --let $dest_server=srv_master2 source suite/ndb_rpl/t/wait_schema_logging.inc; --let $source_server=srv_master1 --let $dest_server=srv_master source suite/ndb_rpl/t/wait_schema_logging.inc; --let $source_server=srv_master1 --let $dest_server=srv_master2 source suite/ndb_rpl/t/wait_schema_logging.inc; --let $source_server=srv_master2 --let $dest_server=srv_master source suite/ndb_rpl/t/wait_schema_logging.inc; # Check schema op binlogging enabled between servers on cluster2 --let $source_server=srv_slave --let $dest_server=srv_slave1 source suite/ndb_rpl/t/wait_schema_logging.inc; --let $source_server=srv_slave --let $dest_server=srv_slave2 source suite/ndb_rpl/t/wait_schema_logging.inc; --let $source_server=srv_slave1 --let $dest_server=srv_slave2 source suite/ndb_rpl/t/wait_schema_logging.inc; --let $source_server=srv_slave2 --let $dest_server=srv_slave1 source suite/ndb_rpl/t/wait_schema_logging.inc; # Reset state of all Binlogging nodes --disable_query_log connection srv_master; --disable_warnings RESET MASTER; --enable_warnings connection srv_master2; --disable_warnings RESET MASTER; --enable_warnings connection srv_slave1; --disable_warnings RESET MASTER; --enable_warnings connection srv_slave2; --disable_warnings RESET MASTER; --enable_warnings --enable_query_log --echo *** Configuring replication via Slave *** --let $rpl_connection_name= srv_slave --source include/rpl_connection.inc --let $rpl_topology= 1->4 --source include/rpl_change_topology.inc --source include/start_slave.inc # Run the test script --let $which_slave=srv_slave --source suite/ndb_rpl/t/ndb_rpl_multi_binlog_update.inc --source include/stop_slave.inc # Reset state of all Binlogging nodes --disable_query_log connection srv_master; --disable_warnings RESET MASTER; --enable_warnings connection srv_master2; --disable_warnings RESET MASTER; --enable_warnings connection srv_slave1; --disable_warnings RESET MASTER; --enable_warnings connection srv_slave2; --disable_warnings RESET MASTER; --enable_warnings --enable_query_log --echo *** Configuring replication via Slave1 *** --let $rpl_connection_name= srv_slave1 --source include/rpl_connection.inc --let $rpl_topology= 1->4,1->5 --source include/rpl_change_topology.inc --source include/start_slave.inc # Run the test script --let $which_slave=srv_slave1 --source suite/ndb_rpl/t/ndb_rpl_multi_binlog_update.inc --source include/stop_slave.inc # Reset state of all Binlogging nodes --disable_query_log connection srv_master; --disable_warnings RESET MASTER; --enable_warnings connection srv_master2; --disable_warnings RESET MASTER; --enable_warnings connection srv_slave1; --disable_warnings RESET MASTER; --enable_warnings connection srv_slave2; --disable_warnings RESET MASTER; --enable_warnings --enable_query_log --echo *** Configuring replication via Slave2 *** --let $rpl_connection_name= srv_slave2 --source include/rpl_connection.inc --let $rpl_topology= 1->4,1->5,1->6 --source include/rpl_change_topology.inc --source include/start_slave.inc # Run the test script --let $which_slave=srv_slave2 --source suite/ndb_rpl/t/ndb_rpl_multi_binlog_update.inc --source include/stop_slave.inc # Cleanup and reset replication settings to how # they where when test started --let $rpl_topology= none --source include/rpl_change_topology.inc