Database service switching method and device, readable storage medium and computer equipment

A database and master database technology, applied in the computer field, can solve problems such as response delays in upper-layer services, and achieve the effect of avoiding response delays

Pending Publication Date: 2019-11-05
TENPAY PAID TECH
View PDF0 Cites 10 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] Based on this, it is necessary to provide a database service switching method, device, computer-readable storage medium and computer equipment for the technical problem of response delay in accessing upper-layer services after switching using the traditional database service switching method

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
  • Database service switching method and device, readable storage medium and computer equipment
  • Database service switching method and device, readable storage medium and computer equipment
  • Database service switching method and device, readable storage medium and computer equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0032] In order to make the purpose, technical solution and advantages of the present application clearer, the present application will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present application, and are not intended to limit the present application.

[0033] figure 1 It is an application environment diagram of the database service switching method in an embodiment. refer to figure 1 , the database service switching method is applied to a database service switching system. The database service switching system includes a terminal 110 and a server 120 . Terminal 110 and server 120 are connected via a network. The terminal 110 may specifically be a desktop terminal or a mobile terminal, and the mobile terminal may specifically be at least one of a mobile phone, a tablet computer, a notebook computer, and the like. The...

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 relates to a database service switching method and a device, a readable storage medium and computer equipment, and the method comprises the steps: obtaining the priority data of a slavedatabase in a database cluster when a master database of the database cluster cannot provide a service; and obtaining the slave database with the highest priority according to the priority data, taking the slave database with the highest priority as a new master database, and switching the master database of the database cluster into the new master database. And when the data corresponding to theupper-layer business is deployed in multiple sets of database clusters and the main databases of the multiple sets of database clusters cannot provide services, the switching sequence of the databasesis controlled through the priority data, so that the multiple sets of database clusters can be switched to the same slave database. Therefore, striped access of upper-layer services is realized, thatis, the upper-layer services are accessed in the same database, and a delay effect caused by cross-database access is avoided.

Description

technical field [0001] The present application relates to the field of computer technology, in particular to a database service switching method, device, readable storage medium and computer equipment. Background technique [0002] With the popularization of computers and the rapid development of Internet technology, higher requirements are put forward for database services. At present, relational databases are widely used. MySQL database is a typical relational database. MySQL database mostly adopts a replication architecture with one master and multiple slaves. machine (slave database) schema. However, in the actual use of the MySQL database, the hosts in the MySQL database often go down due to various reasons, resulting in the failure of the entire MySQL database cluster. At this time, it is necessary to switch the database service. After the traditional database service switching method is used to switch, the access of the upper layer service will have a problem of res...

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): G06F16/27G06F16/21G06F16/23G06F16/28
CPCG06F16/21G06F16/2365G06F16/275G06F16/284
Inventor 赖明星姜承尧
Owner TENPAY PAID 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