403Webshell
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 :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ Back ]     

Current File : /www/server/mysql/src/mysql-test/suite/ndb_rpl/t/ndb_rpl_slave_lsu.test
# 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

Youez - 2016 - github.com/yon3zu
LinuXploit