Page MenuHomePhabricator

sre.mysql.pool / depool / parsercache cleanup: first part
Closed, ResolvedPublic

Description

At the moment sre.mysql.pool acts as a frontend for sre.mysql.parsercache and supports entire sections depooling, both parsercache and msX, so we should:

  • Split pool/depool codebase as needed across pool.py and depool.py

Details

Related Changes in Gerrit:

Event Timeline

Marostegui triaged this task as Medium priority.Apr 6 2026, 9:14 AM
Marostegui moved this task from Triage to Refine on the DBA board.

@FCeratto-WMF I think for clarity maybe we need to rename this to:

sre.mysql.section
or
sre.mysql.pool-section

What do you think?
We should check if this existing cookbook is being used somewhere else
From a quick grep I only see it referenced in pool.py (as the delegate call) and its own tests, nothing else in the repo calls it directly. But can you double check?

Last time we discussed it the idea was to use sre.mysql.pool as a frontend for pooling/depooling anything so we could merge the codebase together to keep it simple.

FCeratto-WMF renamed this task from Rename sre.mysql.parsercache to something else to sre.mysql.pool / depool / parsercache cleanup.May 27 2026, 4:06 PM

Related to this and T427381: I updated the description with some more detailed steps

Change #1295480 had a related patch set uploaded (by Federico Ceratto; author: Federico Ceratto):

[operations/cookbooks@master] sre.mysql: split pool/depool

https://gerrit.wikimedia.org/r/1295480

Completed depooling of db2228 by fceratto@cumin1003: Depool test

Starting pool of db2228 by fceratto@cumin1003: Pool test

Completed pooling of db2228 by fceratto@cumin1003: Pool test

Completed depooling of db2228 by fceratto@cumin1003: Depool test

Starting pool of db2228 by fceratto@cumin1003: Pool test

Completed pooling of db2228 by fceratto@cumin1003: Pool test

Depooled pc1023.eqiad.wmnet and pc2023.codfw.wmnet Depool test - fceratto@cumin1003 - T422361

Depooled pc1023.eqiad.wmnet and pc2023.codfw.wmnet Pool test - fceratto@cumin1003 - T422361

Depooled pc1023.eqiad.wmnet and pc2023.codfw.wmnet Depool test - fceratto@cumin1003 - T422361

Depooled pc1023.eqiad.wmnet and pc2023.codfw.wmnet Pool test - fceratto@cumin1003 - T422361

Change #1295480 merged by jenkins-bot:

[operations/cookbooks@master] sre.mysql: split pool/depool

https://gerrit.wikimedia.org/r/1295480

FCeratto-WMF renamed this task from sre.mysql.pool / depool / parsercache cleanup to sre.mysql.pool / depool / parsercache cleanup: first part.Fri, Jul 17, 7:50 AM
FCeratto-WMF closed this task as Resolved.
FCeratto-WMF updated the task description. (Show Details)
FCeratto-WMF moved this task from Ready to Done on the DBA board.

For better clarity I'm moving the next steps in a dedicated task T432435