Presented by:

  • Avinash Vallarapu (Avi) is the CEO and Founder of HexaCluster, a company specialized in Database Migrations, PostgreSQL Consulting, Application Migrations and Modernizations, and AI/ML Services. Before creating HexaCluster, Avi was the CEO and Co-founder of MigOps, specialized in database migrations to PostgreSQL. He created the PostgreSQL practice at Percona as a Global Services Lead and Product Owner, and worked as a Database Architect at OpenSCG and Dell. With a vast experience in technologies like Oracle, PostgreSQL, MySQL and MongoDB for the last 2 decades, Avi had co-authored multiple books on PostgreSQL : Beginning PostgreSQL on Cloud and PostgreSQL 13 Cookbook.

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

    • PGCONF India
    • PGCON Ottawa
    • Percona Live Frankfurt
    • Postgres Conference New York
    • Percona Live Texas
    • Postgres Open Florida
    • Postgres Conference Silicon Valley
    • Percona Live
    • GITEX Global
    • and some more conferences.
  • His areas of expertise are PostgreSQL Migrations, Training and Consulting.

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 with a live demo of each of them.

  • 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 PostgreSQL HA using Patroni.
    • 3. What is repmgr, pgpool-II and pg_auto_failover 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 a failover.

Date:
Duration:
50 min
Room:
Conference:
Postgres Conference 2020
Language:
Track:
Ops and Administration
Difficulty:
Easy