This is the scenario I need to make it work:
50 different servers geographically dispersed running the same application all connected to one "Home" server running the same application. Same database schema on all locations, Servers and Home.
Some important highlights:
- I have made every single table have a primary 36 characters UUID to ensure universally unique records on all instances.
- I need to have all 50 servers to synch to Home in a sort of multi-master-master environment.
- Basically Server1 = Home then Server2 = Home.
- No need to synch Server1 to Server2 (since Home will hold the same information)
- Remote servers may become disconnected for several hours at a time before coming back online. While at that time some information may be updated in both Server1, Server2... and Home
- Connection speeds from Servers to Home are very slow, as low as 56 to 1Mbp
So.. how can I make this work? Is MySQL the best option or should I consider Postgres or any other similar?
The application is PHP based with use of Doctrine2 as the DBAL/ORM so switching DB's would not be a problem.
Thank you.
