ORIGINAL QUESTION: I have multiple servers that all need to act as masters, as if one fails the next server kicks in and takes over. I'm just wondering what the best way to replicate is. All servers are in different data centers.
- Would it be ok to set up every server as a master-master with the 'supermaster'?
- What sort of conflicts would I have?
- Are there better ways to do this?
UPDATED QUESTION: We have servers all around the world in different data centers and each server needs access to a db usually this is on localhost.
Each server needs to be able to update the database and each server is pretty much a mirror of every other server. These all stay in sync via one server(supermaster) that all can communicate with.
All the servers only communicates with supermaster, they are not aware of any other server. The super master it self is a mirror of the other servers, just with the added service of syncing them all.
Some times the supermaster is offline for various reasons; when this happens the other servers carry on as normal which includes reading and writing data. When the supermaster comes back up, it starts the syncing process and sorts out and resolves conflicts between the other servers, when this is complete all servers have a mirror of the data and are all 'synced'.
So after thinking a bit more on the question, My questions is;
- Is there any way to have a single db on each server that are the same across the board, without having a single point where I can update the db as in a Star Topology?
- Is there a better option for replicating mysql across the board for my situation?
Any help is much appreciated.