Replication Mechanisms for Database Environments

摘要

Data replication in a database includes identifying a source database system. The source database includes a main index file and a delta log file. To create a replica, one or more symbolic links to the source database system are generated. The symbolic links identify a path to a physical location of the source database. A replica of the source database is generated based on the symbolic links. The replica includes a copy of the main index file and delta log file. Information associated with the replica and the symbolic links is stored in a recovery log. Replica are provided transparently to most database engine components by re-using partitioning infrastructure. Components “see” replica as tables with a single partition; that partition is a local replica.

主权项

1. A method for data replication within a database environment comprising:
identifying a source database table, wherein the source database table includes a main index file and a delta log file; generating one or more symbolic links to the source database table, wherein each symbolic link identifies a path to a physical location of the source database table; generating a replica of the source database table based on the symbolic links, wherein the replica includes a copy of the main index file and delta log file; and storing information associated with the replica and the symbolic links in a recovery log.