Presented by:

  • Avinash Vallarapu (Avi) is currently working for Percona as a PostgreSQL Support Tech Lead. Before joining Percona, he worked for OpenSCG for 2.2 years as a Database Architect and for Dell as a Tech Lead for 9.8 Years. He has a vast experience in technologies like Oracle, PostgreSQL, MySQL and MongoDB. He is an avid Python and Golang developer. He has co-authored a book on PostgreSQL : Beginning PostgreSQL on Cloud and another book on MySQL is in progress.

  • He spoke at various PostgreSQL Conferences in the past including -

    • PGCONF India - 2017
    • PGCON 2018
    • Percona Live - PostgreSQL Track (2018) and
    • 2 talks for PGCONF 2019.
  • His areas of expertise are PostgreSQL Training, Consulting and Migrations.

No video of the event yet, sorry!

  • PostgreSQL is an advanced open source database that is completely community driven. Continuous development and performance improvements while making it feature rich gave PostgreSQL a great market penetration. When a database server is deployed in production, it is important to achieve several 9's of availability. It starts with a replication setup that is stable and some tool that could manage a failover transparent to application. This talk starts with a list of replication types in PostgreSQL followed by a detailed understanding of some of the widely used open source tools for high availability and automatic failover in PostgreSQL.

  • ** Following topics will be discussed during this talk - **

    • 1. How the implementation of HA differs for each type of replication available in PostgreSQL
    • 2. How to combine HAproxy with etcd plus a detailed explanation of the RAFT Algorithm for HA using Patroni.
    • 3. What is stolon, pgpool-II and repmgr and how can they be helpful.
    • 4. Some other tools admins may wish to explore.
    • 5. What are the tools and solutions that help you achieve automatic failover in AWS and other cloud-based environments.
    • 6. How to avoid huge data loss during failover.

Date:
2019 September 20 11:10
Duration:
50 min
Room:
Winchester (1)
Conference:
Silicon Valley 2019
Language:
Track:
Ops and Administration
Difficulty:
Medium