2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
1
include/rpl_init.inc [topology=1->2->1]
7
2
show variables like 'relay_log%';
9
relay_log MYSQLD_DATADIR/relay-log
11
6
relay_log_info_file relay-log.info
13
8
relay_log_space_limit 0
15
change master to master_host='127.0.0.1',master_user='root',
16
master_password='',master_port=MASTER_PORT;
19
change master to master_host='127.0.0.1',master_user='root',
20
master_password='',master_port=SLAVE_PORT;
21
include/start_slave.inc
22
9
CREATE TABLE t1 (a INT KEY) ENGINE= MyISAM;
23
10
INSERT INTO t1 VALUE(1);
25
12
INSERT INTO t1 VALUE(2);
26
Checking that both slave threads are running.
27
Relay_Log_File relay-log.000003
13
include/check_slave_is_running.inc
14
Relay_Log_File = 'mysqld-relay-bin.000003'