分区和分片的区别_数据库分片和分区的资源

原创于 2020-12-21 13:34:10 发布 · 97 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#分区和分片的区别

本文探讨了在面对数据库规模从千万级增长到百亿级时所遇到的扩展性问题，并讨论了分片和分区等策略来解决这一挑战。作者考虑了多种数据库产品，包括Oracle、MSSQL Server和MySQL等。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

I'm working with a database schema that is running into scalability issues. One of the tables in the schema has grown to around 10 million rows, and I am exploring sharding and partitioning options to allow this schema to scale to much larger datasets (say, 1 billion to 100 billion rows). Our application must also be deployable onto several database products, including but not limited to Oracle, MS SQL Server, and MySQL.

This is a large problem in general, and I'd like to read up on what options are available. What resources are out there (books, whitepapers, web sites) for database sharding and partitioning strategies?

解决方案

I agree with the other answers that you should look at your schema and indexes before resorting to sharding. 10 million rows is well within the capabilities of any of the major database engines.

However if you want some resources for learning about the subject of sharding then try these: