SkyTools

Database management tools from Skype: WAL shipping, queueing, replication.
Download

SkyTools Ranking & Summary

Advertisement

  • Rating:
  • License:
  • Freeware
  • Price:
  • FREE
  • Publisher Name:
  • Skype Limited
  • Publisher web site:
  • http://www.skype.com/
  • Operating Systems:
  • Mac OS X
  • File Size:
  • 251 KB

SkyTools Tags


SkyTools Description

Database management tools from Skype: WAL shipping, queueing, replication. SkyTools is a free and open source package of tools provided by the Skype Team to manage clusters of PostgreSQL servers.LondisteReplication engine written in Python. It uses PgQ as transport mechanism. Its main goals are robustness and easy usage. Thus its not as complete and featureful as Slony-I. Features:· Tables can be added one-by-one into set.· Initial COPY for one table does not block event replay for other tables.· Can compare tables on both sides.· Supports sequences.· Easy installation. PgQGeneric queue implementation. Based on ideas from Slony-I - snapshot based event batching. Features:· Generic multi-consumer, multi-producer queue.· There can be several consumers on one queue.· It is guaranteed that each of them sees a event at least once. But it's not guaranteed that it sees it only once.· The goal is to provide a clean API as SQL functions. The frameworks on top of that don't need to understand internal details. Technical design:· Events are batched using snapshots (like Slony-I).· Consumers are poll-only, they don't need to do any administrative work.· Queue administration is separate process from consumers.· Tolerant of long transactions.· Easy to monitor. What's New in This Release: · pgqadm: rename 'as' function argument as it's keyword in Python 2.6 londiste provider add-seq: · Detect existing sequences. · Make --all ignore pgq, londiste and temp schemas. · Proper quoting was missing in few places. · walmgr: Create pg_xlog/archive_status directory for slave restore. · (Mark Kirkwood) · londiste provider add: detect and warn about user AFTER triggers · that run before Londiste one. docs: · Documentation for log_size, log_count and use_skylog options. · Refresh dependency list, add rsync · Mention --with-asciidoc in INSTALL. · --with-asciidoc: make it tolerate missing asciidoc and/or xmlto. · deb84 Makefile target.


SkyTools Related Software