Data replication method and system for database management system

摘要

Disclosed is a data replication method in a Database Management System (DBMS). The data replication method includes generating a replication log through a transaction log of a master database to thereby transmit the generated replication log to a distributor, determining a slave host distributing the replication log to thereby distribute the replication log to the corresponding slave host, and reflecting the replication log in a slave database.

主权项

1. A data replication method in a Database Management System (DBMS), the data replication method comprising:
generating a replication log through a transaction log of a master host and transmitting the generated replication log to a distributor which is used as a relay system between the master host and a plurality of slave hosts, the transaction log including,
an undo log to archive a previous data image and to abort an updating operation, anda redo log to archive a data image obtained after performing the updating operation, and to repeat the updating operation, the replication log comprising the redo log; determining one or more slave hosts in charge of distributing the replication log among the plurality of slave hosts, and distributing the replication log from the distributor to the one or more determined slave hosts; and applying the replication log to the one or more determined slave hosts such that the replication log is reflected in the one or more determined slave hosts, wherein the replication log defines a desired replication configuration between the master host and the slave host to be N:M.