企业分布式数据库架构方案研究与设计  

Research and design of enterprise distributed database architecture

作　　者：张雪芳 邱希 ZHANG Xue-fang;QIU Xi(Wuhan Research Institute of Posts and Telecommunications,Wuhan 430074,China)

机构地区：[1]武汉邮电科学研究院

出　　处：《电子设计工程》2019年第13期35-40,共6页Electronic Design Engineering

摘　　要：随着互联网产品的发展,传统的集中式数据库开始表现出性能瓶颈,分布式数据库的研究与设计应运而生,基于大部分停留在理论层面的研究且关键技术集中在大型互联网公司等情况,所以本文主要针对中小公司采用较多的关系型数据库进行分布式数据库架构方案的设计。通过先分析研究分布式数据库的读写分离、分表分库的原理进而引出数据库中间件的概念,然后对比当前主流数据库中间件优缺点,最终选择以mycat作为数据库中间件进行数据的分片以及读写分离,设计一套可供企业分布式数据库架构参考的可行性方案。针对该方案的响应时间测试得出百万数据查询最大3.27s,最小0.1s,平均0.52s就可以获取结果。With the development of Internet products,traditional centralized databases begin to show performance bottlenecks.The research and design of distributed databases emerge at the historic moment. Based on the situation that most of the research stays at the theoretical level and the key technologies are concentrated in large Internet companies,this paper mainly focuses on small and medium- sized companies.The system database is used to design the distributed database architecture.By analyzing the principles of read-write separation and table-based separation of distributed database,the concept of database middleware is introduced.Then,by comparing the advantages and disadvantages of current mainstream database middleware,mycat is chosen as database middleware for data segmentation and read- write separation,and a set of distributed data for enterprises is designed.Feasibility scheme of library architecture reference.According to the response time test of this scheme,the maximum query time is 3.27 seconds,the minimum is 0.1 seconds,and the average is 0.52 seconds.

关 键 词：分布式数据库 数据库中间件 数据库集群方案 事务消息 负载均衡 

分 类 号：TN101[电子电信—物理电子学]