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.
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.
Will a standard TCP load-balancer suffice, or do I *need* to use PgPool in raw mode (or some other equivalent)?
pgsql-novice by date
|Next:||From: Jasen Betts||Date: 2010-01-07 11:59:18|
|Subject: Re: Using a variable in sql in a function|
|Previous:||From: John J. Urbaniak||Date: 2010-01-07 11:13:49|
|Subject: Re: Error on Vacuum?|