1
include/master-slave.inc
3
CREATE TABLE t1 (a INT);
5
INSERT INTO t1 VALUES (1);
7
include/rpl_stop_server.inc [server_number=1]
8
# Move the master binlog files and the index file to a new place
9
# Restart master with log-bin option set to the new path
10
# Master has restarted successfully
11
# Create the master-bin.index file with the old format
13
include/rpl_stop_server.inc [server_number=1]
14
# Move back the master binlog files
15
# Remove the unneeded master-bin.index file
16
# Restart master with log-bin option set to default
17
# Master has restarted successfully
19
include/stop_slave.inc
20
include/rpl_stop_server.inc [server_number=2]
23
# Restart slave with options log-bin, relay-log set to the new paths
24
# Slave server has restarted successfully
25
include/start_slave.inc
26
include/stop_slave.inc
28
INSERT INTO t1 VALUES (2);
29
INSERT INTO t1 VALUES (2);
30
INSERT INTO t1 VALUES (2);
31
INSERT INTO t1 VALUES (2);
34
include/start_slave.inc
35
include/diff_tables.inc [master:t1,slave:t1]
37
include/stop_slave.inc
38
include/rpl_stop_server.inc [server_number=2]
40
# restarted with previous slave settings
41
include/start_slave.inc