Slony-I
From Wikipedia, the free encyclopedia
Slony-I is an asynchronous master-slave replication system for the PostgreSQL DBMS, providing support for cascading and failover. Asynchronous means that when a database transaction has been committed to the master server, it is not yet guaranteed to be available in slaves. Cascading means that replicas can be created from other replicas, i.e. they needn't directly connect to the master.
The name "slony" comes from the Russian word слоны which stands for "elephants".[1] This is a reference to the PostgreSQL elephant logo.
Unlike many other replication solutions for PostgreSQL, Slony-I is not tied to any particular version of the database, which makes it possible to upgrade a database cluster one node at a time, without any downtime.
[edit] See also
[edit] References
- ^ Slony-I manual: Slony-I Concepts. Retrieved on 2008-02-03.
- Ludovic Marcotte (2005-04-28). Database Replication with Slony-I. Linux Journal.
- A. Elein Mustain (2004-11-18). Introducing Slony. O'Reilly OnLamp.