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

Master-slave database switching method, computing device and storage medium

A master database and database technology, applied in the database field, can solve problems such as unusable business, reduce database switching efficiency, and enhance user fault perception, so as to improve overall efficiency and avoid data loss.

Active Publication Date: 2021-03-02
ZHANGYUE TECH CO LTD
View PDF10 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] However, the inventor found in the process of implementing the embodiments of the present invention that the above-mentioned prior art has at least the following technical problems: in the above-mentioned prior art, it is necessary to have the authority of each database, and use this authority to get data in the master database and to The obtained data is sent to the new master database, which will greatly reduce the efficiency of database switching, make the business unusable for a long time, and enhance the user's fault perception

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
  • Master-slave database switching method, computing device and storage medium
  • Master-slave database switching method, computing device and storage medium
  • Master-slave database switching method, computing device and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0024] Exemplary embodiments of the present invention will be described in more detail below with reference to the accompanying drawings. Although exemplary embodiments of the present invention are shown in the drawings, it should be understood that the invention may be embodied in various forms and should not be limited to the embodiments set forth herein. Rather, these embodiments are provided for more thorough understanding of the present invention and to fully convey the scope of the present invention to those skilled in the art.

[0025] figure 1 A flow chart of a master-slave database switching method provided by an embodiment of the present invention is shown. This method is used to switch a slave database in the master-slave database to a new master database when the current master database is down. The method can be executed by any computing device capable of processing data. Preferably, the computing device has a switching system dedicated to master-slave database ...

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 master-slave database switching method, a computing device and a storage medium. The method includes: monitoring whether the current first master database is down; Data synchronization position information of each slave database, select a temporary second master database from multiple slave databases; use the master-slave synchronization function to synchronize the data to be synchronized in the temporary second master database to other slave databases; select a new second master database Three master databases; use the plug-in in the first master database to read the data to be synchronized in the first master database, write the data to be synchronized in the first master database into the third master database; update the switched data Configuration information of the master-slave database. Through the above solution of the present invention, when the current master database is down, a slave database can be switched to master data in a timely manner, and no data loss can be ensured.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a master-slave database switching method, computing equipment and storage media. Background technique [0002] The master-slave database is usually composed of a master database and multiple slave databases. The master database has the functions of data reading and writing at the same time, and the slave database can provide business parties independently by keeping in sync with the data in the master database. The data reading function disperses the access pressure of the main database, and solves the problem of slow reading data only from the main database. At the same time, maintaining the availability of the master database is the prerequisite for realizing the above-mentioned master database reading and writing and pressure sharing, that is, it is necessary to always maintain the master data that normally provides data read and write functions. [0003] In the prior art, ...

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): G06F11/14G06F16/21G06F16/27
CPCG06F11/1461G06F16/21G06F16/27
Inventor 冯威胡子麟
Owner ZHANGYUE 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