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).



  • These are the kinds of questions we encourage, actually. So yes, please do.
    – jcolebrand Mod
    Mar 29, 2011 at 16:44

3 Answers 3


Yes, that would definitely be on topic here.

This site is for questions that are of interest to, and can best be answered by, full time database professionals.

Also see my answer here:
Overlap between codereview and dba


Your question is very appropriate in this forum. In fact, I wish I saw hundreds of questions like yours in this forum. MySQL DBAs face these things day in and day out.

  • THanks @RolandoMySQLDBA. Actually, you answered my question on this topic last week. Thanks again! (-: KM
    – KM.
    Apr 4, 2011 at 21:09
  • I hope this encourages others to take the plunge and openly discuss stuff like this. Apr 4, 2011 at 21:21

So far the questions are mostly developer questions or query optimization questions. Which is fine but only a small part of a DBA's job.

Answering more DBA specific questions would be terrific!

  • Some of the juicy questions have been asked elsewhere, i.e. ServerFault, StackOverflow, SuperUser. We should just ask in their Meta Sites to Route Their Questions to Us. DBA Infrastructure and Internals? Definitely. Storage Engine choice? Perhaps. Query optimizations? Maybe. Specific Recommendations? OK. Answer question to Do Your Job? Not in DBAStackExchange. Those questions should go to ServerFault, StackOverflow, and SuperUser. Apr 22, 2011 at 14:33
  • yeah. A rerouting is in order. Apr 24, 2011 at 3:07

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .