User Tools

Site Tools


mysql:changemasterswithoutdowntime

This is an old revision of the document!


Changing Masters with reduced downtime

Intro

This explains how to change the master of a running mysql database by the mechanism of:

  1. Create a new slave wihtout downtime
  2. Stop the current master and start a new master (the last slave)

http://plusbryan.com/mysql-replication-without-downtime

https://dev.mysql.com/doc/refman/5.0/en/replication-solutions-switch.html

mysql/changemasterswithoutdowntime.1435052190.txt.gz ยท Last modified: 2022/12/02 21:02 (external edit)