基于MYSQL的分布式数据中间层
发布时间：2018-11-02 09:24
【摘要】：近年来,随着移动互联网的高速发展,运营商的用户激增,用户产生的数据也在呈几何级的增长。根据德勤咨询公司发布的研究报告,2012年运营商的用户的存量数据达到了192亿条,总数据容量高达21TB之多。电信企业的核心系统,比如在线交易支持的计费系统和客户关系管理系统等,面临巨大的压力,特别是性能和扩展性。传统的集中式数据库因为扩展性,以及高昂的价格等问题而无法满足业务增长需求。此外,目前具有高性能和高扩展性的云计算系统也主要是针对不支持事务的分析型应用,无法像传统的DBMS那样可以支持在线事务处理。针对该问题,根据XXXX公司对于数据即服务平台的要求,在充分研究了云计算最新技术的基础上,我们设计和初步实现了以分布式数据中间层+MYSQL数据库+PCServer的D AAS平台。我们的系统具有四个基本特征：1)统一访问接口,对数据库应用透明；2)高可用性,消除数据单点故障；3)高伸缩性,可以动态增加、删除数据和存储节点；4)隔离性,数据资源相互隔离。分布式数据中间层经过TPC-C测试,完全支持标准的MYSQL在线事务处理。此外在保证了功能的基础上,分布式数据中间层具有一定的系统扩展性。
[Abstract]:In recent years, with the rapid development of mobile Internet, the number of users of operators has increased sharply, and the data generated by users are also increasing in geometric level. According to a study released by Deloitte and Touche, in 2012, carriers had 19.2 billion user stock data, with a total data capacity of as much as 21TB. The core systems of telecom enterprises, such as online transaction supporting billing system and customer relationship management system, are under great pressure, especially performance and expansibility. Traditional centralized databases are unable to meet business growth due to scalability and high prices. In addition, the current cloud computing systems with high performance and high scalability are mainly for non-transaction analysis applications, which can not support online transaction processing as traditional DBMS. In order to solve this problem, according to the requirement of XXXX company for data as a service platform, we design and implement D AAS platform based on distributed data intermediate layer MYSQL database PCServer on the basis of fully studying the latest technology of cloud computing. Our system has four basic features: 1) unified access interface, transparent to database application; 2) high availability, eliminating single point failure of data; 3) high scalability, dynamic increase, deletion of data and storage nodes; 4) isolation, data resources are isolated from each other. The distributed data Intermediate layer is tested by TPC-C and fully supports standard MYSQL online transaction processing. In addition, on the basis of ensuring the function, the middle layer of distributed data has a certain system extensibility.
【学位授予单位】：复旦大学
【学位级别】：硕士
【学位授予年份】：2013
【分类号】：TP311.13
本文编号：2305621
[Abstract]:In recent years, with the rapid development of mobile Internet, the number of users of operators has increased sharply, and the data generated by users are also increasing in geometric level. According to a study released by Deloitte and Touche, in 2012, carriers had 19.2 billion user stock data, with a total data capacity of as much as 21TB. The core systems of telecom enterprises, such as online transaction supporting billing system and customer relationship management system, are under great pressure, especially performance and expansibility. Traditional centralized databases are unable to meet business growth due to scalability and high prices. In addition, the current cloud computing systems with high performance and high scalability are mainly for non-transaction analysis applications, which can not support online transaction processing as traditional DBMS. In order to solve this problem, according to the requirement of XXXX company for data as a service platform, we design and implement D AAS platform based on distributed data intermediate layer MYSQL database PCServer on the basis of fully studying the latest technology of cloud computing. Our system has four basic features: 1) unified access interface, transparent to database application; 2) high availability, eliminating single point failure of data; 3) high scalability, dynamic increase, deletion of data and storage nodes; 4) isolation, data resources are isolated from each other. The distributed data Intermediate layer is tested by TPC-C and fully supports standard MYSQL online transaction processing. In addition, on the basis of ensuring the function, the middle layer of distributed data has a certain system extensibility.
【学位授予单位】：复旦大学
【学位级别】：硕士
【学位授予年份】：2013
【分类号】：TP311.13
【参考文献】
相关硕士学位论文 前4条
1 许海洋;分布式事务处理协议的研究与应用[D];山东科技大学;2011年
2 胡珉;对数据库中间件性能调优的设计与实现[D];沈阳工业大学;2004年
3 谢睿;基于OPC规范的数据访问中间件的研究与设计[D];华北电力大学（北京）;2009年
4 苏玮;分布式缓存技术在插入密集型系统中应用的研究与实现[D];电子科技大学;2012年
，本文编号：2305621
本文链接：https://www.wllwen.com/guanlilunwen/kehuguanxiguanli/2305621.html
