Multicast Database Replication Group Address
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Traditional database replication methods require distinct point-to-point connections, limiting the number of replicate databases due to network bandwidth constraints and increasing network overhead when replicating data to multiple databases.
Innovation Solution
Implementing a multicast database replication system where data is sent to a replication group address, automatically replicating it to subscribed databases without the need for individual point-to-point connections, using a protocol like UDP for data dissemination.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If distinct point-to-point connections are established between primary database and each replicate database, then data replication can be performed reliably, but network bandwidth is limited and the number of replicate databases is constrained
Solution Approach 1:
The patent merges multiple point-to-point connections into a single multicast connection. Instead of establishing separate connections from the primary database to each replicate database, a single multicast connection is created that simultaneously delivers data to all replicate databases, thereby supporting a greater number of replicates without proportionally increasing network connections.
Solution Approach 2:
The multicast connection serves multiple functions simultaneously: it provides data replication to multiple replicate databases through a single connection, making the connection universal rather than dedicated to a single replicate. This multi-functionality allows one connection to serve many databases.
2Reliability
If data is transmitted separately to each replicate database over point-to-point connections, then each database receives complete data, but network overhead and bandwidth usage increase
Solution Approach 1:
The patent combines multiple separate data transmission operations into a single multicast transmission. The primary database sends one copy of the data over the multicast connection, and all replicate databases receive it simultaneously, eliminating the need to send identical data multiple times over separate connections.
Solution Approach 2:
The network infrastructure (routers) automatically creates copies of the multicast data packet at network nodes to distribute it to multiple destinations. This shifts the copying function from the application layer to the network layer, reducing application overhead.
3Adaptability or versatility
If multiple point-to-point connections are maintained for database replication, then data can be replicated to multiple databases, but the system complexity increases
Solution Approach 1:
The patent consolidates connection management by replacing multiple individual connection management tasks with a single multicast connection management task. The primary database only needs to manage one multicast connection instead of multiple point-to-point connections, significantly reducing system complexity.
Data Source
AI summary
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.