Unanswered: Load Balancing, High Availability and Fail-Over with Postgres
I'm planning an installation with 4 servers included.
The example structure is:
# Load Balancer 1: lb1.example.com, IP: 192.168.0.100
# Load Balancer 2: lb2.example.com, IP: 192.168.0.101
# Web Server 1: http1.example.com, IP: 192.168.0.102
# Web Server 2: http2.example.com, IP: 192.168.0.103
I've set this up on Debian Lenny and I will be using postgres 8.1
How can I achieve database synchronization in such structure?
There is a single application I will be running written in PHP. How should I set up postgres in such a structure so that I can achieve High Availability and fail-over? I really prefer an active-active setup.