Method and device for synchronizing database instance in database management platform

A management platform and database technology, applied in the database field, can solve the problems of high labor cost, error-prone, low efficiency, etc., and achieve the effect of reducing management cost, improving success rate and synchronization efficiency

Active Publication Date: 2014-12-31
BEIJING FEINNO COMM TECH
View PDF6 Cites 8 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The present invention provides a method and device for synchronizing database instances in a database management platform to solve the existing problems of high labor cost, error-prone and low efficiency caused by manual 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
  • Method and device for synchronizing database instance in database management platform
  • Method and device for synchronizing database instance in database management platform

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0023] In order to make the object, technical solution and advantages of the present invention clearer, the implementation manner of the present invention will be further described in detail below in conjunction with the accompanying drawings.

[0024] A method for synchronizing database instances in a database management platform provided by an embodiment of the present invention, see figure 1 , the method is suitable for step S100, including the following:

[0025] S100: Judging whether the database instance (slave library) that needs to be synchronized has ever established a synchronization relationship, that is, judging whether the database instance that needs to be synchronized is a slave database that has established a synchronization relationship. When the database instance is a database instance that has established a synchronization relationship When the database instance is a slave database, enter step S101, and when the database instance is a quasi-slave database th...

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 method and a device for synchronizing a database instance in a database management platform. The method for synchronizing the database instance in the database management platform comprises the following steps of judging whether a database instance required to create synchronization is a sub base in which synchronization relation is created or not; if so, detecting whether the current synchronization state of the sub base is normal or not; when the current synchronization state of the sub base is abnormal, judging whether a switching record of the sub base can be acquired or not; if the switching record of the sub base can be acquired, when a main base recorded in the switching record is matched with a main base recorded in the sub base, starting the operation of creating the synchronization relation between the sub base and the corresponding main base; if the switching record of the sub base cannot be acquired or the main base recorded in the switching record is not matched with the main base recorded in the sub base, acquiring a synchronization command, and creating the synchronization relation between the sub base and the corresponding main base by using the synchronization command.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a method and device for synchronizing database instances in a database management platform. Background technique [0002] The MySQL database has been serving Internet companies for ten years. Among many relational database products, the storage engine characteristics of MySQL make it gradually become the data storage medium of choice for various business models. [0003] With the continuous updating of Internet products, the type of data stored in the database has changed from simple storage of information to storage of multi-dimensional data such as transactions, points, logs, and user dynamics. The server is equipped, and the database structure is also increased from a single instance to a multi-instance. [0004] Currently, the mainstream architecture used by MySQL in the industry consists of a master database (Master) and more than one (including one) slave database (Slave...

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 BEIJING FEINNO COMM TECH
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