Primary/backup switching method and device of database

A technology of active-standby switching and data switching, applied in the database field, can solve the problems of cumbersome database active-standby switching process, slow response speed, and high error rate

Active Publication Date: 2016-12-07
金篆信科有限责任公司
View PDF11 Cites 22 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The present invention provides a method and device for switching between active and standby databases, the purpose of which is to so

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
  • Primary/backup switching method and device of database
  • Primary/backup switching method and device of database
  • Primary/backup switching method and device of database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0088] In order to make the technical problems, technical solutions and advantages to be solved by the present invention clearer, the following will describe in detail with reference to the drawings and specific embodiments.

[0089] see figure 1 , the present invention provides a method and device for switching between active and standby databases. The flow interacts with the first database and the second database, the first database and the second database report a heartbeat message to the management server, and the management server sends a master-standby switch request to the first database and the second database; the first database And the second database interacts through data flow, and the second database synchronizes the heartbeat message of the first database.

[0090] see image 3 , the embodiment of the present invention provides a method for database master / backup switching, which is applied to a management server, including:

[0091] Step 11, monitoring the op...

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 embodiment of the invention provides a primary/backup switching method and device of a database. The method comprises the following steps: monitoring the operation of a first database which serves as a current primary database, and sending a backup-to-primary request to a second database which serves as a current backup database when a the operation exception of the first database is detected; obtaining feedback data reported when he second database is successfully switched to a current primary database since the second database detects that data in the first database and the second database is consistent, and obtaining data switching information which is finally synchronized from the first database by the second database according to the feedback data; and sending a primary-to-backup request which contains the data switching information to the first database to cause the first database to judge that the data synchronized to the second database is not subjected to data loss according to the data switching information, and switching to the current backup database.

Description

technical field [0001] The invention relates to the field of databases, in particular to a method and device for database master / backup switching. Background technique [0002] In today's database applications, high database concurrency and fast data growth are two major characteristics of today's database business. In a short period of time, there may be a large amount of data addition or modification. With the increase in the magnitude of data, from bytes, kilobytes, megabytes to the current 10 gigabytes, combined with the good horizontal expansion characteristics of the database, the distributed database based on the database has been widely used. At the same time, in order to improve the disaster tolerance of the database, various database providers have proposed corresponding strategies. Among them, the master-slave replication strategy, its core idea is that the master database provides external services, and the slave database reads the binary log generated by the ma...

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
IPC IPC(8): G06F17/30
CPCG06F16/00
Inventor 郭龙波陈河堆白涛张宗禹汪彦舒
Owner 金篆信科有限责任公司
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