Before our test last weekend, we posted THE PLAN, as promised here’s a follow-up of how things went:
Prep (2 hours before the test)
Shorten DNS TTL down to 5 minutes
Pause page duty (that’s damn sure going to go off)
Firewall Oregon redis to prevent mutation (went smooth, late plan addition)
Slave Oregon redis from the New York master (smooth, late addition)
The Test
Shutdown affected backends in HAProxy (New York)
Start the DNS swap to Oregon IPs
Start the SQL 2012 Availability Group failovers to Oregon (largest problem) …