A
A
anikavoi2020-05-04 15:10:52
PostgreSQL
anikavoi, 2020-05-04 15:10:52

Proxying to all backends, giving the fastest one?

There are two postgris servers with configured replication.
There is a third server on which you need to put something that will accept SELECT requests and immediately send them to BOTH servers. Give the first answer received to the client, and quietly forget the one that comes later.

I tried haproxy, pgbouncer, pgpool2, the first two did not have such a mode, pgpool did not take off (xs).

Answer the question

In order to leave comments, you need to log in

1 answer(s)
X
xmoonlight, 2020-05-04
@xmoonlight

The request queue manager needs to be done on the 3rd server.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question