CN105354111A - Redundancy backup method suitable for wide-area distributed real-time database - Google Patents

Redundancy backup method suitable for wide-area distributed real-time database Download PDF

Info

Publication number
CN105354111A
CN105354111A CN201510718972.9A CN201510718972A CN105354111A CN 105354111 A CN105354111 A CN 105354111A CN 201510718972 A CN201510718972 A CN 201510718972A CN 105354111 A CN105354111 A CN 105354111A
Authority
CN
China
Prior art keywords
copy
wide
data
hot
redundancy
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
Application number
CN201510718972.9A
Other languages
Chinese (zh)
Inventor
王瑾
董宁
杨立波
彭栋
彭晖
魏娜
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
State Grid Corp of China SGCC
State Grid Hebei Electric Power Co Ltd
State Grid Jiangsu Electric Power Co Ltd
State Grid Beijing Electric Power Co Ltd
Nari Technology Co Ltd
Original Assignee
State Grid Corp of China SGCC
State Grid Hebei Electric Power Co Ltd
State Grid Jiangsu Electric Power Co Ltd
State Grid Beijing Electric Power Co Ltd
Nari Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by State Grid Corp of China SGCC, State Grid Hebei Electric Power Co Ltd, State Grid Jiangsu Electric Power Co Ltd, State Grid Beijing Electric Power Co Ltd, Nari Technology Co Ltd filed Critical State Grid Corp of China SGCC
Priority to CN201510718972.9A priority Critical patent/CN105354111A/en
Publication of CN105354111A publication Critical patent/CN105354111A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/07Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/14Error detection or correction of the data by redundancy in operation
    • G06F11/1402Saving, restoring, recovering or retrying
    • G06F11/1446Point-in-time backing up or restoration of persistent data
    • G06F11/1458Management of the backup or restore process
    • G06F11/1461Backup scheduling policy
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/07Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/14Error detection or correction of the data by redundancy in operation
    • G06F11/1402Saving, restoring, recovering or retrying
    • G06F11/1446Point-in-time backing up or restoration of persistent data
    • G06F11/1458Management of the backup or restore process
    • G06F11/1464Management of the backup or restore process for networked environments
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/27Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Databases & Information Systems (AREA)
  • Quality & Reliability (AREA)
  • Computing Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Hardware Redundancy (AREA)

Abstract

The present invention discloses a redundancy backup method suitable for a wide-area distributed real-time database. In a wide-area system, one or more copies are established in a distributed real-time database system for data in the system in a redundant manner, and consistency of the system is ensured by management of the copies. The method comprises the following steps: (1) the copies are divided into a cold copy and a thermal copy, wherein the thermal copy provides an external access, and the cold copy is only used as a backup copy providing no external service capability, and a thermal copy as a benchmark in all thermal copies becomes a master copy, and only the master copy is allowed to be written; (2) managing a status of the copy, wherein the copy is managed by means of status conversion the copy such as master/standby data switching and cold/thermal copy switching, so as to ensure consistency of data of the system; and (3) performing secondary positioning on a request that the master copy cannot achieve. According to the redundancy backup method suitable for a wide-area distributed real-time database provided by the present invention, a redundancy mechanism between different servers and different systems in the system is implemented; and consistency of the data in the wide-area distributed system is ensured by management of the copies.

Description

A kind of redundancy backup method being applicable to wide-area distribution type real-time data base
affiliated field
The present invention relates to a kind of redundancy backup method being applicable to wide-area distribution type real-time data base, belong to wide-area distribution type real-time dataBase system field.
Background technology
Wide-area distribution type real-time dataBase system is made up of the real-time database system be distributed in several systems, in order to the extensibility of each subsystem, and for realizing between subsystem redundancy scheme each other, therefore on subsystem internal different server, subsystem internal redundant node is built, between subsystem, build the redundancy scheme of subsystem simultaneously, but the redundancy scheme do not realized in existing real-time dataBase system in system between different server and between system, thus be difficult to ensure data consistency in wide-area distribution type system.
Summary of the invention
For overcoming the deficiency in prior art, the object of the invention is to provide a kind of based on copy, and be applicable to the redundancy backup method of wide-area distribution type real-time data base, data in distributed real-time database system are built redundant node between different server and between system in system, is ensured the consistance of data in wide-area distribution type system by the management of copy.
For achieving the above object: technical scheme of the present invention is as follows:
Be applicable to a redundancy backup method for wide-area distribution type real-time data base, in wide area system, not only will redundant node in system between different server in constructing system, also will between system the redundancy scheme of constructing system level.Data in distributed real-time database system set up one or more copy in a redundant way in systems in which, are ensured the consistance of system by the management of copy.It comprises following three steps:
1) copy is divided into access ability is not externally provided and in support copy cold copy and to be used for as reference copies and for the hot copy of external reference, there is a copy as benchmark in all hot copies and become primary copy, only have primary copy to allow write;
2) state of copy is managed, by the State Transferring of copy as the management that primary standby data switches, cold and hot copy has switched copy, the consistance of guarantee system data; The State Transferring of copy can through multiple state, and in system, data trnascription state comprises cold copy, hot copy, primary copy, synchronization counterpart and fault copy;
3) to the primary copy request of being beyond one's reach, secondary location is carried out; Described secondary location cannot access primary copy when data access, and when primary copy does not also break down, obtain a copy and be supplied to request of access in the hot copy of current non-master.
The beneficial effect that the present invention reaches:
The present invention realizes the redundancy scheme in system between different server and between system; And ensure data consistency in wide-area distribution type system by the management of copy; The present invention's many application real-time data base data syn-chronization mode ensure that portability, can along with real-time database security of system, stably operate in the operating system platforms such as IBMAIX, SunSolaris, AlphaTru64, HPUX, Linux, Windows; System programming language adopts ANSIC/C++, and meets IEEEPOSIX.2 standard.
Accompanying drawing explanation
Fig. 1 is real-time data base redundancy backup pattern between wide-area distribution type system
Fig. 2 is copy state transition graph.
Embodiment
Below in conjunction with accompanying drawing, the present invention is further described in detail.
The invention discloses a kind of redundancy backup method being applicable to wide-area distribution type real-time data base, in wide area system, not only will redundant node in system between different server in constructing system, also will between system the redundancy scheme of constructing system level.Data in distributed real-time database system set up one or more copy in a redundant way in systems in which, are ensured the consistance of system by the management of copy.
Method of the present invention comprises following step:
1) copy is divided into cold copy and hot copy, hot copy for external reference, cold copy only copy in support, not externally by service ability, there is a copy as benchmark in all hot copies becomes primary copy, only has primary copy to allow write;
2) state of copy is managed, by the State Transferring of copy as the management that primary standby data switches, cold and hot copy has switched copy, the consistance of guarantee system data;
3) to the primary copy request of being beyond one's reach, secondary location is carried out.
First the present invention sets up redundancy backup between wide-area distribution type system, can be two-way standby mutually between two cover systems, also can be standby mutually each other between many cover systems.
Inter-system data redundancy mutually standby function completes the management of copy by the State Transferring of copy.
When primary copy cannot be accessed, comprise database abnormal, the situations such as network is unreachable, this copy can be converted to fault copy, and inter-system data redundancy mutually standby function can specify new primary copy.
Cold copy is converted to the process need manual intervention of hot copy.In transfer process, copy state becomes synchronously by inter-system data redundancy mutually standby function, and checks whether the data of this copy may have access to, if access exception, this copy will be converted to fault copy; If checking process is normal, for doing an all data refreshing from main to this copy, to ensure data consistency, refreshing completes, and this copy is set to hot copy.
The redundancy backup method that the present invention relates to be combine be operated in the independent development of application layer wide-area distribution type real-time data base on realize, do not rely on concrete operating system, be applicable to various operating system.The many application real-time data base data syn-chronization mode that the present invention relates to ensure that portability, can along with real-time database security of system, stably operate in the operating system platforms such as IBMAIX, SunSolaris, AlphaTru64, HPUX, Linux, Windows; System programming language adopts ANSIC/C++, and meets IEEEPOSIX.2 standard.
More than show and describe ultimate principle of the present invention and principal character and advantage of the present invention.The technician of the industry should understand; the present invention is not restricted to the described embodiments; what describe in above-described embodiment and instructions just illustrates principle of the present invention; without departing from the spirit and scope of the present invention; the present invention also has various changes and modifications, and these changes and improvements all fall in the claimed scope of the invention.Application claims protection domain is defined by appending claims and equivalent thereof.

Claims (4)

1. one kind is applicable to the redundancy backup method of wide-area distribution type real-time data base, it is characterized in that, in wide area system, the data in distributed real-time database system set up one or more copy in a redundant way in systems in which, are ensured the consistance of system by the management of copy; Its concrete grammar comprises step:
1) copy is divided into access ability is not externally provided and in support copy cold copy and to be used for as reference copies and for the hot copy of external reference, there is a copy as benchmark in all hot copies and become primary copy, only have primary copy to allow write;
2) manage the state of copy, completed the management of copy by the State Transferring of copy, ensure the consistance of system data; The State Transferring of copy can through multiple state, and in system, the state of data trnascription comprises cold copy, hot copy, primary copy, synchronization counterpart and fault copy;
3) to the primary copy request of being beyond one's reach, secondary location is carried out; Described secondary location cannot access primary copy when data access, and when primary copy does not also break down, obtain a copy and be supplied to request of access in the hot copy of current non-master.
2. the redundancy backup method being applicable to wide-area distribution type real-time data base according to claim 1, it is characterized in that: in described step 1), redundancy backup is set up between wide-area distribution type system, two-way standby mutually between two cover systems or the above system of two covers.
3. the redundancy backup method being applicable to wide-area distribution type real-time data base according to claim 1, is characterized in that: in described step 2) in, inter-system data redundancy mutually standby function completes the management of copy by the State Transferring of copy.
4. the redundancy backup method being applicable to wide-area distribution type real-time data base according to claim 1, it is characterized in that: in described step 3), cold copy is converted in the process of hot copy, copy state becomes synchronously by inter-system data redundancy mutually standby function, and check whether the data of this copy may have access to, if access exception, this copy will be converted to fault copy; If checking process is normal, for doing an all data refreshing from main to this copy, to ensure data consistency, refreshing completes, and this copy is set to hot copy.
CN201510718972.9A 2015-10-29 2015-10-29 Redundancy backup method suitable for wide-area distributed real-time database Pending CN105354111A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201510718972.9A CN105354111A (en) 2015-10-29 2015-10-29 Redundancy backup method suitable for wide-area distributed real-time database

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201510718972.9A CN105354111A (en) 2015-10-29 2015-10-29 Redundancy backup method suitable for wide-area distributed real-time database

Publications (1)

Publication Number Publication Date
CN105354111A true CN105354111A (en) 2016-02-24

Family

ID=55330085

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201510718972.9A Pending CN105354111A (en) 2015-10-29 2015-10-29 Redundancy backup method suitable for wide-area distributed real-time database

Country Status (1)

Country Link
CN (1) CN105354111A (en)

Cited By (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105959356A (en) * 2016-04-26 2016-09-21 华中科技大学 Method of realizing multi-cloud storage fault-tolerance conversion mechanism
CN106383754A (en) * 2016-09-19 2017-02-08 北京众享比特科技有限公司 Database backup and recovery system based on block chain technology, and database backup method based on block chain technology, and database recovery method based on block chain technology
CN107277151A (en) * 2017-06-27 2017-10-20 曙光信息产业(北京)有限公司 A kind of clocking method of job scheduling system
CN109347655A (en) * 2018-09-11 2019-02-15 上海天旦网络科技发展有限公司 Fault recovery system and method and storage medium based on network data
CN109783016A (en) * 2018-12-25 2019-05-21 西安交通大学 A kind of elastic various dimensions redundancy approach in distributed memory system
CN112929438A (en) * 2021-02-04 2021-06-08 中国工商银行股份有限公司 Business processing method and device of double-site distributed database

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1219063A (en) * 1997-12-05 1999-06-09 富士通株式会社 Method and apparatus for data base synchronizing in intelligent network
US7539744B2 (en) * 2000-09-13 2009-05-26 Fortinet, Inc. Network operating system for maintaining redundant master control blade management information
CN103152209A (en) * 2013-03-29 2013-06-12 和记奥普泰通信技术有限公司 Application service operation processing system based on multi-machine hot backup
CN104317803A (en) * 2014-09-23 2015-01-28 厦门美柚信息科技有限公司 Data access structure and method of database cluster

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1219063A (en) * 1997-12-05 1999-06-09 富士通株式会社 Method and apparatus for data base synchronizing in intelligent network
US7539744B2 (en) * 2000-09-13 2009-05-26 Fortinet, Inc. Network operating system for maintaining redundant master control blade management information
CN103152209A (en) * 2013-03-29 2013-06-12 和记奥普泰通信技术有限公司 Application service operation processing system based on multi-machine hot backup
CN104317803A (en) * 2014-09-23 2015-01-28 厦门美柚信息科技有限公司 Data access structure and method of database cluster

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
翟明玉 等: "电网调度广域分布式实时数据库系统体系架构和关键技术", 《电力系统自动化》 *

Cited By (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105959356A (en) * 2016-04-26 2016-09-21 华中科技大学 Method of realizing multi-cloud storage fault-tolerance conversion mechanism
CN105959356B (en) * 2016-04-26 2019-04-12 华中科技大学 A method of realizing the cloudy fault-tolerant transformation mechanism of storage
CN106383754A (en) * 2016-09-19 2017-02-08 北京众享比特科技有限公司 Database backup and recovery system based on block chain technology, and database backup method based on block chain technology, and database recovery method based on block chain technology
CN107277151A (en) * 2017-06-27 2017-10-20 曙光信息产业(北京)有限公司 A kind of clocking method of job scheduling system
CN109347655A (en) * 2018-09-11 2019-02-15 上海天旦网络科技发展有限公司 Fault recovery system and method and storage medium based on network data
CN109347655B (en) * 2018-09-11 2022-03-01 上海天旦网络科技发展有限公司 Network data based fault recovery system and method and storage medium
CN109783016A (en) * 2018-12-25 2019-05-21 西安交通大学 A kind of elastic various dimensions redundancy approach in distributed memory system
CN112929438A (en) * 2021-02-04 2021-06-08 中国工商银行股份有限公司 Business processing method and device of double-site distributed database
CN112929438B (en) * 2021-02-04 2022-09-13 中国工商银行股份有限公司 Business processing method and device of double-site distributed database

Similar Documents

Publication Publication Date Title
CN105354111A (en) Redundancy backup method suitable for wide-area distributed real-time database
US8626936B2 (en) Protocol independent server replacement and replication in a storage area network
CN103559104B (en) A kind of distributed redundancy real-time database framework based on mixed communication
US9201747B2 (en) Real time database system
CN105471960A (en) Information interaction system and method between private clouds and public cloud
CN103078927A (en) Key-value data distributed caching system and method thereof
CN108897641B (en) Log analysis service real-time synchronization system under database master-slave environment
US20170206148A1 (en) Cross-region failover of application services
JP6905161B2 (en) Management methods, systems, and devices for master and standby databases
JP2007241486A (en) Memory system
CN102394873A (en) Authority management system of track traffic integration monitoring and method thereof
CN110719282B (en) Authentication dual-active system based on unified authority
CN106919473A (en) A kind of data disaster recovery and backup systems and method for processing business
CN1299203C (en) Data disaster tocerance backup control system
CN106850269A (en) A kind of management system of cloud platform
CN103810174A (en) Database switching method and database switching system
CN108810150A (en) The data copy method of cooperative office system application layer disaster recovery and backup systems
CN114003350B (en) Data distribution method and system of super-fusion system
CN105404565A (en) Dual-live-data protection method and apparatus
CN103428288A (en) Method for synchronizing copies on basis of partition state tables and coordinator nodes
CN111611550B (en) Computer system, computer device and authorization management method
CN105354332A (en) Method and system for implementing mutual standby of database and middleware based on BCP (Batch Communications Program)
CN111104250A (en) Method, apparatus and computer program product for data processing
CN117076196A (en) Database disaster recovery management and control method and device
CN106027313B (en) Network link disaster tolerance system and method

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
RJ01 Rejection of invention patent application after publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20160224