Database Clusters: Making Complex Things Simple
summary
Discusses database clustering for scaling high-load projects: when adding backend servers and processes increases concurrent connections and database overhead, presents practical solutions and approaches to simplify complex clustering tasks for databases to improve scalability and performance.
AI-written summary · about
chapters (14)
- 0:00Introduction
- 1:11Growing load and system evolution
- 4:20Backend server balancing
- 5:25Database scaling theory
- 7:13Cache server problems
- 10:22Building Redis cluster
- 13:17Adding fault tolerance
- 19:25PostgreSQL clustering
- 24:06Database replication types
- 28:03Master-slave clusters
- 30:11Logical replication for indexing
- 31:40PostgreSQL sharding
- 33:08Final recommendations and conclusions
- 34:09Q&A
related talks
38mDeploying Database Clusters in the Cloud
47mMy Database Can't Handle the Load. What to Do?
28mSmall Data: Databases in the real world
29mBuilding on Strengths, Learning from Differences
27mScaling for Intelligence: Distributed SQL Databases in the Age of AI
25mThe future of databases: Combining operational and analytical data at massive scale
45mBest Practices for Optimizing Database Projects
51mMariaDB Scaling - From Single Instance to Multiple Clusters