Page MenuHomeMiraheze

Migrate Databases over to new infrastructure
Closed, ResolvedPublic

Description

Service: Database
Owner: Technology-Team (Infrastructure)
Task Start Date: 02/01/2022
End Goal: Traffic Serving
Task Actions:

  • Setup replication between production and SCSVG
  • Monitor this regularly to ensure it maintains up to date, up until migration day
  • Liaise with Technology-Team (MediaWiki) to get read-only for a small period of time before and after planned migration period
  • Disconnect SCSVG and 'old' production, making SCSVG the new 'production'
  • Liaise with Technology-Team (MediaWiki) to ensure no problems occur public facing

Event Timeline

John triaged this task as Normal priority.Dec 18 2021, 19:02
John created this task.
John updated the task description. (Show Details)

Using the latest database backups, I’ll move them across later today, and look to create a migratory action plan for a live migration.

I have decided based on how long the initial stage is taking, creating a temporary replication setup is better - both servers have SSDs, and are relatively local (<3ms) so this setup should work.

The other alternative would be a 12-18 hour read only period for wikis - we can limit disruption for this immensely by using replication.

Replication is configured as below - I will post regular updates onto this task until all is in sync...

db101: 23.13 hours behind db11
db111: 31 hours behind db12
db121: not replicating
db101: 19.75 hours behind db11
db111: 30.09 hours behind db12
db121: 31.67 hours behind db13
db101: 15.07 hours behind db11
db111: 28.89 hours behind db12
db121: 29.12 hours behind db13
db101: 0 hours behind db11
db111: 29.05 hours behind db12
db101: 0 hours behind db11
db111: 22.88 hours behind db12
db121: reimporting again
db101: 0 hours behind db11
db111: 0 hours behind db12
db121: 53.31 hours behind db13
db101: 0 hours behind db11
db111: 0 hours behind db12
db121: 23.66 hours behind db13
db101: 0 hours behind db11
db111: 0 hours behind db12
db121: 0 hours behind db13
John updated the task description. (Show Details)