user_grant_handler: add grouping by section
Open, Needs TriagePublic
Actions

Assigned To

Authored By

	FCeratto-WMF
	Mar 3 2026, 10:47 AM

Project Tags

Referenced Files

None

Subscribers

Aklapper

FCeratto-WMF

Marostegui

Description

user_grant_handler introduced for T393990 applies changes on databases in alphabetical order.
To increase safety, allow it to batch the changes by section and by datacenter and by instance role (replicas first, then masters)

Related Objects

Mentioned Here: T393990: Deploy grants for cumin1003

Event Timeline

FCeratto-WMF created this task.Mar 3 2026, 10:47 AM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMar 3 2026, 10:47 AM

FCeratto-WMF added a project: Sustainability (Incident Followup).Mar 3 2026, 11:17 AM

We should always apply grants with set session sql_log_bin=0 and if creating users with IF NOT EXISTS and if dropping with: IF EXISTS

Test sequence: test-s4, misc, backups, pc*, everything else

FCeratto-WMF moved this task from Triage to Ready on the DBA board.Mar 9 2026, 11:31 AM

FCeratto-WMF moved this task from Ready to In progress on the DBA board.Mar 11 2026, 2:31 PM

FCeratto-WMF moved this task from In progress to Ready on the DBA board.Mar 20 2026, 11:13 AM

user_grant_handler: add grouping by sectionOpen, Needs TriagePublicActions

Description

Related Objects

Event Timeline

user_grant_handler: add grouping by section
Open, Needs TriagePublic
Actions