Details
Status | Subtype | Assigned | Task | ||
---|---|---|---|---|---|
Restricted Task | |||||
Open | None | T120532 Use user-specific passwords for accessing Analytics MariaDB replica databases | |||
Resolved | aaron | T88445 MediaWiki active/active datacenter investigation and work (tracking) | |||
Resolved | Krinkle | T270223 FY2021-2022: Enable basic Multi-DC operations for read traffic (tracking) | |||
Resolved | tstarling | T134809 App servers <=> mariadb SSL/TLS for cross-datacenter writes | |||
Resolved | LSobanski | T111653 Encrypt all the things | |||
Resolved | jcrespo | T111654 Set up TLS for MariaDB replication | |||
Resolved | jcrespo | T151995 Rolling restart of external storage servers for TLS certificate update |
Event Timeline
Change 324411 had a related patch set uploaded (by Jcrespo):
mariadb: Drop ssl (tls) options from external storage servers
Change 324411 merged by Jcrespo:
mariadb: Drop ssl (tls) options from external storage servers
Mentioned in SAL (#wikimedia-operations) [2016-11-30T12:29:38Z] <jynus> mysql restart and general upgrade for es2015 T151995
Mentioned in SAL (#wikimedia-operations) [2016-11-30T13:08:16Z] <jynus> mysql restart and general upgrade for es2019 T151995
Mentioned in SAL (#wikimedia-operations) [2016-11-30T13:15:51Z] <jynus> mysql restart and general upgrade for es2017 T151995
Mentioned in SAL (#wikimedia-operations) [2016-11-30T14:06:45Z] <jynus> mysql restart and general upgrade for es2014 T151995
Mentioned in SAL (#wikimedia-operations) [2016-11-30T14:42:41Z] <jynus> mysql restart and general upgrade for es2011 T151995
Mentioned in SAL (#wikimedia-operations) [2016-11-30T15:11:20Z] <jynus> mysql restart and general upgrade for es2012 T151995
Mentioned in SAL (#wikimedia-operations) [2016-11-30T15:29:10Z] <jynus> mysql restart and general upgrade for es2013 T151995
!log stopping for 24 hours cross-dc replication on shards es2,es3 codfw->eqiad (es1015, es1019)
Mentioned in SAL (#wikimedia-operations) [2016-11-30T15:50:36Z] <jynus> mysql restart and general upgrade for es2016 T151995
Mentioned in SAL (#wikimedia-operations) [2016-11-30T16:12:57Z] <jynus> mysql restart and general upgrade for es2018 T151995
Change 324481 had a related patch set uploaded (by Jcrespo):
mariadb: Depool es1012 for maintenance and upgrade
Mentioned in SAL (#wikimedia-operations) [2016-11-30T17:20:53Z] <jynus> mysql restart and general upgrade for es1012 T151995
Change 324518 had a related patch set uploaded (by Jcrespo):
mariadb: Depool es1013 for maintenance and general upgrade
Change 324518 merged by Jcrespo:
mariadb: Depool es1013 for maintenance and general upgrade
Mentioned in SAL (#wikimedia-operations) [2016-11-30T18:43:07Z] <jynus> mysql restart and general upgrade for es1013 T151995
Change 324539 had a related patch set uploaded (by Jcrespo):
mariadb: depool db1017 for maintenance and general upgrade
Change 324539 merged by Jcrespo:
mariadb: depool db1017 for maintenance and general upgrade
Mentioned in SAL (#wikimedia-operations) [2016-11-30T20:07:22Z] <jynus> mysql restart and general upgrade for es1017 T151995
Change 324665 had a related patch set uploaded (by Jcrespo):
mariadb: Depool es1016 for maintenance
Mentioned in SAL (#wikimedia-operations) [2016-12-01T07:22:00Z] <jynus> mysql upgrade and restart for es1016 T151995
Change 324667 had a related patch set uploaded (by Jcrespo):
mariadb: Depool es1011 for mysql restart
Mentioned in SAL (#wikimedia-operations) [2016-12-01T07:38:04Z] <jynus> mysql restart for es1011 T151995
Change 324670 had a related patch set uploaded (by Jcrespo):
mariadb: Depool es1014 for mysql restart
Mentioned in SAL (#wikimedia-operations) [2016-12-01T07:51:35Z] <jynus> mysql restart for es1014 T151995
Change 324674 had a related patch set uploaded (by Jcrespo):
mariadb: Depool es1018 for mysql upgrade and restart
Change 324674 merged by Jcrespo:
mariadb: Depool es1018 for mysql upgrade and restart
Mentioned in SAL (#wikimedia-operations) [2016-12-01T09:14:19Z] <jynus> mysql restart and upgrade for es1018 T151995
Change 324683 had a related patch set uploaded (by Jcrespo):
mariadb: Master switchover on es2 shard (eqiad) es1015 -> es1011
Change 324684 had a related patch set uploaded (by Jcrespo):
Master switchover on es3 shard (eqiad) es1019 -> es1014
Change 324688 had a related patch set uploaded (by Jcrespo):
mariadb: swithover es2 master (eqiad) es1015 -> es1011
Change 324688 merged by jenkins-bot:
mariadb: swithover es2 master (eqiad) es1015 -> es1011
Change 324683 merged by Jcrespo:
mariadb: Master switchover on es2 shard (eqiad) es1015 -> es1011
Change 324695 had a related patch set uploaded (by Marostegui):
wmnet: Change es2 master
Change 324723 had a related patch set uploaded (by Jcrespo):
mariadb: swithover es3 master (eqiad) es1019 -> es1014
Change 324723 merged by Jcrespo:
mariadb: swithover es3 master (eqiad) es1019 -> es1014
Change 324684 merged by Jcrespo:
Master switchover on es3 shard (eqiad) es1019 -> es1014
Mentioned in SAL (#wikimedia-operations) [2016-12-01T15:08:34Z] <marostegui> DNS change for es2 and es3 after the master switchovers - T151995
Change 324740 had a related patch set uploaded (by Jcrespo):
Depool es1015 for maintenance
Mentioned in SAL (#wikimedia-operations) [2016-12-01T16:19:13Z] <jynus> mysql restart for es1015 T151995
Mentioned in SAL (#wikimedia-operations) [2016-12-01T16:58:31Z] <jynus> mysql restart for es1019 T151995
Change 324754 had a related patch set uploaded (by Jcrespo):
Repool es2019 after maintenance
Waiting for es2019 and es2015 to warmup their buffer pools to repool them and I could close this.