Multicast database replication

摘要

Systems, methods and computer program products for multicast database replication are described herein. An embodiment includes creating a replication group for replication of data. One or more replicate (or target) databases are subscribed to the replication group and the replication group may include one or more subscribed replicate databases. The replication group is associated with a replication group address. Embodiments send (or publish) data that is to be replicated to the replication group multicast address causing automatic replication of the data to the subscribed replicate databases. In this way, by sending data to be replicated once to a replication group address, the data is automatically replicated to several subscribed replicate databases and a replication server need not establish distinct point-to-point connections with each replicate database.

主权项

1. A computer-implemented method for database replication, comprising:
creating a first replication group and a second replication group for replication of data from one or more tables of one or more databases that are marked for replication, wherein said databases also comprise one or more tables not marked for replication, wherein each replication group is associated with its own unique replication group address; subscribing one or more databases to said first replication group and said second replication group; maintaining a list of databases subscribed to each replication group; transmitting a first set of data to a first replication group address to cause replication of said first set of data to said databases subscribed to said first replication group, wherein said databases subscribed to said first replication group periodically send acknowledge messages for successfully received data packets of said transmitted data and wherein each acknowledge message is sent for a plurality of said successfully received data packets; receiving a request to re-transmit a missing data packet from the first set of data, when said missing data packet is not received by one or more of said databases subscribed to said first replication group; and re-transmitting said missing data packet to said one or more of said databases while continuing to transmit said first set of data to said first replication group address, and wherein said creating, said subscribing and said sending are performed using one or more processors.