403Webshell
Server IP : 172.67.216.182  /  Your IP : 172.69.176.134
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_multi_binlog_update.inc
###############################################################################
# Description: Performs binloggable and non binloggable DDL and DML at each
#              MySQLD in pair of clusters with (at least) 3 MySQLDs each.
#              Then connects to each MySQLD and examines the contents of
#              its Binlog.
#              Expected contents depends on the configuration of Binlogging
#              in the cluster used.
#              Default from rpl_ndb_multi_binlog_update.test is as shown
#              below. 
# 
# Testing scenario: Cluster 1 replicates to Cluster 2
#
#  Key : BL= Binlogging, LSU = LogSlaveUpdates = On
#
#                       BL                        BL
#  cluster 1 [  srv_master  srv_master1  srv_master2  ]
#                   |
#                   |-----------------------
#                   v          v            v
#  cluster 2 [  srv_slave  srv_slave1  srv_slave2 ]
#                                  BL      BL LSU
#
#  Cluster 1:
#  - Schema change originates on all severs in Cluster 1
#  - MySQLD1 which is binlogging master. 
#    Identification: connection (srv_master), config (mysqld.1.1).
#  - MySQLD2 which is not binlogging.
#    Identification: connection (srv_master1), config (mysqld.1.2).
#  - MySQLD3 which is binlogging but not currently master.
#    Identification: connection (srv_master2), config (mysqld.1.3).
#
#  Cluster 2:
#  - MySQLD1: 
#    Can act as slave, not binlogging
#    Identification: connection (srv_slave), config (mysqld.1.slave).
#  - MySQLD2: 
#    Can act as slave, binlogging, log-slave-updates = off
#    Identification: connection (srv_slave1), config (mysqld.2.slave).
#  - MySQLD3 
#    Can act as slave, binlogging, log-slave-updates = on
#    Identification: connection (srv_slave2), config (mysqld.3.slave).
#
# See rpl_ndb_multi_binlog_update.test for default configuration.
# Originally motivated by bug#45756
# See rpl_ndb_slave_lsu.test for full testcase
#
# Preconditions :
#   - Connections srv_master, srv_master1, srv_master2, srv_slave, 
#     srv_slave1, srv_slave2 exist.
#   - $which_slave contains the name of the slave server performing
#     the replication slave role.
#
###############################################################################

###############################################################################
#                            Checking Replication
###############################################################################
--echo *** Generating slave cluster originated binloggable changes ***
connection srv_slave;
CREATE TABLE bug_45756_slave_logged_1 (a int) engine = NDB;
INSERT INTO bug_45756_slave_logged_1 VALUES (1);
DROP TABLE bug_45756_slave_logged_1;

connection srv_slave1;
CREATE TABLE bug_45756_slave_logged_2 (a int) engine = NDB;
INSERT INTO bug_45756_slave_logged_2 VALUES (1);
DROP TABLE bug_45756_slave_logged_2;

connection srv_slave2;
CREATE TABLE bug_45756_slave_logged_3 (a int) engine = NDB;
INSERT INTO bug_45756_slave_logged_3 VALUES (1);
DROP TABLE bug_45756_slave_logged_3;

--echo ***Generating slave cluster non-binloggable changes***
connection srv_slave;
SET SQL_LOG_BIN= 0;
CREATE TABLE bug_45756_slave_not_logged_1 (a int) engine = NDB;
INSERT INTO bug_45756_slave_not_logged_1 VALUES (1);
DROP TABLE bug_45756_slave_not_logged_1;
SET SQL_LOG_BIN= 1;

connection srv_slave1;
SET SQL_LOG_BIN= 0;
CREATE TABLE bug_45756_slave_not_logged_2 (a int) engine = NDB;
INSERT INTO bug_45756_slave_not_logged_2 VALUES (1);
DROP TABLE bug_45756_slave_not_logged_2;
SET SQL_LOG_BIN= 1;

connection srv_slave2;
SET SQL_LOG_BIN= 0;
CREATE TABLE bug_45756_slave_not_logged_3 (a int) engine = NDB;
INSERT INTO bug_45756_slave_not_logged_3 VALUES (1);
DROP TABLE bug_45756_slave_not_logged_3;
SET SQL_LOG_BIN= 1;

--echo *** Generating data to be replicated ***
connection srv_master;
CREATE TABLE bug45756_master_logged_1 (a int) engine = NDB;
INSERT INTO bug45756_master_logged_1 VALUES (1);
DROP TABLE bug45756_master_logged_1;

connection srv_master1;
CREATE TABLE bug45756_master_logged_2 (a int) engine = NDB;
INSERT INTO bug45756_master_logged_2 VALUES (1);
DROP TABLE bug45756_master_logged_2;

connection srv_master2;
CREATE TABLE bug45756_master_logged_3 (a int) engine = NDB;
INSERT INTO bug45756_master_logged_3 VALUES (1);
DROP TABLE bug45756_master_logged_3;

--echo *** Generating changes not to be replicated ***
connection srv_master;
SET SQL_LOG_BIN= 0;
CREATE TABLE bug45756_master_not_logged_1 (a int) engine = NDB;
INSERT INTO bug45756_master_not_logged_1 VALUES (1);
DROP TABLE bug45756_master_not_logged_1;
SET SQL_LOG_BIN= 1;

connection srv_master1;
SET SQL_LOG_BIN= 0;
CREATE TABLE bug45756_master_not_logged_2 (a int) engine = NDB;
INSERT INTO bug45756_master_not_logged_2 VALUES (1);
DROP TABLE bug45756_master_not_logged_2;
SET SQL_LOG_BIN= 1;

connection srv_master2;
SET SQL_LOG_BIN= 0;
CREATE TABLE bug45756_master_not_logged_3 (a int) engine = NDB;
INSERT INTO bug45756_master_not_logged_3 VALUES (1);
DROP TABLE bug45756_master_not_logged_3;
SET SQL_LOG_BIN= 1;

connection srv_master;
sync_slave_with_master $which_slave;

--echo *** Checking binlog contents on every server in both clusters ***
connection srv_master;
--echo 
--echo 
--echo 
--echo connection srv_master;
show variables like 'server_id';
show variables like 'log_bin';
show variables like 'log_slave_updates';
--source include/show_binlog_events.inc
let $BINLOG_FILENAME=master-bin;
--source suite/ndb_rpl/t/ndb_rpl_get_binlog_events.inc


connection srv_master1;
--echo 
--echo 
--echo 
--echo connection srv_master1;
show variables like 'server_id';
show variables like 'log_bin';
show variables like 'log_slave_updates';
--source include/show_binlog_events.inc

connection srv_master2;
--echo 
--echo 
--echo 
--echo connection srv_master2;
show variables like 'server_id';
show variables like 'log_bin';
show variables like 'log_slave_updates';
--source include/show_binlog_events.inc
let $BINLOG_FILENAME=master-bin;
--source suite/ndb_rpl/t/ndb_rpl_get_binlog_events.inc

connection srv_slave;
--echo 
--echo 
--echo 
--echo connection srv_slave;
show variables like 'server_id';
show variables like 'log_bin';
show variables like 'log_slave_updates';
--source include/show_binlog_events.inc

connection srv_slave1;
--echo 
--echo 
--echo 
--echo connection srv_slave1;
show variables like 'server_id';
show variables like 'log_bin';
show variables like 'log_slave_updates';
--source include/show_binlog_events.inc
let $BINLOG_FILENAME=slave-master-bin;
--source suite/ndb_rpl/t/ndb_rpl_get_binlog_events.inc

connection srv_slave2;
--echo 
--echo 
--echo 
--echo connection srv_slave2;
show variables like 'server_id';
show variables like 'log_bin';
show variables like 'log_slave_updates';
--source include/show_binlog_events.inc
let $BINLOG_FILENAME=slave-master-bin;
--source suite/ndb_rpl/t/ndb_rpl_get_binlog_events.inc

connection $which_slave;

Youez - 2016 - github.com/yon3zu
LinuXploit