Page MenuHomePhabricator

FCeratto-WMF (Federico Ceratto)
Site Reliability Engineer

Projects (6)

Today

  • No visible events.

Tomorrow

  • No visible events.

Thursday

  • No visible events.

User Details

User Since
Jan 7 2025, 6:49 PM (56 w, 6 d)
Availability
Available
IRC Nick
federico3
LDAP User
Federico Ceratto
MediaWiki User
FCeratto-WMF [ Global Accounts ]

Recent Activity

Yesterday

FCeratto-WMF created P88734 (An Untitled Masterwork).
Mon, Feb 9, 5:44 PM
FCeratto-WMF created P88733 (An Untitled Masterwork).
Mon, Feb 9, 4:32 PM
FCeratto-WMF created P88731 (An Untitled Masterwork).
Mon, Feb 9, 3:43 PM
FCeratto-WMF moved T416582: Migrate dborch1001 to Bookworm from Refine to In progress on the DBA board.
Mon, Feb 9, 10:44 AM · Patch-For-Review, DBA
FCeratto-WMF closed T383674: Abstract away different database depooling mechanisms into a cookbook, a subtask of T384810: MariaDB lifetime management system, as Resolved.
Mon, Feb 9, 10:23 AM · Patch-For-Review, DBA
FCeratto-WMF closed T383674: Abstract away different database depooling mechanisms into a cookbook as Resolved.
Mon, Feb 9, 10:22 AM · DBA

Thu, Feb 5

FCeratto-WMF moved T416578: Fix power power accounting for misc cluster from Triage to Ready on the DBA board.
Thu, Feb 5, 11:51 AM · observability, Grafana, DBA
FCeratto-WMF claimed T416578: Fix power power accounting for misc cluster.
Thu, Feb 5, 11:51 AM · observability, Grafana, DBA
FCeratto-WMF created T416578: Fix power power accounting for misc cluster.
Thu, Feb 5, 11:51 AM · observability, Grafana, DBA

Tue, Feb 3

FCeratto-WMF created P88518 (An Untitled Masterwork).
Tue, Feb 3, 4:14 PM
FCeratto-WMF closed T384909: sre.mysql.pool check for lag, a subtask of T384810: MariaDB lifetime management system, as Resolved.
Tue, Feb 3, 4:12 PM · Patch-For-Review, DBA
FCeratto-WMF closed T384909: sre.mysql.pool check for lag as Resolved.
Tue, Feb 3, 4:11 PM · DBA
FCeratto-WMF added a comment to T384909: sre.mysql.pool check for lag.

Thanks, closing!

Tue, Feb 3, 2:33 PM · DBA
FCeratto-WMF added a comment to T384909: sre.mysql.pool check for lag.

Currently we wait for Icinga to be/go green before pooling (and this implies the replication lag has to be low enough).
The check can be bypassed using --skip-safety-checks and in that case we do the gradual pooling regardless of lag or Icinga status in general.

Tue, Feb 3, 2:30 PM · DBA
FCeratto-WMF added a comment to P88467 (An Untitled Masterwork).
sudo db-switchover --timeout=25 --replicating-master --read-only-master --only-slave-move db1176.eqiad.wmnet db-test1002.eqiad.wmnet
Tue, Feb 3, 10:26 AM
FCeratto-WMF added a comment to P88467 (An Untitled Masterwork).
$ hostname
cumin1003
$ sudo db-switchover --timeout=25 --replicating-master --read-only-master --only-slave-move db1176 db-test2001
Starting preflight checks...
[ERROR]: Read only status could be not read from one or more servers
$ 
Tue, Feb 3, 10:21 AM
FCeratto-WMF placed T414660: Requesting access to L3 data access for kimpham (developer name Kim.pham) up for grabs.
Tue, Feb 3, 8:37 AM · SRE, SRE-Access-Requests

Thu, Jan 29

FCeratto-WMF edited P88102 (An Untitled Masterwork).
Thu, Jan 29, 10:30 AM
FCeratto-WMF created P88102 (An Untitled Masterwork).
Thu, Jan 29, 10:27 AM

Tue, Jan 27

FCeratto-WMF moved T415564: sre.mysql.clone: start replication on the target after the source from Ready to In progress on the DBA board.
Tue, Jan 27, 4:33 PM · DBA

Mon, Jan 26

FCeratto-WMF added a comment to T415564: sre.mysql.clone: start replication on the target after the source.

Later on with T374026 we could also repool the two hosts at the same time.

Mon, Jan 26, 6:33 PM · DBA
FCeratto-WMF updated the task description for T415564: sre.mysql.clone: start replication on the target after the source.
Mon, Jan 26, 6:23 PM · DBA

Thu, Jan 22

FCeratto-WMF closed T414789: Grant Access to NDA for Johannnes89 as Resolved.

Change deployed, closing task. Please reopen it if there's any issue.

Thu, Jan 22, 2:48 PM · WMF-NDA-Requests, SRE, LDAP-Access-Requests

Wed, Jan 21

FCeratto-WMF closed T413364: Requesting access to analytics-privatedata-users for kareid as Resolved.

Thanks, closing task.

Wed, Jan 21, 6:49 PM · Data-Engineering, SRE-Access-Requests, SRE
FCeratto-WMF closed T412875: Requesting access to cassandra-staging-devs for dr0ptp4kt as Resolved.

I'm closing the task as resolved for now. @dr0ptp4kt if there's any issue please reopen the task.

Wed, Jan 21, 2:17 PM · SRE, SRE-Access-Requests
FCeratto-WMF closed T414830: please update astein puppet ssh key, a subtask of T411679: Requesting access to analytics-privatedata-users for astein, as Resolved.
Wed, Jan 21, 2:08 PM · Fundraising-Backlog, SRE, SRE-Access-Requests
FCeratto-WMF closed T414830: please update astein puppet ssh key as Resolved.

Change deployed on Puppet, closing task.

Wed, Jan 21, 2:08 PM · SRE

Tue, Jan 20

FCeratto-WMF added a comment to T414830: please update astein puppet ssh key.

SSH key verified, opening CR.

Tue, Jan 20, 9:41 PM · SRE
FCeratto-WMF added a comment to T414789: Grant Access to NDA for Johannnes89.

@FRomeo_WMF and @greg hello - could you please review the request for approval?

Tue, Jan 20, 3:01 PM · WMF-NDA-Requests, SRE, LDAP-Access-Requests
FCeratto-WMF closed T414671: Requesting access to SRE/production access for Kim.pham (kimpham in phab) as Resolved.

Change deployed, closing task.

Tue, Jan 20, 1:30 PM · SRE, SRE-Access-Requests
FCeratto-WMF closed T414660: Requesting access to L3 data access for kimpham (developer name Kim.pham) as Resolved.

Change deployed, closing task.

Tue, Jan 20, 1:29 PM · SRE, SRE-Access-Requests
FCeratto-WMF updated the task description for T414671: Requesting access to SRE/production access for Kim.pham (kimpham in phab).
Tue, Jan 20, 10:28 AM · SRE, SRE-Access-Requests

Mon, Jan 19

FCeratto-WMF added a comment to T413364: Requesting access to analytics-privatedata-users for kareid.

@KReid-WMF access configured - can you please confirm it works so we can close the task? Thanks

Mon, Jan 19, 4:42 PM · Data-Engineering, SRE-Access-Requests, SRE
FCeratto-WMF changed the status of T239814: Automate DB upgrades, a subtask of T384810: MariaDB lifetime management system, from In Progress to Open.
Mon, Jan 19, 2:57 PM · Patch-For-Review, DBA
FCeratto-WMF changed the status of T239814: Automate DB upgrades from In Progress to Open.
Mon, Jan 19, 2:57 PM · Patch-For-Review, Data-Persistence-Automations, User-Ladsgroup, DBA
FCeratto-WMF updated subscribers of T414671: Requesting access to SRE/production access for Kim.pham (kimpham in phab).

If I'm understanding correctly that this is a request for the deployment group, @thcipriani can you please approve it?

Mon, Jan 19, 2:09 PM · SRE, SRE-Access-Requests
FCeratto-WMF updated the task description for T414774: undisable vanderwaalforces in phabricator and ldap.
Mon, Jan 19, 1:58 PM · SRE, Phabricator, LDAP-Access-Requests
FCeratto-WMF added a comment to T239814: Automate DB upgrades.

As discussed I'll add a lock on the section to update one host at a time and show it on https://zarcillo.wikimedia.org/ui/locks

Mon, Jan 19, 1:07 PM · Patch-For-Review, Data-Persistence-Automations, User-Ladsgroup, DBA
FCeratto-WMF updated the task description for T414660: Requesting access to L3 data access for kimpham (developer name Kim.pham).
Mon, Jan 19, 12:43 PM · SRE, SRE-Access-Requests
FCeratto-WMF changed the status of T413364: Requesting access to analytics-privatedata-users for kareid from Open to In Progress.
Mon, Jan 19, 12:40 PM · Data-Engineering, SRE-Access-Requests, SRE
FCeratto-WMF claimed T414830: please update astein puppet ssh key.

Pending OOB confirmation of the SSH key

Mon, Jan 19, 12:33 PM · SRE
FCeratto-WMF added a subtask for T411679: Requesting access to analytics-privatedata-users for astein: T414830: please update astein puppet ssh key.
Mon, Jan 19, 12:21 PM · Fundraising-Backlog, SRE, SRE-Access-Requests
FCeratto-WMF added a parent task for T414830: please update astein puppet ssh key: T411679: Requesting access to analytics-privatedata-users for astein.
Mon, Jan 19, 12:21 PM · SRE
FCeratto-WMF added a comment to T414830: please update astein puppet ssh key.

Related to T411679 where the access was initially granted.

Mon, Jan 19, 12:21 PM · SRE
FCeratto-WMF updated subscribers of T414660: Requesting access to L3 data access for kimpham (developer name Kim.pham).

Hello @Milimetric @Ahoelzl @Ottomata - can you please review this access request for analytics-privatedata-users? Thanks

Mon, Jan 19, 10:44 AM · SRE, SRE-Access-Requests
FCeratto-WMF changed the status of T414660: Requesting access to L3 data access for kimpham (developer name Kim.pham) from Open to In Progress.
Mon, Jan 19, 10:40 AM · SRE, SRE-Access-Requests
FCeratto-WMF closed T356053: Test setup for MariaDB as Resolved.

Implemented in T400056

Mon, Jan 19, 10:38 AM · Data-Persistence-Automations, DBA
FCeratto-WMF closed T412126: Yubikey-SSH-FIDO for ryankemper as Resolved.
Mon, Jan 19, 10:32 AM · SRE, SRE-Access-Requests
FCeratto-WMF updated the task description for T412126: Yubikey-SSH-FIDO for ryankemper.
Mon, Jan 19, 10:32 AM · SRE, SRE-Access-Requests
FCeratto-WMF closed T414678: Requesting access to analytics-privatedata-users for johannesrichterwmde as Resolved.

Thanks, closing task.

Mon, Jan 19, 9:54 AM · SRE, SRE-Access-Requests

Fri, Jan 16

FCeratto-WMF added a comment to T414678: Requesting access to analytics-privatedata-users for johannesrichterwmde.

@Johannes_Richter_WMDE i updated the permissions, can you please confirm that you have access now? Thanks

Fri, Jan 16, 4:55 PM · SRE, SRE-Access-Requests
FCeratto-WMF updated the task description for T414678: Requesting access to analytics-privatedata-users for johannesrichterwmde.
Fri, Jan 16, 4:54 PM · SRE, SRE-Access-Requests
FCeratto-WMF added a comment to T412875: Requesting access to cassandra-staging-devs for dr0ptp4kt.

@dr0ptp4kt the change was deployed, can you please confirm if the access works for you now?

Fri, Jan 16, 4:48 PM · SRE, SRE-Access-Requests
FCeratto-WMF added a comment to T412126: Yubikey-SSH-FIDO for ryankemper.

Ryan confirmed on IRC, opening https://gerrit.wikimedia.org/r/c/operations/puppet/+/1227848

Fri, Jan 16, 4:47 PM · SRE, SRE-Access-Requests
FCeratto-WMF changed the status of T383674: Abstract away different database depooling mechanisms into a cookbook, a subtask of T384810: MariaDB lifetime management system, from In Progress to Open.
Fri, Jan 16, 3:10 PM · Patch-For-Review, DBA
FCeratto-WMF changed the status of T383674: Abstract away different database depooling mechanisms into a cookbook from In Progress to Open.

@Marostegui ok - I'll put it back into Open/Pending in the meantime.

Fri, Jan 16, 3:10 PM · DBA
FCeratto-WMF updated the task description for T412875: Requesting access to cassandra-staging-devs for dr0ptp4kt.
Fri, Jan 16, 2:46 PM · SRE, SRE-Access-Requests
FCeratto-WMF added a comment to T413634: DannyS712 "offboarding".

Hello @DannyS712 sorry for the ping, when you have a second could you please reply to https://phabricator.wikimedia.org/T413634#11505670

Fri, Jan 16, 2:23 PM · Release-Engineering-Team, SecTeam-Processed, LDAP-Access-Requests, Security-Team, SRE-Access-Requests, SRE, User-DannyS712
FCeratto-WMF updated the task description for T414678: Requesting access to analytics-privatedata-users for johannesrichterwmde.
Fri, Jan 16, 1:58 PM · SRE, SRE-Access-Requests
FCeratto-WMF updated the task description for T414678: Requesting access to analytics-privatedata-users for johannesrichterwmde.
Fri, Jan 16, 1:49 PM · SRE, SRE-Access-Requests
FCeratto-WMF updated the task description for T409926: Primary-replica switchover automation.
Fri, Jan 16, 11:55 AM · Patch-For-Review, DBA
FCeratto-WMF updated the task description for T409926: Primary-replica switchover automation.
Fri, Jan 16, 11:54 AM · Patch-For-Review, DBA
FCeratto-WMF added a comment to T239814: Automate DB upgrades.

I updated the task summary: the cookbook is doing depooling, replication lag checks, icinga checks and repooling and was tested on different hosts.

Fri, Jan 16, 11:46 AM · Patch-For-Review, Data-Persistence-Automations, User-Ladsgroup, DBA
FCeratto-WMF updated the task description for T239814: Automate DB upgrades.
Fri, Jan 16, 11:45 AM · Patch-For-Review, Data-Persistence-Automations, User-Ladsgroup, DBA
FCeratto-WMF added a comment to T412126: Yubikey-SSH-FIDO for ryankemper.

[Pinged RKemper on IRC]

Fri, Jan 16, 11:22 AM · SRE, SRE-Access-Requests
FCeratto-WMF updated the task description for T414660: Requesting access to L3 data access for kimpham (developer name Kim.pham).
Fri, Jan 16, 10:35 AM · SRE, SRE-Access-Requests
FCeratto-WMF updated the task description for T414671: Requesting access to SRE/production access for Kim.pham (kimpham in phab).
Fri, Jan 16, 10:34 AM · SRE, SRE-Access-Requests
FCeratto-WMF updated the task description for T414671: Requesting access to SRE/production access for Kim.pham (kimpham in phab).
Fri, Jan 16, 9:54 AM · SRE, SRE-Access-Requests
FCeratto-WMF updated the task description for T414671: Requesting access to SRE/production access for Kim.pham (kimpham in phab).
Fri, Jan 16, 9:54 AM · SRE, SRE-Access-Requests
FCeratto-WMF added a comment to T414660: Requesting access to L3 data access for kimpham (developer name Kim.pham).

Pending out of band SSH verification.

Fri, Jan 16, 9:53 AM · SRE, SRE-Access-Requests
FCeratto-WMF updated the task description for T414660: Requesting access to L3 data access for kimpham (developer name Kim.pham).
Fri, Jan 16, 9:48 AM · SRE, SRE-Access-Requests
FCeratto-WMF updated the task description for T414660: Requesting access to L3 data access for kimpham (developer name Kim.pham).
Fri, Jan 16, 9:44 AM · SRE, SRE-Access-Requests

Thu, Jan 15

FCeratto-WMF added a comment to T304653: Release and package auto_schema 0.1.0.

we've done quite a bunch of work to get the wmfmariadbpy repo to build and publish packages that can be installed on cumin hosts - we can add auto schema to it in a dedicated package and dedicated directory

Thu, Jan 15, 10:22 AM · Auto schema, User-Ladsgroup, DBA

Wed, Jan 14

FCeratto-WMF created T414564: Power Supply Redundancy alert on es1057.
Wed, Jan 14, 10:31 AM · SRE, DC-Ops, ops-eqiad

Tue, Jan 13

FCeratto-WMF moved T373436: cookbook to change a host's master from Ready to In progress on the DBA board.
Tue, Jan 13, 1:56 PM · Patch-For-Review, DBA, Data-Persistence-Automations
FCeratto-WMF changed the status of T373436: cookbook to change a host's master from Open to In Progress.
Tue, Jan 13, 1:56 PM · Patch-For-Review, DBA, Data-Persistence-Automations

Mon, Jan 12

FCeratto-WMF renamed T373436: cookbook to change a host's master from cookbook: mariadb change master to to cookbook to change a host's master.
Mon, Jan 12, 2:54 PM · Patch-For-Review, DBA, Data-Persistence-Automations
FCeratto-WMF changed the status of T376370: mariadb: create a synthetic monitoring indicator for dc switchover readiness, a subtask of T384810: MariaDB lifetime management system, from Stalled to Open.
Mon, Jan 12, 1:24 PM · Patch-For-Review, DBA
FCeratto-WMF changed the status of T376370: mariadb: create a synthetic monitoring indicator for dc switchover readiness from Stalled to Open.
Mon, Jan 12, 1:24 PM · Data-Persistence-Automations, DBA
FCeratto-WMF closed T412943: Drop the cupe_private column from the cu_private_event table on WMF wikis as Resolved.

Completed on codfw.

Mon, Jan 12, 12:14 PM · Data-Engineering, DBA, Schema-change-in-production
FCeratto-WMF closed T413688: Add status columns to transcode table in wmf production, a subtask of T362123: Retool transcode table with a status column, as Resolved.
Mon, Jan 12, 11:42 AM · Patch-For-Review, TimedMediaHandler-Transcode
FCeratto-WMF closed T413688: Add status columns to transcode table in wmf production as Resolved.

Completed on codfw

Mon, Jan 12, 11:42 AM · Data-Engineering, Schema-change-in-production, DBA
FCeratto-WMF added a comment to T413688: Add status columns to transcode table in wmf production.

Completed on eqiad DC master

Mon, Jan 12, 9:45 AM · Data-Engineering, Schema-change-in-production, DBA
FCeratto-WMF added a comment to T412943: Drop the cupe_private column from the cu_private_event table on WMF wikis.

Completed on eqiad DC master

Mon, Jan 12, 9:17 AM · Data-Engineering, DBA, Schema-change-in-production
FCeratto-WMF added a comment to T315642: Monitor GTID status.

I saw the alert on alertmanager:

Screenshot 2026-01-12 at 09-52-18 Alerts for wikimedia.org.png (322×631 px, 65 KB)

Mon, Jan 12, 8:55 AM · DBA

Jan 9 2026

FCeratto-WMF closed T414052: Fix confusing sre.mysql.clone output as Resolved.
Jan 9 2026, 3:46 PM · DBA
FCeratto-WMF moved T315642: Monitor GTID status from Ready to Pending comment on the DBA board.
Jan 9 2026, 3:42 PM · DBA
FCeratto-WMF moved T383674: Abstract away different database depooling mechanisms into a cookbook from Blocked to Pending comment on the DBA board.
Jan 9 2026, 3:42 PM · DBA
FCeratto-WMF moved T414052: Fix confusing sre.mysql.clone output from Ready to Pending comment on the DBA board.
Jan 9 2026, 3:41 PM · DBA

Jan 8 2026

FCeratto-WMF updated the task description for T413688: Add status columns to transcode table in wmf production.
Jan 8 2026, 2:42 PM · Data-Engineering, Schema-change-in-production, DBA
FCeratto-WMF added a comment to T413688: Add status columns to transcode table in wmf production.

Completed on codfw on replicas.

Jan 8 2026, 2:42 PM · Data-Engineering, Schema-change-in-production, DBA
FCeratto-WMF added a comment to T412943: Drop the cupe_private column from the cu_private_event table on WMF wikis.

Completed on codfw on replicas.

Jan 8 2026, 2:42 PM · Data-Engineering, DBA, Schema-change-in-production

Jan 7 2026

FCeratto-WMF added a comment to T413688: Add status columns to transcode table in wmf production.

Completed in eqiad on replicas.

Jan 7 2026, 9:52 AM · Data-Engineering, Schema-change-in-production, DBA
FCeratto-WMF added a comment to T412943: Drop the cupe_private column from the cu_private_event table on WMF wikis.

Completed in eqiad on replicas.

Jan 7 2026, 9:51 AM · Data-Engineering, DBA, Schema-change-in-production
FCeratto-WMF moved T413688: Add status columns to transcode table in wmf production from Pending comment to Blocked on the DBA board.
Jan 7 2026, 9:51 AM · Data-Engineering, Schema-change-in-production, DBA
FCeratto-WMF moved T412943: Drop the cupe_private column from the cu_private_event table on WMF wikis from Pending comment to Blocked on the DBA board.
Jan 7 2026, 9:51 AM · Data-Engineering, DBA, Schema-change-in-production

Jan 5 2026

FCeratto-WMF moved T413688: Add status columns to transcode table in wmf production from In progress to Pending comment on the DBA board.
Jan 5 2026, 10:53 AM · Data-Engineering, Schema-change-in-production, DBA
FCeratto-WMF moved T412943: Drop the cupe_private column from the cu_private_event table on WMF wikis from In progress to Pending comment on the DBA board.
Jan 5 2026, 10:53 AM · Data-Engineering, DBA, Schema-change-in-production
FCeratto-WMF changed the status of T412943: Drop the cupe_private column from the cu_private_event table on WMF wikis from Open to In Progress.
Jan 5 2026, 10:50 AM · Data-Engineering, DBA, Schema-change-in-production
FCeratto-WMF moved T413688: Add status columns to transcode table in wmf production from Ready to In progress on the DBA board.
Jan 5 2026, 10:44 AM · Data-Engineering, Schema-change-in-production, DBA