mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 10:56:12 +01:00
69 lines
1.8 KiB
Text
69 lines
1.8 KiB
Text
include/master-slave.inc
|
|
[connection master]
|
|
connection master;
|
|
connection slave;
|
|
connection master;
|
|
CREATE TABLE t1 (a INT);
|
|
FLUSH BINARY LOGS;
|
|
INSERT INTO t1 VALUES (1);
|
|
connection slave;
|
|
include/stop_slave.inc
|
|
connection master;
|
|
# Shutdown master
|
|
include/rpl_stop_server.inc [server_number=1]
|
|
# Move the master binlog files and the index file to a new place
|
|
# Restart master with log-bin option set to the new path
|
|
# Master has restarted successfully
|
|
connection slave;
|
|
include/start_slave.inc
|
|
connection master;
|
|
# Create the master-bin.index file with the old format
|
|
connection slave;
|
|
include/stop_slave.inc
|
|
connection master;
|
|
# Shutdown master
|
|
include/rpl_stop_server.inc [server_number=1]
|
|
# Move back the master binlog files
|
|
# Remove the unneeded master-bin.index file
|
|
# Restart master with log-bin option set to default
|
|
# Master has restarted successfully
|
|
connection slave;
|
|
include/start_slave.inc
|
|
connection master;
|
|
connection slave;
|
|
# stop slave
|
|
include/stop_slave.inc
|
|
include/rpl_stop_server.inc [server_number=2]
|
|
connection master;
|
|
# relocate binlogs
|
|
# relocate relay logs
|
|
# Restart slave with options log-bin, relay-log set to the new paths
|
|
connection slave;
|
|
# Slave server has restarted successfully
|
|
include/start_slave.inc
|
|
include/stop_slave.inc
|
|
connection master;
|
|
FLUSH LOGS;
|
|
INSERT INTO t1 VALUES (2);
|
|
INSERT INTO t1 VALUES (2);
|
|
INSERT INTO t1 VALUES (2);
|
|
INSERT INTO t1 VALUES (2);
|
|
FLUSH LOGS;
|
|
connection slave;
|
|
FLUSH LOGS;
|
|
include/start_slave.inc
|
|
connection master;
|
|
connection slave;
|
|
include/diff_tables.inc [master:t1,slave:t1]
|
|
connection master;
|
|
DROP TABLE t1;
|
|
connection slave;
|
|
include/stop_slave.inc
|
|
include/rpl_stop_server.inc [server_number=2]
|
|
connection master;
|
|
# remove tmpdir
|
|
# restarted with previous slave settings
|
|
connection slave;
|
|
include/start_slave.inc
|
|
connection master;
|
|
include/rpl_end.inc
|