Re: Load Balancing and Backup

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: Load Balancing and Backup
Дата
Msg-id 4099517D.6010206@archonet.com
обсуждение исходный текст
Ответ на Re: Load Balancing and Backup  (Steve Atkins <steve@blighty.com>)
Список pgsql-general
Steve Atkins wrote:
> On Fri, Apr 30, 2004 at 01:17:16PM -0400, CS Wagner wrote:
>>
>>What I would most desire is a program that pretends to be a postgres
>>server.  I can log into it with psql, a jdbc driver, or php's
>>pg_connect.  When I do a select (no update) command, it will send that
>>off to the least loaded mirror.  When I do an update/insert/delete, it
>>hits all the mirrors.  Also, it can designate one database (most likely
>>local to this pretend server) as the master so I can easily clone it to
>>make more mirrors.
>>
>>Does anything remotely similar to that exist?
>
>
> Sounds like dbbalancer, but I've no idea whether that's ready for
> production use. I supect not.

Possibly pgpool too. See the mailing-list archives for pg-announce (last
month) for the details.

--
   Richard Huxton
   Archonet Ltd

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: select for update & lock contention
Следующее
От: Eric Ridge
Дата:
Сообщение: Changing the size of a varchar field