48 lines
1.7 KiB
Plaintext
48 lines
1.7 KiB
Plaintext
include/master-slave.inc
|
|
Warnings:
|
|
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
|
|
Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
|
|
[connection master]
|
|
CREATE TABLE t1 (a INT);
|
|
FLUSH BINARY LOGS;
|
|
INSERT INTO t1 VALUES (1);
|
|
include/stop_slave.inc
|
|
# 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
|
|
include/start_slave.inc
|
|
# Create the master-bin.index file with the old format
|
|
include/stop_slave.inc
|
|
# 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
|
|
include/start_slave.inc
|
|
include/rpl_stop_server.inc [server_number=2]
|
|
# relocate binlogs
|
|
# relocate relay logs
|
|
# Restart slave with options log-bin, relay-log set to the new paths
|
|
# Slave server has restarted successfully
|
|
include/start_slave.inc
|
|
include/stop_slave.inc
|
|
FLUSH LOGS;
|
|
INSERT INTO t1 VALUES (2);
|
|
INSERT INTO t1 VALUES (2);
|
|
INSERT INTO t1 VALUES (2);
|
|
INSERT INTO t1 VALUES (2);
|
|
FLUSH LOGS;
|
|
FLUSH LOGS;
|
|
include/start_slave.inc
|
|
include/diff_tables.inc [master:t1,slave:t1]
|
|
DROP TABLE t1;
|
|
include/stop_slave.inc
|
|
include/rpl_stop_server.inc [server_number=2]
|
|
# remove tmpdir
|
|
# restarted with previous slave settings
|
|
include/start_slave.inc
|
|
include/rpl_end.inc
|