Troubleshooting method, device, server and storage medium

Abstract

The present application proposes a fault handling method, device, server, and storage medium. The method is applied to the server, including: detecting whether a master database fails; if so, determining a new master database from at least one slave database, and performing a failover of the master database; obtain the routing configuration file; modify the routing information in the routing configuration file by calling the routing configuration tool through the first middleware, and obtain the updated routing configuration file; if the second middleware detects the routing configuration The routing information in the file is changed, the updated routing configuration file is reloaded, and the data connection between the second middleware and the new primary database is re-established. This application uses a self-developed routing configuration tool to automatically modify the routing information of the read-write separation middleware, which not only improves the high availability of the database, but also reduces manual intervention, saves labor costs, and realizes rapid self-healing of business traffic.

Description

technical field [0001] The present application mainly relates to the computer field, and specifically relates to a fault handling method, device, server and storage medium. Background technique [0002] As an infrastructure for storing data, databases are widely used in fields such as computers and network communications. In the face of problems such as large data volume, complex business and high response delay requirements, the use of database clusters can separate reads and writes and improve the system performance of the database. A database cluster usually includes a master database and one or more slave databases, wherein the master database is responsible for writing data, the slave database is responsible for reading data, and the slave database backs up data from the master database. When the primary database fails, the secondary database can be promoted to the primary database, thereby reducing the downtime of the business and ensuring high availability of the dat...

AI Technical Summary

Problems solved by technology

[0004] However, open source tools that provide high availability and read-write separation generally exist independently. When a database failure occurs, manual intervention is required, and business traffic is difficult to heal itself.

Images