Technique for duplexing database

A server comprising one or more processors for performing change data capture (CDC) between a source database and a target database, the one or more processors comprising:

• a resource data acquisition module acquiring resource data which is data obtained by monitoring a current resource of a source database server;
• a comparison information generation module generating comparison information by comparing the resource data and a predetermined source database server load threshold value;
• a control module determining an operation mode of a changed data capture process which operates in the source database server based on the comparison information, the operation mode including a union mode and a division mode, and changing an operation mode of the process to the determined mode,
• wherein, the control module further:
• determines the operation mode of the changed data capture process as the union mode when the resource data is less than the predetermined source database server load threshold value in the comparison information;
• and
• determines the operation mode of the changed data capture process as the division mode when the resource data is equal to or more than the predetermined source database server load threshold value in the comparison information;
• extracts changed information included in a record of a redo log of the source database in the source database;
• and
• performs an operation performing step of performing an operation according to the changed operation mode in the mode changing step,
• wherein the operation performing step comprises:
• when the changed operation mode is the union mode, analyzing a transaction for the extracted changed information in the source database, reassembling associated transactions to generate changed data in the source database, completing commit of the changed data in the source database, and reflecting the committed changed data to a target database;
• or
• when the changed operation mode is the division mode, transmitting the changed information to the target database so as to generate the changed data in the target database by reassembling the transactions for the changed information in the target database and reflect committed changed data in the target database.

A method for performing change data capture (CDC) between a source database and a target database, the method comprising:

• a resource data acquisition step of acquiring resource data which is data obtained by monitoring a current resource of a source database server;
• a comparison information generation step of generating comparison information by comparing the resource data and a predetermined source database server load threshold value;
• a mode determination step of determining an operation mode of a changed data capture process which operates in the source database server based on the comparison information, the operation mode including a union mode and a division mode, wherein the mode determination step includes:
• determining the operation mode of the changed data capture process as the union mode when the resource data is less than the predetermined source database server load threshold value in the comparison information;
• and
• determining the operation mode of the changed data capture process as the division mode when the resource data is equal to or more than the predetermined source database server load threshold value in the comparison information;
• a mode changing step of changing the operation mode of the process to a mode determined in the mode determination step,
• an extraction step of extracting changed information included in a record of a redo log of the source database in the source database;
• and
• an operation performing step of performing an operation according to the changed operation mode in the mode changing step,
• wherein the operation performing step comprises:
• when the changed operation mode is the union mode, analyzing a transaction for the extracted changed information in the source database, reassembling associated transactions to generate changed data in the source database, completing commit of the changed data in the source database, and reflecting the committed changed data to a target database;
• or
• when the changed operation mode is the division mode, transmitting the changed information to the target database so as to generate the changed data in the target database by reassembling the transactions for the changed information in the target database and reflect committed changed data in the target database.