Horizontal Scaling using PostgreSQL 9

Josh Berkus (PostgreSQL Experts, Inc.)
Tutorial
Location: Ballroom C
Average rating: ****.
(4.00, 3 ratings)

The new PostgreSQL feature which makes everyone excited about version 9.0 is binary replication, otherwise known as Hot Standby / Streaming Replication. Many users are still not quite sure how to set it up, however. Further, while binary replication is easy to use in its simplest configuration, incorporating it into high performance, high-availability systems can be somewhat baffling.

Josh Berkus and other members of the PostgreSQL experts staff will walk attendees through setting up Hot Standby and Streaming Replication in various configurations in order to give them a thorough grounding in how the new replication works and how to manage it. This tutorial will involve hands-on exercises, visual aids, and audience participation.

Topics covered will include:

  • Setting up your first replication pair
  • Hot Standby, Streaming Replication, or Both?
  • Failover and Failback
  • What is Query Cancel?
  • Tuning replication performance
  • What to monitor and how
  • Replication as part of a high availability infrastructure

All attendees should bring a laptop with Linux or Mac OSX, either natively or in a VM, with PostgreSQL 9.0.1 installed.

Photo of Josh Berkus

Josh Berkus

PostgreSQL Experts, Inc.

Josh Berkus is primarily known as one of the Core Team of the world-spanning open source database project PostgreSQL. As CEO of PostgreSQL Experts, Inc., he speaks on database and open source topics all over the world, and consults on database design, performance, and open source community building. He also makes pottery and is a darned good cook.

Comments on this page are now closed.

Comments

Kathy Mazur Worden
04/11/2011 7:25pm PDT

As someone with no postgres experience I found this tutorial very helpful. Excellent presentation.

  • EnterpriseDB
  • Amazon Web Services
  • Clustrix
  • Continuent
  • Facebook
  • HTI Consultoria e Tecnologia
  • Monty Program
  • Percona
  • Rackspace Hosting
  • Schooner Information Technology
  • SkySQL
  • Xeround

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at yromaine@oreilly.com

Media Partners Opportunities

For media partnerships, contact mediapartners@ oreilly.com

Press & Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

O'Reilly MySQL Conference Bulletin

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference Bulletin (login required).

Contact Us

View a complete list of O'Reilly MySQL Conference Contacts