PostgreSQL DBA's Troubleshooting Toolkit: Unraveling Complex Issues with Expertise.
PostgreSQL DBA's Troubleshooting Toolkit
Presented by:
Lalit Choudhary
from
Percona
Worked on database technologies for more than 13+ years with various roles as DBA, QA, and Tester. Currently working with PERCONA as a Database Engineer for MySQL and PostgreSQL databases.
Checkout the slides
Objective: From this topic, DBA should know how to approach if they are looking for testing, reproducing issues, Health checks, and monitoring for PostgreSQL.
Talk abstract:
- Introduction: The significance of testing and monitoring tools and why DBA needs them.
- Obstacles: Testing environment Provisioning, Time-consuming, and Monetary cost.
- Solution: Utilizing opensource tools and virtualization options for quick setups and tests: Docker, Lxc, Vagrant, etc.
- The best and fastest way to setup complex PostgreSQL setups like PostgreSQL replication, Patroni Cluster, and Kubernetes Operator environment for PostgreSQL using an opensource tool called Anydbver(Developed and Maintained by Percona engineer) https://github.com/ihanick/anydbver
- Things to monitor for good performance, Current vs. Historical data analysis
- Monitoring Tools: pg_gather(https://github.com/jobinau/pg_gather), PMM [with use cases and examples]
- Date:
- 2024 March 1 - 11:35
- Duration:
- 40 min
- Room:
- Grand Victoria B
- Conference:
- PGConf India, 2024
- Language:
- Track:
- Database Administration
- Difficulty:
- Medium
- PostgreSQL I/O Patterns
- Start Time:
- 2024 March 1 11:35
- Room:
- Robusta + Arabica
- PostgreSQL 16: What's New? A comprehensive overview of the Latest Features
- Start Time:
- 2024 March 1 11:35
- Room:
- Grand Victoria A