This is a package of tools used in Skype for replication and
failover. Also it includes a generic queuing mechanism PgQ and
utility library for Python scripts.
https://developer.skype.com/SkypeGarage/DbProjects/SkyTools
Main components are:
PgQ
---
This is the queue machanism we use. Consists of PL/pgsql, PL/python
and C code in database, with Python framework on top of it. It is
based on snapshot based event handling ideas from Slony-I,
written for general usage.
Londiste
--------
Replication tool written in Python, using PgQ as event transport.
Goals:
- Survive high load, long transactions - implemented in PgQ.
- Easy to administer - eg. tables can be added one-by-one to set.
- Initial COPY does not block event replay for other tables.
Compared to Slony-I it is not that featureful, no support for
chained replication, even support for sequences got added
only recently.
walmgr
------
This script will setup WAL archiving, does initial backup and
runtime WAL archive and restore.
