db1063 will replace current s5 master as part of: T162133
It needs to be recloned.
It is currently running Jessie 8.7 and 10.0.29 so only recloning is needed. I would not upgrade it to 10.0.30 (although we have slave servers running that version for almost a month without any issues).
I would suggest we reclone from db1071 as it is running 10.0.23 the other hosts: db1070, d1082, db1087 and db1092 are running 10.0.30 so it might not be ideal
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | Joe | T154658 Prepare and improve the datacenter switchover procedure | |||
| Resolved | None | T155099 Database maintenance scheduled while eqiad datacenter is non primary (after the DC switchover) | |||
| Resolved | None | T134476 Decommission old coredb machines (<=db1050) | |||
| Resolved | None | T162699 Decomissions old s2 eqiad hosts (db1018, db1021, db1024, db1036) | |||
| Resolved | jcrespo | T162133 Replace some masters in eqiad while it is not active | |||
| Resolved | Marostegui | T163109 Reclone db1063 to become a slave in s5 |
Change 349378 had a related patch set uploaded (by Marostegui):
[operations/mediawiki-config@master] db-eqiad.php: Move db1063 to s5
Change 349381 had a related patch set uploaded (by Marostegui):
[operations/puppet@production] site.pp: Move db1063 to s5
Change 349378 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad.php: Move db1063 to s5
Change 349382 had a related patch set uploaded (by Marostegui):
[operations/mediawiki-config@master] db-eqiad.php: Depool db1070
Change 349382 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad.php: Depool db1071
Mentioned in SAL (#wikimedia-operations) [2017-04-21T07:47:53Z] <marostegui> Stop MySQL on db1071 and db1063 to reclone db1063 - T163109
Change 349387 had a related patch set uploaded (by Marostegui):
[operations/software@master] s2,5.hosts: Move db1063 from s2 to s5
Change 349387 merged by jenkins-bot:
[operations/software@master] s2,5.hosts: Move db1063 from s2 to s5
Change 349381 merged by Marostegui:
[operations/puppet@production] site.pp: Move db1063 to s5
Change 349402 had a related patch set uploaded (by Marostegui):
[operations/mediawiki-config@master] db-eqiad.php: Repool db1071
Change 349402 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad.php: Repool db1071
Mentioned in SAL (#wikimedia-operations) [2017-04-21T10:35:36Z] <marostegui@naos> Synchronized wmf-config/db-eqiad.php: Repool db1071 - T163109 (duration: 01m 20s)
The scope of this ticket is done. db1063 is now replicating as slave (that means binlog type = MIXED) so that needs to be changed before making it the master.
SSL and GTID are enabled.
We will follow up the master switchover on the main ticket: T162133