Page MenuHomePhabricator

Set up a way to persist non-default number of wikireplicas connections across all instances
Open, MediumPublic

Description

Since we no longer have few wikireplica servers with only one instance each, the maintain-dbusers script or a similar faculty needs to maintain the max_user_connections of those users who have gone through our approval process for increases.

Normally, we record those at modules/role/templates/mariadb/grants/wiki-replicas.sql in puppet. Currently there are only 3 of them.

-- quarry user granted 48 connections #T180141
GRANT USAGE ON *.* TO 's52788'@'%' WITH MAX_USER_CONNECTIONS 48;
-- user for wikiscan granted 15 connections T227462
GRANT USAGE ON *.* TO 'u12903'@'%' WITH MAX_USER_CONNECTIONS 15;
-- catscan2 (petscan) user granted 40 connections T255730
GRANT USAGE ON *.* TO 's51156'@'%' WITH MAX_USER_CONNECTIONS 40;

Event Timeline

Bstorm created this task.Dec 3 2020, 10:28 PM
bd808 moved this task from Backlog to Wiki replicas on the Data-Services board.Dec 4 2020, 11:18 PM
Andrew triaged this task as Medium priority.Dec 8 2020, 5:11 PM
Andrew moved this task from Inbox to Soon! on the cloud-services-team (Kanban) board.