Multi-Master Replication or......?
user requirement:
1. 3 sites, separated by geographic distance.
2. using privately owned wire for network connectivity.
3. any breakage of connection between sites, users can still get to a database (i.e., database at each site).
4. any breakage of database, users can still get to a database.
5. databases must be within 30 minutes of in-sync with each other.
The customer started out talking about a solution (multi-mastered
replication) instead of the requirements (listed above). Now that I have the requirements, I'm looking at options on how to meet them. As part of that work, thought I'd look to this community for ideas.
thanks!