Apparatus and method for realizing cross-gateway Mysql database synchronization based on cloud message service platform

Abstract

The invention discloses a device and a method for realizing cross-gateway Mysql database synchronization based on a cloud message service platform, belonging to the technical field of cross-gateway data synchronization. The device for realizing the synchronization of the cross-gateway Mysql database based on the cloud message service platform comprises a Mysql log collection module, Message queueone, conversion module one, file name with code file storage module one, gateway module, message queue two, conversion module two, file name with code file storage module two and Mysql data storage module, message queue one and Mysql log collection module, conversion module one are respectively connected. The device for realizing the synchronization of the cross-gateway Mysql database based on thecloud message service platform solves the synchronization problem of the cross-gateway Mysql database, ensures the timeliness and high efficiency of the Mysql database, and has good popularization and application value.

Description

technical field [0001] The invention relates to the technical field of data synchronization across network gatekeepers, and specifically provides a device and method for realizing synchronization of Mysql databases across network gatekeepers based on a cloud message service platform. Background technique [0002] In a government or enterprise environment, often due to security needs, the internal network and the external network need to be "physically separated", but the internal network and the external network also need to exchange data (such as Mysql database synchronization), so a gatekeeper is introduced. The full name of the gatekeeper is the security isolation gatekeeper, and the isolation definition of the gatekeeper has three levels: [0003] Physical isolation: In the process of simulating manual exchange, data exchange must be performed on node machines in the internal and external networks, and data exchange with any computer on the network cannot be realized. Th...

AI Technical Summary

Problems solved by technology

In the internal network environment with gatekeeper isolation, when the isolation security is guaranteed (only file exchange is allowed, protocol is not allowed to pass, etc.), CMSP cannot transmit data normally, such as simply taking the message out of the message queue to generate a file and passing it The exchange by the gatekeeper destroys the order of the messages, and the CMSP loses some application scenarios that require strict order, such as Mysql database synchronization

Images