Re: Load Balancing and Backup

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