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

Поиск
Список
Период
Сортировка
От Benjamin Henrion
Тема Split read/write queries between 2 servers (one master and one slave with streaming replication)?
Дата
Msg-id CANjd3nfW0_Px0uAPMEXkths3jaD+YuBwbw843mzkdQY-__4obQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Split read/write queries between 2 servers (one master and one slave with streaming replication)?  (Adam Cornett <adam.cornett@gmail.com>)
Список pgsql-general
Hi,

I am trying pgpool2 to split read and write queries, where reads
should go to the slave server (streaming replication) and writes to
the master server.

Anybody has a config file that works for pgpool2?

Best,

--
Benjamin Henrion <bhenrion at ffii.org>
FFII Brussels - +32-484-566109 - +32-2-3500762
"In July 2005, after several failed attempts to legalise software
patents in Europe, the patent establishment changed its strategy.
Instead of explicitly seeking to sanction the patentability of
software, they are now seeking to create a central European patent
court, which would establish and enforce patentability rules in their
favor, without any possibility of correction by competing courts or
democratically elected legislators."

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

Предыдущее
От: Lonni J Friedman
Дата:
Сообщение: pg_upgrade + streaming replication ?
Следующее
От: Adam Cornett
Дата:
Сообщение: Re: Split read/write queries between 2 servers (one master and one slave with streaming replication)?