High Availability and Automatic Failover in PostgreSQL.
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 PostgreSQL is in progress.
He spoke at various PostgreSQL Conferences in the past including -
- PGCONF India - 2017/2019
- PGCON Ottawa 2018
- Percona Live Frankfurt 2018
- Postgres Conference New York 2019
- Percona Live Texas 2019
- Postgres Open Florida 2019
- Postgres Conference Silicon Valley 2019
- Percona Live Amsterdam 2019
- Upcoming PGCONF India 2020, New York, Percona Live and some more conferences.
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 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.
- 50 min
- Postgres Conference 2020
- Ops and Administration