Slony-I is a "master to multiple slaves" replication system supporting cascading and slave promotion. The big picture for the development of Slony-I is as a master-slave system that includes all features and capabilities needed to replicate large databases to a reasonably limited number of slave systems. Reasonable, in this context, is probably no more than a few dozen servers. If the number of servers grows beyond that, the cost of communications becomes prohibitively high.
|Tags||Database Database Engines/Servers Clustering/Distributed Networks|
|Implementation||C Perl Unix Shell|
Release Notes: This release has numerous improvements over previous versions.
Release Notes: Compatibility with 8.1 was added. SUBSCRIBE SET performance was improved. TRUNCATE is used to clear out tables at subscription time, if possible. Man pages for slon, slonik, as well as all the slonik commands can now be generated. There is official Debian packaging under way in the "experimental" area. A fairly large number of minor bugs that have been reported have been fixed.
Release Notes: Greatly expanded documentation. Logs optionally include date stamps. Slonik now supports define/include (similar to CPP) . Automatic generation of "Listen Paths" (formerly an error-prone manual process). slon daemons are greatly more configurable and can use config files. Log shipping allows creating offline replicas. Numerous improvements to automate maintenance. The build environment no longer requires a full PostgreSQL source tree. Numerous bugfixes.