A
A
Alexander Savchuk2015-08-06 18:16:22
PostgreSQL
Alexander Savchuk, 2015-08-06 18:16:22

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

1 answer(s)
R
Random_var, 2015-08-06
@Random_var

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 question

Ask a Question

731 491 924 answers to any question