开发者社区> 问答> 正文

What is Scaling in MySQL?

已解决

What is Scaling in MySQL?

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

    In MySQL, scaling capacity is actually the ability to handle the load, and it’s useful to think of load from several different angles such as:

    Quantity of data
    Number of users
    User activity
    Size of related datasets
    
    2021-10-16 17:30:13
    赞同 1 展开评论 打赏
  • At the initial stage of business, the database design mostly adopts the structure of single database and single table. With the development of business and the growth of QPS and data volume to a certain bottleneck, the architecture of single database and single table cannot be supported. At this time, it is necessary to expand the database level. Database expansion can be divided into the following scenarios:

    Read performance extension

    Write performance extension

    Sub database and sub table

    2021-10-16 17:29:30
    赞同 展开评论 打赏
问答排行榜
最热
最新

相关电子书

更多
搭建电商项目架构连接MySQL 立即下载
搭建4层电商项目架构,实战连接MySQL 立即下载
PolarDB MySQL引擎重磅功能及产品能力盛大发布 立即下载

相关镜像