Building Tungsten Clusters with PostgreSQL Hot Standby and Streaming Replication

Alex Alexander & Linas Virbalas

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 them, taking Tungsten as an example. 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 and gotchas

Please join us for an enlightening discussion a set of PostgreSQL features that are interesting to a wide range of PostgreSQL users.

Building-Tungsten-Clusters-with-PostgreSQL-Hot-Standby-and-Streaming-Replication-PG-East-2010.ppt2.71 MB