Page MenuHomePhabricator

Implement a script to facilitate sanitarium failovers between DCs
Open, MediumPublic

Description

Once the goal of moving sanitarium to multi-instance (T190704) is achieved, we will end up with 4 sanitarium hosts, 2 active in eqiad (db1124 and db1125) and 2 passive in codfw (db2094 and db2095).

Each host replicate different sections on each DC.

db1124: s1, s3, s5, s8

db2094: s1, s3, s5,s8

db1125: s2, s4, s6, s7

db1095: s2, s4, s6, s7

If we have to failover to codfw, we need to manually look for the equivalent positions (if we do not use GTID) on the binlogs, so we can star replication on the other DC.

It would be a good idea to have a script that automatically provides the exact binlog/position coordinates that are equivalent on both hosts, so replication can started.

Event Timeline

Marostegui triaged this task as Medium priority.Jun 4 2018, 1:15 PM
Marostegui created this task.
Marostegui moved this task from Triage to Backlog on the DBA board.
Vvjjkkii renamed this task from Implement a script to facilitate sanitarium failovers between DCs to oobaaaaaaa.Jul 1 2018, 1:06 AM
Vvjjkkii raised the priority of this task from Medium to High.
Vvjjkkii updated the task description. (Show Details)
Vvjjkkii removed a subscriber: Aklapper.
Marostegui renamed this task from oobaaaaaaa to Implement a script to facilitate sanitarium failovers between DCs.Jul 2 2018, 5:00 AM
Marostegui lowered the priority of this task from High to Medium.
Marostegui updated the task description. (Show Details)