Page MenuHomePhabricator

Mark mediawikiwiki.translate_cache as private so it doesn't replicate to wiki replicas
Closed, ResolvedPublic

Description

As a follow up discussion from T272428, let's mark translate_cache table as private so it doesn't replicate to labsdb/cloudb hosts.

Event Timeline

Marostegui triaged this task as Medium priority.Jan 26 2021, 9:05 AM
Marostegui moved this task from Triage to Ready on the DBA board.

Change 658558 had a related patch set uploaded (by Kormat; owner: Kormat):
[operations/puppet@production] realm: Add translate_cache to $private_tables.

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

Change 658558 merged by Kormat:
[operations/puppet@production] realm: Add translate_cache to $private_tables.

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

Mentioned in SAL (#wikimedia-operations) [2021-01-26T09:29:39Z] <kormat@cumin1001> START - Cookbook sre.hosts.downtime for 0:30:00 on 6 hosts with reason: Restart mariadb to pick up config changes T272957

Mentioned in SAL (#wikimedia-operations) [2021-01-26T09:29:42Z] <kormat@cumin1001> END (PASS) - Cookbook sre.hosts.downtime (exit_code=0) for 0:30:00 on 6 hosts with reason: Restart mariadb to pick up config changes T272957

Urbanecm added a subscriber: Urbanecm.

This is not a subtask of a former train blocker, removing relationship.

Kormat claimed this task.
Kormat added a subscriber: Kormat.

Table added to $private_tables, change pushed, sanitarium mariadbs restarted, and changes confirmed to be live.

Thanks @Kormat! @abi_ @Nikerabbit can you please let us know when the table is created so we can double check it is indeed not replicated?

Creation of the table is not high priority for us as it's not yet needed on production. That's why I tried to keep that discussion out of the train blocker task.