MySQL 5.6.14 Source Code Document
 All Classes Namespaces Files Functions Variables Typedefs Enumerations Enumerator Friends Macros Groups Pages
master-slave-bhs.inc
1 # Insert blackhole slave into regular replication chain
2 # We hide any output below due using untouched result files of rpl suite
3 
4 --disable_warnings
5 --disable_query_log
6 
7 connection master;
8 
9 # Connect blackhole slave to master.
10 connect (blackhole_slave,127.0.0.1,root,,test,$BHS_MYPORT,);
11 connection blackhole_slave;
12 source include/have_blackhole.inc;
13 SET storage_engine=BLACKHOLE;
14 STOP SLAVE;
15 source include/wait_for_slave_to_stop.inc;
16 RESET SLAVE;
17 eval CHANGE MASTER TO MASTER_USER='root', MASTER_CONNECT_RETRY=1, MASTER_HOST='127.0.0.1', MASTER_PORT=$MASTER_MYPORT;
18 START SLAVE;
19 source include/wait_for_slave_to_start.inc;
20 
21 # Stop slave and reconnect to blackhole slave
22 connection slave;
23 STOP SLAVE;
24 RESET SLAVE;
25 eval CHANGE MASTER TO MASTER_USER='root', MASTER_CONNECT_RETRY=1, MASTER_HOST='127.0.0.1', MASTER_PORT=$BHS_MYPORT;
26 START SLAVE;
27 source include/wait_for_slave_to_start.inc;
28 
29 --enable_query_log
30 --enable_warnings