@aaron would like to enable https://gerrit.wikimedia.org/r/#/c/289985/ via config. It would be nice to do this in betalabs too (instead of just starting with testwiki).
Description
Description
Details
Details
| Subject | Repo | Branch | Lines +/- | |
|---|---|---|---|---|
| db-labs: Enable 'useGTIDs' in Beta Cluster, same as prod | operations/mediawiki-config | master | +1 -0 |
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | Krinkle | T139044 Enable GTID on beta cluster mariaDB once upgraded | |||
| Resolved | dduvall | T138778 Upgrade mariadb in deployment-prep from Precise/MariaDB 5.5 to Jessie/MariaDB 5.10 | |||
| Resolved | dduvall | T147110 Delete deployment-db1 and deployment-db2 |
Event Timeline
Comment Actions
Upgrade happened in 2016, hence this task is not stalled anymore.
No idea if it is still valid though (given stuff like 7f888f94a4a97092f0b825eba2fb6a25eb0159c8 or 462855cefc1bb466243a01c7f8a33dd657d78efc)
Comment Actions
No idea if it is still valid though
Not sure if you ask because you think it is done in production and/or beta, or because the problems we found on production about it :-D. We are in a hybrid status because both. Upgrading to 10+ forces gtid, but not fully. Some iterations will be needed on both envs.
Comment Actions
For the purpose of this task, enabling useGTIDs => true is enough to close it. This was done in production a while ago for the core databases.
Two weeks ago, it was also enabled in prod for external databases (e.g. ES content blobs, and Flow) as part of https://gerrit.wikimedia.org/r/#/c/operations/mediawiki-config/+/525147/.
However, oddly, what was intended as the first step (Beta Cluster) does not yet have it configured. I don't know whether that can be done or not.
Comment Actions
We have GTID enabled for replication on the slaves but we don't really use it for replication topology changes as we've found lots of issues with it in production. Essentially, we relay on the old position/binlog file when having to move slaves around.
Note that the DBA team doesn't own the Beta cluster.
Comment Actions
Change 597624 had a related patch set uploaded (by Krinkle; owner: Krinkle):
[operations/mediawiki-config@master] db-labs: Enable 'useGTIDs' in Beta Cluster, same as prod
Comment Actions
Change 597624 merged by jenkins-bot:
[operations/mediawiki-config@master] db-labs: Enable 'useGTIDs' in Beta Cluster, same as prod