MySQL replicate multiple places
- by Frederik Nielsen
Very trick task to find a good title for this question, but here goes the q:
I have a few development machines, where I develop my PHP applications on, and testing via a local webserver.
This works out pretty well for each machine. However, I would like to replicate the DB from my machines to a central location.
So, to sum up:
DEV1 - CENTRAL
DEV2 - CENTRAL
DEV3 - CENTRAL
CENTRAL - DEV1
CENTRAL - DEV2
CENTRAL - DEV3
I hope this makes sense, as I cannot find an easy way to tell it.
Basically, it is a 2-way replication, where all 4 databases contain the same info, and each of them can be updated locally, to then be pushed out to the others.
Is this actually doable?
All my dev machines are running Windows 7, and my central DB server is running CentOS 6.