My employers presented me with a challenge this week. The task was not difficult in the end but to me it was an untried concept involving MySQL.
I have never been a fan of MySQL and generally turn my nose at the thought of using it, let alone replicating it etc.
The task in question? Master -> Master -> Slave -> Slave replication.
From this point forward I will expect you to have MySQL installed and set-up as normal.
- Master 1 will be known as Master 1 and Slave 2 with IP 10.1.1.1
- Master 2 will be known as Master 2 and Slave 1 with IP 10.1.1.2
- Slave 1 will be known as Slave 3 with IP 10.1.1.3
- and Slave 2 will be known as Slave 4 with IP 10.1.1.4
Modify your MySQL config file, usually named …