For our example scenario, we'll use a three-server topology, which is commonly employed for simple failover. (I used the same setup in my post on how to enable GTIDs in MariaDB Server.) A is the active master, B is a standby master set up to replicate from A, and C is a multi-purpose slave replicating from A. I also set up A to replicate from B. This way, if A fails, the system will start writing to B, and once A comes back up it will recover all the transactions from B through replication. Typically, this setup is used in combination with a tool like Master High Availability Manager (MHA) to migrate the slave from one master to the next.
For this particular case, assuming that the application(s) write to the active master only, we're going to set the domain ID for all servers to 1.
No comments:
Post a Comment