A method and device for improving database availability

Abstract

The present invention provides a method and device for improving the availability of a database, which can automatically detect and automatically execute a switching scheme when a database fails, thereby improving the availability of the database; at the same time, it prevents operation and maintenance personnel from checking the database in real time and reduces human supervision costs. The method for improving database availability of the present invention includes: the database server sends the database availability detection task to the client that has established a database connection according to the set rule at a set time interval; the database server receives the database returned by the client. After the unavailable detection report, set up the anomaly detection task of the database, and distribute the anomaly detection task to N clients; after the database server receives the abnormal detection report of the database returned by the N clients , according to the number of database anomaly detection reports received, it is determined that the database is a faulty database, and the database is switched to a standby database of the database.

Description

technical field [0001] The invention relates to the technical field of computers and software thereof, in particular to a method and device for improving database usability. Background technique [0002] With the rapid development of the Internet, various data of Internet companies have shown explosive growth. Although there are many distributed non-relational database NoSql to solve some of the problems caused by data growth, there are still some businesses that require relational databases. for support. Existing relational databases are weak in distributed deployment of distributed things, especially when the amount of data is large, stand-alone databases become a performance bottleneck; although many companies' products are using their own data level segmentation rules, they only Can temporarily solve database performance problems. [0003] In the existing technical solution, if the database fails, the interrupted service needs to wait for the database problem to be res...

AI Technical Summary

Problems solved by technology

[0005] 1. When the database fails, it is often not immediately discovered by the operation and maintenance personnel. It is necessary to manually determine the problem and then implement the master-slave database switching plan, and the database switching needs to be completed with the cooperation of multiple parties, and the problem cannot be repaired immediately.

[0006] 2. Due to the unpredictable timing of database problems, operation and maintenance personnel are required to be on duty 7 x 24 hours to check, which increases the cost of human supervision

[0007] 3. Since the existing technical solution is not distributed, there is a separate layer of middleware between the application and the database, and the application accesses the database through the middleware, so once a single middleware fails, the server will be unavailable, and All requests access the middleware, which will slow down the response speed of the middleware and cause the overall performance to drop, resulting in a single point of failure unavailable or a single point of performance bottleneck

[0008] 4. In the existing technical solution, when the client connects to the database, the developer configures it according to the database configuration information, so that the important information of the database is transparent to the developer, thereby creating a security risk

Images