Page MenuHomePhabricator
Create Task
Maniphest T411111

Database Creation request for requestctl.wikimedia.org
Closed, ResolvedPublic
Actions

Description

QPS: Normally, zero. In some specific moment, 10 QPS at peak
Size: less than 10 MB at the start
DB Name: requestctl
User: gus_gus
Accessed from server (s): Alert*; eventually the kubernetes aux worker nodes
Backup Policy: Weekly is ok
Grants needed: read/write, table creation and modification.

Replica: if possible, having cross-dc replica would be great. I want to underline that there's also the option of running a dedicated mariadb instance within the kubernetes aux cluster for this specific project, which would allow for independent switchovers. Given the scarcity of traffic involved, and the small size of the db, we should consider this option.

Details

Related Changes in Gerrit:
SubjectRepoBranchLines +/-
production-m2.sql.erb: Add requestctl database grantsoperations/puppetproduction+17 -1
Customize query in gerrit

Related Objects
Search...

Event Timeline

Joe created this task.Nov 26 2025, 4:20 PM
• Marostegui assigned this task to FCeratto-WMF.Nov 26 2025, 4:51 PM
• Marostegui triaged this task as Medium priority.
• Marostegui moved this task from Triage to Refine on the DBA board.
• Marostegui subscribed.

We do have a replica on each DC for all mX sections (where this database would land). Do you need to read from it or is it just for HA?
This is a misc example topology: https://orchestrator.wikimedia.org/web/cluster/alias/m1

• Marostegui added a comment.Nov 27 2025, 6:34 AM

@Joe if you want to use your "own" database on k8s, that's entirely up to you. Otherwise we can place this db in m2 cc @FCeratto-WMF

FCeratto-WMF moved this task from Refine to Ready on the DBA board.Dec 1 2025, 2:33 PM
FCeratto-WMF moved this task from Ready to In progress on the DBA board.Dec 2 2025, 11:09 AM
FCeratto-WMF added a comment.EditedDec 2 2025, 11:20 AM

As discussed on IRC I'm creating the database as:

DB Name: requestctl
User: gus_gus
Section: m2
• Marostegui added a comment.Dec 2 2025, 11:23 AM

Remember the user needs to have privileges from the proxies IPs only and the connection should be made to m2-master.eqiad.wmnet as that is rerouted via haproxy to the appropiated host.

FCeratto-WMF added a comment.Dec 2 2025, 11:33 AM

Documented in https://wikitech.wikimedia.org/w/index.php?title=MariaDB/misc&oldid=2367153

gerritbot added a comment.Dec 2 2025, 11:52 AM

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

[operations/puppet@production] production-m2.sql.erb: Add requestctl database grants

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

gerritbot added a project: Patch-For-Review.Dec 2 2025, 11:52 AM
gerritbot added a comment.Dec 2 2025, 2:58 PM

Change #1214002 merged by Federico Ceratto:

[operations/puppet@production] production-m2.sql.erb: Add requestctl database grants

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

Maintenance_bot removed a project: Patch-For-Review.Dec 2 2025, 3:31 PM
FCeratto-WMF moved this task from In progress to Blocked on the DBA board.Dec 2 2025, 4:11 PM
FCeratto-WMF closed this task as Resolved.Dec 4 2025, 9:30 AM

Verified out-of-band on IRC: @Joe received the password and the database is ready. Closing.

Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits