1
# Replication tests need binlog
2
source include/have_log_bin.inc;
4
connect (master,127.0.0.1,root,,test,$MASTER_MYPORT,);
5
connect (master1,127.0.0.1,root,,test,$MASTER_MYPORT,);
6
connect (slave,127.0.0.1,root,,test,$SLAVE_MYPORT,);
7
connect (slave1,127.0.0.1,root,,test,$SLAVE_MYPORT,);
10
# Set the default connection to 'master'
3
# Configure two servers to be replication master and slave.
7
# [--let $rpl_server_count= N]
8
# [--let $rpl_check_server_ids= 1]
9
# [--let $rpl_skip_reset_master_and_slave= 1]
10
# [--let $rpl_skip_change_master= 1]
11
# [--let $rpl_skip_start_slave= 1]
12
# [--let $rpl_debug= 1]
13
# [--let $slave_timeout= NUMBER]
14
# --source include/master-slave.inc
17
# $rpl_check_server_ids, $rpl_skip_reset_master_and_slave,
18
# $rpl_skip_change_master, $rpl_skip_start_slave, $rpl_debug,
20
# See include/rpl_init.inc
23
# By default, two servers are configured. You can configure more
24
# servers (servers 3, 4, etc are neither masters nor slaves) by
25
# setting this variable. See also include/rpl_init.inc
28
--let $include_filename= master-slave.inc
29
if ($rpl_server_count)
31
--let $include_filename= master-slave.inc [rpl_server_count=$rpl_server_count]
33
--source include/begin_include_file.inc
36
--let $rpl_topology= 1->2
37
--source include/rpl_init.inc
39
--let $rpl_connection_name= master
40
--let $rpl_server_number= 1
41
--source include/rpl_connect.inc
43
--let $rpl_connection_name= master1
44
--let $rpl_server_number= 1
45
--source include/rpl_connect.inc
47
--let $rpl_connection_name= slave
48
--let $rpl_server_number= 2
49
--source include/rpl_connect.inc
51
--let $rpl_connection_name= slave1
52
--let $rpl_server_number= 2
53
--source include/rpl_connect.inc
56
--let $include_filename= master-slave.inc
57
--source include/end_include_file.inc
60
# Set the default connection to 'master'. Do this after
61
# end_include_file.inc, so that it gets printed to the query log.
62
--let $rpl_connection_name= master
63
--source include/rpl_connection.inc