Database access method, system and device and readable storage medium

A database and master database technology, applied in the field of database access, can solve problems such as loss of high availability, long time, large business impact, etc., and achieve the effect of high availability access

Pending Publication Date: 2021-01-29
政采云有限公司
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] However, after the MHA failover, the IP of the database server changes, and the application needs to modify the corresponding configuration to reconnect. This modification process takes a lot of time and has a relatively large impact on the business, thus losing high availability for the application. the meaning of

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 access method, system and device and readable storage medium
  • Database access method, system and device and readable storage medium
  • Database access method, system and device and readable storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0046] The core of the present application is to provide a method, system, device and readable storage medium for database access, which are used to realize highly available domain name access after database failover.

[0047] In order to make the purposes, technical solutions and advantages of the embodiments of the present application clearer, the technical solutions in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments It is a part of the embodiments of this application, not all of them. Based on the embodiments in this application, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the scope of protection of this application.

[0048] Please refer to figure 1 , figure 1 It is a flow chart of a database access method provided by the embodiment of this applic...

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 database access method. The method comprises the steps of detecting an identity of a to-be-detected node; when the identity of the to-be-tested node changes, judging whetherthe current identity of the to-be-tested node is a main node or not; if so, registering the address and the port of the main node to a registration center; establishing a first corresponding relationship between the main node and the write server through the registration center, wherein the application program accesses a main database located at the main node through the write server. By utilizingthe service discovery characteristic of the registration center, the application program can access the main database located at the main node through the write server without worrying about whetherthe IPs of the write node database and the read-only node database are changed or not, the application is not perceived during database fault switching, the execution of the service is not influenced,and high-availability access of the domain name after database fault switching is realized. The invention furthermore provides a database access system and device, and a readable storage medium, which have the above beneficial effects.

Description

technical field [0001] The present application relates to the field of database access, in particular to a database access method, system, device and readable storage medium. Background technique [0002] For Internet companies, the use of databases is becoming more and more extensive, and the availability of database services is becoming more and more important. In order to achieve high availability of database services, currently more commonly used or relatively mature solutions are based on high availability software MHA (Master High Availability) to manage databases. [0003] MHA is a script management tool written in Perl language. This tool is an excellent high-availability software for failover and master-slave promotion in a high-availability database environment. In the process of database failover, MHA can complete the database failover operation within 0~30s, and in the process of failover, MHA can ensure the consistency of data to the greatest extent, so as to a...

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/20
CPCG06F11/2023
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