Главная
Study mode:
on
1
intro
2
preamble
3
where we used to be...
4
where we are now
5
conway's law
6
communication
7
shift left
8
self service
9
dashboards
10
problems with databases
11
slow queries
12
incompatible changes in schema
13
missing indexes
14
too many indexes
15
- n+1 selects
16
- joins
17
- lack of visibility
18
- migrations
19
test - do they work?
20
load testing?
21
nonoptimal configuration
22
know the context to find the root cause
23
monitoring and observability
24
executing the query
25
anatomy of an sql query
26
observability
27
database guardrails
28
be proactive and push to the left!
29
metis demo
30
about metis
31
summary
32
thank you!
Description:
Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only! Grab it 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. Read more

Effective Observability in PostgreSQL, MySQL, and Other SQL Databases

Conf42
Add to list