Service discovery for PostgreSQL
As per https://gitlab.com/gitlab-com/infrastructure/issues/1330#note_26460479 we want a service discovery mechanism that can be used to figure out what host is a PostgreSQL primary, and which hosts are secondaries. This system should expose its data via DNS so it can be queried by GitLab in a generic way. This also means pgbouncer can re-use it since it has support for looking up hosts from DNS entries (https://pgbouncer.github.io/faq.html#how-to-load-balance-queries-between-several-servers).
cc @northrup
Activity
mentioned in issue #1330 (closed)
mentioned in issue #1504
Four months ago this was concieved of in a conversation between @yorickpeterse and myself. Should we keep this issue open or is the work being done in other issues that we can link and close this one?
@northrup gitlab-org/omnibus-gitlab#2571 is the ticket to get this available in the omnibus package. I'm not sure if there is an infrastructure ticket yet to use it in production.
Essentially this is covered in: https://gitlab.com/gitlab-com/infrastructure/issues/2422
Connecting consul to pgbouncer, and reconfiguring it as the primary changes should be the way to go on this, if i am not mistaken.
If there are no objections, i would links this issue, and close this one. @yorickpeterse ?
mentioned in issue #2422 (closed)
@jtevnan Sure, we can close this one.
