Database server, replication server and method for replicating data of a database server by at least one replication server
AssigneeSoftware AG
InventorsHeinz Kreuder, Harald Schöning
Life of this patent
Estimating the term…
Abstract
The present invention concerns a method for replicating data of a database server (10) by at least one replication server (20), the method comprising the following steps performed by the at least one replication server (20): a. sending a database request (40) to the database server (10), wherein the database request (40) comprises metadata (421c, 421d) indicating replication data requested by the at least one replication server (20); and b. receiving a database response (40′) from the database server (10), wherein the database response (40′) comprises the requested replication data indicated by the metadata (421c, 421d).
Claims18
A method for replicating data of a database that is hosted on a database server system by at least one replication server that includes at least one processor, the method comprising:
- sending, via the at least one processor, a database request to the database server, wherein the database request comprises metadata indicating replication data requested by the at least one replication server;
- and
- receiving, via the at least one processor, a database response from the database server, wherein the database response comprises the requested replication data indicated by the metadata,
- wherein the database request is wrapped in a conventional request to the database hosted on the database server,
- wherein the replication data requested by the at least one replication server relates to redo log data stored in a redo log of the database server, the redo log storing modifications made to data stored within the database, and wherein the metadata indicates the redo log data requested by the at least one replication server.
A method for replicating data stored in a database of a database server that includes a processing system, the database including a transaction log that stores modifications made to data stored within the database, the method comprising:
- receiving, via the processing system, a database request from at least one replication server, wherein the database request comprises metadata indicating replication data requested by the at least one replication server;
- and
- sending, via the processing system, a database response to the at least one replication server, wherein the database response comprises the requested replication data indicated by the metadata,
- wherein the database request is wrapped as a conventional request to the database,
- wherein the replication data requested by the at least one replication server relates to transaction log data in the transaction log of the database, and wherein the metadata of the database request indicates data of the transaction log that is requested by the at least one replication server.
A database server, comprising:
- a non-transitory storage medium configured to store a database that includes a plurality of records, the database being associated with a redo log that tracks transactions made against the database;
- an interface configured to receive a database request from at least one replication server, wherein the database request comprises metadata indicating replication data of the redo log that is associated with the data stored within the database;
- and
- a processing system including at least one processor, the processing system configured to:
- generate a database response for the at least one replication server, wherein the database response comprises the requested replication data from the redo log of the database which is indicated by the metadata of the database request;
- and
- send the database response to the at least one replication server,
- wherein the database request is structured as being wrapped in a conventional request to the database.
A replication apparatus, comprising:
- a processing system that includes at least one processor, the processing system configured to:
- generate a database request for a database hosted on a database computing system, wherein the database request comprises metadata indicating replication data requested by the at least one replication server;
- and
- send the database request to the database computing system for processing thereon;
- and
- an interface configured to receive a database response from the database computing system that hosts a database, wherein the database response comprises the requested replication data indicated by the metadata,
- wherein the database request is wrapped in a conventional request to the database,
- wherein the database is associated with a transaction log that logs modifications that have been performed to the stored data of the database between a first database state and a second database state,
- wherein the database response includes data from the transaction log.
A non-transitory computer readable storage medium storing computer readable instructions for use with a database replication apparatus that includes at least one processor, the stored instructions comprising instructions configured to at least:
- construct a replication data request that includes at least one parameter for identifying information that is managed by a database hosted on a database computing system, the database including a plurality of data segments that are retrievable via conventional database requests;
- send the replication data request to the database computing system to retrieve information from the database based at least in part on the at least one parameter of the replication data request;
- and
- receive responsive replication data, from the database computing system, that is in accordance with the sent replication data request and the at least one parameter,
- wherein the database is a transactional database that is associated with a transaction log that keeps track of all transactions that update the database,
- wherein the responsive replication data includes data based on the transaction log,
- wherein the replication data request is wrapped in a convention database request of a type of the conventional database requests.
Dependencies are inferred from the claim text.