How to scale a relational database?

Опубликовано: 25 Ноябрь 2024
на канале: ProgressiveCoder
578
17

Cloud Computing | Database Scalability | Replication | Sharding | Replication vs Sharding | Distributed Databases

Yes, you can scale a relational database.

Of course, it’s much simpler to have a relational database running on a single machine. You scale it up as necessary by adding more computing resources.

However, a non-distributed database will always be limited in storage and computing power.

So, how can you scale a relational database?

You can use sharding or replication.

In this video, I introduce the two approaches and compare them. Finally, I discuss when you should use one over the other.

— TIMESTAMPS ⏰ —

00:00 - Intro
00:33 - Sharding vs Replication
01:53 - Choosing a Strategy

— Subscribe to the Newsletter ✉️ —
https://progressivecoder.substack.com/

— Connect with Me 🙌 —

TWITTER -   / progressivecod2  

LINKEDIN -   / saurabh-d.  .

GITHUB - https://github.com/dashsaurabh

— Other Platforms 👇👇 —

ProgressiveCoder Blog - https://progressivecoder.com
ProgressiveWebNinja Blog - https://www.progressivewebninja.com
Hashnode - https://saurabhdashora.hashnode.dev/
Dev - https://dev.to/dashsaurabh