Effective Observability in PostgreSQL, MySQL, and Other SQL Databases

Explore effective observability techniques for PostgreSQL, MySQL, and other SQL databases in this comprehensive conference talk from Conf42 DevOps 2024. Delve into the evolution of database management, from traditional approaches to modern challenges. Learn about Conway's Law, communication strategies, and the importance of shifting left in development processes. Discover how to implement self-service solutions and create effective dashboards. Examine common database issues, including slow queries, schema changes, and indexing problems. Investigate ORM challenges such as N+1 selects and join operations. Understand the significance of proper testing and load testing in database management. Gain insights into optimal configuration and the concept of database guardrails. Explore monitoring and observability techniques, including query execution analysis and SQL query anatomy. Witness a demo of Metis, a tool for proactive database management. Acquire valuable knowledge to enhance your database observability skills and improve overall system performance.

intro
preamble
where we used to be...
where we are now
conway's law
communication
shift left
self service
dashboards
problems with databases
slow queries
incompatible changes in schema
missing indexes
too many indexes
- n+1 selects
- joins
- lack of visibility
- migrations
test - do they work?
load testing?
nonoptimal configuration
know the context to find the root cause
monitoring and observability
executing the query
anatomy of an sql query
observability
database guardrails
be proactive and push to the left!
metis demo
about metis
summary
thank you!