I have multiple geographically separated data centres on a private network and would like some ideas for WAN outage tolerant open-source multi-master replication databases. I'm OK with RAM only dbs.
I need to be able to write to a common table on the local master at each data centre and have that information change in all versions of that table in all the data centres.
During a WAN outage I need to be able to continue to write to this common table at each data centre locally. When WAN connectivity resumes I need it to automatically merge all the changes together with some kind of conflict resolution.
Handling latency degregation would be an optional plus.
Is MySQL Cluster Multi-Site Clustering what I'm looking for? I find it hard to figure it out from their documentation.
I don't need an SQL interface or MySQL specifically, simple key:value would work too.
I really hope some more knowledgeable people could point me in the right direction!