Skytools to the rescue, or …

September 1, 2008

… how I should have been doing PostgreSQL replication all along!

I can’t believe I’ve only just discovered SkyTools. If you’re like me, and hadn’t heard of it either until now, it’s a set of PostgreSQL replication and management tools put together by the folks at Skype. Now, you may love or hate Skype, and their eBay overlords, but they do run one of the larger public PostgreSQL clusters around, and it’s really nice to see them sharing their tools. Not as feature-packed as Slony, but something that is certainly only going to get better, and put the pressure on. You can check out the replication capabilities of PostgreSQL/Slony versus the other database “usual suspects” over at the Database Rosetta Stone. Of course, what PostgreSQL really needs is what’s currently being discussed (dare I say, rehashed), on the postgresql-general mailing list. It’s long past due that replication technology was brought into the PostgreSQL kernel! There’s just no valid excuse for avoiding this … and it is one of the two serious technical impediments to much wider adoption of PostgreSQL (the other being in-place upgrades). But enough griping. Go play with Skytools. Go on! Get!

One Response to “Skytools to the rescue, or …”

  1. Ries said

    Londiste (SkyTools) is indeed quite cool.
    However there are many excuses for not building in replication into the core. This is because there are many ways of doing replication and each has it’s strong and weak points. And it all depends how you want to replicate data a-synchronous or synchronous, multi master or master slave. How many slaves do you need, just 2 slaves or may be 10 slaves. What sort of failover do you want etc etc etc.

    The above simple questions cannot be handles by one ‘god’ solution, there are many solutions and can’t be build all into the core.

    We know that MySQL does have replication in the core, but it’s good for only a specific prepose, not all solutions can be handles with build in replication (this is why there are third party replications for MySQL available). The same counts for Oracle as far as I know…

    So if you want to ask me, I am just glad that replication with PostgreSQL is done externally rather then internally.

    It would be nice that PostgreSQL does get ‘some’ helper API’s to support replication better. For example triggers on DDL changes (at least a notify would be nice I guess) and the replicator guru’s can properly tell you a couple of others.

    Just my humble opinion.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: