High Availability and Automatic Failover in PostgreSQL using Open Source Solutions

Tuesday 2:20 PM - 3:10 PM

@ Bear

PostgreSQLOpen Source Databases

50 minutes conference

Intermediate

Tracks:
Case Studies/Use cases, Operations

PostgreSQL is an advanced open source database that is completely community driven. Continuous development and performance improvements while maintaining a secondary focus on Oracle compatibility gave PostgreSQL a great market penetration. When a database server is deployed in production we often wish to achieve several 9's of availability. Is that even possible with PostgreSQL? What is the combination of tools that you could combine and implement to achieve High Availability (HA) and automatic failover in PostgreSQL? How can we avoid data loss during such failover's? We'll address these questions and then some more in this talk.


Speakers

Fernando Laudares Camargos

Fernando Laudares Camargos (Percona)

Senior Support Engineer

Biography:

Fernando joined Percona in early 2013 after 8 years working at Révolution Linux as what now is known as a DevOps Engineer role. At Percona he specialized in MySQL and MongoDB. After a brief sabbatical in 2016 to work in a personal project and a short stint at VividCortex he's back at Percona with the added challenge of taking on PostgreSQL support.


Avinash Vallarapu

Avinash Vallarapu (Percona)

PostgreSQL Support Tech Lead

Biography:

Avinash Vallarapu joined Percona in the month of May 2018. Before joining Percona, Avi worked as a Database Architect at OpenSCG for 2 Years and as a DBA Lead at Dell for 10 Years in Database technologies such as PostgreSQL, Oracle, MySQL and MongoDB. He has given several talks and trainings on PostgreSQL. He has good experience in performing Architectural Health Checks, Performance Tuning and Migrations to PostgreSQL Environments.


Slides



  Download Slides  

Connect with Percona

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.
 

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863
  • 8081 Arco Corporate Drive - Suite 330 - Raleigh, NC 27617, USA