Re: Core team statement on replication in PostgreSQL

Поиск
Список
Период
Сортировка
От Dimitri Fontaine
Тема Re: Core team statement on replication in PostgreSQL
Дата
Msg-id 200805301102.06063.dfontaine@hi-media.com
обсуждение исходный текст
Ответ на Re: Core team statement on replication in PostgreSQL  (Dimitri Fontaine <dfontaine@hi-media.com>)
Список pgsql-hackers
Le vendredi 30 mai 2008, Dimitri Fontaine a écrit :
> This way, no need to switch IP addresses, the clients just connect as usual
> and get results back and do not have to know whether the host they're
> qerying against is a slave or a master. This level of smartness is into
> -core.

Oh, and if you want clients to connect to a single IP and hit either the
master or the slave with some weights to choose one or the other, and a way
to remove from pool on failure etc, I think using haproxy in TCP mode would
do it. HaProxy is really nice for this purpose. http://haproxy.1wt.eu/

Regards,
--
dim

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

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: Overhauling GUCS
Следующее
От: "Mike Rylander"
Дата:
Сообщение: Re: Core team statement on replication in PostgreSQL