I have setup master master MySQL replication to sync changes in both servers.
Now I want to setup 6 servers, is that possible? I'm making 6 because when an area lost it connection over WAN it will continue it's service and then sync it when the connection is back.
Now I'm having problems with the auto increment increment and auto increment offset to avoid data collision.
I'm confused with this and I've read an article and made it worse.
So now I wonder what should be the proper value of my auto increment and offset in each server.