Page MenuHomeSoftware Heritage
Differential D1560

Migrate services to use pgbouncer instances
ClosedPublic
Actions

Authored by ardumont on Jun 6 2019, 6:35 PM.

Details

Reviewers
olasd
ftigeot
douardda
vlorentz
Group Reviewers
Reviewers
Commits
rSPSITE07c9a5c79927: Migrate indexer-storage service to use somerset's pgbouncer instance
rSPSITE676858cb0561: somerset: Reference the indexer db in pgbouncer instance
rSPSITE79580c26e485: Migrate services to use the pgbouncer instances
Summary
  • Migrate existing services (storage, listers, etc...) to use bouncer (instead of direct db accesses)
  • somerset: Reference the indexer db in somerset's pgbouncer instance
  • Migrate indexer-storage service to use somerset's pgbouncer instance

Related T1784

Test Plan

bin/octocatalog-diff

Diff Detail

Repository
rSPSITE puppet-swh-site
Lint
Automatic diff as part of commit; lint not applicable.
Unit
Automatic diff as part of commit; unit tests not applicable.

Event Timeline

ardumont created this revision.Jun 6 2019, 6:35 PM
Harbormaster completed remote builds in B6071: Diff 5122.Jun 6 2019, 6:35 PM
ardumont planned changes to this revision.Jun 7 2019, 10:50 AM
ardumont added a comment.EditedJun 7 2019, 10:56 AM

I want to make sure of something first in regards to the pgbouncer instances.

ardumont added a comment.Jun 7 2019, 11:04 AM

I want to make sure of something first in regards to the pgbouncer instances.

Yes, there was a hit and miss adaptations for belvedere, fixed now.

ardumont updated this revision to Diff 5125.Jun 7 2019, 11:05 AM

Use the right ports (secondary cluster) for the belvedere connections

Harbormaster completed remote builds in B6074: Diff 5125.Jun 7 2019, 11:05 AM
vlorentz accepted this revision.Jun 7 2019, 11:33 AM
This revision is now accepted and ready to land.Jun 7 2019, 11:33 AM
ardumont updated this revision to Diff 5126.Jun 7 2019, 11:37 AM

Plug diff to branch production

Harbormaster completed remote builds in B6076: Diff 5126.Jun 7 2019, 11:37 AM
Closed by commit rSPSITE79580c26e485: Migrate services to use the pgbouncer instances (authored by ardumont). · Explain WhyJun 7 2019, 11:38 AM
This revision was automatically updated to reflect the committed changes.

Revision Contents
Changeset List

Diff 5127

View Options

data/defaults.yaml

Loading...
View Options

data/hostname/belvedere.internal.softwareheritage.org.yaml

Loading...
View Options

data/hostname/moma.softwareheritage.org.yaml

Loading...
About · Developer information · Legal