On Mon, May 10, 2010 at 8:59 PM, John R Pierce <pierce@hogranch.com> wrote:
> Scott Marlowe wrote:
>>>
>>> Is there any sort of abstraction layer (like in the driver level) that
>>> can abstract that and just make updates go to one DB and reads
>>> round-robin to other DBs? Hopefully there's a way to make this design
>>> simple to implement.
>>>
>>
>> Pretty sure pgpool can do the "read from these dbs, write to this one".
>>
>
>
> how would it know if you're going to do updates later on in a transaction?
Go here:
http://pgpool.projects.postgresql.org/pgpool-II/doc/pgpool-en.html
look for replicate_select