CN103838755A - Remote heterogeneous disaster tolerant system of database - Google Patents
Remote heterogeneous disaster tolerant system of database Download PDFInfo
- Publication number
- CN103838755A CN103838755A CN201210483362.1A CN201210483362A CN103838755A CN 103838755 A CN103838755 A CN 103838755A CN 201210483362 A CN201210483362 A CN 201210483362A CN 103838755 A CN103838755 A CN 103838755A
- Authority
- CN
- China
- Prior art keywords
- database
- disaster
- backup
- middleware
- data
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
- G06F11/1446—Point-in-time backing up or restoration of persistent data
- G06F11/1458—Management of the backup or restore process
- G06F11/1464—Management of the backup or restore process for networked environments
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
Abstract
The invention discloses a remote heterogeneous disaster tolerant system of a database and relates to a disaster tolerant system. The remote heterogeneous disaster tolerant system comprises a main system (1) and a disaster backup recovery system (4). The main system is connected with the disaster backup system (4) through a TCP/IP protocol and an ORB soft bus. The main system (1) comprises a matter processing middle piece (2) and a main system database (3). The disaster backup recovery system (4) comprises a disaster recovery backup database access middle piece (5) and a disaster recovery backup database (6). The matter processing middle piece (2) is connected with the disaster backup database access middle piece (5) through a remote data reproducer. The remote heterogeneous disaster tolerant system has great flexibility and transportability and is low in cost, convenient to use, safe, and high in reliability.
Description
Technical field
What the present invention relates to is disaster tolerance system, is specifically related to a kind of long-range isomery disaster tolerance system of database.
Background technology
The network storage equipment provides Information Access and the share service of network information system, and its principal character is embodied in: super large memory capacity, high data transmission rate and high system availability.Traditional network storage equipment is all that RAID disk array is directly connected on the server of network system, and the network memory structure of this form is called DAS (Direct Attached Storage).In addition, SAN (Storage Area Network) and NAS (Network Attached Storage) are also two kinds of common storage architectures.SAN (storage area network) is a kind of high speed storing network that is similar to common LAN (Local Area Network), and the simple and easy method that provides a kind of and existing LAN to be connected allows enterprise to increase independently memory capacity, and makes network performance not be subject to the impact of data access.This independently proprietary network storage mode makes SAN have that extendability is high, manageability good and the advantage such as fault-tolerant ability is strong.
Disaster tolerance, briefly, is exactly the storage backup by system, guarantees, in various unpredictable disasters arrivings, the data message of storage still to be saved from damage.Remote disaster tolerance, be for preventing that thereby local database system from causing data, services to be interrupted because various disaster events collapse, set up a set of redundant system suitable with local data system in strange land, after disaster occurs, remote system can be accepted rapidly local database system data, services is provided, and the service of guarantee is not interrupted substantially.The object of data disaster tolerance is not only wanted protected data, the more important thing is and wants recovery system operation in time, ensures the continuity of data, services.
The core of infosystem disaster tolerance is data disaster tolerance.Application demand for enterprise customer to infosystem long-distance disaster, the numerous and confused Disaster Tolerant Scheme of releasing oneself of some data storage plant and some independent software vendors at present, IBM Corporation, Hewlett-Packard and VERITAS company (company limited of Veritas Softwre) are three and have strength and representational manufacturer.But we can find from their disaster recovery solution: to System Hardware Requirement harshness, the scheme of most producers is all to support the hardware device of oneself, these schemes often need expensive high-end disk array and optical fiber remote connection device, therefore invest hugely, and be subject to many restrictions in the application scenario of hardware device of integrating other brands.What these equipment all required that active and standby system isomorphism is that host node and calamity slave node adopt substantially is identical hardware system and software systems, the particularly software on Database Systems and upper strata thereof, this disaster that software inhouse design defect is brought lacks enough defensive ability/resistance abilities.
Summary of the invention
For the deficiency existing in prior art, the present invention seeks to be to provide a kind of long-range isomery disaster tolerance system of database, there are very large dirigibility and portability, cost is low, easy to use, and safe reliability is high.
To achieve these goals, the present invention realizes by the following technical solutions: the long-range isomery disaster tolerance system of database, comprise main system and disaster recovery and backup systems, and main system is connected with ORB flexible bus by ICP/IP protocol with disaster recovery and backup systems; Described main system comprises transaction middleware and main system data storehouse, disaster recovery and backup systems comprise calamity for Database-access Middleware Based and calamity for database, transaction middleware is connected for Database-access Middleware Based with calamity by duplicating remote data program.
According to the long-range isomery disaster tolerance system of above-mentioned database, wherein, described calamity is connected with main system data storehouse by data recovery procedures for database.
According to the long-range isomery disaster tolerance system of above-mentioned database, wherein, described transaction middleware comprises load server, querying server and global catalog's server, and global catalog's server is connected with load server, querying server respectively by Global Dictionary.
According to the long-range isomery disaster tolerance system of above-mentioned database, wherein, the load balance that described transaction middleware adopts CORBA to provide serves to eliminate performance bottleneck, and adopts redundancy services to prevent single point failure, improves the reliability of system.
According to the long-range isomery disaster tolerance system of above-mentioned database, wherein, described transaction middleware and calamity are for realizing backup logic between Database-access Middleware Based.
Between main system 1 of the present invention and disaster recovery and backup systems 4, be connected with ORB flexible bus by TCP/IP network, active and standby two systems all visit the database of bottom by middleware, the Database-access Middleware Based of active and standby two systems has identical user interface, and the remote copy of data is undertaken by middleware.The reliability that remote data copies and the expense of consistency maintenance have a certain impact to system performance, so take to have " continuing a hectare filling ", the production data of characteristic adopts the data Replica strategy of " application layer pair is write ", and relatively little configuration data and the statistics of data volume adopts the mode of intercepted data storehouse operation (SQL statement) to realize backup logic at middleware layer.The recovery of data adopts copper pipe inquiry middleware to read then and to call by CORBA the mode that the loading middleware of main system loads and realize from standby system database.
The present invention has very large dirigibility and portability, and cost is low, easy to use, and safe reliability is high.
Brief description of the drawings
Describe the present invention in detail below in conjunction with the drawings and specific embodiments;
Fig. 1 is structural representation of the present invention;
Fig. 2 is the structural representation of part between transaction in the present invention;
Fig. 3 is the remote disaster allowable system schematic diagram of the embodiment of the present invention.
Embodiment
For technological means, creation characteristic that the present invention is realized, reach object and effect is easy to understand, below in conjunction with embodiment, further set forth the present invention.
With reference to Fig. 1-2, the long-range isomery disaster tolerance system of the database in the present embodiment, has very large dirigibility and portability, and cost is low, easy to use, and safe reliability is high.It comprises main system 1 and disaster recovery and backup systems 4, and main system 1 is connected with ORB flexible bus by ICP/IP protocol with disaster recovery and backup systems 4; Described main system 1 comprises transaction middleware 2 and main system data storehouse 3, disaster recovery and backup systems 4 comprise calamity for Database-access Middleware Based 5 and calamity for database 6, transaction middleware 2 is connected for Database-access Middleware Based 5 with calamity by duplicating remote data program 7.
In the present embodiment, this calamity is connected with main system data storehouse 3 by data recovery procedures for database 6.
It is worth mentioning that, described transaction middleware 2 comprises load server 21, querying server 22 and global catalog's server 23, and global catalog's server 23 is connected with load server 21, querying server 22 respectively by Global Dictionary.Described transaction middleware 2 adopts the load balance that CORBA provides to serve to eliminate performance bottleneck, and adopts redundancy services to prevent single point failure, improves the reliability of system.Described transaction middleware 2 and calamity are for realizing backup logic between Database-access Middleware Based 5.
Between main system 1 in the present embodiment and disaster recovery and backup systems 4, be connected with ORB flexible bus by TCP/IP network, active and standby two systems all visit the database of bottom by middleware, the Database-access Middleware Based of active and standby two systems has identical user interface, and the remote copy of data is undertaken by middleware.The reliability that remote data copies and the expense of consistency maintenance have a certain impact to system performance, so take to have " continuing a hectare filling ", the production data of characteristic adopts the data Replica strategy of " application layer pair is write ", and relatively little configuration data and the statistics of data volume adopts the mode of intercepted data storehouse operation (SQL statement) to realize backup logic at middleware layer.The recovery of data adopts copper pipe inquiry middleware to read then and to call by CORBA the mode that the loading middleware of main system loads and realize from standby system database.
The remote disaster allowable system that the present embodiment is applied to medical aspect as shown in Figure 3, it is made up of master data center and Backup Data center, wherein, master data center adopts the design of high reliability Cluster Solution, and Backup Data center is connected by optical fiber with master data center.Master data centring system configure host comprises two master servers and other associated servers, by HA software composition multimachine high reliability environment is installed.Data are stored in master data central store disk array.Meanwhile, at remote backup data center configuration performance suitable memory disk array and backup server, can automatically realize the backup completely in real time of master data central store data and Backup Data centre data by special disaster recovery software.At master data center, also configure tape backup server, be used for installing backup software and tape library.Backup server is directly connected to storage array and tape library, the tape backup of day regular data of control system.Wherein, optical transmission device is as the transmission equipment between Liang Ge data center; Liang Ge data center utilizes optical transmission device to form optical self-healing ring (be used to provide high-performance, full redundancy, without switching slot, the roundabout clog-free passage of route) by optical fiber, and optical self-healing ring can provide the communication bandwidth up to 80G (protection) and 160G (non-protection) altogether.Connect for Liang Ge data center provides high bandwidth, highly reliable network by high performance backbone.Backup Data center meets the following conditions: possess the network similar to master data center, communications setting; Possesses the basic system configuration of service application operation; Possess stable, efficient telecommunication channel and connect master data center, guarantee backing up in realtime of data; Possess daily servicing condition and with master data center at a distance of the distance of safe enough.
The Database-access Middleware Based of the Disaster Preparation Center of this embodiment is the basic components of whole remote disaster allowable system, has magnanimity information processing ability, can meet the demand that high-strength data stream is processed, and can be competent at the demand of taking over main system business.He also possesses mobile dirigibility, reliability simultaneously.
More than show and described 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; that in above-described embodiment and instructions, describes 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.The claimed scope of the present invention is defined by appending claims and equivalent thereof.
Claims (5)
1. the long-range isomery disaster tolerance system of database, is characterized in that, comprises main system (1) and disaster recovery and backup systems (4), and main system (1) is connected with ORB flexible bus by ICP/IP protocol with disaster recovery and backup systems (4); Described main system (1) comprises transaction middleware (2) and main system data storehouse (3), disaster recovery and backup systems (4) comprise calamity for Database-access Middleware Based (5) and calamity for database (6), transaction middleware (2) is connected for Database-access Middleware Based (5) with calamity by duplicating remote data program (7).
2. the long-range isomery disaster tolerance system of database according to claim 1, is characterized in that, described calamity is connected with main system data storehouse (3) by data recovery procedures for database (6).
3. the long-range isomery disaster tolerance system of database according to claim 1, it is characterized in that, described transaction middleware (2) comprises load server (21), querying server (22) and global catalog's server (23), and global catalog's server (23) is connected with load server (21), querying server (22) respectively by Global Dictionary.
4. the long-range isomery disaster tolerance system of database according to claim 1, it is characterized in that, the load balance that described transaction middleware (2) adopts CORBA to provide serves to eliminate performance bottleneck, and adopts redundancy services to prevent single point failure.
5. the long-range isomery disaster tolerance system of database according to claim 1, is characterized in that, described transaction middleware (2) and calamity are for realizing backup logic between Database-access Middleware Based (5).
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210483362.1A CN103838755A (en) | 2012-11-23 | 2012-11-23 | Remote heterogeneous disaster tolerant system of database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210483362.1A CN103838755A (en) | 2012-11-23 | 2012-11-23 | Remote heterogeneous disaster tolerant system of database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103838755A true CN103838755A (en) | 2014-06-04 |
Family
ID=50802268
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210483362.1A Pending CN103838755A (en) | 2012-11-23 | 2012-11-23 | Remote heterogeneous disaster tolerant system of database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103838755A (en) |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104679607A (en) * | 2015-02-04 | 2015-06-03 | 山东省计算中心（国家超级计算济南中心） | Disaster tolerance system and method for heterogeneous storage |
| CN105224637A (en) * | 2015-09-24 | 2016-01-06 | 珠海许继芝电网自动化有限公司 | A kind of based on PostgreSQL database active and standby/the comprehensive method of cluster application |
| CN105607969A (en) * | 2015-12-18 | 2016-05-25 | 深圳市金蝶友商电子商务服务有限公司 | Failure period data access recovery system and method |
| CN106686077A (en) * | 2016-12-24 | 2017-05-17 | 上海七牛信息技术有限公司 | System and method for processing network requests across double-layer proxies of data centers in computer rooms |
| CN106815097A (en) * | 2017-01-18 | 2017-06-09 | 北京许继电气有限公司 | Database disaster tolerance system and method |
| CN107357866A (en) * | 2017-07-01 | 2017-11-17 | 广东电网有限责任公司信息中心 | A kind of production domesticization moving method of information system for power enterprise middleware, database |
| CN107391306A (en) * | 2017-07-27 | 2017-11-24 | 国家电网公司 | A kind of isomeric data library backup file access pattern method |
| CN108647117A (en) * | 2018-04-26 | 2018-10-12 | 郑州云海信息技术有限公司 | A kind of method of data backup, main system, equipment and computer readable storage medium |
| CN108762982A (en) * | 2018-05-18 | 2018-11-06 | 杭州数梦工场科技有限公司 | A kind of database restoring method, apparatus and system |
| CN110502535A (en) * | 2019-08-28 | 2019-11-26 | 上海达梦数据库有限公司 | Data access method, device, equipment and storage medium |
| WO2020078450A1 (en) * | 2018-10-19 | 2020-04-23 | 北京微播视界科技有限公司 | Video content push method and apparatus |
| CN112685234A (en) * | 2020-11-26 | 2021-04-20 | 辽宁振兴银行股份有限公司 | Financial-level two-place three-center high-availability MySQL database implementation method |
-
2012
- 2012-11-23 CN CN201210483362.1A patent/CN103838755A/en active Pending
Cited By (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104679607A (en) * | 2015-02-04 | 2015-06-03 | 山东省计算中心（国家超级计算济南中心） | Disaster tolerance system and method for heterogeneous storage |
| CN104679607B (en) * | 2015-02-04 | 2016-02-24 | 山东省计算中心（国家超级计算济南中心） | The disaster tolerance system that a kind of isomery stores and method |
| CN105224637A (en) * | 2015-09-24 | 2016-01-06 | 珠海许继芝电网自动化有限公司 | A kind of based on PostgreSQL database active and standby/the comprehensive method of cluster application |
| CN105607969A (en) * | 2015-12-18 | 2016-05-25 | 深圳市金蝶友商电子商务服务有限公司 | Failure period data access recovery system and method |
| CN106686077A (en) * | 2016-12-24 | 2017-05-17 | 上海七牛信息技术有限公司 | System and method for processing network requests across double-layer proxies of data centers in computer rooms |
| CN106815097A (en) * | 2017-01-18 | 2017-06-09 | 北京许继电气有限公司 | Database disaster tolerance system and method |
| CN107357866A (en) * | 2017-07-01 | 2017-11-17 | 广东电网有限责任公司信息中心 | A kind of production domesticization moving method of information system for power enterprise middleware, database |
| CN107391306A (en) * | 2017-07-27 | 2017-11-24 | 国家电网公司 | A kind of isomeric data library backup file access pattern method |
| CN108647117A (en) * | 2018-04-26 | 2018-10-12 | 郑州云海信息技术有限公司 | A kind of method of data backup, main system, equipment and computer readable storage medium |
| CN108762982A (en) * | 2018-05-18 | 2018-11-06 | 杭州数梦工场科技有限公司 | A kind of database restoring method, apparatus and system |
| CN108762982B (en) * | 2018-05-18 | 2019-09-17 | 杭州数梦工场科技有限公司 | A kind of database restoring method, apparatus and system |
| CN110647425A (en) * | 2018-05-18 | 2020-01-03 | 杭州数梦工场科技有限公司 | Database recovery method and device |
| WO2020078450A1 (en) * | 2018-10-19 | 2020-04-23 | 北京微播视界科技有限公司 | Video content push method and apparatus |
| US11146858B2 (en) | 2018-10-19 | 2021-10-12 | Beijing Microlive Vision Technology Co., Ltd | Method and apparatus for pushing video content |
| CN110502535A (en) * | 2019-08-28 | 2019-11-26 | 上海达梦数据库有限公司 | Data access method, device, equipment and storage medium |
| CN110502535B (en) * | 2019-08-28 | 2022-02-22 | 上海达梦数据库有限公司 | Data access method, device, equipment and storage medium |
| CN112685234A (en) * | 2020-11-26 | 2021-04-20 | 辽宁振兴银行股份有限公司 | Financial-level two-place three-center high-availability MySQL database implementation method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103838755A (en) | Remote heterogeneous disaster tolerant system of database | |
| US9747179B2 (en) | Data management agent for selective storage re-caching | |
| US7058848B2 (en) | Controller-based remote copy system with logical unit grouping | |
| US7111189B1 (en) | Method for transaction log failover merging during asynchronous operations in a data storage network | |
| US6643795B1 (en) | Controller-based bi-directional remote copy system with storage site failover capability | |
| US7886298B2 (en) | Data transfer protocol for data replication between multiple pairs of storage controllers on a san fabric | |
| US7149769B2 (en) | System and method for multi-destination merge in a storage area network | |
| JP5959733B2 (en) | Storage system and storage system failure management method | |
| US20070180309A1 (en) | System and method for mirroring data | |
| US20070214105A1 (en) | Network topology for a scalable data storage system | |
| US20050005001A1 (en) | Cluster computing system and its failover method | |
| CN101540685B (en) | PCIe shared storage blade for blade server | |
| JP2012531654A (en) | Storage system and storage system communication path management method | |
| CN104023246B (en) | A kind of video data private cloud storage system and video data private cloud storage method | |
| WO2012097588A1 (en) | Data storage method, apparatus and system | |
| CN101056254B (en) | An expansion method, system and device of network storage device | |
| CN106888116B (en) | Scheduling method of double-controller cluster shared resources | |
| US9841923B2 (en) | Storage apparatus and storage system | |
| CN108512753B (en) | Method and device for transmitting messages in cluster file system | |
| CN105005515B (en) | A kind of LAN free standby systems | |
| JP2013065120A (en) | Load distribution system, data access device, and load distribution method | |
| US7136975B2 (en) | Storage system, storage control device, and data relay method using storage control device | |
| JP2023547895A (en) | Techniques for generating configurations for electrically isolating fault domains within data centers | |
| CN112783694A (en) | Long-distance disaster recovery method for high-availability Redis | |
| US7680839B1 (en) | System and method for resynchronizing mirrored volumes |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20140604 |