Summary and Quick Start
This is, in general, what you have to do to get this working:
- Install CentOS on all the machines you want to use
- Install PostgreSQL on the machines that will store and serve the database
- Edit the configuration files on the PostgreSQL nodes to match your network and needs
- Start the PostgreSQL servers and check if everything is working
- Install PgPool II on the machines that will act as load Balancers
- Edit the configuration files on the load balancers to match your network and needs
- Set up passwordless logins (with ssh keys) from the load balancers to the database machines
- Copy over the failover script to the load balancers and edit it as needed
- Start the load balancers
- Test some queries against the virtual IP of the load balancers
- Test a node failure and hopefully everything goes well :)
If you already have some experience with these things you can probably just install the OS's, programs, copy over the configuration files for each machine, change the relevant settings (like IP addresses) and be off to the races! :)
If that's what you're interested in, just head over to each folder on the repository to get the files and some quick notes on what you probably have to change.
