本文關(guān)鍵詞： 遠(yuǎn)程數(shù)據(jù)同步 多數(shù)據(jù)中心 異地多活 SQL捕獲 一致性 連接驅(qū)動　出處：《中國民航大學(xué)》2017年碩士論文　論文類型：學(xué)位論文

【摘要】：隨著云計(jì)算和大數(shù)據(jù)的快速發(fā)展,異地多活數(shù)據(jù)中心成為傳大型數(shù)據(jù)中心的發(fā)展趨勢。與傳統(tǒng)的數(shù)據(jù)災(zāi)備中心不同,異地?cái)?shù)據(jù)中心不僅有容災(zāi)能力,還有實(shí)時(shí)業(yè)務(wù)分流的作用。因此,在建設(shè)新一代民航旅客信息服務(wù)系統(tǒng)時(shí),提出了構(gòu)建異地多活數(shù)據(jù)中心的需求,而實(shí)現(xiàn)異地多活的關(guān)鍵是高效的遠(yuǎn)程數(shù)據(jù)同步機(jī)制,論文正是基于這種關(guān)鍵需求而開展研究。本文首先調(diào)研某互聯(lián)網(wǎng)公司、某運(yùn)輸公司售票中心等典型多數(shù)據(jù)中心的運(yùn)行模式,結(jié)合各自的業(yè)務(wù)特點(diǎn)、容災(zāi)能力、一致性級別、每個(gè)數(shù)據(jù)中心承擔(dān)的角色以及如何與其它數(shù)據(jù)中心協(xié)調(diào)工作等方面,提出了同城主備、兩地三中心、異地雙活、異地多活的多數(shù)據(jù)中心運(yùn)行模式。其次,比較了這四種模式的特點(diǎn)以及適用場景,并結(jié)合民航旅客服務(wù)信息系統(tǒng)的不同業(yè)務(wù)需求,分別構(gòu)建了主從同步的異地雙活數(shù)據(jù)中心運(yùn)行模式和對等同步的異地多活數(shù)據(jù)中心運(yùn)行模式。然后針對現(xiàn)有遠(yuǎn)程數(shù)據(jù)同步的方法效率低且不能很好的支持異構(gòu)數(shù)據(jù)庫之間同步的現(xiàn)狀,提出了一種新的遠(yuǎn)程數(shù)據(jù)同步方法-基于驅(qū)動程序SQL捕獲的遠(yuǎn)程數(shù)據(jù)同步機(jī)制,研究了從驅(qū)動程序中捕獲SQL的方法,針對其中可能出現(xiàn)的數(shù)據(jù)不一致的情況,提出了相應(yīng)的一致性校驗(yàn)算法。最后采用線程休眠模擬網(wǎng)絡(luò)延遲,編寫測試應(yīng)用程序,在同構(gòu)和異構(gòu)數(shù)據(jù)庫之間做了大量的同步實(shí)驗(yàn),結(jié)果表明,該機(jī)制能提高遠(yuǎn)程數(shù)據(jù)庫同步效率,并支持異構(gòu)數(shù)據(jù)庫同步,為云計(jì)算大數(shù)據(jù)時(shí)代多數(shù)據(jù)中心建設(shè)提供技術(shù)支持。
[Abstract]:With the rapid development of cloud computing and big data, multi-live data center becomes the development trend of large-scale data center. Different from the traditional data disaster preparedness center, the remote data center not only has the capability of disaster recovery. Therefore, in the construction of a new generation of civil aviation passenger information service system, the need to build multi-live data center is put forward. The key to achieve multi-activity is the efficient remote data synchronization mechanism. This paper is based on this key requirement to carry out research. Firstly, this paper investigates a certain Internet company. A transport company ticket center and other typical multi-data center operation mode, combined with their business characteristics, disaster tolerance, consistency level. The role of each data center and how to coordinate with other data centers and other aspects, put forward the same city master and reserve, the two places three centers, two places, two live, different places more live multi-data center operation mode. Secondly. The characteristics and applicable scenarios of these four modes are compared, and the different business requirements of civil aviation passenger service information system are combined. The operation mode of the master-slave synchronization data center and the multi-live data center operation mode are constructed respectively. Then, the existing methods of remote data synchronization are inefficient and can not support the heterogeneous number very well. According to the status of synchronization between libraries. A new method of remote data synchronization is proposed, which is based on the remote data synchronization mechanism captured by the driver SQL, and the method of capturing SQL from the driver is studied. Aiming at the possible data inconsistency, a corresponding consistency checking algorithm is proposed. Finally, thread sleep is used to simulate network delay and test application is written. A large number of synchronization experiments have been done between isomorphic and heterogeneous databases. The results show that the mechanism can improve the efficiency of remote database synchronization and support heterogeneous database synchronization. For cloud computing big data era of multi-data center construction to provide technical support.
【學(xué)位授予單位】：中國民航大學(xué)
【學(xué)位級別】：碩士
【學(xué)位授予年份】：2017
【分類號】：TP311.13;TP308

【參考文獻(xiàn)】

相關(guān)期刊論文 前4條

1 何慧虹;王勇;史亮;;分布式環(huán)境下基于ZooKeeper服務(wù)的數(shù)據(jù)同步研究[J];信息網(wǎng)絡(luò)安全;2015年09期

2 孫昆;張t ;王子亨;穆森;;多級多域視頻監(jiān)控系統(tǒng)數(shù)據(jù)同步機(jī)制的設(shè)計(jì)[J];計(jì)算機(jī)應(yīng)用;2015年S1期

3 余文濤;李立新;余文彬;王魁;;基于多agent的移動數(shù)據(jù)庫事務(wù)級同步復(fù)制模型研究[J];計(jì)算機(jī)應(yīng)用研究;2015年01期

4 賴錦輝;梁松;;基于層次化調(diào)度策略和動態(tài)數(shù)據(jù)復(fù)制的網(wǎng)格調(diào)度方法[J];計(jì)算機(jī)應(yīng)用研究;2014年02期

相關(guān)碩士學(xué)位論文 前1條

1 常晟;基于事件驅(qū)動的云平臺數(shù)據(jù)同步研究[D];中國科學(xué)院大學(xué)（工程管理與信息技術(shù)學(xué)院）;2014年

，

本文編號：1474925