CN105227394A - A kind of fault detect of the DB2 database based on x86 platform and changing method - Google Patents
A kind of fault detect of the DB2 database based on x86 platform and changing method Download PDFInfo
- Publication number
- CN105227394A CN105227394A CN201510533592.8A CN201510533592A CN105227394A CN 105227394 A CN105227394 A CN 105227394A CN 201510533592 A CN201510533592 A CN 201510533592A CN 105227394 A CN105227394 A CN 105227394A
- Authority
- CN
- China
- Prior art keywords
- bcp
- resource
- platform
- cluster
- database
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of fault detect and changing method of the DB2 database based on x86 platform, belong to fault detect and the changing method of database, the technical problem to be solved in the present invention, for how ensureing that database continues operation in various key application, reaches sustainable benign cycle.Technical scheme is: its step is as follows: (1) installs DB2 and BCP software respectively on two x86 platforms, and two x86 platforms configure the IP of two different segments respectively, is used as public network IP and private network IP; Creation database also configures HADR, starts BCP service; (2) decompress(ion) BCP installation kit under windows environment, opens the administrative client of BCP, logs in any x86 platform, creates cluster, resource group, resource; (3) cluster that BCP administrative client creates is uploaded in two x86 platforms, and start cluster.
Description
Technical field
The present invention relates to a kind of fault detect and changing method of database, specifically a kind of fault detect of the DB2 database based on x86 platform and changing method.
Background technology
Along with the continuous propelling of informatization; the activity of each enterprises and institutions more and more depends on the operating information system of its key; these operating information systems play vital effect to the operation of whole mechanism and development; once delay, machine fault or application are shut down, and bring huge economic loss by mechanism.Visible, those needs are ensured information safety and provides the mechanism of continual information service, operation system
Fault-tolerance and continuity seem particularly important.How to ensure that various key application continues operation, reach forever
Continuous benign cycle of managing, has become the key issue of current enterprises and institutions and the solution of IT field urgent need.
summary of the invention
Technical assignment of the present invention is for above weak point, provides that a kind of structure is simple, production cost is low, is easy to process, the fault detect of the DB2 database based on x86 platform of environmentally safe and changing method.
The technical solution adopted for the present invention to solve the technical problems is: a kind of fault detect of the DB2 database based on x86 platform and changing method, step is as follows: (1) installs DB2 and BCP software respectively on two x86 platforms, two x86 platforms configure the IP of two different segments respectively, are used as public network IP and private network IP; Creation database also configures HADR, starts BCP service;
(2) decompress(ion) BCP installation kit under windows environment, opens the administrative client of BCP, logs in any x86 platform, creates cluster, resource group, resource;
(3) cluster that BCP administrative client creates is uploaded in two x86 platforms, and start cluster;
(4) after starting cluster, all resources in cluster all can give tacit consent to startup on the primary node, host node response user request, and BCP monitors the resource of all establishments in main platform and the state of monitoring resource; If resource breaks down, after BCP software detection breaks down to resource, can automatically switch, by all resource switch on host node in slave node, slave node, by all business on this platform of adapter, realizes detection and the switching of fault, ensures the continuity of business.
Hardware platform is x86 platform, and x86 platform is the platform based on 80x86 processor hardware framework.X86 framework occurs for the first time in the Intel8086 central processing unit of release in 1978, and it develops from Intel8008 processor, and 8008 is then that development is from Intel4004.8086 in 3 years afterwards selected by IBMPC, x86 just becomes the standard platform of personal computer afterwards, becomes always the most successful CPU architecture.
BCP software is the high-availability cluster software product (and being not only a two-node cluster hot backup software) of a specialty, and it provides high-availability solution complete in Windows and Linux platform.When certain node in cluster breaks down due to software or hardware reason, group system can the resource switch such as IP, client traffic on the node of other health, make whole system continually externally can provide service continuously, thus provide reliable guarantee for the key business of mechanism 24x365, reach high availability and the reliability of system 99.999%.
In the production application of reality, two-node cluster hot backup uses widely.DB2 database in two-shipper realizes the data syn-chronization on active and standby two machines by configuration HADR, ensure the consistency of data; But when master server breaks down, corresponding mechanism is needed to make application be switched on standby server, standby host makes standby server become master server and takes over all services, the switching that DB2 does not have corresponding mechanism to realize between active/standby server, although can use; And BCP just can make up this defect, the fault detect of active/standby server can be realized and switch fast.
Compared to the prior art the fault detect of a kind of DB2 database based on x86 platform of the present invention and changing method, have following beneficial effect:
(1) have employed the method that BCP and DB2 database combines, the high availability of fulfillment database;
(2) consistency of data in two-shipper is realized by the HADR characteristic of DB2; Relevant software and hardware resources realization is created to the failure monitoring of hardware environment and switching, the high availability of fulfillment database by BCP;
(3) journal file that host node is produced by the mode that daily record is synchronous by HADR is synchronized in slave node, and slave node realizes, with the data syn-chronization of host node, ensureing the consistency of data on two servers by synchronous received journal file;
(4) BCP is by establishing resource group, comprises related resource in resource group, as Floating IP address resource, Lv resource, application resource, script resource etc., monitors the content that resource group comprises; If break down, BCP will realize switching automatically, by all resource switch on an other enabled node, realize High Availabitity, ensure the continuity of business;
(5) kernel process of the monitor database that BCP can be real-time, guarantees the normal operation of database; Can monitor related hardware and other application programs as required simultaneously, make to guarantee the safe and reliable of the hardware environment that database runs; After network environment is put up, BCP can be configured by x86 platform is long-range, and checks correlation log at any time, realizes managing fast and easily.
As can be seen here, the present invention have reasonable in design, structure is simple, easy to operate feature, thus, have good value for applications.
Accompanying drawing explanation
Below in conjunction with accompanying drawing, the present invention is further described.
Accompanying drawing 1 is BCP operation principle schematic block diagram in the present invention.
Embodiment
Below in conjunction with the drawings and specific embodiments, the invention will be further described.
Embodiment 1
Based on fault detect and the changing method of the DB2 database of x86 platform, step is as follows:
(1) on two x86 platforms, install DB2 and BCP software respectively, two x86 platforms configure the IP of two different segments respectively, are used as public network IP and private network IP respectively; Creation database also configures HADR, starts BCP service.
(2) decompress(ion) BCP installation kit under windows environment, opens the administrative client ClusterManager.jar of BCP, logs in any x86 platform, creates cluster, resource group, resource etc., as the monitoring resource of the kernel process db2sysc of DB2.
(3) cluster that BCP administrative client creates is uploaded in two x86 platforms, and start cluster.
As shown in Figure 1, after starting cluster, all resources in cluster all can give tacit consent to startup on the primary node, host node response user request, and BCP monitors the resource of all establishments in main platform and the state of monitoring resource; If resource breaks down, after BCP software detection breaks down to resource, can automatically switch, by all resource switch on host node in slave node, slave node, by all business on this platform of adapter, realizes detection and the switching of fault, ensures the continuity of business.
Above-mentioned embodiment is only concrete case of the present invention; scope of patent protection of the present invention includes but not limited to above-mentioned embodiment; any claims according to the invention and any person of an ordinary skill in the technical field to its suitable change done or replacement, all should fall into scope of patent protection of the present invention.
Except the technical characteristic described in specification, be the known technology of those skilled in the art.
Claims (1)
1., based on fault detect and the changing method of the DB2 database of x86 platform, it is characterized in that: step is as follows:
(1) on two x86 platforms, install DB2 and BCP software respectively, two x86 platforms configure the IP of two different segments respectively, are used as public network IP and private network IP; Creation database also configures HADR, starts BCP service;
(2) decompress(ion) BCP installation kit under windows environment, opens the administrative client of BCP, logs in any x86 platform, creates cluster, resource group, resource;
(3) cluster that BCP administrative client creates is uploaded in two x86 platforms, and start cluster;
(4) after starting cluster, all resources in cluster all can give tacit consent to startup on the primary node, host node response user request, and BCP monitors the resource of all establishments in main platform and the state of monitoring resource; If resource breaks down, after BCP software detection breaks down to resource, can automatically switch, by all resource switch on host node in slave node, slave node, by all business on this platform of adapter, realizes detection and the switching of fault, ensures the continuity of business.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510533592.8A CN105227394A (en) | 2015-08-27 | 2015-08-27 | A kind of fault detect of the DB2 database based on x86 platform and changing method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510533592.8A CN105227394A (en) | 2015-08-27 | 2015-08-27 | A kind of fault detect of the DB2 database based on x86 platform and changing method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105227394A true CN105227394A (en) | 2016-01-06 |
Family
ID=54996104
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510533592.8A Pending CN105227394A (en) | 2015-08-27 | 2015-08-27 | A kind of fault detect of the DB2 database based on x86 platform and changing method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105227394A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109039741A (en) * | 2018-08-02 | 2018-12-18 | 郑州云海信息技术有限公司 | A kind of method and system for realizing sea of clouds management platform High Availabitity |
| CN109474465A (en) * | 2018-11-13 | 2019-03-15 | 上海英方软件股份有限公司 | A kind of method and system of the high availability that can dynamically circulate based on server cluster |
| CN112380056A (en) * | 2020-11-10 | 2021-02-19 | 上海许继电气有限公司 | Master-slave backup method and device for database of information-guaranteeing master station |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104486131A (en) * | 2014-12-29 | 2015-04-01 | 浪潮电子信息产业股份有限公司 | DB2 database fault detecting and switching method based on Itanium platform |
-
2015
- 2015-08-27 CN CN201510533592.8A patent/CN105227394A/en active Pending
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104486131A (en) * | 2014-12-29 | 2015-04-01 | 浪潮电子信息产业股份有限公司 | DB2 database fault detecting and switching method based on Itanium platform |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109039741A (en) * | 2018-08-02 | 2018-12-18 | 郑州云海信息技术有限公司 | A kind of method and system for realizing sea of clouds management platform High Availabitity |
| CN109474465A (en) * | 2018-11-13 | 2019-03-15 | 上海英方软件股份有限公司 | A kind of method and system of the high availability that can dynamically circulate based on server cluster |
| CN112380056A (en) * | 2020-11-10 | 2021-02-19 | 上海许继电气有限公司 | Master-slave backup method and device for database of information-guaranteeing master station |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106331098B (en) | Server cluster system | |
| US9971660B2 (en) | Virtual machine network loss detection and recovery for high availability | |
| CN104486131B (en) | A kind of fault detect of DB2 database based on Itanium platform and switching method | |
| US8230256B1 (en) | Method and apparatus for achieving high availability for an application in a computer cluster | |
| US8521703B2 (en) | Multiple node/virtual input/output (I/O) server (VIOS) failure recovery in clustered partition mobility | |
| US9450700B1 (en) | Efficient network fleet monitoring | |
| US8910172B2 (en) | Application resource switchover systems and methods | |
| CN106850260A (en) | A kind of dispositions method and device of virtual resources management platform | |
| US9582559B1 (en) | Multi-site storage system with replicated file system synchronization utilizing virtual block storage appliances | |
| CN104408071A (en) | Distributive database high-availability method and system based on cluster manager | |
| CN102394774A (en) | Service state monitoring and failure recovery method for controllers of cloud computing operating system | |
| US20110225095A1 (en) | System and method to define, visualize and manage a composite service group in a high-availability disaster recovery environment | |
| CN113656147B (en) | Cluster deployment method, device, equipment and storage medium | |
| US9442811B2 (en) | Emulating a stretched storage device using a shared replicated storage device | |
| Celesti et al. | A watchdog service making container-based micro-services reliable in IoT clouds | |
| CN104484243B (en) | A kind of highly reliable system and device and method of virtual machine fault-toleranr technique and the combination of high-availability cluster technology | |
| CN104579791A (en) | Method for achieving automatic K-DB main and standby disaster recovery cluster switching | |
| CN111949444A (en) | Data backup and recovery system and method based on distributed service cluster | |
| US9678838B2 (en) | Protecting virtual machines from network failures | |
| CN105227394A (en) | A kind of fault detect of the DB2 database based on x86 platform and changing method | |
| CN112506702A (en) | Data center disaster tolerance method, device, equipment and storage medium | |
| CN116302352A (en) | Cluster disaster recovery processing method and device, electronic equipment and storage medium | |
| CN106612314A (en) | System for realizing software-defined storage based on virtual machine | |
| CN107402839B (en) | Method and system for backing up data | |
| CN103973478A (en) | Disaster preparation system and disaster preparation method for power grid information based on resource pool technology |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20160106 |
|
| RJ01 | Rejection of invention patent application after publication |