DEV Community

Cover image for Database Scaling Tutorial - System Design Basics
Renaissance Engineer
Renaissance Engineer

Posted on

12 3

Database Scaling Tutorial - System Design Basics

Part 3 of series on System Design


Databases are generally the bottleneck to application performance. While app servers can be scaled horizontally with ease, all those servers will still be hitting the same database, which will eventually kill performance. In this tutorial I'll cover some of the key concepts of database design and database scaling

While you don't need to be a database expert, it is good to understand some of the fundamental concepts related to how they work in large scale web applications

Concepts covered:

  • Indexes
  • Denormalization
  • Caching
  • Replication
  • Sharding / Horizontal Partitioning
  • Vertical partitioning
  • Tradeoffs of the above strategies

Top comments (1)

Collapse
 
lagsurfer profile image
Barney

Great video! Thanks for sharing!

Jetbrains image

Build Secure, Ship Fast

Discover best practices to secure CI/CD without slowing down your pipeline.

Read more

👋 Kindness is contagious

Engage with a wealth of insights in this thoughtful article, valued within the supportive DEV Community. Coders of every background are welcome to join in and add to our collective wisdom.

A sincere "thank you" often brightens someone’s day. Share your gratitude in the comments below!

On DEV, the act of sharing knowledge eases our journey and fortifies our community ties. Found value in this? A quick thank you to the author can make a significant impact.

Okay