Jacob Kaplan-Moss

9 items tagged “replication”

📌 2ndQuadrant/repmgr

Replication manager for psql hot/warm standby. Documentation’s a bit lacking right now, but looks pretty intuitive. #

📌 Replication, Clustering, and Connection Pooling - PostgreSQL Wiki

Nice high-level comparison of the various PostgreSQL replication, clustering, load balancing, and connection pooling solutions. #

📌 mmalone's django-multidb at master - GitHub

Mike shows off how to implement multiple master/slave replication support in Django right now. Nifty. #

📌 What happened to Hot Standby?

It’s decisions like this that make me confident and happy about my choice of PostgreSQL. I can barely wait for hot standby to land, but features are worthless if they’re not stable. Maintainers willing to make tough cuts like this one are what makes quality software. #

📌 Hot Standby - PostgreSQL Wiki

Run read-only queries against a database in recovery mode receiving shipped logs, thus allowing simple load balancing for read-heavy applications. This is a candidate for inclusion in Postgres 8.4; I really hope it makes it in. #

📌 Bucardo - multi-master replication for Postgres

“Bucardo is an asynchronous Postgres replication system, allowing for both multi-master and multi-slave operations.” Whoa. #

📌 PostgreSQL warm standby on ZFS crack - Esoteric Curio

Pretty amazing technique: use ZFS to allow read/write against WAL-shipped warm standby PostgreSQL databases. ZFS FTW! #

📌 CollectionDistribution - Solr Wiki

How to correctly distribute a Lucene index. #

📌 SkypeGarage/DbProjects/SkyTools - Skype Developer Zone

Replication, WAL shipping, queuing tools for PostgreSQL, developed by Skype. #