I have a website, I want to host on two diffident very far deployments. I have a rather good connection between them. But the users have a good connection only to what's near them.
My Idea is to duplicate the database servers, but I need complete consistency between them, I.E. a transaction should be considered complete only after committed on both machines.
How can I achieve this? any ideas will be appreciated, clustering, replication, etc.