SkyTools

SkyTools is a free and open-source toolset from the Skype Team designed to help you manage clusters of PostgreSQL servers. It’s pretty handy for anyone working with databases!

What’s Cool About SkyTools?

This software has a replication engine that’s written in Python. It uses PgQ as its transport mechanism, which means it’s built to be both robust and easy to use. Now, while it may not have all the bells and whistles of Slony-I, it definitely gets the job done without being too complicated.

Awesome Features You’ll Love

• You can add tables one by one into a set.


• The initial COPY for one table doesn’t block event replay for others. So, you can keep things moving!


• It lets you compare tables on both sides easily.


• It supports sequences, which is super useful.


• Installation is a breeze!

A Generic Queue Implementation

This tool also offers a generic queue setup inspired by ideas from Slony-I, focusing on snapshot-based event batching. Here are some key features:

• This is a multi-consumer, multi-producer queue—meaning several consumers can work off the same queue.


• Each consumer is guaranteed to see an event at least once. But just so you know, it's not guaranteed they'll only see it once.


• The goal here? A clean API using SQL functions so that frameworks above don’t need to worry about how everything works under the hood.

Technical Design That Works for You

The technical design includes some neat features:

• Events are batched using snapshots (similar to Slony-I).


• Consumers only need to poll; they don’t have any administrative tasks hanging over their heads.


• The queue management runs separately from the consumers, making things easier.


• This system handles long transactions like a champ!


• Monitoring is simple, so you’ll always know what’s happening.

If you're interested in trying out SkyTools, head over to SoftPas! It's an awesome resource for software tools that'll make your life easier. Happy managing those databases!