There are many extensions using the Extra shard 1 (a mysql cluster shared between wikis) with dubious connections patterns, bad for active-active db deployment, such as persistent connections to the master or many reads sent to it.
This is a metaticket to track x1 bad behaviours and create subtasks to the extension owners.
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | Marostegui | T164504 Tracking: Cleanup x1 database connection patterns | |||
| Resolved | Addshore | T164407 Cognate has been disabled from WMF because it caused an outage on x1 by overtaking 10000 concurrent connections | |||
| Resolved | Addshore | T165608 Write an incident report of wikimedia outage caused by Cognate extension | |||
| Open | None | T166122 Cognate does some updates synchronously, and others via JobQueue. That may lead to inconsistencies in the DB | |||
| Resolved | Catrope | T164505 Read queries detected on the x1 master by Echo extension |
Going to close this as we haven't really worked on this meta task for years. We still have T166122 as subtask, which is unlikely to be worked on soon anyways. I have subscribed myself to that one in case there's something else needed.