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

A message service and database technology, which is applied in the field of cross-network gateway Mysql database synchronization based on cloud message service platform, can solve the problems of destroying the order of messages and unable to transmit data normally, so as to solve the problem of cross-gateway synchronization and ensure timely Sexuality and efficiency, and the effect of good promotion and application value

Inactive Publication Date: 2018-11-27
INSPUR QILU SOFTWARE IND
View PDF3 Cites 8 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Apparatus and method for realizing cross-gateway Mysql database synchronization based on cloud message service platform

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0030] Such as figure 1 As shown, the device of the present invention based on the cloud message service platform to realize cross-network Mysql database synchronization includes Mysql source database, Mysql log collection module, message queue one, conversion module one, file name band coded file storage module one, network Gate module, message queue 2, conversion module 2, file name coded file storage module 2, Mysql data storage module and Mysql target database. Mysql source database, Mysql log collection module, message queue 1, conversion module 1, file storage module with coded file name 1 is set in the external network, message queue 2, conversion module 2, file storage module with coded file name 2, The Mysql data storage module and the Mysql target database are located in the intranet.

[0031] The Mysql source database is connected with the Mysql log collection module. Message queue 1 is connected with Mysql log collection module and conversion module 1 respectivel...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

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...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
Inventor 李朝铭肖雪王建华
Owner INSPUR QILU SOFTWARE IND
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap