Re: Split read/write queries between 2 servers (one master and oneslave with streaming replication)?

Поиск
Список
Период
Сортировка
От Pierre Timmermans
Тема Re: Split read/write queries between 2 servers (one master and oneslave with streaming replication)?
Дата
Msg-id 1967814526.885559.1518636446225@mail.yahoo.com
обсуждение исходный текст
Ответ на Re: Split read/write queries between 2 servers (one master and oneslave with streaming replication)?  (Venkateswaran <venkateswaran.srec@gmail.com>)
Ответы Re: Split read/write queries between 2 servers (one master and oneslave with streaming replication)?  (Melvin Davidson <melvin6925@gmail.com>)
Список pgsql-general
Дерево обсуждения
pgpool does just that: it enables you to use the standby database as a read only while other queries are sent to the primary database only (http://www.pgpool.net/). Good product and good support (on the list°

This looks a very interesting possibility, although it is more related to automated failover than to load balancing of read only queries : http://paquier.xyz/postgresql-2/postgres-10-libpq-read-write/, depending on your client it might be supported. It is not supported - yet ? - by the node-postgres driver.

Regards, 

Pierre


On Wednesday, February 14, 2018, 3:29:03 PM GMT+1, Venkateswaran <venkateswaran.srec@gmail.com> wrote:


Hi,

I am also trying to split read and write queries, where reads should go to
the slave server (streaming replication) and writes to the master server.
Any tool available to perform this activity instead of two connection pool?



--

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Windows 10 Pro issue
Следующее
От: Melvin Davidson
Дата:
Сообщение: Re: Split read/write queries between 2 servers (one master and oneslave with streaming replication)?