Answer the question
In order to leave comments, you need to log in
How to properly configure replication on 2 servers (PostgreSQL)?
So, at first there was one server hosting the project. It has pgpool-II for connection pooling. The load has increased, we bought another server with the same configuration. How to distribute http requests is clear to me. But what to do with the database, I do not know. Usually, as I understand it, a third server (proxy) is used, which distributes connections and replicates data between servers. But what about when there is only a 2nd server, without a 3rd one, a proxy?
Answer the question
In order to leave comments, you need to log in
Set up streaming replication and already in the code, drive some of the selects to the replica.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question