Setup automatic failover for misc database servers
Open, MediumPublic
Actions

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?

Related Objects
Search...

		Status	Assigned	Task
		Open	None	T119626 Eliminate SPOF at the main database infrastructure
		Open	None	T141547 Setup automatic failover for misc database servers

Event Timeline

jcrespo created this task.Jul 28 2016, 5:39 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJul 28 2016, 5:39 PM

jcrespo added a parent task: T119626: Eliminate SPOF at the main database infrastructure.Jul 28 2016, 5:39 PM

mark added a subscriber: mark.Aug 2 2016, 3:00 PM

jcrespo moved this task from Triage to Backlog on the DBA board.Aug 2 2016, 5:29 PM

Krinkle updated the task description. (Show Details)Aug 3 2016, 5:17 AM

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

jcrespo mentioned this in T104699: Firewall configurations for database hosts.Aug 17 2016, 10:29 AM

Gilles added a subscriber: Gilles.Aug 17 2016, 4:11 PM

Phabricator_maintenance moved this task from Backlog to Acknowledged on the Operations board.Jan 26 2019, 8:46 PM

Setup automatic failover for misc database serversOpen, MediumPublicActions

Description

Related ObjectsSearch...

Event Timeline

Setup automatic failover for misc database servers
Open, MediumPublic
Actions

Related Objects
Search...