Tag Archives: high availability

Topology refactoring using classic MySQL replication commands – version 2

This one in not very different than Topology refactoring using classic MySQL replication commands – version 1, actually it’s the other way around. Context: Initial state: dbfoo1(M) – dbfoo2(S) \ dbfoo3(S) Desired state: dbfoo1(M) – dbfoo2(MS) – dbrfoo3(S) Let’s get it done: stop slave on dbfoo3 MariaDB [(none)]> stop slave; check the “freezing point” on … Continue reading Topology refactoring using classic MySQL replication commands – version 2

Topology refactoring using classic MySQL replication commands – version 1

A week ago I wrote a post about promoting a mysql slave as master. Today I will write topology refactoring using classic replication commands. Context: Initial state: dbfoo1(M) – dbfoo2(MS) – dbrfoo3(S) Desired state: dbfoo1(M) – dbfoo2(S) \ dbfoo3(S) Let’s get to work: stop slave on dbfoo3 MariaDB [(none)]> stop slave; check the “freezing point” … Continue reading Topology refactoring using classic MySQL replication commands – version 1