 |
VOOZH | about |
|
VOOZH | about |
By Mark Drake
Manager, Developer Education
Any application or website that sees significant growth will eventually need to scale in order to accommodate increases in traffic. For data-driven applications and websites, itโs critical that scaling is done in a way that ensures the security and integrity of their data. It can be difficult to predict how popular a website or application will become or how long it will maintain that popularity, which is why some organizations choose a database architecture that allows them to scale their databases dynamically.
In this conceptual article, we will discuss one such database architecture: sharded databases. Sharding has been receiving lots of attention in recent years, but many donโt have a clear understanding of what it is or the scenarios in which it might make sense to shard a database. We will go over what sharding is, some of its main benefits and drawbacks, and also a few common sharding methods.
Thanks for learning with the DigitalOcean Community. Check out our offerings for compute, storage, networking, and managed databases.
Former Technical Writer at DigitalOcean. Focused on SysAdmin topics including Debian 11, Ubuntu 22.04, Ubuntu 20.04, Databases, SQL and PostgreSQL.
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
Great article, thank you!
When it comes to building multi tenant applications there are generally 3 db options:
If I were to go with a shared db and an isolated schema, would I be able to shard based on the schema alone?
If so is this something I can do with DOโs managed database service, is sharding even a feature of DOโs managed dbs (given that postgres technically does not support it)?
Hi.
I want to implement Range Based Sharding based on a multistore app. So, each horizontal partition correspond to one merchant.
What tutorial do you recommend to implement it on MySQL?
Best regards
This comment has been deleted
Wonderful article.
Good knowledgeโฆThank You
Nice article. Thanks for sharing it.
Useful article - thanks!
Does the sharding (horizontal partitioning) still work if the original database is columnar?
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
Full documentation for every DigitalOcean product.
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
