PostgreSQL High Availability via SLONY and PG POOL II

Kevin Kempter

From East 2010 Speakers

We'll dive deep into a PostgreSQL HA setup using SLONY and PG POOL II.

Covered topics will include:

An Overview of SLONY

Setup of a working SLONY Cluster

Adding/Dropping data structures to/from a SLONY Cluster

SLONY switchover

SLONY Failover

Adding additional nodes

PG POOL II Overview

Setup of a working PG POOL instance

Configuration

The PG POOL Health Check

Load Balancing

The PG POOL System DB

Failover and Failback via PG POOL

The PG POOL Communitaions Manager (PCP) including:

- attaching/detaching nodes to/from the pool

- displaying node information for the nodes under PG POOL's control

- displaying PG POOL process information

- pcp recovery

- displaying the PG POOL System DB info

Pulling it all together including eliminating any remaining single points of failure, heartbeat mechanisms, etc

AttachmentSize
slony-and-pgpool2-pgEast-2010.pdf141.37 KB

Comments

MySQL vs PostgreSQL is a

MySQL vs PostgreSQL is a decision many must make when approaching open-source relational databases management systems. Both are time-proven solutions that compete strongly with proprietary database software. MySQL has long been assumed to be the faster but less full-featured of the two database systems, while PostgreSQL was assumed to be a more densely featured database system often described as an open-source version of Oracle. MySQL has been popular among various software projects because of its speed and ease of use, while PostgreSQL has had a close following from developers who come from an Oracle or SQL Server background. Payday Loan Direct From Lender