Method and device for carrying out fault repairing on database management platform

A management platform and fault repair technology, applied in the database field, can solve problems such as high operational complexity, high error rate, database service interruption, etc., to achieve the effect of ensuring normal operation, reducing error rate and labor costs

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

AI Technical Summary

Problems solved by technology

[0006] The present invention provides a fault repair method and device for a database management platform to solve the problem of high operational complexity, high error rate, and database service interruption caused by manual data recovery caused by the complex database structure and large amount of data in the existing solutions questions, etc.

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 carrying out fault repairing on database management platform
  • Method and device for carrying out fault repairing on database management platform
  • Method and device for carrying out fault repairing on database management platform

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0022] 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.

[0023] The fault automatic repair function of the database management platform provided by the embodiment of the present invention does not require manual intervention in the data recovery operation. The database management platform is used to automatically detect the status of the faulty database instance, and the start of the data recovery operation is triggered by the repair command, and the platform can complete the online complete Backup, copy data, establish master-slave relationship, automatically start data synchronization and other operations to realize automatic repair of faults.

[0024] An embodiment of the present invention provides a fault repair method for a database management platform, see figure 1 , the method include...

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 carrying out fault repairing on a database management platform. The method for carrying out the fault repairing on the database management platform, provided by the embodiment of the invention, comprises the steps of judging a role of a fault database instance in an instance group before fault when a repairing command on the fault database instance in the database management platform is received; judging whether a switching record corresponding to the fault database instance can be obtained from a saved switching record table or not when the role of the fault database instance is a main database; establishing a master-slave relation between the fault database instance and a current main database in the instance group by utilizing the switching record when the switching record of the fault database instance is obtained, carrying out synchronous operation of the fault database instance and the current main database, and making the fault database instance online when an online condition is met.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a fault recovery method and device for 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] Initially, the amount of data is still in a small stage. MySQL provides application access in the form of a single instance service that shares a server with the application. When the server has a hardware failure, or the application and MySQL compete for resources, the MySQL resource is exhausted. Crash, or the various restrictions of the low version at that time caused MySQL to run abnormally. At this time, DBA (Database Administrator, database administrator) manual intervention is required to restore the data using the pre-saved...

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/27G06F16/284
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