mysql:changemasters
This is an old revision of the document!
Table of Contents
Changing Masters
The problem
I have a mysql master database with an slave. I want to change the master server. Downtime it is not a problem, however, I will try to reduce downtime.
My servers, for the sake of this example will be named: master, future-master, slave.
First: make future-master to become an slave of master
For that, I've found this:
http://plusbryan.com/mysql-replication-without-downtime
This explains how to change the master of a running mysql database by the mechanism of:
- Create a new slave wihtout downtime
- Stop the current master and start a new master (the last slave)
https://dev.mysql.com/doc/refman/5.0/en/replication-solutions-switch.html
mysql/changemasters.1435070895.txt.gz · Last modified: 2022/12/02 21:02 (external edit)