Tuesday, June 1, 2010

PostgreSQL 9 - Tungsten Clusters with Hot Standby and Streaming Replication

Hot standby and streaming replication will move the needle forward for high availability and scaling for a wide number of applications. Tungsten already supports clustering using warm standby. In this talk we will describe how to build clusters using the new PostgreSQL features and give our report from the trenches

This talk will cover how hot standby and streaming replication work from a user perspective, then dive into a description of how to use these features and how Tungsten makes them truly shine.

We'll cover the following issues:

  • Configuration of warm standby and streaming replication
  • Provisioning new standby instances
  • Strategies for balancing reads across primary and standby database
  • Managing failover
  • Troubleshooting
Register here!