Debian Codegraph @

mysql-test/suite/rpl/t/rpl_start_alter_mysqlbinlog_1.test

raw
1 #
2 # Start Alter with binlog applied using mysqlbinlog
3 # single master with only one domain id
4 #
5 --source include/have_innodb.inc
6 --source include/have_debug.inc
7 --source include/master-slave.inc
8
9 --connection master
10 set global binlog_alter_two_phase=true;
11 --connection slave
12 --source include/stop_slave.inc
13 SET STATEMENT sql_log_bin=0 FOR
14 ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB;
15 set global gtid_strict_mode=1;
16
17 --echo # Legacy Master Slave
18 --let $domain_1=0
19 --let $domain_2=0
20 --let $M_port= $MASTER_MYPORT
21 --let $S_port= $SLAVE_MYPORT
22 --let $sync_slave=0
23
24 --source include/start_alter_include.inc
25 --connection master
26 --let $MYSQLD_DATADIR= `select @@datadir;`
27 --exec $MYSQL_BINLOG $MYSQLD_DATADIR/master-bin.000001 > $MYSQLTEST_VARDIR/tmp/master.sql
28 select @@gtid_binlog_state;
29 RESET master;
30
31 --connection slave
32 --exec $MYSQL --host=127.0.0.1 --port=$SLAVE_MYPORT -e "source $MYSQLTEST_VARDIR/tmp/master.sql"
33 select @@gtid_binlog_state;
34 set global gtid_strict_mode=0;
35 --source include/start_slave.inc
36
37 --connection master
38 set global binlog_alter_two_phase=false;
39 remove_file $MYSQLTEST_VARDIR/tmp/master.sql;
40 --source include/rpl_end.inc