The goal of this tutorial is to show you how to use multi-master to aggregate databases with the same name, but different data from different masters, on the same slave.
- master1 => a French subsidiary
- master2 => a British subsidiary
Both have the same database PRODUCTION but the data are totally different.
This screenshot is made from my own monitoring tool:
PmaControl. You have to read 10.10.16.232 on master2 and not
The fault of my admin system! :p)
We will start with three servers—2 masters and 1 slave—you can add more masters if needed. For this tutorial, I used Ubuntu 12.04. I’ll let you choose the right procedure for your distribution from Downloads.