Upload

Loading icon Loading...

This video is unavailable.

PostgreSQL High Availability with Corosync/Pacemaker

Sign in to YouTube

Sign in with your Google Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to like Andrew Ross's video.

Sign in to YouTube

Sign in with your Google Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to dislike Andrew Ross's video.

Sign in to YouTube

Sign in with your Google Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to add Andrew Ross's video to your playlist.

Published on May 31, 2013

The Corosync/Pacemaker framework which is part of the LinuxHA stack can be used to provide monitoring and automatic failover capabilities. Now with streaming replication in place, it makes sense to use this robust infrastructure for PostgreSQL master and its replica handling. The open source pgsql resource agent also does this now. This talk will talk about using Corosync/Pacemaker with Postgres.

The talk will be on the following lines:

Introduce the Corosync/Pacemaker LinuxHA stack and talk about its features
Talk about PostgreSQL 9 and the high availability requirements
Talk about how streaming replication helps meet these requirements
Talk about how using Virtual IP and the Corosync/Pacemaker resource agents, a robust high availability solution can be provided by using PostgreSQL streaming replication
I have done work around high availability in Postgres-XC and blogged about it as well at http://www.stormdb.com/blog/nikhil_so...

Corosync/Pacemaker is a great platform to use for HA and talking about it at PGCon will raise awareness about it.

Loading icon Loading...

Loading icon Loading...

Loading icon Loading...

Loading icon Loading...

Ratings have been disabled for this video.
Rating is available when the video has been rented.
This feature is not available right now. Please try again later.

Loading icon Loading...

Loading...
Working...
to add this to Watch Later

Add to