Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Data synchronization method and device, electronic equipment and storage medium

A data synchronization and data technology, applied in the computer field, can solve the problems that the system cannot quickly respond to user read and write requests, and the performance of system access is reduced, so as to improve user experience, avoid the reduction of system access performance, and ensure rapid response.

Pending Publication Date: 2022-06-07
TENCENT TECH (SHENZHEN) CO LTD +1
View PDF0 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

When HA occurs in MySQL, because the cache of the slave database is different from that of the master database, the slave database needs to load the data required for read and write access from its disk to its cache. This process usually takes several hours to complete. , causing the system to fail to respond quickly to the user's read and write requests, and the system's access performance is reduced

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
  • Data synchronization method and device, electronic equipment and storage medium
  • Data synchronization method and device, electronic equipment and storage medium
  • Data synchronization method and device, electronic equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0058] The technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application. Obviously, the described embodiments are only a part of the embodiments of the present application, but not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by those of ordinary skill in the art without creative work shall fall within the protection scope of the present application.

[0059] It should be noted that the terms "first", "second" and the like in the description and claims of the present application and the above drawings are used to distinguish similar objects, and are not necessarily used to describe a specific sequence or sequence. It is to be understood that data so used may be interchanged under appropriate circumstances so that the embodiments of the application described herein can be practiced in seque...

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 data synchronization method and device, electronic equipment and a storage medium. The method comprises the steps that a data page chain table in a cache instance of a main database is scanned; determining a page number set corresponding to each table space identifier according to the table space identifier and the page number corresponding to each data page in the data page linked list; according to the page number set corresponding to each table space identifier, determining a target data recording range of a table space corresponding to each table space identifier in the main data file; according to the target data recording range of the table space corresponding to each table space identifier in the main data file, cache state information of the main database is generated; and determining a to-be-loaded data page matched with the cache state information in the slave data file, and loading the to-be-loaded data page into the cache of the slave database. According to the method, the cache data of the master database can be accurately, quickly and actively recovered from the slave database, so that the quick response to the read-write request of the user after the HA occurs is ensured, and the reduction of the access performance of the system is avoided.

Description

technical field [0001] The present application relates to the field of computer technology, and in particular, to a data synchronization method, apparatus, electronic device, and storage medium. Background technique [0002] Master-slave replication means that one server acts as the master database server, another or more servers act as the slave database server, and the data in the master database server is automatically copied to the slave database server. MySQL is a relational database management system. MySQLHA (Highly Available) means that in order to ensure high availability, when the primary database of MySQL is down for some reason, the read and write business access traffic of the primary database will be switched to the standby slave. database, let the slave database continue to provide services. [0003] In the related art, the basis of MySQL master-slave replication is that the master database records changes in the binary log, and the slave database automatical...

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): G06F16/27G06F16/2455
CPCG06F16/27G06F16/24552
Inventor 陈松威
Owner TENCENT TECH (SHENZHEN) CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com