I had a master in Amsterdam and slaves over the globe, Amsterdam, Canada, India, Singapore
The reads all done on slaves, writes on master
Actually the read after a write in Amsterdam was delayed updated, so the slaves were stale which i tried to solve by making them wait when a write had been done
This worked for some time, but is impacted by latency and other details
Better is to create a multi master setup, for example by forking the whole database and making a sync between the master databases
My idea is;
Can you build a sync between forked masters?