While looking for a suitable slave to be db1095's future master I thought about db1070 because:
I noticed it is not using file per table:
ie: dewiki's size is 63G and wikidatawiki size is 8G whereas the ibdata file is 1.1T
db1071 is using it and the sizes are:
dewiki -> 382G
wikidatawiki -> 858G
Both are serving API
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | jcrespo | T140788 Labs databases rearchitecture (tracking) | |||
| Resolved | jcrespo | T153058 LabsDB infrastructure pending work | |||
| Resolved | None | T159423 Meta ticket: Migrate multi-source database hosts to multi-instance | |||
| Resolved | • Marostegui | T153743 Add and sanitize s2, s4, s5, s6 and s7 to sanitarium2 and new labsdb hosts | |||
| Resolved | • Marostegui | T137191 Defragment db1070, db1082, db1087, db1092 | |||
| Resolved | • Marostegui | T157931 s5: db1070 not using file per table |
db1070 finished importing all the files. It is now replicating and trying to catch up
Seconds_Behind_Master: 247481
Change 343051 had a related patch set uploaded (by Marostegui):
[operations/mediawiki-config] db-eqiad.php: Repool db1070 with low weight
Change 343051 merged by jenkins-bot:
[operations/mediawiki-config] db-eqiad.php: Repool db1070 with low weight
Mentioned in SAL (#wikimedia-operations) [2017-03-16T14:31:22Z] <marostegui@tin> Synchronized wmf-config/db-eqiad.php: Repool db1070 with low weight - T157931 (duration: 00m 45s)
So, db1070 has caught up. I have repooled it with a low weight to see how it behaves. Replication had no issues.
I will leave it like that (increasing its weight) until Monday or so, before recloning the other hosts which also need to be switched to use file per table: T137191
Change 343085 had a related patch set uploaded (by Marostegui):
[operations/mediawiki-config] db-eqiad.php: Increase weight for db1070
Change 343085 merged by jenkins-bot:
[operations/mediawiki-config] db-eqiad.php: Increase weight for db1070
Mentioned in SAL (#wikimedia-operations) [2017-03-16T16:44:37Z] <marostegui@tin> Synchronized wmf-config/db-eqiad.php: Increase weight for db1070 - T157931 (duration: 00m 41s)
Change 343250 had a related patch set uploaded (by Marostegui):
[operations/mediawiki-config] db-eqiad.php: Increase weight db1070
Change 343250 merged by jenkins-bot:
[operations/mediawiki-config] db-eqiad.php: Increase weight db1070
Mentioned in SAL (#wikimedia-operations) [2017-03-17T07:24:55Z] <marostegui@tin> Synchronized wmf-config/db-eqiad.php: Increase weight for db1070 - T157931 (duration: 00m 45s)
db1070 has been up for 24h now without any issues and receiving production traffic, so considering this resolved.