Page MenuHomePhabricator

Setup a maps staging DB
Open, Needs TriagePublic

Description

For the migration of maps to Bookworm (T381565) we had used six former Ganeti nodes as test servers.

We'll keep maps-test2001 around as a separate staging system (single PG master, no replicas, a separate role::maps::staging will be used (https://gerrit.wikimedia.org/r/c/operations/puppet/+/1201077)) to eventually point the wikikube staging endpoint to it. This will allow us to test changes like https://gerrit.wikimedia.org/r/c/mediawiki/services/kartotherian/+/1201020 or https://phabricator.wikimedia.org/T407491 more systematically w/o risk to the main production setup.

It's an old Ganeti node, but it should be good for the remainder of the FY and we will refresh it with new hardware in the next one.

Event Timeline

Created a new bucket with swift post and the Tegola AUTH credentials on thanos-fe1004:

root@thanos-fe1004:~# swift stat tegola-swift-staging-codfw-v001
                      Account: AUTH_tegola
                    Container: tegola-swift-staging-codfw-v001
                      Objects: 0
                        Bytes: 0
                     Read ACL:
                    Write ACL:
                      Sync To:
                     Sync Key:
                 Content-Type: application/json; charset=utf-8
                  X-Timestamp: 1763045396.18537
                Last-Modified: Thu, 13 Nov 2025 14:49:57 GMT

Change #1204915 had a related patch set uploaded (by Muehlenhoff; author: Muehlenhoff):

[labs/private@master] Add stub secrets for the staging role

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

Change #1204915 merged by Muehlenhoff:

[labs/private@master] Add stub secrets for the staging role

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

After a chat with Moritz we realized that the better path is probably to create another account for staging, and create the new container in there. In this way we fully disentangle prod from staging, and we don't risk to mess up prod tiles when working in staging.

Change #1204926 had a related patch set uploaded (by Muehlenhoff; author: Muehlenhoff):

[labs/private@master] Add missing secret

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

Change #1204926 merged by Muehlenhoff:

[labs/private@master] Add missing secret

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

Change #1205009 had a related patch set uploaded (by Muehlenhoff; author: Muehlenhoff):

[operations/puppet@production] Set (initially stub) Swift container for Tegola

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

Change #1205009 merged by Muehlenhoff:

[operations/puppet@production] Set (initially stub) Swift container for Tegola

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

Change #1205086 had a related patch set uploaded (by Muehlenhoff; author: Muehlenhoff):

[operations/puppet@production] Set (initially) stub Eventgate config for maps/staging

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

Change #1205086 merged by Muehlenhoff:

[operations/puppet@production] Set (initially) stub Eventgate config for maps/staging

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

Mentioned in SAL (#wikimedia-operations) [2025-11-19T07:59:54Z] <moritzm> started OSM import on maps-test2001 T409528

Change #1210587 had a related patch set uploaded (by Muehlenhoff; author: Muehlenhoff):

[operations/puppet@production] Enable imports on maps-test2001

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

Change #1210598 had a related patch set uploaded (by Elukey; author: Elukey):

[operations/mediawiki-config@master] Add a staging-specific stream for Maps tiles change

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

Change #1210599 had a related patch set uploaded (by Elukey; author: Elukey):

[operations/puppet@production] profile::thanos::swift: add tegola account for staging

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

Change #1210599 merged by Elukey:

[operations/puppet@production] profile::thanos::swift: add tegola account for staging

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

Change #1211609 had a related patch set uploaded (by Elukey; author: Elukey):

[operations/deployment-charts@master] services: move tegola and kartotherian to the new staging db

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

Change #1211609 merged by Elukey:

[operations/deployment-charts@master] services: move tegola and kartotherian to the new staging db

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

Change #1210587 merged by Muehlenhoff:

[operations/puppet@production] Enable imports on maps-test2001

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

Change #1211631 had a related patch set uploaded (by Elukey; author: Elukey):

[operations/deployment-charts@master] services: set new caching and kafka configuration for Tegola staging

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

Change #1210598 merged by jenkins-bot:

[operations/mediawiki-config@master] Add a staging-specific stream for Maps tiles change

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

Mentioned in SAL (#wikimedia-operations) [2025-11-26T14:47:10Z] <elukey@deploy2002> Started scap sync-world: Backport for [[gerrit:1210598|Add a staging-specific stream for Maps tiles change (T409528)]]

Mentioned in SAL (#wikimedia-operations) [2025-11-26T14:49:28Z] <elukey@deploy2002> elukey: Backport for [[gerrit:1210598|Add a staging-specific stream for Maps tiles change (T409528)]] synced to the testservers (see https://wikitech.wikimedia.org/wiki/Mwdebug). Changes can now be verified there.

Mentioned in SAL (#wikimedia-operations) [2025-11-26T14:53:52Z] <elukey@deploy2002> Finished scap sync-world: Backport for [[gerrit:1210598|Add a staging-specific stream for Maps tiles change (T409528)]] (duration: 06m 41s)

Change #1211631 merged by Elukey:

[operations/deployment-charts@master] services: set new caching and kafka configuration for Tegola staging

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

Next steps:

  • Wait for imposm to catch up from OSM upstream.
  • Warm up the Tegola cache on Swift.

After the above two steps the stack will be ready to be used :)

Change #1214526 had a related patch set uploaded (by Elukey; author: Elukey):

[operations/deployment-charts@master] services: add maps-next.w.o as FQDN for kartotherian staging

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

The initial imposm catchup sync after the PBF import has just completed.

Change #1215089 had a related patch set uploaded (by Elukey; author: Elukey):

[operations/deployment-charts@master] services: add maps-next.w.o as FQDN for kartotherian staging

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

Change #1215098 had a related patch set uploaded (by Elukey; author: Elukey):

[operations/deployment-charts@master] services: add maps-next.w.o as FQDN for kartotherian staging

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

Change #1214526 abandoned by Elukey:

[operations/deployment-charts@master] services: add maps-next.w.o as FQDN for kartotherian staging

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

Change #1215089 abandoned by Elukey:

[operations/deployment-charts@master] services: add maps-next.w.o as FQDN for kartotherian staging

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