Re: Load Balancing and Backup

On Fri, 30 Apr 2004, CS Wagner wrote:

> I assume this issue has been solved repeatedly, but I cannot find any 
> information on it...
> 
> I have a website that runs reports on data from a postgres database.  An 
> average report takes about 10 minutes.  I'd like to load balance it so I 
> can have multiple people run reports without causing the login request 
> to take forever.  Also, it is rather important that data updated in the 
> database be updated on all mirrors of it immediately - not with an 
> hourly or daily update.
> 
> 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?

http://sqlrelay.sourceforge.net/