基于MYSQL的分布式數(shù)據(jù)中間層
發(fā)布時間:2018-11-02 09:24
【摘要】:近年來,隨著移動互聯(lián)網(wǎng)的高速發(fā)展,運營商的用戶激增,用戶產(chǎn)生的數(shù)據(jù)也在呈幾何級的增長。根據(jù)德勤咨詢公司發(fā)布的研究報告,2012年運營商的用戶的存量數(shù)據(jù)達到了192億條,總數(shù)據(jù)容量高達21TB之多。電信企業(yè)的核心系統(tǒng),比如在線交易支持的計費系統(tǒng)和客戶關系管理系統(tǒng)等,面臨巨大的壓力,特別是性能和擴展性。傳統(tǒng)的集中式數(shù)據(jù)庫因為擴展性,以及高昂的價格等問題而無法滿足業(yè)務增長需求。此外,目前具有高性能和高擴展性的云計算系統(tǒng)也主要是針對不支持事務的分析型應用,無法像傳統(tǒng)的DBMS那樣可以支持在線事務處理。針對該問題,根據(jù)XXXX公司對于數(shù)據(jù)即服務平臺的要求,在充分研究了云計算最新技術的基礎上,我們設計和初步實現(xiàn)了以分布式數(shù)據(jù)中間層+MYSQL數(shù)據(jù)庫+PCServer的D AAS平臺。我們的系統(tǒng)具有四個基本特征:1)統(tǒng)一訪問接口,對數(shù)據(jù)庫應用透明;2)高可用性,消除數(shù)據(jù)單點故障;3)高伸縮性,可以動態(tài)增加、刪除數(shù)據(jù)和存儲節(jié)點;4)隔離性,數(shù)據(jù)資源相互隔離。分布式數(shù)據(jù)中間層經(jīng)過TPC-C測試,完全支持標準的MYSQL在線事務處理。此外在保證了功能的基礎上,分布式數(shù)據(jù)中間層具有一定的系統(tǒng)擴展性。
[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 許海洋;分布式事務處理協(xié)議的研究與應用[D];山東科技大學;2011年
2 胡珉;對數(shù)據(jù)庫中間件性能調優(yōu)的設計與實現(xiàn)[D];沈陽工業(yè)大學;2004年
3 謝睿;基于OPC規(guī)范的數(shù)據(jù)訪問中間件的研究與設計[D];華北電力大學(北京);2009年
4 蘇瑋;分布式緩存技術在插入密集型系統(tǒng)中應用的研究與實現(xiàn)[D];電子科技大學;2012年
,本文編號:2305621
本文鏈接:http://sikaile.net/guanlilunwen/kehuguanxiguanli/2305621.html
最近更新
教材專著