Skip to content
When should you shard your database?  episode artwork

Apr 28, 2020 21 min

When should you shard your database?

from The Backend Engineering Show with Hussein Nasser Hosted by Hussein Nasser

Database Application level sharding is the process of splitting a table into multiple database instances in order to distribute the load. However, Sharding a database is an expensive operation (maintainability and overhead) and I suggest you do that only when you absolutely need to. That means when your single instance database can no longer serve queries with minimum latency. So I suggest you monitor that and only shard if necessary.. I rather do replication make master / backup and make requests read from replica than Sharding just because it is easier.. good question... nice idea for a video 5:00 Partition horizontally 7:45 Replication (Master/backup) Scale reads 11:00 Scale writes by region 12:30 Sharding 16:40 Sharding in YouTube

Episode details come from the podcast's RSS feed.

Embed this episode

Ready to play

When should you shard your database?

0:00 21:19

No transcript yet.

Requests help us decide what to transcribe next.

Frequently asked questions

How long is this episode of The Backend Engineering Show with Hussein Nasser?

This episode is 21 minutes long.

When was this The Backend Engineering Show with Hussein Nasser episode published?

This episode was published on April 28, 2020.

Can I download this The Backend Engineering Show with Hussein Nasser episode?

Yes. Use the download control on the episode player to save the publisher-provided media file.