CN103034697A - Method for realizing high availability of distributed database - Google Patents
Method for realizing high availability of distributed database Download PDFInfo
- Publication number
- CN103034697A CN103034697A CN2012105171394A CN201210517139A CN103034697A CN 103034697 A CN103034697 A CN 103034697A CN 2012105171394 A CN2012105171394 A CN 2012105171394A CN 201210517139 A CN201210517139 A CN 201210517139A CN 103034697 A CN103034697 A CN 103034697A
- Authority
- CN
- China
- Prior art keywords
- node
- data base
- database
- high availability
- distributed
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention aims at providing a method for realizing high availability of distributed databases. By enabling a distributed database cluster to be in a state of being dispersedly and synchronously redundant and enabling redundant databases and a master database to participate in the service of the distributed databases, the high availability of the distributed databases is improved and the consistency and the integrity of the distributed databases are guaranteed.
Description
Technical field
The present invention relates to the fields such as high availability of distributed data base.
Background technology
In today of rapid development of information technology, no matter be internet or the data volume of enterprises, all be in the development and increase of index speed.Under the large data background, distributed data base becomes the important means that solves large data bottleneck, and how to realize that the high availability of distributed data base is most important for the application of distributed data base.
In order to solve the high availability of distributed data base, invented the method for distributed redundancy, the method guarantees the high availability of data by each node in the distributed data base is realized multilevel redundancy between node.
Summary of the invention
The purpose of this invention is to provide a kind of method that distributed data base realizes high availability, by the synchronizing redundant that carries out that the distributed data base cluster is disperseed, and redundant database and master data base are participated in simultaneously the service of distributed data base, thereby improved the high availability of distributed data base, and guaranteed consistance and the integrality of distributed data base.
For achieving the above object, the present invention has set a kind of high availability of distributed data base.
1. calculate the redundant node position, according to the most efficient availability, assurance host node and redundant node are enough disperseed, and the high availability that has satisfied when mistake occurs reaches 99.9%.
2. when upgrading operation, guarantee host node and the concurrent renewal of redundant node at different levels, comprised insertion renewal and the deletion action of data.
3. during query manipulation, according to the execution according to the weight allocation query manipulation of host node and redundant node at different levels, improved the service performance of whole distributed data base.
Description of drawings
Accompanying drawing is workflow schematic diagram of the present invention, in this example, will realize 2 parts of redundant datas (add host node and be altogether 3 parts) at 4 data nodes.Thereby can guarantee when any 2 node failures, not affect the normal use of whole distributed data base.
Embodiment
Below in conjunction with accompanying drawing technical solutions according to the invention are done and to be described in further detail.
Accompanying drawing has showed how to realize high availability under distributed database environment, distributed data base totally 4 station servers wherein, and redundant digit is 2, and the weight of each server is respectively 1 and arrives, and its specific implementation step is as follows.
1) 4 host nodes of initialization.
2) first part of redundancy, when selecting redundancy for each database node, can not with host node at same station server, the number of nodes of this server is minimum simultaneously, the redundancy of database A is chosen on the database server 2 like this, the redundancy of database B is chosen on the server 3, and the redundancy of database C is chosen on the database server 4, and the redundancy of database D is chosen on the database server 1.
3) second part of redundancy, when selecting redundancy for each database node, can not with host node at same station server, the number of nodes of this server is minimum simultaneously, the redundancy of database A is chosen on the database server 3 like this, the redundancy of database B is chosen on the server 4, and the redundancy of database C is chosen on the database server 1, and the redundancy of database D is chosen on the database server 2.
When 4) upgrading operation, if data operate at database A, then need to be at A, A ' and A " upper concurrent execution.
5) during query manipulation, if carry out inquiry at database A, then the inquiry probability that is assigned to of server 1 is 1/ (1+2+3), the inquiry probability 2/ (1+2+3) that server 2 is assigned to, the inquiry probability 3/ (1+2+3) that server 3 is assigned to.
6) behind any 2 node failures, remain 2 nodes and still keep complete data, do not affect the normal effect of whole distributed data base, thereby guarantee the high availability of distributed data base.
Claims (4)
1. the high availability implementation method of distributed data base is characterized in that:
1) under the distributed database environment, the high availability of fulfillment database increases many minutes redundancies of each database node.
2) host node is dispersed on the different database servers from redundant node, has realized high availability.
3) host node and redundant node data are upgraded without Lag synchronization, guarantee the real-time consistency of data.
4) host node and redundant node participate in the service that distributed data base externally provides according to weight, have realized the high efficiency of distributed data base.
2. such as the high availability implementation method under the right 1 described distributed database environment, it is characterized in that: master data base and redundant database are dispersed in the different nodes under the distributed data base efficiently, have realized high availability.
Such as host node as described in the right 1 and redundant node without Lag synchronization new data more, guarantee the real-time consistency of data, the arbitrary node fault will can not affect data consistency and integrality.
4. participate in the service that distributed data base externally provides such as right 1 described host node and redundant node according to weight, realized the high efficiency of distributed data base.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2012105171394A CN103034697A (en) | 2012-12-06 | 2012-12-06 | Method for realizing high availability of distributed database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2012105171394A CN103034697A (en) | 2012-12-06 | 2012-12-06 | Method for realizing high availability of distributed database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103034697A true CN103034697A (en) | 2013-04-10 |
Family
ID=48021591
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2012105171394A Pending CN103034697A (en) | 2012-12-06 | 2012-12-06 | Method for realizing high availability of distributed database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103034697A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105095486A (en) * | 2015-08-17 | 2015-11-25 | 浪潮(北京)电子信息产业有限公司 | Cluster database disaster recovery method and device |
| CN108959604A (en) * | 2018-07-13 | 2018-12-07 | 浙江彩虹鱼科技有限公司 | Safeguard the method, apparatus and computer readable storage medium of data-base cluster |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1992953A (en) * | 2005-12-30 | 2007-07-04 | 中兴通讯股份有限公司 | Method for implementing distributed HLR memory database |
| US20090326726A1 (en) * | 2008-06-25 | 2009-12-31 | Versify Solutions, Llc | Aggregator, monitor, and manager of distributed demand response |
-
2012
- 2012-12-06 CN CN2012105171394A patent/CN103034697A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1992953A (en) * | 2005-12-30 | 2007-07-04 | 中兴通讯股份有限公司 | Method for implementing distributed HLR memory database |
| US20090326726A1 (en) * | 2008-06-25 | 2009-12-31 | Versify Solutions, Llc | Aggregator, monitor, and manager of distributed demand response |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105095486A (en) * | 2015-08-17 | 2015-11-25 | 浪潮(北京)电子信息产业有限公司 | Cluster database disaster recovery method and device |
| CN108959604A (en) * | 2018-07-13 | 2018-12-07 | 浙江彩虹鱼科技有限公司 | Safeguard the method, apparatus and computer readable storage medium of data-base cluster |
| CN108959604B (en) * | 2018-07-13 | 2020-11-10 | 浙江彩虹鱼科技有限公司 | Method, apparatus and computer readable storage medium for maintaining database cluster |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10152377B2 (en) | Layering a distributed storage system into storage groups and virtual chunk spaces for efficient data recovery | |
| AU2017201918B2 (en) | Prioritizing data reconstruction in distributed storage systems | |
| CN103503414B (en) | A kind of group system calculating storage and merge | |
| US9268808B2 (en) | Placement policy | |
| CN110737541B (en) | Method and system for distributing data in distributed storage system | |
| CN103810061B (en) | A kind of High Availabitity cloud storage method | |
| CN111614733B (en) | Deployment method, device and storage medium of distributed multi-fragmentation cluster | |
| CN104050248B (en) | A kind of document storage system and storage method | |
| CN103744906A (en) | System, method and device for data synchronization | |
| CN103067525A (en) | Cloud storage data backup method based on characteristic codes | |
| CN109690494B (en) | Hierarchical fault tolerance in system storage | |
| CN103399894A (en) | Distributed transaction processing method on basis of shared storage pool | |
| CN103955510A (en) | Massive electricity marketing data integration method uploaded by ETL cloud platform | |
| CN104111994A (en) | Label data screening method and device based on mixed data source | |
| CN104536965A (en) | System and method for data query and presentation under big data condition | |
| CN105095103A (en) | Storage device management method and device used for cloud environment | |
| CN104104739A (en) | Data synchronization method for metadata service cluster of cloud storage system | |
| CN105491078A (en) | Data processing method and device in SOA system, and SOA system | |
| CN105187502A (en) | Method and system based on distributed elastic block storage | |
| CN109446202A (en) | Identifier allocation method, device, server and storage medium | |
| CN107451246B (en) | Information resource integrated processing system suitable for large-scale city | |
| CN105528381A (en) | Database data migration method and system | |
| US20200133867A1 (en) | Method, apparatus, and computer program product for providing cache service | |
| CN104951528B (en) | A kind of method and terminal of Data Migration | |
| CN108733307B (en) | Storage management method, apparatus and computer readable medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20130410 |