Relational Databases: The Crown Jewel of Infrastructure.
DOWNLOADING CONCEPT: 1. WHY AND WHEN TO USE AN RDBMS?...
↳A Relational Database Management System (RDBMS) organizes data into tables (rows and columns) that can be linked—or related—based on data common to each.
When to use it
↳- When your data has a strict, predictable schema (e.g., Financial ledgers, User Accounts, E-commerce Orders).
↳- When you need strict ACID guarantees (Atomicity, Consistency, Isolation, Durability).
↳- When relationships between entities are complex and you need powerful query capabilities (JOINs).
When NOT to use it
↳- When your data is highly unstructured or rapidly changing (use NoSQL like MongoDB).
↳- When you are storing massive amounts of time-series data or simple key-value pairs (use Redis or InfluxDB).
▲ LIVE INCIDENTCPU on the primary DB is pegged at 100%. Queries are timing out.
sre@arena:~/relational-databases
sre@arena:~$ SELECT pid, state, query, duration FROM pg_stat_activity WHERE state = 'active' ORDER BY duration DESC;