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

Data synchronization method and device for a database

A data synchronization and database technology, applied in the database field, can solve the problems of waste of system resources, scattered data storage, inability to perform centralized query, etc., and achieve the effect of solving the waste of resources

Active Publication Date: 2018-06-15
BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD +1
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In this case, the data storage is scattered, and centralized query cannot be performed, and only the master database provides production services, while the slave database does not provide services, resulting in a waste of a lot of system resources

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 for a database
  • Data synchronization method and device for a database
  • Data synchronization method and device for a database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0044] In order to make the purpose, technical solution and advantages of the present invention more clear, the present invention will be further described in detail below with reference to the accompanying drawings and examples.

[0045] Such as figure 1 As shown, the data synchronization method of the database of the present invention includes:

[0046] Step 1. Monitor database events of at least one master database server;

[0047] Step 2. When the main database server executes the database event, read the database event from the main database server and store it in an event queue;

[0048] Step 3, read the database event from the event queue, and send the read database event to a slave database server;

[0049] Step 4. The slave database server executes the received database event.

[0050] Wherein, there is at least one master database in the master database server; at least one slave database is stored in the slave database server; the slave database stored in the sla...

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 synchronizing method and device of a database. The method includes the steps of monitoring database events of at least one primary database server; reading the database events from the primary database servers and storing the events in an event queue when the primary database servers execute the database events; reading the database events from the event queue and sending the read database events to a secondary database server; executing the received database events through the secondary database server. By means of the method and device, data synchronizing from multiple primary database servers to a single secondary database server of a MySQL database is achieved, and therefore the problem that backup from the primary database servers to the single secondary database server of the MySQL database cannot be conducted is solved, the problem that resources are wasted when multiple secondary database servers conduct the backup is solved as well, and the problem that no centralized place for providing query for sub-database sub-table items in the MySQL database exists is solved.

Description

technical field [0001] The invention relates to database technology, in particular to a database data synchronization method and device. Background technique [0002] MySQL is a relational database management system. Because of its small size, fast speed, low total cost of ownership, and open source, it is widely used in the development and use of small and medium-sized websites. [0003] In order to prevent problems such as data damage and loss during system operation, the database system requires regular and / or irregular maintenance, backup and other work. In addition, in order to ensure the stability of the system, the database system also adopts a data synchronization scheme, such as a master-slave database. The master database and the slave database are located in different servers, and the master database and the slave database store the same data content. Next, the data synchronization operation is performed between the master database and the slave database, so that...

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 Patents(China)
IPC IPC(8): G06F17/30
CPCG06F16/27G06F16/284
Inventor 赵晓平唐超马丽伟秦波王锋
Owner BEIJING JINGDONG SHANGKE INFORMATION TECH 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