Master-slave database switching method, computing equipment 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: 2020-12-01
ZHANGYUE TECH CO LTD
View PDF10 Cites 3 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 equipment and storage medium
  • Master-slave database switching method, computing equipment and storage medium
  • Master-slave database switching method, computing equipment 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, computing equipment and a storage medium. The method comprises the steps of monitoring whether a current first master database crashesor not; when it is monitored that the current first master database crashes, selecting a temporary second master database from a plurality of slave databases according to the data synchronization position information of each slave database; synchronizing the temporary to-be-synchronized data of the second master database to other slave databases by utilizing a master-slave synchronization function; selecting a new third main database; reading to-be-synchronized data of the first main database by utilizing a plug-in in the first main database, and writing the to-be-synchronized data of the first main database into the third main database; and updating the configuration information of the master-slave database after switching. By means of the scheme, when the current master database crashes, the slave database can be switched into the master data in time, and it can be guaranteed that the data is not lost.

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 Applications(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 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