KR100661513B1 - Db managing device of the duplex processor system and controlling method therefore - Google Patents

Abstract

A device for managing a database in a dual processor and a controlling method thereof are provided to maximize operation stability of a dual system by making an active processor check a state of replication between the active and standby processor, and updating database data to a standby side in case of a normal state. The dual processor respectively includes an application block(3A,3B) and a database server(5A,5B). The application block calls/processes a needed database task by inputting the active processor to a function parameter of a database library to perform the needed database task according to an application request of a manger terminal(2). The database server processes the data stored in the database(4A,4B) by only the active processor according to a database task request signal of the application block and transmits/updates the processed database data to the standby side through the replication in case that the replication is normally operated.

Description

DB managing device of the duplex processor system and controlling method therefore}

1 is an explanatory diagram illustrating a conventional redundancy system.

2 is an explanatory diagram for explaining a database management device of the redundant processor of the present invention.

3 is a flowchart of the present invention.

<Detailed Description of Codes>

1A-B: Redundant Processor 2: Operator Terminal

3A-B: Application Block Section 4A-B: DB

5A-B: DB Server

The present invention relates to an apparatus for managing a database of a redundant processor and a method of controlling the same. In particular, when an application requests a DB task, the DB server simultaneously accesses both DB servers of the active / standby processor, and then performs and replicates the DB only by connecting the active processor. The present invention relates to a database management apparatus and a control method of a redundant processor for updating the DB data to the standby side according to the normal status.

In general, the transmission technology began with the spiral carrier in the 1910s, developed into the analog transmission technology, and in the form of the digital transmission technology. Later, the digital transmission technology has evolved the development of the D1 channel bank with a 1.544Mbps transmission speed in the 1960s. It was. Moreover, such digital technology has been applied to the field of exchange technology in the mid-1970s. It has revolutionized the multiplexing of wired transmission systems by introducing the digital relay switch called 4ESS.

By the way, the conventional transmission or exchange system as described above is configured in the form of a shelf or rack that can be mounted to the various boards, for example, the processor board for controlling various functions of the subscriber board or other boards, wherein the processor board is usually internal In order to prevent call disconnection or system error due to instability of devices, it is composed of redundancy structure divided into active and standby side through bus line.

Then, referring to the conventional redundant processor device as described above with reference to FIG. 1, each of the active or standby redundant processor 70A-B has a DB library (LIBRARY) to perform a necessary DB operation according to the application requirements of the administrator. The application block unit 71A-B for calling and processing a function, and the data stored in the DB 72A-B according to the DB operation request signal of the application block unit 71A-B and processing the processed DB data. The DB server 73A-B transmits the update to the standby side through replication.

On the other hand, looking at the DB update operation of the conventional redundant processor,

For example, when an operator issues a command to check the state of the exchange system from the outside, the application block unit 71A of the active processor board 70A recognizes this and performs a DB operation. In this case, the application block unit 71A ) Connects to the DB server 73A using a DB library function such as DB_ select, DB_update, DB_insert, DB_delete, DB_modify, DB_count ..., and the like. Then, the DB server 73A performs the DB operation requested by the application block unit 71A through the DB library function in the DB 72A, and then executes the DB data of the standby processor 70B connected by replication. Send to 73B. Then, the DB server 73B of the standby processor 70B updates the DB data received through the replication from the active processor 70A in its DB 72B.

However, the above-described conventional redundant processor apparatus is a duplexing scheme in which DB updates between the active processor and the standby processor are unconditionally transmitted to the replication connected between the DB servers, so that when the replication between these two processors operates abnormally, the DB data between the two processors is inconsistent. Therefore, the system could not operate normally when switching, and if replication is abnormal, the DB data between the two processors is inconsistent and the DBs of the two processors are separately managed so that the operation stability of the redundant processor is significantly reduced. there was.

Accordingly, the present invention has been invented to solve the above problems, the active processor to check the status of the replication between the active / standby, and update the DB data to the standby side only when normal to maximize the operation stability of the redundant system accordingly It is an object of the present invention to provide a database management apparatus of a redundant processor and a control method thereof.

Another object of the present invention is to connect to the DB server processing only the active processor to process the DB data between the processors regardless of whether or not the replication is always consistent, so the duplication processor is significantly improved transfer stability of the redundant processor accordingly To provide a database management apparatus and a control method thereof.

The present invention for achieving the above object in the redundant processor operating in the active or standby, each of the redundant processor inputs the active processor to the function parameters of the DB library to perform the necessary DB operation according to the application request of the administrator terminal An application block unit for calling and processing the data stored in the DB only by an active processor according to the DB job request signal of the application block units 3A-B and replicating the processed DB data only when the replication is normally operated. Provided is a database management apparatus of a redundant processor including a DB server to be transmitted to and updated by the standby side through.

Another feature of the present invention is to check the initialization variable when the command to call the current DB function in the redundancy system executes the DB server connection if there is no change in the active processor and changes the flag content if there is a change and then the DB server An active server connection step for executing a connection, a DB job execution step for performing a requested DB job only on a DB server of an active processor after the active server connection step, and active if the currently connected replication is normally operated after the DB job execution step. The normal update step of transmitting and updating the DB data processed by the processor to the processor side, and if the currently connected replication does not operate normally after the DB job execution step, the replication is abnormal. Provided is a control method of a database management apparatus of a redundant processor including an update abandonment step not to transmit.

Hereinafter, the present invention will be described in detail with reference to the accompanying drawings.

In the present invention, each of the active or standby redundant processors 1A-B has an active processor for function parameters of the DB library to perform necessary DB operations according to the application request of the administrator terminal 2 as shown in FIG. The application stored in the DB 4A-B only by the active processor in accordance with the DB operation request signal of the application block unit 3A-B and the application block unit 3A-B. Only when it is normally operated, the DB server 5A-B transmits the processed DB data to the standby side through replication and updates it.

Next, a control method applied to the above apparatus will be described.

As shown in FIG. 3, the method of the present invention proceeds to the DB function call confirmation step S2 in the initial state S1 and checks whether a command for calling the current DB function is generated. At this time, if the command to call the current DB function is not generated as a result of checking during the DB function call confirmation step (S2), the current step ends and proceeds to the standby state. However, as a result of checking during the DB function call confirmation step (S2), if a command to call the current DB function is generated, the process proceeds to the active server connection step (S3) and checks the initialization variable. If there is a change, change the flag and execute DB server connection.

Herein, when there is a change in the active processor during the active server connection step (S3), a memory allocation step for environment and connection, and a host connection step after reading the IP address from the configuration file and forming a connection to the local host after the memory allocation step. And a flag changing step of changing the contents of init_flag confirming that the transfer from the current active processor to the standby processor is performed after the host connection step.

On the other hand, after the active server connection step (S3) proceeds to the DB operation execution step (S4) to perform the requested DB operation only in the DB server of the active processor. After the DB task execution step (S4), the process proceeds to the replication status checking step (S5) to check whether the currently connected replication is normally operated. At this time, when the replication status check step (S5) is confirmed that the currently connected replication is normally operated, the process proceeds to the normal update step (S6) and transmits and updates the DB data processed by the active processor to the processor side. However, as a result of checking during the replication status checking step (S5), if the currently connected replication is not normally operated, the process is abandoned in the update abandonment step (S7). Therefore, the replicated DB data is not transmitted to the standby side through the replication.

In other words, when the operator issues a command to check the state of the switching system from the outside, the application block unit 3A of the active processor board 1A recognizes this and performs a DB operation.

That is, the application block unit 3A checks the initialization variable (init_flag) to execute the DB server connection when there is no change of the active processor, and allocates memory for environment and connection when there is a change of the active processor, and assigns an IP address. Read the file from the configuration file to establish a connection to the local host, then change the contents of init_flag to confirm that it has switched from the current active processor to the standby processor.

Meanwhile, the application block unit 3A connects to the DB server 5A using a DB library function such as DB_ select, DB_update, DB_insert, DB_delete, DB_modify, DB_count ..., and the like. (3A) calls the active processor by inputting the function parameter of the DB library, then connects to both the DB servers 5A-B of the active / standby processor (1A-B), and operates the DB only in the input active processor (1A). Do this.

After the above process, the DB server 5A checks whether the currently connected replication is normally operated. At this time, if the currently connected replication is normally operated, the DB server 5A receives the DB data processed by the active processor 1A from the standby processor 1B. It transmits data to the side and updates the database data. However, when the currently connected replication is not normally operated, the DB server 5A does not transmit the working DB data to the standby side through replication because the replication is abnormal. At this time, even if there is another DB operation request, only the DB server 5A of the active processor 1A is connected to perform the DB operation. Therefore, if replication is normally restored because DB data inconsistency does not occur, the DB data between the two processors is consistent. do.

Meanwhile, the present invention manages the DB operation conveniently by initializing the first call and then managing act_flag which confirms the change of the active processor from the next call.

As described above, the present invention connects to both DB servers of the active / standby processor at the same time and requests the DB work of the application, and then performs the DB operation only by connecting the active processor, and checks the status of replication between the active / standby standby in the active processor. DB data is updated to the standby side only if it is normal, thus maximizing the operational stability of the redundant system.

In addition, according to the present invention, since DB operations are processed by connecting to a DB server only in an active processor, DB data is always consistent between processors regardless of whether or not replication is normal. Therefore, transfer stability of the redundant processor is also significantly improved. have.

Claims (3)

In a redundant processor operating in active or standby, Each of the redundant processors includes an application block unit for inputting and processing an active processor in a function parameter of a DB library to perform a necessary DB operation according to an application request of an administrator terminal, and a DB operation of the application block units 3A-B. Data processing of the redundant processor comprising: a DB server processing data stored in the DB only by the active processor according to the request signal, and transmitting the updated DB data to the standby side through replication only when the replication is normally operated. Base management device. If the command to call the current DB function is created in the redundant system, check the initialization variable and execute the DB server connection if there is no change in the active processor, change the flag contents if there is a change, and then execute the DB server connection. DB operation execution step of performing the requested DB operation only in the DB server of the active processor after the connection step, the active server connection step, and the DB processed by the active processor when the currently connected replication is normally operated after the DB operation execution step. The normal update step of transferring data to the processor side and updating, and if the currently connected replication does not operate normally after the DB job execution step, because replication is abnormal, the updated DB data is not transferred to the standby side through replication. The control method of the database management apparatus of the redundant processor, characterized in that comprising the step giving agent. The host connection method of claim 2, wherein the active server connection step comprises: a memory allocation step for environment and connection when there is a change in an active processor; and a host connection that reads an IP address from a configuration file and forms a connection to a local host after the memory allocation step. And a flag changing step of changing a content of init_flag which confirms that the current processor has been switched from the current active processor to the standby processor after the host connection step.

Images