基于Mycat的高性能数据库架构设计
首发时间:2021-03-02
摘要:随着英语在线学习业务的不断发展,越来越多的人们选择线上英语学习平台进行学习,进而也对平台数据库带来了巨大的流量和数据量的压力。高性能的数据库设计是各网络平台的重要基础。本文针对英语学习平台的需要,基于Mycat数据库中间件设计了一套能应对高并发读写请求的数据库系统架构,满足了随着平台业务扩展而出现的对于数据库性能的要求。通过MySQL读写分离和分库分表的配置,达到了提升数据库性能的目的。选用合适的路由算法,解决了可能出现的数据热点问题。唯一ID的配置选用ZK递增ID方式,保证了数据ID的全局唯一性。最后通过对比实验验证了设计的有效性。
For information in English, please click here
Design of High Performance Database Architecture Based on Mycat
Abstract:With the continuous development of online English learning business, more and more people choose online English learning platform for learning, which also brings huge pressure on the platform database traffic and data volume.High performance database design is the important foundation of each network platform.Aiming at the needs of English learning platform, this paper designs a database system architecture based on MyCAT database middleware that can cope with high concurrent read and write requests, and meets the requirements for database performance that appear with the expansion of the platform\'s business.Through the R/W splitting and the configuration of database and table in MySQL, the purpose of improving database performance is achieved.The appropriate routing algorithm is selected to solve the possible hot data problems.The configuration of unique ID selects ZK increment ID to ensure the global uniqueness of data ID.Finally, the effectiveness of the design is verified by a comparative experiment.
Keywords: computer software database R/Wsplitting sharding
基金:
引用
No.****
同行评议
勘误表
基于Mycat的高性能数据库架构设计
评论
全部评论0/1000