CN103744743A - Heartbeat signal redundant configuration method based on RAC model of database - Google Patents
Heartbeat signal redundant configuration method based on RAC model of database Download PDFInfo
- Publication number
- CN103744743A CN103744743A CN201410022220.4A CN201410022220A CN103744743A CN 103744743 A CN103744743 A CN 103744743A CN 201410022220 A CN201410022220 A CN 201410022220A CN 103744743 A CN103744743 A CN 103744743A
- Authority
- CN
- China
- Prior art keywords
- database
- heartbeat
- rac
- network
- eth1
- 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 provides a heartbeat signal redundant configuration method based on the RAC model of database. The heartbeat signal redundant configuration method includes: plugging in and pulling out network cables of a heartbeat network in sequence; checking parameters of a system such as log information of messages, log information of ocssd database, log information of crsd database and the like in the system; ensuring the stability of the heartbeat network by combining operation processes with information to deduce whether the function of the RAC model of oracle database can achieve or not. Compared with the prior art, the problem of storage fragmentation based on a file system can be solved and sub-second retrieval of video data can be supported by the heartbeat signal redundant configuration method based on the RAC model of database. The heartbeat signal redundant configuration method has the advantages of being good in practicality and easy to promote.
Description
Technical field
The present invention relates to computer cluster technology field, specifically a kind of method of the redundant configuration based on database RAC pattern heartbeat signal.
Background technology
RAC, full name real application clusters, is translated into " Real Application Clusters ", is the new technology adopting in Oracle new edition database, is the one of high availability, is also the core technology that oracle database is supported grid computing environment.Under Oracle RAC environment, integrated clustered software and the storage management software of providing of Oracle, for user has reduced application cost.When application scale need to expand, user is expanding system as required, to guarantee the performance of system.RAC pattern has possessed advantage:
1, multinode load balancing;
2, provide high available: failure tolerant and seamless handover function, the impact that hardware and software mistake is caused minimizes;
3, by executed in parallel technology, improve the transaction response time----be generally used for data analysis system;
4, by raising extending transversely number of deals per second and linking number----conventionally for online transaction system;
5, save hardware cost, can, with multiple cheap PC server generations for expensive minicomputer or large scale computer, save corresponding maintenance cost simultaneously;
6, extensibility is good, can conveniently add deletion of node, development hardware resource.
Just because of RAC pattern has possessed more advantage, so it be widely used existing cluster in the middle of, but because the hardware environment of integrated level and cluster is comparatively complicated, thus urgently propose a kind of comparatively comprehensively, method of testing is verified integrality and the accuracy of clustered deploy(ment) efficiently.
A kind of method of testing of the redundancy heartbeat signal based on database RAC pattern, it is exactly the special a kind of method of testing formulated of RAC cluster for existing oracle database, by this test process, can confirm that whether the setting that this cluster does for hardware view and software view when disposing is correct, whether can realize the operation of due do in order to guarantee that data-base cluster can stability and high efficiency.
Summary of the invention
Technical assignment of the present invention is to solve the deficiencies in the prior art, and a kind of method of the redundant configuration based on database RAC pattern heartbeat signal is provided.
Technical scheme of the present invention realizes in the following manner, the method for this kind of redundant configuration based on database RAC pattern heartbeat signal, and its specific implementation process is:
One, architecture is set:
Two high-end servers that oracle database has been installed are set, and these two databases are configured to RAC pattern, and difference called after database 1 and database 2;
One connects the monitoring server of two-server main process equipment simultaneously, needs the log information of record in monitoring and mobile phone test process;
By naked disk, shine upon respectively the voting dish to two databases;
The heartbeat network switch being connected with the heartbeat network adapter of two high-end server main frames by heartbeat netting twine, wherein two heartbeat network adapter of every host configuration, called after eth1 and eth2 respectively, and carry out bond and bind active-standby mode, by eth1, be major network mouth, eth2 is standby network interface;
Two, pull out the heartbeat eth1 of database 2, verify the whether success of binding of this heartbeat network, whether heartbeat signal occurs to switch action and guarantee that database RAC cluster can normally work normally; If database heartbeat is switched to eth2, database is normal;
Three, turn back to the heartbeat eth1 of database 2, then pull out eth2 heartbeat, whether validation database heartbeat can carry out normal switching mutually, if connecting, recovers on eth1 heartbeat network, pull out after eth2 heartbeat network, eth1 heartbeat network activation, system and database normally move;
Four, pull out two radical center wire jumper eth1 and eth2 of database 2 simultaneously, database 2 and the heartbeat network of database 1 are interrupted, whether the mechanism of checking RAC arranges normally, and confirm whether normal system journal and database journal record, if now database 2 is restarted after waiting for one minute, the arbitration dish of database can send failure warning, and the relevant information of system journal and database journal record is normal.
Described heartbeat network adapter refers to gigabit, 10,000,000,000 or IB network interface card.
The beneficial effect that the present invention compared with prior art produced is:
The method of a kind of redundant configuration based on database RAC pattern heartbeat signal of the present invention is by plugging in a certain order heartbeat network, and recording-related information, by the RAC pattern of record operation steps and corresponding informance being come to specified data storehouse, whether set correctly; Make hardware Physical layer and software application layer can guarantee the realization of highly redundant framework, thereby greatly improved stability, the redundancy of system; Server hardware manufacturer, database development manufacturer and system integration manufacturer have effectively been solved, the demand to machine stable operation in project in integrated and test development process; The investigation that can carry out at the project initial stage problem by this invention, also greatly reduces the risk after cluster is applied just; Applied widely, not only for the test of the binding of hardware network interface card, or the test to whole database RAC cluster, to operating system stability and compatible test, practical, be easy to popularization.
Accompanying drawing explanation
Accompanying drawing 1 is grid topological diagram of the present invention.
Accompanying drawing 2 is bond binding topological diagram of the present invention.
Embodiment
Below in conjunction with accompanying drawing, the method for a kind of redundant configuration based on database RAC pattern heartbeat signal of the present invention is described in detail below.
As shown in accompanying drawing 1, Fig. 2, a kind of method of the redundant configuration based on database RAC pattern heartbeat signal, first be the netting twine by plugging in certain sequence heartbeat network, and under system, check the correlation parameters such as the messages log information, database ocssd log information, database crsd log information of system.By the combination of operation steps and information, determine the stability of heartbeat network, thereby infer whether the RAC pattern of this oracle database realizes its function.Its specific implementation process is:
One, architecture is set:
Two high-end servers that oracle database has been installed are set, and these two databases are configured to RAC pattern, and difference called after database 1 and database 2;
One connects the monitoring server of two-server main process equipment simultaneously, needs the log information of record in monitoring and mobile phone test process;
By naked disk, shine upon respectively the voting dish to two databases;
The heartbeat network switch being connected with the heartbeat network adapter of two high-end server main frames by heartbeat netting twine, wherein two heartbeat network adapter of every host configuration, called after eth1 and eth2 respectively, and carry out bond and bind active-standby mode, by eth1, be major network mouth, eth2 is standby network interface.
Bond heartbeat binding situation before operation:
Bonding?Mode:?fault-tolerance?(active-backup)
Primary?Slave:?None
Currently?Active?Slave:?eth1
MII?Status:?up
MII?Polling?Interval?(ms):?100
Up?Delay?(ms):?0
Down?Delay?(ms):?0
Slave?Interface:?eth1
MII?Status:?up
Link?Failure?Count:?0
Permanent?HW?addr:?00:e0:ed:1f:de:1e
Slave?Interface:?eth2
MII?Status:?up
Link?Failure?Count:?0
Permanent?HW?addr:?00:e0:ed:27:87:ca
Pull out the heartbeat eth1 of database 2.
Object: can normally work in order to ensure database RAC cluster, heartbeat network is the redundant mode by two heartbeat network adapter ports are bound.So, by pulling out the heartbeat of wherein, can verify the whether success of binding of this heartbeat network, whether heartbeat signal occurs to switch action and guarantee that database RAC cluster can normally work normally.
Normal phenomenon and result: database heartbeat is switched to eth2, and database is normal.
The present mode of normal bond:
Bonding?Mode:?fault-tolerance?(active-backup)
Primary?Slave:?None
Currently?Active?Slave:?eth2
MII?Status:?up
MII?Polling?Interval?(ms):?100
Up?Delay?(ms):?0
Down?Delay?(ms):?0
Slave?Interface:?eth1
MII?Status:?down
Link?Failure?Count:?1
Permanent?HW?addr:?00:e0:ed:1f:de:1e
Slave?Interface:?eth2
MII?Status:?up
Link?Failure?Count:?0
Permanent?HW?addr:?00:e0:ed:27:87:ca
Operation steps: turn back to the heartbeat eth1 of database 2, then pull out eth2 heartbeat.
Object: by this operation, whether bond0 pattern that can validation database heartbeat can carry out switching mutually normally, to guarantee any interruption of wire jumper in fundamental disagreement in bond0, can not affect system and database moves normally.
Normal phenomenon and result: while turning back to eth1, eth1 heartbeat network connects recovery, and heartbeat master network is also on eth2; Pull out after eth2 heartbeat network, eth1 heartbeat network activation, system and database normally move.
The present mode of normal bond:
Bonding?Mode:?fault-tolerance?(active-backup)
Primary?Slave:?None
Currently?Active?Slave:?eth1
MII?Status:?up
MII?Polling?Interval?(ms):?100
Up?Delay?(ms):?0
Down?Delay?(ms):?0
Slave?Interface:?eth1
MII?Status:?up
Link?Failure?Count:?0
Permanent?HW?addr:?00:e0:ed:1f:de:1e
Slave?Interface:?eth2
MII?Status:?down
Link?Failure?Count:?1
Permanent?HW?addr:?00:e0:ed:27:87:ca
Operation steps: two radical center wire jumper eth1 and the eth2 that simultaneously pull out database 2.
Object: by the method, database 2 and the heartbeat network of database 1 are interrupted, whether the mechanism of checking RAC arranges normally, and confirm whether normal system journal and database journal record.
Normal phenomenon and result: database 2 is restarted after waiting for one minute, because database heartbeat is all interrupted, the arbitration dish of database can send failure warning.So database 1 can send and allow the order of restarting from node database 2 detecting one minute and after not recovering heartbeat signal, thereby causes database 2 to restart phenomenon, the generation of this phenomenon is normal.The relevant information record of system journal and database journal is normal.
The above; only for preferably embodiment of the present invention, but protection scope of the present invention is not limited to this, is anyly familiar with in technical scope that those skilled in the art disclose in the present invention; the variation that can expect easily or replacement, within all should being encompassed in protection scope of the present invention.Therefore, protection scope of the present invention should be as the criterion with the protection domain of claim.
Claims (2)
1. a method for the redundant configuration based on database RAC pattern heartbeat signal, is characterized in that its specific implementation process is:
One, architecture is set:
Two high-end servers that oracle database has been installed are set, and these two databases are configured to RAC pattern, and difference called after database 1 and database 2;
One connects the monitoring server of two-server main process equipment simultaneously, needs the log information of record in monitoring and mobile phone test process;
By naked disk, shine upon respectively the voting dish to two databases;
The heartbeat network switch being connected with the heartbeat network adapter of two high-end server main frames by heartbeat netting twine, wherein two heartbeat network adapter of every host configuration, called after eth1 and eth2 respectively, and carry out bond and bind active-standby mode, by eth1, be major network mouth, eth2 is standby network interface;
Two, pull out the heartbeat eth1 of database 2, verify the whether success of binding of this heartbeat network, whether heartbeat signal occurs to switch action and guarantee that database RAC cluster can normally work normally; If database heartbeat is switched to eth2, database is normal;
Three, turn back to the heartbeat eth1 of database 2, then pull out eth2 heartbeat, whether validation database heartbeat can carry out normal switching mutually, if connecting, recovers on eth1 heartbeat network, pull out after eth2 heartbeat network, eth1 heartbeat network activation, system and database normally move;
Four, pull out two radical center wire jumper eth1 and eth2 of database 2 simultaneously, database 2 and the heartbeat network of database 1 are interrupted, whether the mechanism of checking RAC arranges normally, and confirm whether normal system journal and database journal record, if now database 2 is restarted after waiting for one minute, the arbitration dish of database can send failure warning, and the relevant information of system journal and database journal record is normal.
2. the method for a kind of redundant configuration based on database RAC pattern heartbeat signal according to claim 1, is characterized in that: described heartbeat network adapter refers to gigabit, 10,000,000,000 or IB network interface card.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410022220.4A CN103744743A (en) | 2014-01-17 | 2014-01-17 | Heartbeat signal redundant configuration method based on RAC model of database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410022220.4A CN103744743A (en) | 2014-01-17 | 2014-01-17 | Heartbeat signal redundant configuration method based on RAC model of database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103744743A true CN103744743A (en) | 2014-04-23 |
Family
ID=50501763
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410022220.4A Pending CN103744743A (en) | 2014-01-17 | 2014-01-17 | Heartbeat signal redundant configuration method based on RAC model of database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103744743A (en) |
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104486128A (en) * | 2014-12-23 | 2015-04-01 | 浪潮(北京)电子信息产业有限公司 | System and method for realizing redundant heartbeat between nodes of double-controller |
| CN104503871A (en) * | 2014-12-29 | 2015-04-08 | 浪潮电子信息产业股份有限公司 | Implementation method based on full-redundancy model of small computer system |
| CN104639637A (en) * | 2015-02-09 | 2015-05-20 | 浪潮电子信息产业股份有限公司 | Double heartbeat line method on NF5240M3 |
| CN104852969A (en) * | 2015-04-24 | 2015-08-19 | 昆明船舶设备集团有限公司 | Highly reliable RAC and HANS system fusion |
| CN104965741A (en) * | 2015-06-30 | 2015-10-07 | 浪潮(北京)电子信息产业有限公司 | Method and apparatus for installing real-time application clusters |
| CN105227885A (en) * | 2015-09-10 | 2016-01-06 | 上海开圣影视文化传媒有限公司 | A kind of production of film and TV data-storage system based on HA cluster |
| CN105843713A (en) * | 2016-04-01 | 2016-08-10 | 杭州沃趣网络科技有限公司 | Method for realizing Oracle RAC (real application cluster) through shared-nothing storage of dual system |
| CN106255960A (en) * | 2015-04-02 | 2016-12-21 | 三菱电机株式会社 | Redundant system and communication unit |
| CN106919477A (en) * | 2017-03-03 | 2017-07-04 | 上海爱数信息技术股份有限公司 | The analytic method and system of a kind of virtual disk |
| CN107968734A (en) * | 2017-11-29 | 2018-04-27 | 郑州云海信息技术有限公司 | A kind of method of the automatic test Network Packet Loss performance under network card binding pattern |
| CN108897645A (en) * | 2018-06-12 | 2018-11-27 | 郑州云海信息技术有限公司 | A kind of data-base cluster disaster recovery method and system based on spare heartbeat disk |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060117074A1 (en) * | 2004-11-30 | 2006-06-01 | Ezzat Ahmed K | Method and apparatus for database cluster recovery |
| CN101226397A (en) * | 2008-02-04 | 2008-07-23 | 南京理工大学 | High reliability distributed Ethernet test control system |
| CN101505306A (en) * | 2009-03-23 | 2009-08-12 | 烽火通信科技股份有限公司 | Inter-node reliable communication method in distributed system |
| CN102014029A (en) * | 2010-12-25 | 2011-04-13 | 中国人民解放军国防科学技术大学 | Method for detecting abnormal conditions of external service network in dual active |
| CN103023973A (en) * | 2012-11-19 | 2013-04-03 | 浪潮电子信息产业股份有限公司 | Cluster server designing method based on CPCI (Compact Peripheral Component Interconnect) structure |
-
2014
- 2014-01-17 CN CN201410022220.4A patent/CN103744743A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060117074A1 (en) * | 2004-11-30 | 2006-06-01 | Ezzat Ahmed K | Method and apparatus for database cluster recovery |
| CN101226397A (en) * | 2008-02-04 | 2008-07-23 | 南京理工大学 | High reliability distributed Ethernet test control system |
| CN101505306A (en) * | 2009-03-23 | 2009-08-12 | 烽火通信科技股份有限公司 | Inter-node reliable communication method in distributed system |
| CN102014029A (en) * | 2010-12-25 | 2011-04-13 | 中国人民解放军国防科学技术大学 | Method for detecting abnormal conditions of external service network in dual active |
| CN103023973A (en) * | 2012-11-19 | 2013-04-03 | 浪潮电子信息产业股份有限公司 | Cluster server designing method based on CPCI (Compact Peripheral Component Interconnect) structure |
Non-Patent Citations (2)
| Title |
|---|
| TOLYWANG: "《Oralcle 10g RAC 修改心跳为绑定网卡(设置冗余)》", 《HTTP://BLOG.ITPUB.NET/35489/VIEWSPACE-695781/》 * |
| 潘伟: "基于Oracle 10g数据库系统高可用性框架研究与设计", 《中国优秀硕士学位论文全文数据库信息科技辑》 * |
Cited By (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104486128B (en) * | 2014-12-23 | 2018-07-17 | 浪潮(北京)电子信息产业有限公司 | A kind of system and method for realizing redundancy heartbeat between dual controller node |
| CN104486128A (en) * | 2014-12-23 | 2015-04-01 | 浪潮(北京)电子信息产业有限公司 | System and method for realizing redundant heartbeat between nodes of double-controller |
| CN104503871A (en) * | 2014-12-29 | 2015-04-08 | 浪潮电子信息产业股份有限公司 | Implementation method based on full-redundancy model of small computer system |
| CN104639637A (en) * | 2015-02-09 | 2015-05-20 | 浪潮电子信息产业股份有限公司 | Double heartbeat line method on NF5240M3 |
| CN106255960A (en) * | 2015-04-02 | 2016-12-21 | 三菱电机株式会社 | Redundant system and communication unit |
| CN106255960B (en) * | 2015-04-02 | 2018-02-09 | 三菱电机株式会社 | redundant system and communication unit |
| CN104852969A (en) * | 2015-04-24 | 2015-08-19 | 昆明船舶设备集团有限公司 | Highly reliable RAC and HANS system fusion |
| CN104965741A (en) * | 2015-06-30 | 2015-10-07 | 浪潮(北京)电子信息产业有限公司 | Method and apparatus for installing real-time application clusters |
| CN105227885A (en) * | 2015-09-10 | 2016-01-06 | 上海开圣影视文化传媒有限公司 | A kind of production of film and TV data-storage system based on HA cluster |
| CN105843713A (en) * | 2016-04-01 | 2016-08-10 | 杭州沃趣网络科技有限公司 | Method for realizing Oracle RAC (real application cluster) through shared-nothing storage of dual system |
| CN105843713B (en) * | 2016-04-01 | 2019-06-28 | 杭州沃趣科技股份有限公司 | A kind of method that dual systems realizes Oracle RAC without shared storage |
| CN106919477A (en) * | 2017-03-03 | 2017-07-04 | 上海爱数信息技术股份有限公司 | The analytic method and system of a kind of virtual disk |
| CN106919477B (en) * | 2017-03-03 | 2020-05-22 | 上海爱数信息技术股份有限公司 | Virtual disk analysis method and system |
| CN107968734A (en) * | 2017-11-29 | 2018-04-27 | 郑州云海信息技术有限公司 | A kind of method of the automatic test Network Packet Loss performance under network card binding pattern |
| CN108897645A (en) * | 2018-06-12 | 2018-11-27 | 郑州云海信息技术有限公司 | A kind of data-base cluster disaster recovery method and system based on spare heartbeat disk |
| CN108897645B (en) * | 2018-06-12 | 2021-07-27 | 郑州云海信息技术有限公司 | Database cluster disaster tolerance method and system based on standby heartbeat disk |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103744743A (en) | Heartbeat signal redundant configuration method based on RAC model of database | |
| CN105589776B (en) | A kind of Fault Locating Method and server | |
| CN104731670B (en) | A kind of rotation formula spaceborne computer tolerant system towards satellite | |
| WO2018103533A1 (en) | Method, device, and equipment for fault handling | |
| AU2016203273A1 (en) | A method for a source storage device sending data to a backup storage device for storage, and storage device | |
| US11573737B2 (en) | Method and apparatus for performing disk management of all flash array server | |
| CN102394914A (en) | Cluster brain-split processing method and device | |
| US9507664B2 (en) | Storage system including a plurality of storage units, a management device, and an information processing apparatus, and method for controlling the storage system | |
| WO2015058711A1 (en) | Rapid fault detection method and device | |
| CN104036043A (en) | High availability method of MYSQL and managing node | |
| CN103257908A (en) | Software and hardware cooperative multi-controller disk array designing method | |
| CN104469699A (en) | Cluster quorum method and multi-cluster cooperation system | |
| CN212541329U (en) | Dual-redundancy computer equipment based on domestic Loongson platform | |
| CN113342261A (en) | Server and control method applied to same | |
| CN102457400B (en) | Method for preventing split brain phenomenon from occurring on distributed replicated block device (DRBD) resource | |
| US11010086B2 (en) | Data synchronization method and out-of-band management device | |
| CN112948484A (en) | Distributed database system and data disaster recovery drilling method | |
| CN109117317A (en) | A kind of clustering fault restoration methods and relevant apparatus | |
| CN109885420B (en) | PCIe link fault analysis method, BMC and storage medium | |
| US11016863B2 (en) | Self-contained disaster detection for replicated multi-controller systems | |
| CN113342593B (en) | Method and apparatus for high availability management of full flash memory array servers | |
| EP4170519A1 (en) | Data synchronization method and device | |
| CN112445652B (en) | Remote copy system | |
| CN113742142B (en) | Method for managing SATA hard disk by storage system and storage system | |
| CN103116474B (en) | A kind of raid card method for designing for data recovery and selfreparing |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20140423 |
|
| WD01 | Invention patent application deemed withdrawn after publication |