Thread: Using TCP load-balancers for read-only connections
As a PostgreSQL newbie, I've got a question about load-balancing/high-availability which isn't covered by Chapter 25 ("High Availability, Load Balancing and Replication") of the documentation. But first, some background.
Background
----------
I'm planning a distributed database deployment. The deployment will run across a small number of geographically remote sites. I'll use Slony-I for master-slave replication between all machines in the deployment. (The write rate is extremely low and the write latency for remote sites is acceptable.)
There will be 2 (or perhaps more if necessary) database nodes in each site, accessed by many clients. For read-only operations, clients will only access nodes in their local site only. (For write operations, they obviously have to go to the master.)
I want read-only operations to be tolerant of the loss of a single database node in the client's site.
Question
--------
Will a standard TCP load-balancer suffice, or do I *need* to use PgPool in raw mode (or some other equivalent)?
Many thanks,
Andrew