Jan Wieck, PostgreSQL Project
Robert Kaye, Mayhem and Chaos Coordinator, MusicBrainz
Andrew Sullivan, Afilias
Date: Thursday, July 29
Time: 4:30pm - 6:05pm
Location: Salon G
Up until a couple of years ago, PostgreSQL had little to offer in the way of database replication. Now there is a selection of solutions, with more on the way. How do you choose between them? What problems does replication solve? (And which doesn't it?) Join us and find out!
Andrew Sullivan covers the use of erserver for load reduction, data merging, data warehousing, and warm failover. We'll discuss the limitations of the software, what you can do to work around those limitations, and then talk about some example applications.
Robert Kaye talks about lazy replication, which offers a flexible solution for mirroring a database in a read-only fashion using a loose network of database servers. He presents a case study that outlines what applications are suited to lazy replication, and how to avoid the pitfalls that MusicBrainz encountered while developing this system.
Jan Wieck explains his project, Slony-I, which will be a new enterprise level replication solution for the PostgreSQL database system. The design goals contain all the key features required by data centers for failover, backup and recovery purposes, that an asynchronous replication system can offer.
A Q&A session follows the presentations.
Download presentation file