A system supporting database synchronization through multiple channels in a local area network

Abstract

The present invention discloses a system that supports database synchronization via multiple channels in a local area network. The system includes a synchronization information channel configuration module, a synchronization information channel creation and management module, and a synchronization information pre-processing and guidance module. The synchronization information channel configuration module is used to configure the IP addresses, priorities, and channel switching decision types of all channels of the peer database deployment node; the synchronization information channel creation and management module is used to determine a unique synchronization interaction channel based on the configuration, the actual communication status of the channel, and the channel switching strategy; the synchronization information pre-processing and guidance module is used to obtain synchronization information packets sent by the database and guide synchronization information packets intended for transmission outside the node through the current synchronization interaction channel; and the synchronization information packets of the external node database received from the synchronization interaction channel are guided to the local database. The present invention fully utilizes the redundant backup capabilities of multiple network segments, providing a solution for the application of high-availability database architectures in more severe scenarios.

Description

Technical Field

[0001] The present invention relates to computer database and communication field design technology, and in particular to a system supporting database synchronization through multiple channels (multiple network segments) in a local area network. Background Art

[0002] Database synchronization is a fundamental feature of high-availability database architectures. In current high-availability database architectures, each node can only synchronize information with its peer node via a single network segment. In environments with multi-channel connectivity, this approach fails to fully utilize the advantages of multi-channel backup. If the pre-designated synchronization segment fails, inter-database synchronization cannot continue, reducing system robustness. Summary of the Invention

[0003] In order to solve the problem of database synchronization failure when the preset synchronization network segment between a pair of databases fails in a multi-segment connection state, the present invention aims to provide a system that supports database synchronization through multiple channels in a local area network. By creating and managing multiple channels and organizing and guiding data flow, dynamic routing of database synchronization information data is achieved when not all networks are interrupted, thereby ensuring the normal operation of the database synchronization function and improving the network fault tolerance and robustness of the database high-availability architecture.

[0004] The object of the present invention is achieved through the following technical solutions:

[0005] A system supporting database synchronization through multiple channels in a local area network includes a synchronization information channel configuration module 101, a synchronization information channel creation and management module 102, and a synchronization information pre-processing and guidance module 103;

[0006] The synchronization information channel configuration module 101 is used to configure the IP addresses of all channels deployed with the peer database node, the priority of each IP address for each channel, and the channel switching decision type.

[0007] The synchronization information channel creation and management module 102 is used to set different priorities for multiple channels based on the configuration information of the synchronization information channel configuration module 101 and the actual communication status of the channels; check the channel communication status and update the status settings; determine a unique synchronization interaction channel based on the current priority and channel switching strategy, and the determined synchronization interaction channel provides transmission and reception services for the synchronization information pre-processing and guidance module 103;

[0008] The synchronization information pre-processing and guidance module 103 is used to obtain the synchronization information data packets sent by the database; identify and extract the synchronization information data packets; guide the synchronization information data packets to be sent outside the node to be sent through the current synchronization interaction channel; and guide the external node database synchronization information data packets received from the synchronization interaction channel to this database.

[0009] Preferably, the synchronous information channel configuration module 101 includes a human-computer interaction functional component, a compliance detection functional component, and a retrieval and writing functional component;

[0010] The human-computer interaction functional component provides the user with an interface for configuring each channel. The configuration information should include: all IP addresses of the peer database deployment node, the priority of the channel corresponding to each IP address, and the channel switching decision type;

[0011] The compliance detection component is used to detect whether the channel switching decision type of this node is consistent with that of the peer database deployment node, and whether the priority of the corresponding IP channel is consistent. If they are consistent, the compliance test passes;

[0012] The retrieval and writing functional component is used to store the generated configuration information and query the configured or stored channel information.

[0013] Preferably, the synchronous information channel creation and management module 102 includes a channel creation component, a channel status monitoring and marking component, a channel decision component and a channel queue;

[0014] The channel creation component creates different channels according to the configuration information generated and deployed to the node by the synchronization information channel configuration module 101 and adds them to the channel queue;

[0015] The channel status monitoring and marking component maintains and records the communication status and priority of these channels according to the set inspection strategy;

[0016] The channel decision component comprehensively determines a unique interactive synchronization channel during system initialization and when a channel failure occurs based on the channel switching decision type, the status of each channel, and the priority of each channel configured in the synchronization information channel configuration module 101.

[0017] Preferably, the synchronization information pre-processing and guiding module 103 includes an egress synchronization information acquisition and processing component, a synchronization information downward delivery component, an ingress synchronization information acquisition and processing component, and a synchronization information upward submission component;

[0018] The outgoing node synchronization information acquisition and processing component receives synchronization information packets from the local node database, analyzes the destination address of the packet, compares it with the in-use channel information, encapsulates the original packet, and then passes it to the synchronization information delivery component.

[0019] The synchronization information downward delivery component sends the encapsulated data packet to the node of the peer database through the synchronization interaction channel determined by the synchronization information channel creation and management module 102;

[0020] The node synchronization information acquisition and processing component receives and extracts synchronization information data packets from the synchronization interaction channel determined by the synchronization information channel creation and management module 102, and reports them to the synchronization information upward forwarding component after verification;

[0021] The synchronization information is forwarded upward to the component to disassemble the synchronization information data packet and deliver it to the local node database, completing a one-way transmission of synchronization information.

[0022] The beneficial effects of the present invention are:

[0023] For the high-availability database architecture under multi-segment connection status, the present invention fully utilizes the redundant backup capabilities of multiple network segments, greatly improves the robustness of the synchronization of the high-availability architecture, expands the deployment scenarios of traditional synchronous databases, and provides a solution for the application of the high-availability database architecture in more severe scenarios. BRIEF DESCRIPTION OF THE DRAWINGS

[0024] Figure 1 This is a block diagram of the functional components of a system supporting database synchronization through multiple channels in a local area network as shown in an embodiment;

[0025] Figure 2 It is a schematic diagram of information included in the configuration data;

[0026] Figure 3 This is an example diagram of an application scenario. DETAILED DESCRIPTION

[0027] The present invention will be further described in detail below with reference to the accompanying drawings and embodiments.

[0028] See also Figure 1 As shown, the system shown in this embodiment supports database synchronization through multiple channels in a local area network. Any node in the network can include the following modules: a synchronization information channel configuration module 101, a synchronization information channel creation and management module 102, and a synchronization information pre-processing and guidance module 103.

[0029] The synchronous information channel configuration module 101 runs only during configuration. It is used to configure the IP addresses of all channels with the peer database deployment node, the priority of each IP address for each channel, the channel switching decision type, and other information. The synchronous information channel configuration module 101 can configure information related only to its own node, or it can complete the configuration of all nodes on a single node and then transmit it to other nodes via the network.

[0030] The synchronous information channel configuration module 101 includes a human-computer interaction functional component, a compliance detection functional component, and a retrieval and writing functional component.

[0031] The human-computer interaction functional component provides the user with an interface for configuring each channel. The configuration information should include: all IP addresses of the peer database deployment node, the usage priority of each IP corresponding to the channel (the principle is that each IP corresponds to one channel, and based on the actual scenario, each network segment can correspond to one channel), and the channel switching decision type (different decision types are preset in the synchronous information channel creation and management module 102). The configuration data information is shown in the figure below. Figure 2 .

[0032] The compliance detection function component is used to detect whether the channel switching decision type of this node is consistent with that of the opposite database deployment node, and whether the priority of the channel of the corresponding IP is consistent. If they are consistent, the compliance detection passes.

[0033] The retrieval and writing functional component is used to store the generated configuration information and query the configured or stored channel information.

[0034] The synchronization information channel creation and management module 102 is used to generate corresponding synchronization interaction channels according to the configuration information; set different priorities for multiple channels according to the configuration information and the actual communication status of the channels; check the channel communication status and update the status settings according to the set inspection strategy (regularly or irregularly); determine the only synchronization interaction channel based on the current priority and channel switching strategy, and the determined synchronization interaction channel provides sending and receiving services for the synchronization information pre-processing and guidance module 103.

[0035] The synchronous information channel creation and management module 102 includes a channel creation component, a channel status monitoring and marking component, a channel decision component and a channel queue.

[0036] The channel creation component creates different channels according to the configuration information generated and deployed to the node by the synchronization information channel configuration module 101 and adds them to the channel queue.

[0037] The channel status monitoring and marking component maintains and records the communication status of these channels (marked as normal or abnormal) and their priorities according to the set inspection strategy (regular or irregular). The inspection strategy is the strategy that determines the method and timing of inspecting the communication status of each channel.

[0038] The channel decision component comprehensively determines a unique channel during system initialization and channel failure based on the channel switching decision type, the status of each channel, the priority of each channel, and other information configured in the synchronization information channel configuration module 101 (the channel decision components deployed in the two databases ensure the reliability of local node decisions by exchanging channel change information: they can coordinate and determine a consistent available channel when information conflicts).

[0039] The synchronization information pre-processing and guidance module 103 directly interacts with the database to obtain the synchronization information data packets sent by the database; identify and extract the synchronization information data packets; guide the synchronization information data packets to be sent outside the node to be sent through the current synchronization interaction channel; and guide the received external node database synchronization information data packets to the corresponding processing module of this database.

[0040] The synchronization information pre-processing and guiding module 103 includes an egress node synchronization information acquisition and processing component, a synchronization information downward delivery component, an ingress node synchronization information acquisition and processing component, and a synchronization information upward forwarding component.

[0041] The outgoing node synchronization information acquisition and processing component receives the synchronization information data packet from the local node database, analyzes the destination address of the data packet, compares it with the in-use channel information, encapsulates the original data packet, and then passes it to the synchronization information downward delivery component.

[0042] The synchronization information downward delivery component sends the encapsulated data packet to the node of the peer database through the synchronization interaction channel determined by the synchronization information channel creation and management module 102.

[0043] The ingress node synchronization information acquisition and processing component receives and extracts synchronization information data packets from the synchronization interaction channel determined by the synchronization information channel creation and management module 102, and reports them to the synchronization information upward forwarding component after verification.

[0044] The synchronization information is forwarded upward to the component to disassemble the synchronization information data packet and deliver it to the local node database, completing a one-way transmission of synchronization information.

[0045] See also Figure 3 This demonstrates a typical application scenario. A high-availability database architecture is built within a local area network (LAN) consisting of three network segments. The database pairs are connected through these three network segments, and the database deployment nodes are configured with IP addresses from each of the three network segments.

[0046] To apply this system in this environment:

[0047] First, use the synchronous information channel configuration module 101 to generate configuration files for database 1 and database 2 respectively, specify the three IP addresses of the deployment node of the opposite database 2 for database 1, and assign corresponding priorities (the highest priority channel is set by default to the network channel specified during database synchronization configuration), and set the channel switching decision type to not grab the priority after the faulty network is restored (that is, after the original highest priority channel C1 fails, the second available channel C2 is promoted to the in-use channel. After C1 is restored, the in-use channel is not switched to C1, and C2 is still used); specify the three IP addresses of the deployment node of the opposite database 1 for database 2, and assign corresponding priorities. The configured priorities can ensure that the channels in the same network segment have the same priority, and set the channel switching decision type to not grab the priority after the faulty network is restored.

[0048] After synchronization interaction is initiated, the synchronization information channel creation and management module 102 creates the channel and maintains status and priority information according to the previous steps. Databases synchronize using the highest-priority channel, 192.168.AX / 24. For example, for database 1 to database 2 to transmit synchronization information, the synchronization information pre-processing and guidance module 103 on the database 1 deployment node determines that the data packet channel is 192.168.AX / 24, which is the same as the currently used channel. It then encapsulates and sends the data packet over 192.168.AX / 24. The synchronization information pre-processing and guidance module 103 on the database 2 deployment node receives the synchronization data packet from channel 192.168.AX / 24, unpacks it, and transmits it to database 2, completing a one-way transmission.

[0049] When the 192.168.AX / 24 network segment fails, the synchronization information channel creation and management module 102 on both nodes detects an abnormality in the currently active channel based on monitoring results, marks this status information, and sets the next highest priority available channel, 192.168.BX / 24, as the current active channel. For example, when database 1 transmits synchronization information to database 2, the synchronization information pre-processing and guidance module 103 on the database 1 deployment node determines that the data packet's channel is 192.168.AX / 24, which is inconsistent with the currently active channel. It encapsulates the data packet and sends it via 192.168.BX / 24. The synchronization information pre-processing and guidance module 103 on the database 2 deployment node receives the synchronization data packet from channel 192.168.BX / 24, decapsulates it, and finds that the destination is 192.168.A.11. It then passes it to database 2 via its ingress node synchronization information acquisition and processing component, completing a one-way transmission. When channel 192.168.AX / 24 returns to normal, the synchronization information channel creation and management module 102 on the two nodes finds that 192.168.AX / 24 has returned to normal based on the monitoring results, and marks the status information. According to the current channel switching decision type, the active channel is not switched to 192.168.AX / 24, and 192.168.BX / 24 is still used.

[0050] The present invention is particularly suitable for environments with multi-segment connection deployments. Through real-time monitoring and marking of the communication status of multiple network channels, available database pair synchronization interaction channels are selected, and the transmission of database synchronization information between the database and the channel is directed and guided at the database deployment node, thereby ensuring the uniqueness of the transmission of synchronization information data. At the same time, it solves the problem of synchronization work interruption when a single set channel is interrupted, and fully utilizes the backup advantages and capabilities of the redundant network deployment environment.

[0051] It is understandable that those skilled in the art can make equivalent substitutions or changes based on the technical solution and inventive concept of the present invention, and all these changes or substitutions should fall within the scope of protection of the claims attached to the present invention.

Claims

1. A system for supporting database synchronization through multiple channels in a local area network, comprising a synchronization information channel configuration module (101), a synchronization information channel creation and management module (102), and a synchronization information pre-processing and guidance module (103), characterized in that: The synchronous information channel configuration module (101) is used to configure the IP addresses of all channels deployed with the peer database node, the priority of use of the channels corresponding to each IP address, and the channel switching decision type; The synchronous information channel creation and management module (102) is used to set different priorities for multiple channels according to the configuration information of the synchronous information channel configuration module (101) and the actual communication status of the channels; check the channel communication status and update the status setting; determine a unique synchronous interaction channel according to the current priority and channel switching strategy, and the determined synchronous interaction channel provides sending and receiving services for the synchronous information pre-processing and guidance module (103); The synchronization information pre-processing and guiding module (103) is used to obtain synchronization information data packets sent by the database; identify and extract synchronization information data packets; guide synchronization information data packets to be sent to the outside of the node to be sent through the current synchronization interaction channel; guide synchronization information data packets of the external node database received from the synchronization interaction channel to the current database; The synchronization information pre-processing and guiding module (103) includes an egress node synchronization information acquisition and processing component, a synchronization information downward delivery component, an ingress node synchronization information acquisition and processing component, and a synchronization information upward delivery component; The outgoing node synchronization information acquisition and processing component receives synchronization information packets from the local node database, analyzes the destination address of the packet, compares it with the in-use channel information, encapsulates the original packet, and then passes it to the synchronization information delivery component. The synchronization information downward delivery component sends the encapsulated data packet to the node of the opposite-end database through the synchronization interaction channel determined by the synchronization information channel creation and management module (102); The node synchronization information acquisition and processing component receives and extracts synchronization information data packets from the synchronization interaction channel determined by the synchronization information channel creation and management module (102), and reports the data packets to the synchronization information upward forwarding component after verification; The synchronization information is forwarded upward to the component to disassemble the synchronization information data packet and deliver it to the local node database, completing a one-way transmission of synchronization information.

2. A system for supporting database synchronization through multiple channels in a local area network according to claim 1, characterized in that The synchronous information channel configuration module (101) comprises a human-computer interaction functional component, a compliance detection functional component, and a retrieval and writing functional component; The human-computer interaction functional component provides the user with an interface for configuring each channel. The configuration information should include: all IP addresses of the peer database deployment node, the priority of the channel corresponding to each IP address, and the channel switching decision type; The compliance detection component is used to detect whether the channel switching decision type of this node is consistent with that of the peer database deployment node, and whether the priority of the corresponding IP channel is consistent. If they are consistent, the compliance test passes; The retrieval and writing functional component is used to store the generated configuration information and query the configured or stored channel information.

3. The system for supporting database synchronization through multiple channels in a local area network according to claim 1, characterized in that The synchronous information channel creation and management module (102) comprises a channel creation component, a channel status monitoring and marking component, a channel decision component and a channel queue; The channel creation component creates different channels according to the configuration information generated and deployed to the node by the synchronization information channel configuration module (101) and includes them in the channel queue; The channel status monitoring and marking component maintains and records the communication status and priority of these channels according to the set inspection strategy; The channel decision component comprehensively determines a unique interactive synchronization channel during system initialization and when a channel failure occurs according to the channel switching decision type, the status of each channel, and the priority of each channel configured in the synchronization information channel configuration module (101).

Images