CN104486131B - A kind of fault detect of DB2 database based on Itanium platform and switching method - Google Patents
A kind of fault detect of DB2 database based on Itanium platform and switching method Download PDFInfo
- Publication number
- CN104486131B CN104486131B CN201410831800.8A CN201410831800A CN104486131B CN 104486131 B CN104486131 B CN 104486131B CN 201410831800 A CN201410831800 A CN 201410831800A CN 104486131 B CN104486131 B CN 104486131B
- Authority
- CN
- China
- Prior art keywords
- resource
- bcp
- node
- database
- fault detect
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 29
- 238000012544 monitoring process Methods 0.000 claims abstract description 6
- 230000008569 process Effects 0.000 claims abstract description 6
- 230000001360 synchronised effect Effects 0.000 claims description 6
- 230000004044 response Effects 0.000 claims description 3
- 238000001514 detection method Methods 0.000 abstract description 4
- 230000007246 mechanism Effects 0.000 description 6
- 238000005516 engineering process Methods 0.000 description 4
- 230000000694 effects Effects 0.000 description 2
- 230000004913 activation Effects 0.000 description 1
- 230000004888 barrier function Effects 0.000 description 1
- 230000001419 dependent effect Effects 0.000 description 1
- 230000002045 lasting effect Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
Landscapes
- Hardware Redundancy (AREA)
Abstract
The invention discloses a kind of fault detect of DB2 database based on Itanium platform and switching method, belong to the fault detection technique field of database, methods described employs the method that BCP softwares are combined with DB2 database in the two-node cluster hot backup based on Itanium platform, realizes fault detect and switching；The uniformity of data in two-shipper is realized by the HADR characteristics of DB2 database；Related software and hardware resources are created by BCP softwares, realize the fault detect and switching to hardware environment.The present invention, by monitoring of the monitoring realization of the associated process to DB2 database to DB2 database, ensures the normal operation of database, ensures that business continuity is reliable by using tide BCP softwares.
Description
Technical field
It is specifically a kind of based on Itanium platform the present invention relates to a kind of fault detection technique field of database
The fault detect of DB2 database and switching method.
Background technology
Itanium platform is the platform based on Itanium processor hardware structure.Itanium processor is the bit of Intel's first item 64
Product, there is the registers of 64-bit addressing ability and 64 bit wides, thus we it be referred to as 64 bit CPUs.Due to being sought with 64
Location ability, it can use 1,000,000 TB address space, it is sufficient to computing enterprise-level or ultra-large database tasks；64
Wide register can make CPU floating-point operations reach very high precision.In fact IA--64 processors also have dominant concurrency,
Characteristic, these technologies such as branch prediction, congenial loading all design for top, enterprise-level server and work station, instruct
Level concurrency can promote the software instruction structure optimized, more refer to so as to enable a processor to perform in same time
Order.
With the continuous propulsion of informatization, the activity of each enterprises and institutions is more and more dependent on its key
Operating information system, operation and development of these operating information systems to whole mechanism play vital effect, once hair
Raw delay machine failure or application shutdown, huge economic loss will be brought to mechanism.It can be seen that to those needs ensure information safety and
For the mechanism for providing continual information service, the fault-tolerance and continuity of operation system are particularly important.How to protect
Hinder the various lasting operations of crucial application, reach sustainable benign cycle, it has also become current enterprises and institutions and IT fields
It is badly in need of the key issue solved.
Assemble the BCP of tide technology elite（Business continuity protection, business continuity protection）It is soft
Part is a professional high-availability cluster software product (rather than just a two-node cluster hot backup software), and it can be provided for you
Complete high-availability solution on Windows and Linux platforms.When some node in cluster is due to software or hard
When part reason breaks down, group system can make whole on the resource switch such as IP, client traffic to other healthy nodes
Individual system continuously continual can externally provide service, so as to provide reliable guarantor for mechanism 24x365 key business
Barrier, has reached the high availability and reliability of system 99.999%.
DB2 is a series of Relational DBMSs that IBM produces, respectively in different operating system UNIX,
Serviced on Windows Access, ORACLE platforms；Large-scale application system is mainly used in, there is preferable scalability, can
Support from large scale computer to single user environment, applied under the platforms such as OS/2, Windows.DB2 provides high-level data profit
With property, integrality, security, restorability, and the small-scale executive capability for arriving large-scale application program, have with platform without
The basic function and sql command of pass.DB2 employs data staging technology, and large scale computer data can be made easily to download to LAN
Database server so that client/server user and the application program based on LAN can access large scale computer data, and make
Database localizes and remotely connected transparence.DB2 is famous to possess a very complete query optimizer, outside it
Connection improves query performance, and supports multi-task parallel to inquire about.DB2 has good network support ability, each subsystem
Ten tens of thousands of individual distributed users can be connected, thousands of individual active threads can be activated simultaneously, to large-scale distributed application system particularly
It is applicable.
In the production application of reality, two-node cluster hot backup uses very extensive.DB2 database in two-shipper, which can pass through, to be configured
HADR realizes the data syn-chronization on active and standby two machines, ensures the uniformity of data；But when master server breaks down, need
To want corresponding mechanism and be switched to so that applying on standby server so that standby server becomes master server and takes over all services,
But DB2 database does not have corresponding mechanism to realize the switching between active/standby server, although standby host can use.
The content of the invention
The technical assignment of the present invention is to provide a kind of fault detect that can realize active/standby server and be switched fast one
The fault detect of DB2 database of the kind based on Itanium platform and switching method.
The present invention technical assignment realize in the following manner,
A kind of fault detect of DB2 database based on Itanium platform and switching method, in the two-shipper based on Itanium platform
The method that BCP softwares are combined with DB2 database is employed in hot standby, realizes fault detect and switching；Pass through DB2 database
HADR characteristics realize the uniformity of data in two-shipper；Related software and hardware resources are created by BCP softwares, realized to hardware environment
Fault detect and switching.
HADR is by way of daily record is synchronous, and journal file is synchronized in slave node caused by host node, and slave node leads to
The journal file realization received by synchronization and the data syn-chronization of host node are crossed, realizes data on the business device of two two-node cluster hot backups
Uniformity.
BCP software establishing resource groups, resource are included in resource group, the content included to resource is monitored；If occur
Failure, BCP softwares realize switching automatically, by all resource switch to other enabled node, realize High Availabitity, ensure business
Continuity.
Resource in resource group includes Floating IP address resource, Lv resources, application resource, script resource.
A kind of fault detect of DB2 database based on Itanium platform and switching method, detailed step include：
（1）, two nodes in the two-node cluster hot backup of Itanium platform KUX systems on, install respectively DB2 database and
BCP softwares；
（2）, two nodes are respectively configured with the IP address of two different segments, with being used as public network IP address and private network IP
Location, two nodes are divided into host node and slave node；
（3）, create DB2 database, and configure HADR, start BCP software services；
（4）, in the environment of windows operating systems decompress BCP software installation bags, open BCP softwares managing customer
ClusterManager.jar files are held, log in any one node, create the resource in cluster, resource group and resource group；
（5）, the cluster that the management clients of BCP softwares creates uploaded in the server of two two-node cluster hot backups, and open
Dynamic cluster；
（6）, start cluster after, all resources in cluster acquiescence starts on the primary node, host node response user's request；
（7）, the resource of all establishments and monitor the state of resource in BCP software supervision host nodes；
（8）If, resource break down, after BCP software detections break down to resource, switch over automatically, by host node
On all resource switch into slave node, slave node will take over all business on host node, realize fault detect and switching,
The continuity of guarantee business.
Step（4）In, the resource in resource group is the kernel process db2sysc of DB2 database monitoring resource.
A kind of fault detect of DB2 database based on Itanium platform of the present invention and switching method have advantages below：
1st, the method that BCP is combined with DB2 database is employed, realizes the high availability of database；Can be soft by BCP
Switching when whether part automatic detection DB2 database breaks down and break down；
2nd, BCP softwares can monitor the kernel process of DB2 database in real time, it is ensured that the normal operation of database；Simultaneously
Related hardware and other applications can be monitored as needed, make to ensure the hardware environment that data place is run
Securely and reliably；
3rd, after network environment is put up, BCP softwares can remotely be configured by PC, and check relevant date at any time
Will, realization fast and easily manage；
4th, the prison to DB2 database is realized by the monitoring of the associated process to DB2 database using tide BCP softwares
Control, ensure the normal operation of database, ensure that business continuity is reliable.
Brief description of the drawings
The present invention is further described below in conjunction with the accompanying drawings.
Fig. 1 is fault detect and the FB(flow block) of switching method of a kind of DB2 database based on Itanium platform.
Embodiment
Failure with reference to Figure of description and specific embodiment to a kind of DB2 database based on Itanium platform of the present invention
Detection and switching method are described in detail below.
Embodiment 1：
A kind of fault detect of DB2 database based on Itanium platform of the present invention and switching method, are put down based on Anthem
The method that BCP softwares are combined with DB2 database is employed in the two-node cluster hot backup of platform, realizes fault detect and switching；Pass through DB2
The HADR characteristics of database realize the uniformity of data in two-shipper；Related software and hardware resources are created by BCP softwares, realized to soft
The fault detect and switching of hardware environment.
HADR is by way of daily record is synchronous, and journal file is synchronized in slave node caused by host node, and slave node leads to
The journal file realization received by synchronization and the data syn-chronization of host node are crossed, realizes data on the business device of two two-node cluster hot backups
Uniformity.
BCP software establishing resource groups, resource are included in resource group, the content included to resource is monitored；If occur
Failure, BCP softwares realize switching automatically, by all resource switch to other enabled node, realize High Availabitity, ensure business
Continuity.
Resource in resource group includes Floating IP address resource, Lv resources, application resource, script resource.
Two-node cluster hot backup is refered in particular to based on the hot standby of the two-server in high-availability system（Or High Availabitity）, because of two machine High Availabitities
At home using more, therefore two-node cluster hot backup of gaining the name, two-shipper High Availabitity are divided into by the switching mode in work：Main-standby mode
（Active-Standby modes）With double host modes（Active-Active modes）, main-standby mode is to refer to a service
Device is in the state of activation of certain business（That is Active states）, another server be in the stand-by state of the business（I.e.
Standby states).And double host modes refer to two kinds of different business activestandby state each other on two-server respectively（I.e.
Active-Standby and Standby-Active states）.
Embodiment 2：
A kind of fault detect of DB2 database based on Itanium platform of the present invention and switching method, detailed step include：
（1）, two nodes in the two-node cluster hot backup of Itanium platform KUX systems on, install respectively DB2 database and
BCP softwares；
（2）, two nodes are respectively configured with the IP address of two different segments, with being used as public network IP address and private network IP
Location, two nodes are divided into host node and slave node；
（3）, create DB2 database, and configure HADR, start BCP software services；
（4）, in the environment of windows operating systems decompress BCP software installation bags, open BCP softwares managing customer
ClusterManager.jar files are held, log in any one node, create the resource in cluster, resource group and resource group；
（5）, the cluster that the management clients of BCP softwares creates uploaded in the server of two two-node cluster hot backups, and open
Dynamic cluster；
（6）, start cluster after, all resources in cluster acquiescence starts on the primary node, host node response user's request；
（7）, the resource of all establishments and monitor the state of resource in BCP software supervision host nodes；
（8）If, resource break down, after BCP software detections break down to resource, switch over automatically, by host node
On all resource switch into slave node, slave node will take over all business on host node, realize fault detect and switching,
The continuity of guarantee business.
Step（4）In, the resource in resource group is the kernel process db2sysc of DB2 database monitoring resource.
By embodiment above, the those skilled in the art can readily realize the present invention.But should
Work as understanding, the present invention is not limited to above-mentioned embodiment.On the basis of disclosed embodiment, the technical field
Technical staff can be combined different technical characteristics, so as to realize different technical schemes.
Claims (5)
1. fault detect and the switching method of a kind of DB2 database based on Itanium platform, it is characterised in that put down based on Anthem
The method that BCP softwares are combined with DB2 database is employed in the two-node cluster hot backup of platform, realizes fault detect and switching；Pass through DB2
The HADR characteristics of database realize the uniformity of data in two-shipper；Related software and hardware resources are created by BCP softwares, realized to soft
The fault detect and switching of hardware environment；
Detailed step includes：
（1）, two nodes in the two-node cluster hot backup of Itanium platform KUX systems on, DB2 database is installed respectively and BCP is soft
Part；
（2）, two nodes are respectively configured with the IP address of two different segments, be used as public network IP address and private network IP address, two
Individual node is divided into host node and slave node；
（3）, create DB2 database, and configure HADR, start BCP software services；
（4）, in the environment of windows operating systems decompress BCP software installation bags, open BCP softwares management client
ClusterManager.jar files, any one node is logged in, create the resource in cluster, resource group and resource group；
（5）, the cluster that the management clients of BCP softwares creates uploaded in the server of two two-node cluster hot backups, and start collection
Group；
（6）, start cluster after, all resources in cluster acquiescence starts on the primary node, host node response user's request；
（7）, the resource of all establishments and monitor the state of resource in BCP software supervision host nodes；
（8）If, resource break down, after BCP software detections break down to resource, switch over automatically, by host node
For all resource switch into slave node, slave node will take over all business on host node, realize fault detect and switching.
2. fault detect and the switching method of a kind of DB2 database based on Itanium platform according to claim 1, it is special
Sign is HADR by way of daily record is synchronous, and journal file is synchronized in slave node caused by host node, and slave node passes through
Journal file received by synchronization realizes the data syn-chronization with host node, realizes one of data on the business device of two two-node cluster hot backups
Cause property.
3. fault detect and the switching method of a kind of DB2 database based on Itanium platform according to claim 1, it is special
Sign is BCP software establishing resource groups, includes resource in resource group, the content included to resource is monitored；If generation event
Barrier, BCP softwares realize switching automatically, by all resource switch to another enabled node.
4. fault detect and the switching method of a kind of DB2 database based on Itanium platform according to claim 3, it is special
Sign is that the resource in resource group includes Floating IP address resource, Lv resources, application resource, script resource.
5. fault detect and the switching method of a kind of DB2 database based on Itanium platform according to claim 1, it is special
Sign is step（4）In, the resource in resource group is the kernel process db2sysc of DB2 database monitoring resource.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410831800.8A CN104486131B (en) | 2014-12-29 | 2014-12-29 | A kind of fault detect of DB2 database based on Itanium platform and switching method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410831800.8A CN104486131B (en) | 2014-12-29 | 2014-12-29 | A kind of fault detect of DB2 database based on Itanium platform and switching method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104486131A CN104486131A (en) | 2015-04-01 |
| CN104486131B true CN104486131B (en) | 2018-01-09 |
Family
ID=52760639
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410831800.8A Active CN104486131B (en) | 2014-12-29 | 2014-12-29 | A kind of fault detect of DB2 database based on Itanium platform and switching method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104486131B (en) |
Families Citing this family (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105119745A (en) * | 2015-08-19 | 2015-12-02 | 浪潮(北京)电子信息产业有限公司 | Method and system for improving availability of DB2 DPF |
| CN105227394A (en) * | 2015-08-27 | 2016-01-06 | 浪潮电子信息产业股份有限公司 | DB2 database fault detection and switching method based on x86 platform |
| CN105183591A (en) * | 2015-09-07 | 2015-12-23 | 浪潮(北京)电子信息产业有限公司 | High-availability cluster implementation method and system |
| CN105354332A (en) * | 2015-12-04 | 2016-02-24 | 浪潮(北京)电子信息产业有限公司 | Method and system for implementing mutual standby of database and middleware based on BCP (Batch Communications Program) |
| CN108762999A (en) * | 2018-05-23 | 2018-11-06 | 郑州云海信息技术有限公司 | A kind of kernel failure collection method and device |
| 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 |
| CN111241200B (en) * | 2020-01-10 | 2024-02-20 | 浙江华创视讯科技有限公司 | Master-slave synchronous processing method and device based on SQLite database |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103246522A (en) * | 2013-05-28 | 2013-08-14 | 浪潮电子信息产业股份有限公司 | Fast building method for hot standby environment based on virtualization platform |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2007000765A2 (en) * | 2005-06-27 | 2007-01-04 | Marwan Zeibak | Apparatus and method for evaluating data points against cadastral regulations |
-
2014
- 2014-12-29 CN CN201410831800.8A patent/CN104486131B/en active Active
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103246522A (en) * | 2013-05-28 | 2013-08-14 | 浪潮电子信息产业股份有限公司 | Fast building method for hot standby environment based on virtualization platform |
Non-Patent Citations (1)
| Title |
|---|
| 用DB2 9.5 实现高可用性;Monty Wright;《https://www.ibm.com /developerworks/cn/data/library/ techarticles/ dm-0807wright/index. html》;20081111;正文第3-11页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104486131A (en) | 2015-04-01 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104486131B (en) | A kind of fault detect of DB2 database based on Itanium platform and switching method | |
| US20230153210A1 (en) | Application migration between environments | |
| US8230256B1 (en) | Method and apparatus for achieving high availability for an application in a computer cluster | |
| US10114834B2 (en) | Exogenous virtual machine synchronization and replication | |
| CN107707393B (en) | Multi-active system based on Openstack O version characteristics | |
| US10089307B2 (en) | Scalable distributed data store | |
| US8521703B2 (en) | Multiple node/virtual input/output (I/O) server (VIOS) failure recovery in clustered partition mobility | |
| US9747179B2 (en) | Data management agent for selective storage re-caching | |
| CN102833310B (en) | Workflow engine trunking system based on virtualization technology | |
| US10394670B2 (en) | High availability and disaster recovery system architecture | |
| JP2011530127A (en) | Method and system for maintaining data integrity between multiple data servers across a data center | |
| US9442811B2 (en) | Emulating a stretched storage device using a shared replicated storage device | |
| CN104660386A (en) | Method for improving DB2 disaster recovery high availability based on Itanium platform | |
| CN104184837A (en) | High-availability cloud computing all-in-one machine | |
| CN103902401A (en) | Virtual machine fault tolerance method and device based on monitoring | |
| CN103973478A (en) | Disaster preparation system and disaster preparation method for power grid information based on resource pool technology | |
| CN105227394A (en) | DB2 database fault detection and switching method based on x86 platform | |
| Adeshiyan et al. | Using virtualization for high availability and disaster recovery | |
| Wang et al. | Application of server virtualization technology based on citrix xenserver in the information center of the public security bureau and fire service department | |
| Peng et al. | UCloudStack-A Private Cloud Platform for Lightweight Delivery | |
| Calzolari et al. | High availability using virtualization | |
| CN109995560A (en) | Cloud resource pond management system and method | |
| Salapura et al. | Enabling enterprise-level workloads in the enterprise-class cloud | |
| US20240289309A1 (en) | Error deduplication and reporting for a data management system based on natural language processing of error messages | |
| Brady | Designing GIS for high availability and high performance |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |