开发者社区 问答 正文

What is Sharding in SQL?

已解决

What is Sharding in SQL?

展开
收起
1780169608831412 2021-10-16 16:52:28 649 分享 版权
2 条回答
写回答
取消 提交回答
  • 网络规划设计师、敏捷专家、CISP、ITSS服务经理、ACA全科目、ACP4项、ACE、CBP、CDSP、CZTP等。拥有 PRINCE2 Foundation/Practitioner、CCSK、ITIL、ISO27001、PMP等多项国际认证。 专利5+、期刊10+、知识产权师。核心期刊审稿人。
    采纳回答

    The process of breaking up large tables into smaller chunks (called shards) that are spread across multiple servers is called Sharding.

    The advantage of Sharding is that since the sharded database is generally much smaller than the original; queries, maintenance, and all other tasks are much faster.

    2021-10-16 17:30:33
    赞同 1 展开评论
  • It means that the data in the same database is scattered and stored on multiple databases (hosts) under certain conditions, so as to achieve the effect of dispersing the load of a single device

    2021-10-16 17:25:30
    赞同 展开评论
问答分类:
SQL
问答标签:
问答地址: