Binlog-based configurable mysql database real-time synchronization method

A real-time synchronization and database technology, applied in electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as inconsistencies between databases and configuration files, interactive actions that cannot be synchronized, and inconsistencies between two servers, etc., to improve reliability and stability effects

Inactive Publication Date: 2016-09-21
PALADI NETWORK TECH HANGZHOU
View PDF6 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, the synchronization of the database and files in this way is independent of each other, which may cause inconsistencies between the database and configuration files, and in some applications that interact with the underlying system, those interactive actions cannot be synchronized, resulting in inconsistencies between the two servers, hot standby Some features don't work properly after switching

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
  • Binlog-based configurable mysql database real-time synchronization method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0020] The present invention will be described in further detail below in conjunction with the accompanying drawings and specific embodiments.

[0021] Such as figure 1 As shown, the present invention is based on the mysql binlog, triggers the synchronous action through the mysql sql operation, and uses the configuration file to flexibly control the synchronous table and the data requiring special processing. The specific implementation steps are as follows:

[0022] Step 1: Configure binlog on both server A and server B to be synchronized, and configure them as hosts; use the logfile file to store the file name of the current binlog, and the logpos file to store the location of the current binlog. Configure the tables that need to be synchronized and the tables that need special processing in the configuration file.

[0023] Step 2: Initialize between server A and server B, so that the two hosts are in the same initial state;

[0024] (2.1) Server A packs the tables, confi...

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 binlog-based configurable mysql database real-time synchronization method. The method is triggered on the basis of a mysql action event, and interactive action of a user among a database influencing configuration operation of a system, a configuration file and an underlying system on a page can be all executed by a backup server in one mysql action event, namely that a certain action of the user done at a main server can be completely copied to the backup server in real time. Consistent configuration of two servers in hot standby is guaranteed, service can be normally provided after switching, and the reliability and stability of the system are improved.

Description

technical field [0001] The invention relates to the field of data synchronization, in particular to a binlog-based configurable mysql database real-time synchronization method. Background technique [0002] Hot standby is a disaster recovery method for servers, and it is a backup form of servers. When the main server fails, the system automatically activates the backup server to complete the service switchover. Therefore, the configuration between the two servers should be synchronized. Although mysql provides a database replication function, which can realize the synchronization of two databases, there are also many file synchronization software that can synchronize files. However, the synchronization of the database and files in this way is independent of each other, which may cause inconsistencies between the database and configuration files, and in some applications that interact with the underlying system, those interactive actions cannot be synchronized, resulting in i...

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
CPCG06F16/275
Inventor 陈云吴建波
Owner PALADI NETWORK TECH HANGZHOU
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