SLONY and PG Pool II

Kevin Kempter

This talk would present and end2end look at SLONY including an overview, details of a sample setup of a SLONY cluster, setup details for switchover and failover scripts plus a look at incorporating PG Pool II into the cluster. Topics Covered/TOC:

Overview
Installation & general info
Slonik
Setup of a sample SLONY cluster
initialization/setup of the cluster
preparing the slave(s)
the slon daemon
starting replication
Walk through of the initialization/setup for the sample cluster
Switchover
Failover
PG Pool II
install / setup
Configuration
Setup for automated failover
Walkthrough of end-2-end sample instance
AttachmentSize
slony-and-pgpool2.pdf127.08 KB