Presented by:
Avinash Vallarapu
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.
** 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 Patroni, 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 PDT
- Duration:
- 50 min
- Room:
- Winchester (1)
- Conference:
- Silicon Valley 2019
- Language:
- Track:
- Ops and Administration
- Difficulty:
- Medium