| 摘要 |
PURPOSE: A method for a database replication is provided to copy modified contents of a database(local database) with respect to many databases which are physically located at different portions into other databases(remote database). CONSTITUTION: Replication transmitters created by replication managers try a connection to replication receivers of a priority database server(S101,S102). If a replication receiver is connected, the replication transmitter transmits information of tables which participate in a replication to the replication receiver, receives a replication constraint condition checking result, and checks a success or not(S103). A replication starting point is adjusted and the position thereof is stored in a corresponding replication object(S104). It is checked whether a replication terminating request exists from a user database server or other database server(S105). If a replication terminating request does not exist and a replication LSN(XLSN, LSN: log sequence number) is not identified with the current LSN of the database server(S107), a log record of the XLSN position is obtained in a database log, and the XLSN value is increased(S108). If the obtained log record is not a data modification or transaction control log(S109), the stage is returned to the above (S105) stage. If the obtained log record is a data modification or transaction control log and a log record type is a transaction starting log, a transaction is registered in a replication transaction table.
|
