Would this forum be appropriate for asking questions on best ways to configure MySQL in a high-availability manner with automated failover, and quick replication? Or would it be serverfault? Any other?
With servers in two data centers with latency, the problems I'm looking to address are
- Automated failover from primary data center to secondary data center
- Data synching/replication across the two data centers
- Upon recovery/fail-back to primary data center, quick data synching from secondary server(s) to primary server(s).