Jeff Amiel wrote:
> There are other techniques to balance the load of the database calls so
> that some go to one box and some to others, yet keep the data in synch...
> Continuent makes a commercial p/cluster product as well as an open
> source product called Sequoia that sit in the JDBC layer and direct
> traffic and control the load balancing.
pgpool allows you to load balance queries between two servers. While it
doesn't solve the issue of trying to read a row that hasn't been
replicated, it does offer you a bit of control that may be of use to
you. Any statement that is in a transaction will automatically go to
the master DB. If some queries are sensitive to this issue, and some
aren't, then you might be able to make pgpool work for you by wrapping
the sensitive ones in a transaction.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.