Page MenuHomePhabricator

Setup automatic failover for misc database servers
Closed, ResolvedPublic

Description

Probably consistency is not a huge issue for non-core databases; HA is more important. It can also serve as a production test for a future HA solution for mediawiki (T119626)

3 main problems:

  • Automatic proxy failover, dbproxy1* (several options)
  • How to handle long-running connections from many services
  • Do we want to flip the read_only automatically? how?

Event Timeline

akosiaris triaged this task as Medium priority.Aug 11 2016, 2:31 PM
Marostegui claimed this task.
Marostegui subscribed.

I am going to close this for now, as this will be done with orchestrator as part of a bigger task.
For now we do have automatic failover with haproxy, which requires human intervention only to set the standby host writable. We probably do not want to switch read_only automatically in case of flapping.