-
Notifications
You must be signed in to change notification settings - Fork 10
Requirements
ruismoura edited this page Sep 28, 2015
·
4 revisions
You can create this setup with as little as 3 machines, by running 2 instances of PgPool II in 2 of the machines running PostgreSQL. You can increase performance by moving the PgPool instances to their own machines and by adding extra PostgreSQL slaves (specially if the load on the database is mostly read queries).
I recommend using at least 5 machines so each program runs on it's own, simplifying the troubleshooting process.
PgPool II at the moment (09/2015) only supports Linux Machines.
I used CentOS 7 so if you're on a different GNU/Linux distribution some things might work differently. (I also used CentOS 6.5 on some of the PostgreSQL machines to avoid some re-installations)
- On my PostgreSQL machines I used both CentOS 6.5 and 7.1.1 with PostgreSQL 9.4.4
- For load balancing I used two machines with CentOS 7.1.1 and installed PgPool II 3.4.3
- Automated failover is handled by a custom script that PgPool II runs when a node goes down
- Home
- Overview
- Requirements
- Setup
- Summary and Quick Start
- Database (PostgreSQL) 1. PostgreSQL Installation 2. Configuring the Master 3. Configuring the Slaves 4. Testing Replication 5. Manual Failover
- Load Balancing (PgPool II) 1. PgPool II Installation 2. Configuration 3. Managing and Testing
- Automatic Failover 1. Setting it up 2. Testing
- Troubleshooting
- References