CN103744743A - Heartbeat signal redundant configuration method based on RAC model of database - Google Patents

Abstract

The present invention provides a method for redundant configuration of heartbeat signals based on database RAC mode. Firstly, plug and unplug the network cables of the heartbeat network in a certain order, and check the messages log information of the system, the database ocssd log information, and the database crsd log under the system. information and other related parameters. Determine the stability of the heartbeat network through the combination of operation steps and information, so as to infer whether the RAC mode of the oracle database realizes its function. Compared with the prior art, the redundant configuration method based on the heartbeat signal of the database RAC mode avoids the fragmentation problem based on file system storage, and supports second-level retrieval of video data; it has strong practicability and is easy to popularize.

Description

A method of redundant configuration based on heartbeat signal of database RAC mode

technical field

The invention relates to the technical field of computer clusters, in particular to a method for redundant configuration based on a database RAC mode heartbeat signal.

Background technique

RAC, the full name of real application clusters, translated as "real-time application clusters", is a new technology adopted in the new version of Oracle database. It is a kind of high availability and the core technology for Oracle database to support grid computing environment. In the Oracle RAC environment, Oracle integration provides cluster software and storage management software, which reduces application costs for users. When the application scale needs to be expanded, the user can expand the system on demand to ensure the performance of the system. The RAC mode has the following advantages:

1. Multi-node load balancing;

2. Provide high availability: fault tolerance and seamless switching functions to minimize the impact of hardware and software errors;

3. Improve transaction response time through parallel execution technology - usually used in data analysis systems;

4. Increase the number of transactions and connections per second through horizontal expansion - usually for online transaction systems;

5. Save hardware costs, you can use multiple cheap PC servers to replace expensive minicomputers or mainframes, and save corresponding maintenance costs at the same time;

6. Good scalability, can easily add and delete nodes, expand hardware resources.

Because the RAC mode has many advantages, it is widely used in the existing clusters. However, due to the complexity of the integration and the hardware environment of the cluster, it is urgent to propose a more comprehensive and efficient testing method. To verify the integrity and accuracy of the cluster deployment.

A test method for redundant heartbeat signals based on the database RAC mode is a test method specially formulated for the RAC cluster of the existing oracle database. Through this test process, it can be confirmed that the cluster is deployed at the hardware level and software level Whether the settings are correct and whether they can achieve the desired effect to ensure the stable and efficient operation of the database cluster.

Contents of the invention

The technical task of the present invention is to solve the deficiencies of the prior art, and provide a method for redundant configuration based on the heartbeat signal of the database RAC mode.

The technical solution of the present invention is realized in the following manner, the method for redundant configuration of the heartbeat signal based on the database RAC mode, and its specific implementation process is:

1. Set up the infrastructure:

Set up two high-end servers that have installed the oracle database. The two databases are configured in RAC mode and named database 1 and database 2 respectively;

A monitoring server connected to two server host devices at the same time, the log information that needs to be recorded during monitoring and mobile phone testing;

The voting disks of the two databases are respectively mapped to the raw disks;

A heartbeat network switch connected to the heartbeat network cards of two high-end server hosts through a heartbeat network cable. Each host is configured with two heartbeat network cards, named eth1 and eth2 respectively, and bonded to the master and backup mode, and eth1 is the master network eth2 is the standby network port;

2. Unplug the heartbeat eth1 of database 2, verify whether the binding of the heartbeat network is successful, and whether the heartbeat signal has a normal switching action to ensure that the database RAC cluster can work normally; if the database heartbeat is switched to eth2, the database is normal;

3. Plug back the heartbeat line eth1 of database 2, and then unplug the eth2 heartbeat line to verify whether the database heartbeat can be switched normally. and the normal operation of the database;

4. Unplug the two heartbeat wires eth1 and eth2 of database 2 at the same time, so that the heartbeat network between database 2 and database 1 is interrupted, verify whether the RAC mechanism is set normally, and confirm whether the system log and database log records are normal. At this time, if When database 2 restarts after waiting for one minute, the arbitration disk of the database will issue a failure warning, and the related information of the system log and database log will be recorded normally.

The heartbeat network card refers to a Gigabit, 10 Gigabit or IB network card.

The beneficial effect that the present invention produces compared with prior art is:

A method for redundant configuration of heartbeat signals based on database RAC mode according to the present invention inserts and unplugs the heartbeat network in a certain order, records relevant information, and determines whether the RAC mode of the database is set by recording the operation steps and corresponding information. correct; make the hardware physical layer and software application layer to ensure the realization of high-redundancy architecture, thereby greatly improving the stability and redundancy of the system; effectively solve the problem of server hardware manufacturers, database development manufacturers and system integration manufacturers. The need for stable operation of the machine during project integration and test development; through this invention, problems can be checked at the early stage of the project, and the risk after the cluster is applied is greatly reduced; the scope of application is wide, not only for the binding of hardware network cards The specified test is the test of the entire database RAC cluster, the test of the stability and compatibility of the operating system, which is practical and easy to promote.

Description of drawings

Accompanying drawing 1 is the system network topological diagram of the present invention.

Accompanying drawing 2 is the bond binding topological diagram of the present invention.

Detailed ways

A method for redundant configuration based on the heartbeat signal of the database RAC mode of the present invention will be described in detail below in conjunction with the accompanying drawings.

As shown in Figure 1 and Figure 2, a redundant configuration method based on the heartbeat signal of the database RAC mode, first of all, by plugging and unplugging the network cable of the heartbeat network in a certain order, and viewing the system messages log information and database under the system ocssd log information, database crsd log information and other related parameters. Determine the stability of the heartbeat network through the combination of operation steps and information, so as to infer whether the RAC mode of the oracle database realizes its function. Its specific implementation process is:

1. Set up the infrastructure:

Set up two high-end servers that have installed the oracle database. The two databases are configured in RAC mode and named database 1 and database 2 respectively;

A monitoring server connected to two server host devices at the same time, the log information that needs to be recorded during monitoring and mobile phone testing;

The voting disks of the two databases are respectively mapped to the raw disks;

A heartbeat network switch connected to the heartbeat network cards of two high-end server hosts through a heartbeat network cable. Each host is configured with two heartbeat network cards, named eth1 and eth2 respectively, and bonded to the master and backup mode, and eth1 is the master network eth2 is the standby network port.

The bond heartbeat binding situation before the 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

Unplug the heartbeat eth1 of database 2.

Purpose: In order to ensure that the database RAC cluster can work normally, the heartbeat network is a redundant mode by binding the ports of two heartbeat network cards. Therefore, by unplugging one of the heartbeat cables, you can verify whether the binding of the heartbeat network is successful, and whether the heartbeat signal has a normal switching action to ensure that the database RAC cluster can work normally.

Normal phenomena and results: The database heartbeat is switched to eth2, and the database is normal.

The current mode of a 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: Plug back the heartbeat cable eth1 of database 2, and then unplug the heartbeat cable eth2.

Purpose: Through this operation, you can verify whether the bond0 mode of the database heartbeat can be switched to each other normally, so as to ensure that the interruption of either of the two heartbeat lines in bond0 will not affect the normal operation of the system and database.

Normal phenomena and results: When eth1 is plugged back in, the eth1 heartbeat network connection is restored, and the heartbeat main network is still on eth2; after the eth2 heartbeat network is unplugged, the eth1 heartbeat network is activated, and the system and database operate normally.

The current mode of a 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: Unplug the two heartbeat cables eth1 and eth2 of database 2 at the same time.

Purpose: Use this method to interrupt the heartbeat network between database 2 and database 1, verify whether the RAC mechanism is set normally, and confirm whether the system log and database log records are normal.

Normal phenomena and results: Database 2 restarts after waiting for one minute, because the heartbeat of the database is completely interrupted, and the arbitration disk of the database will issue a failure warning. So database 1 will issue a command to restart slave node database 2 after detecting for one minute and not recovering the heartbeat signal, which will cause database 2 to restart, which is normal. Information about the system log and database log is recorded normally.

The above is only a preferred embodiment of the present invention, but the scope of protection of the present invention is not limited thereto. Any person skilled in the art can easily conceive of any changes or modifications within the technical scope disclosed in the present invention. Replacement should be covered within the protection scope of the present invention. Therefore, the protection scope of the present invention should be determined by the protection scope of the claims.

Claims (2)

1. a kind of method based on the redundant configuration of database RAC mode heartbeat signal, it is characterized in that its concrete realization process is: 1. Set up the infrastructure: Set up two high-end servers that have installed the oracle database. The two databases are configured in RAC mode and named database 1 and database 2 respectively; A monitoring server connected to two server host devices at the same time, the log information that needs to be recorded during monitoring and mobile phone testing; The voting disks of the two databases are respectively mapped to the raw disks; A heartbeat network switch connected to the heartbeat network cards of two high-end server hosts through a heartbeat network cable. Each host is configured with two heartbeat network cards, named eth1 and eth2 respectively, and bonded to the master and backup mode, and eth1 is the master network eth2 is the standby network port; 2. Unplug the heartbeat eth1 of database 2, verify whether the binding of the heartbeat network is successful, and whether the heartbeat signal has a normal switching action to ensure that the database RAC cluster can work normally; if the database heartbeat is switched to eth2, the database is normal; 3. Plug back the heartbeat line eth1 of database 2, and then unplug the eth2 heartbeat line to verify whether the database heartbeat can be switched normally. and the normal operation of the database; 4. Unplug the two heartbeat wires eth1 and eth2 of database 2 at the same time, so that the heartbeat network between database 2 and database 1 is interrupted, verify whether the RAC mechanism is set normally, and confirm whether the system log and database log records are normal. At this time, if When database 2 restarts after waiting for one minute, the arbitration disk of the database will issue a failure warning, and the related information of the system log and database log will be recorded normally. 2. A method for redundant configuration based on a database RAC mode heartbeat signal according to claim 1, wherein the heartbeat network card refers to a Gigabit, 10 Gigabit or IB network card.

Images