CN117215841A

CN117215841A - Database switching method, device, computer equipment and readable storage medium

Info

Publication number: CN117215841A
Application number: CN202311139657.1A
Authority: CN
Inventors: 郭明月
Original assignee: Ping An E Wallet Electronic Commerce Co Ltd
Current assignee: Ping An E Wallet Electronic Commerce Co Ltd
Priority date: 2023-09-04
Filing date: 2023-09-04
Publication date: 2023-12-12

Abstract

The application discloses a database switching method, a database switching device, computer equipment and a readable storage medium, relates to the technical field of database operation and maintenance, and solves the problem that the switching efficiency is reduced when the switching failure is very easy to occur after the switching of a database at present. The method comprises the following steps: receiving a database performance detection instruction, and determining a database cluster to be detected indicated by the database performance detection instruction, wherein the database performance detection instruction carries a plurality of pieces of performance information to be detected; determining a main database and a backup database in a database cluster to be detected, and performing performance detection on the main database and the backup database according to a plurality of pieces of performance information to be detected to obtain a plurality of detection results; and when the detection results indicate that the detection is passed, switching the service currently processed by the main database to the backup database for processing.

Description

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

Technical Field

The application belongs to the technical field of database operation and maintenance, and in particular relates to a database switching method, a database switching device, computer equipment and a readable storage medium.

Background

The high availability cluster means that when a server fails, services, resources, IP (Internet Protocol ) and the like in the server can be transferred to another server, so that the continuity of service is satisfied, and the two or more servers form the server high availability cluster.

In the practical application process, a situation of high availability switching of the primary and the secondary in the database cluster is often encountered, for example, when a machine fails and the configuration of the primary database is adjusted, the primary database needs to be switched, and the service being processed by the primary database is transferred to the backup database. However, the applicant realizes that most companies in the industry mainly adopt a page switching mode to switch the active and standby databases in a single database cluster, and the switching step simply calls a switching command, so that the databases are very prone to switching failure after switching, and the switching efficiency is reduced.

Disclosure of Invention

In view of the above, the present invention provides a database switching method, device, computer device and readable storage medium, and aims to solve the problem that the switching efficiency is reduced when the database is very prone to failure after switching.

According to a first aspect of the present application, there is provided a database switching method, comprising:

receiving a database performance detection instruction, and determining a database cluster to be detected indicated by the database performance detection instruction, wherein the database performance detection instruction carries a plurality of pieces of performance information to be detected;

determining a main database and a backup database in the database cluster to be detected, and performing performance detection on the main database and the backup database according to the performance information to be detected to obtain a plurality of detection results;

and when the detection results indicate that the detection is passed, switching the service currently processed by the main database to the backup database for processing.

Optionally, determining a primary database and a backup database in the database cluster to be detected, performing performance detection on the primary database and the backup database according to the performance information to be detected, to obtain a plurality of detection results, including:

when the to-be-detected performance information in the plurality of to-be-detected performance information indicates to detect a database state, a first database state of the main database and a second database state of the backup database are read, and a detection result is generated according to the first database state and the second database state, wherein when the first database state and the second database state indicate normal, a detection result indicating that detection is passed is generated, and when the first database state or the second database state indicates abnormal, a detection result indicating that detection is failed is generated; and/or the number of the groups of groups,

When the to-be-detected performance information in the plurality of to-be-detected performance information indicates to detect a high-availability progress state of a database cluster, reading a secure shell protocol ssh secret-free login permission of the database cluster, and reading master-slave replication states of the master database and the backup database, and generating a detection result according to the ssh secret-free login permission and the master-slave replication states, wherein a detection result indicating that detection is passed is generated when the ssh secret-free login permission and the master-slave replication states indicate normal, and a detection result indicating that detection is failed is generated when the ssh secret-free login permission or the master-slave replication states indicate abnormal; and/or the number of the groups of groups,

when the performance information to be detected in the plurality of performance information to be detected indicates to detect the core parameters, reading a first core parameter of the main database and a second core parameter of the backup database, and generating a detection result according to the first core parameter and the second core parameter, wherein when the first core parameter is consistent with the second core parameter, a detection result indicating that the detection is passed is generated, and when the first core parameter is inconsistent with the second core parameter, a detection result indicating that the detection is not passed is generated; and/or the number of the groups of groups,

When the performance information to be detected in the plurality of performance information to be detected indicates long transaction detection, reading a long transaction which is running in the main database, and generating a detection result according to the long transaction, wherein when the long transaction is not running in the main database, a detection result indicating that detection is passed is generated, and when the long transaction is running in the main database, a detection result indicating that detection is not passed is generated.

Optionally, the method further comprises:

acquiring account information initiating a database performance detection instruction;

acquiring a white list and detecting whether the white list comprises the account information;

generating a verification passing prompt when the white list is determined to comprise the account information, and sending the verification passing prompt to a client logged in with the account information;

and when a database switching instruction of the client is received, switching the service currently processed by the main database to the backup database for processing, wherein the database switching instruction is initiated by a user of the client after receiving the verification passing prompt.

Optionally, in a process of switching a service currently processed by the primary database to the backup database for processing, the method further includes:

Inquiring read-only parameters of the main database and the backup database, and reading a first initial parameter value corresponding to the read-only parameters of the main database and a second initial parameter value corresponding to the read-only parameters of the backup database, wherein the first initial parameter value indicates that an initial role of the main database is a main database role, and the second initial parameter value indicates that the initial role of the backup database is a backup database role;

transmitting the first initial parameter value and the second initial parameter value to a client initiating a database performance detection instruction, so that the client marks the main database by adopting the main database description field based on the received first initial parameter value, and marks the backup database by adopting the backup database description field based on the received second initial parameter value;

inquiring read-only parameters of the main database and the backup database at preset time intervals, and reading current parameter values corresponding to the read-only parameters of the main database and/or the backup database when detecting that the read-only parameters of the main database and/or the backup database change;

And sending the current parameter values corresponding to the read-only parameters of the main database and/or the backup database to the client so that the client adopts a backup database description field to remark the main database based on the received current parameter values corresponding to the read-only parameters of the main database and/or adopts a main database description field to remark the backup database based on the received current parameter values corresponding to the read-only parameters of the backup database.

obtaining a virtual Internet Protocol (IP) address of the backup database;

based on the virtual IP address, sending a connection request to the backup database at intervals of preset time, and receiving a connection success identifier or a connection failure identifier returned by the backup database;

and sending the connection success identifier or the connection failure identifier returned by the backup database to the client, wherein the client marks the backup database by adopting the connection success identifier or the connection failure identifier based on the received connection success identifier or the connection failure identifier returned by the backup database.

Optionally, after the service currently processed by the primary database is switched to the backup database for processing, the method further includes:

receiving a connection state detection instruction, and acquiring a primary application host list of the main database from an operation record of the main database, wherein the primary application host list comprises a plurality of server IP addresses connected with the main database before database switching;

acquiring a current application host list of the backup database from an operation record of the backup database, wherein the current application host list comprises a plurality of current server IP addresses which are connected with the backup database currently;

comparing a plurality of server IP addresses included in the original application host list with the current host list;

if the current host list comprises the plurality of server IP addresses, determining that a plurality of application systems corresponding to the plurality of server IP addresses are connected to the backup database;

if the current host list is determined not to comprise at least one server IP address in the plurality of server IP addresses, generating a connection failure reminder of the at least one server IP address, and sending the connection failure reminder of the at least one server IP address to a client initiating the connection state detection instruction.

Optionally, the method further comprises:

when the received database performance detection instruction indicates performance detection on a plurality of database clusters, determining a main database and a backup database in each database cluster in the plurality of database clusters, and determining a plurality of pieces of performance information to be detected carried by the database performance detection instruction;

performing performance detection on the main database and the backup database of the database clusters in parallel according to the performance information to be detected to obtain a plurality of detection results corresponding to each database cluster;

determining at least one target database cluster in the plurality of database clusters, and simultaneously switching the currently processed service of the main database of each target database cluster in the at least one target database cluster to the backup database of the target database for processing based on an asynchronous processing thread, wherein a plurality of detection results corresponding to the at least one target database cluster indicate that the detection is passed.

According to a second aspect of the present application, there is provided a database switching apparatus comprising:

the determining module is used for receiving a database performance detection instruction and determining a database cluster to be detected indicated by the database performance detection instruction, wherein the database performance detection instruction carries a plurality of pieces of performance information to be detected;

The detection module is used for determining a main database and a backup database in the database cluster to be detected, and performing performance detection on the main database and the backup database according to the plurality of pieces of performance information to be detected to obtain a plurality of detection results;

and the switching module is used for switching the service currently processed by the main database to the backup database for processing when the detection results indicate that the detection is passed.

Optionally, the detection module is further configured to: when the to-be-detected performance information in the plurality of to-be-detected performance information indicates to detect a database state, a first database state of the main database and a second database state of the backup database are read, and a detection result is generated according to the first database state and the second database state, wherein when the first database state and the second database state indicate normal, a detection result indicating that detection is passed is generated, and when the first database state or the second database state indicates abnormal, a detection result indicating that detection is failed is generated; and/or when the performance information to be detected in the plurality of performance information to be detected indicates to detect the high available process state of the database cluster, reading the secure shell protocol ssh secret-free login permission of the database cluster, and reading the master-slave replication state of the master database and the backup database, and generating a detection result according to the ssh secret-free login permission and the master-slave replication state, wherein when the ssh secret-free login permission and the master-slave replication state indicate normal, a detection result indicating that detection is passed is generated, and when the ssh secret-free login permission or the master-slave replication state indicate abnormal, a detection result indicating that detection is failed is generated; and/or when the performance information to be detected in the plurality of performance information to be detected indicates to detect the core parameter, reading a first core parameter of the main database and a second core parameter of the backup database, and generating a detection result according to the first core parameter and the second core parameter, wherein when the first core parameter is consistent with the second core parameter, a detection result indicating that the detection is passed is generated, and when the first core parameter is inconsistent with the second core parameter, a detection result indicating that the detection is not passed is generated; and/or when the performance information to be detected in the plurality of performance information to be detected indicates that long transaction detection is performed, reading the long transaction which is running in the main database, and generating a detection result according to the long transaction, wherein when the long transaction is not running in the main database, a detection result indicating that the detection is passed is generated, and when the long transaction is running in the main database, a detection result indicating that the detection is not passed is generated.

Optionally, the apparatus further comprises:

the first detection module is used for acquiring account information for initiating a database performance detection instruction; acquiring a white list and detecting whether the white list comprises the account information; generating a verification passing prompt when the white list is determined to comprise the account information, and sending the verification passing prompt to a client logged in with the account information; and when a database switching instruction of the client is received, switching the service currently processed by the main database to the backup database for processing, wherein the database switching instruction is initiated by a user of the client after receiving the verification passing prompt.

Optionally, the apparatus further comprises:

the first query module is used for querying read-only parameters of the main database and the backup database, and reading a first initial parameter value corresponding to the read-only parameters of the main database and a second initial parameter value corresponding to the read-only parameters of the backup database, wherein the first initial parameter value indicates that an initial role of the main database is a main database role, and the second initial parameter value indicates that the initial role of the backup database is a backup database role;

The first labeling module is used for sending the first initial parameter value and the second initial parameter value to a client side initiating a database performance detection instruction, so that the client side adopts the main database description field to label the main database based on the received first initial parameter value, and adopts the backup database description field to label the backup database based on the received second initial parameter value;

the second query module is used for querying the read-only parameters of the main database and the backup database at intervals of preset time intervals, and when detecting that the read-only parameters of the main database and/or the backup database change, the second query module reads the current parameter values corresponding to the read-only parameters of the main database and/or the backup database;

and the second labeling module is used for sending the current parameter values corresponding to the read-only parameters of the main database and/or the backup database to the client so that the client adopts a backup database description field to remark the main database based on the received current parameter values corresponding to the read-only parameters of the main database and/or adopts a main database description field to remark the backup database based on the received current parameter values corresponding to the read-only parameters of the backup database.

Optionally, the apparatus further comprises:

a first obtaining module, configured to obtain a virtual internet protocol IP address of the backup database;

the connection module is used for sending a connection request to the backup database at intervals of preset time based on the virtual IP address and receiving a connection success identifier or a connection failure identifier returned by the backup database;

and the sending module is used for sending the connection success identifier or the connection failure identifier returned by the backup database to the client, wherein the client marks the backup database by adopting the connection success identifier or the connection failure identifier based on the received connection success identifier or the connection failure identifier returned by the backup database.

Optionally, the apparatus further comprises:

the second acquisition module is used for receiving a connection state detection instruction, and acquiring a primary application host list of the main database from an operation record of the main database, wherein the primary application host list comprises a plurality of server IP addresses connected with the main database before database switching;

a third obtaining module, configured to obtain a current application host list of the backup database from an operation record of the backup database, where the current application host list includes a plurality of current server IP addresses currently connected to the backup database;

The comparison module is used for comparing the IP addresses of the servers included in the original application host list with the current host list;

the judging module is used for determining that a plurality of application systems corresponding to the plurality of server IP addresses are connected to the backup database if the current host list comprises the plurality of server IP addresses; if the current host list is determined not to comprise at least one server IP address in the plurality of server IP addresses, generating a connection failure reminder of the at least one server IP address, and sending the connection failure reminder of the at least one server IP address to a client initiating the connection state detection instruction.

Optionally, the apparatus further comprises:

the first determining module is used for determining a main database and a backup database in each database cluster in the database clusters when the received database performance detection instruction indicates performance detection of the database clusters, and determining a plurality of pieces of performance information to be detected carried by the database performance detection instruction;

the second detection module is used for carrying out performance detection on the main database and the backup database of the database clusters in parallel according to the performance information to be detected to obtain a plurality of detection results corresponding to each database cluster;

The first switching module is used for determining at least one target database cluster in the plurality of database clusters, and simultaneously switching the currently processed service of the main database of each target database cluster in the at least one target database cluster to the backup database of the target database for processing based on an asynchronous processing thread, wherein a plurality of detection results corresponding to the at least one target database cluster indicate that the detection is passed.

According to a third aspect of the present application there is provided a computer device comprising a memory storing a computer program and a processor implementing the steps of the method of any of the first aspects described above when the computer program is executed by the processor.

According to a fourth aspect of the present application there is provided a computer readable storage medium having stored thereon a computer program which when executed by a processor performs the steps of the method of any of the first aspects described above.

By means of the technical scheme, the database switching method provided by the application receives the database performance detection instructions carrying the performance information to be detected, determines the database cluster to be detected indicated by the database performance detection instructions, determines the main database and the backup database in the database cluster to be detected, performs performance detection on the main database and the backup database according to the performance information to be detected to obtain a plurality of detection results, switches the service currently processed by the main database to the backup database for processing when the detection results indicate that the detection is passed, performs performance detection on the main database and the backup database in the database cluster before switching the databases, and switches the service currently processed by the main database to the backup database for processing when no problem of the performance of the main database and the backup database is detected, thereby reducing the probability of switching failure, and solving the problems that the switching failure is extremely easy to occur and the switching efficiency is reduced after the switching of the existing databases.

The foregoing description is only an overview of the present application, and is intended to be implemented in accordance with the teachings of the present application in order that the same may be more clearly understood and to make the same and other objects, features and advantages of the present application more readily apparent.

Drawings

Various other advantages and benefits will become apparent to those of ordinary skill in the art upon reading the following detailed description of the preferred embodiments. The drawings are only for purposes of illustrating the preferred embodiments and are not to be construed as limiting the application. Also, like reference numerals are used to designate like parts throughout the figures. In the drawings:

fig. 1 shows a flowchart of a database switching method according to an embodiment of the present application.

Fig. 2 shows a flowchart of another database switching method according to an embodiment of the present application.

Fig. 3 shows a flowchart of another database switching method according to an embodiment of the present application.

Fig. 4A shows a schematic structural diagram of a database switching device according to an embodiment of the present application.

Fig. 4B is a schematic structural diagram of a database switching device according to an embodiment of the present application.

Fig. 4C shows a schematic structural diagram of a database switching device according to an embodiment of the present application.

Fig. 4D shows a schematic structural diagram of a database switching device according to an embodiment of the present application.

Fig. 4E shows a schematic structural diagram of a database switching device according to an embodiment of the present application.

Fig. 5 is a schematic structural diagram of another database switching device according to an embodiment of the present application.

Fig. 6 shows a schematic device structure of a computer device according to an embodiment of the present application.

Detailed Description

Various aspects and features of the present application are described herein with reference to the accompanying drawings.

It should be understood that various modifications may be made to the embodiments of the application herein. Therefore, the above description should not be taken as limiting, but merely as exemplification of the embodiments. Other modifications within the scope and spirit of the application will occur to persons of ordinary skill in the art.

The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments of the application and, together with a general description of the application given above, and the detailed description of the embodiments given below, serve to explain the principles of the application.

These and other characteristics of the application will become apparent from the following description of a preferred form of embodiment, given as a non-limiting example, with reference to the accompanying drawings.

It is also to be understood that, although the application has been described with reference to some specific examples, those skilled in the art can certainly realize many other equivalent forms of the application.

The above and other aspects, features and advantages of the present application will become more apparent in light of the following detailed description when taken in conjunction with the accompanying drawings.

Specific embodiments of the present application will be described hereinafter with reference to the accompanying drawings; however, it is to be understood that the disclosed embodiments are merely exemplary of the application, which can be embodied in various forms. Well-known and/or repeated functions and constructions are not described in detail to avoid obscuring the application in unnecessary or unnecessary detail. Therefore, specific structural and functional details disclosed herein are not intended to be limiting, but merely as a basis for the claims and as a representative basis for teaching one skilled in the art to variously employ the present application in virtually any appropriately detailed structure.

The specification may use the word "in one embodiment", "in another embodiment", "in a third embodiment ⁱ In yet another embodiment, "or" in other embodiments, "all of which may refer to one or more of the same or different embodiments in accordance with the application.

An embodiment of the present application provides a database switching method, as shown in fig. 1, including:

101. and receiving a database performance detection instruction, and determining a database cluster to be detected indicated by the database performance detection instruction.

At present, when a machine fails or the configuration of a main database is regulated, the database is often required to be switched, the service processed by the main database is transferred to a backup database, most companies in the industry mainly adopt a page switching mode to switch the main database and the backup database in a single database cluster, the switching step only simply calls a switching command, the condition that the database is easy to fail in switching after being switched, and the switching efficiency is reduced. Therefore, the application provides a database switching method, which is used for checking the database clusters before switching the databases, and the main and standby switching can be performed only after the database clusters pass the checking, so that the situation of switching failure is avoided, and the database switching efficiency is improved.

The technical scheme of the application can be executed by a management node in a database cluster, the management node runs on a management server, the database cluster also comprises a plurality of data nodes (also called storage nodes), each data node runs on a server, and the server can be an independent server or a cloud server for providing cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communication, middleware services, domain name services, security services, content distribution networks (Content Delivery Network, CDNs), basic cloud computing services such as big data and artificial intelligent platforms and the like, so that the management node can execute the database switching method. When the management node receives a database performance detection instruction sent by the client, determining a database cluster to be detected indicated by the database performance detection instruction, wherein the database performance detection instruction carries a plurality of pieces of performance information to be detected.

102. And determining a main database and a backup database in the database cluster to be detected, and performing performance detection on the main database and the backup database according to the plurality of pieces of performance information to be detected to obtain a plurality of detection results.

In order to screen out the database cluster without performance problem, performance detection is required to be performed on the database cluster according to a plurality of pieces of performance information to be detected, the database cluster comprises a main database and a backup database, further performance detection is required to be performed on the main data and the backup database of the main database cluster, that is, when a management node receives a database performance detection instruction, the main database and the backup database are determined in the database cluster to be detected indicated by the database performance detection instruction, and performance detection is performed on the main database and the backup database according to a plurality of pieces of performance information to be detected, so as to obtain a plurality of detection results.

It should be noted that, in the actual application process, the database cluster often includes a main database and a plurality of backup databases, if the database cluster includes a plurality of backup databases, performance detection needs to be performed on the main database and the plurality of backup databases according to a plurality of pieces of performance information to be detected to obtain a plurality of detection results.

103. And when the detection results indicate that the detection is passed, switching the service currently processed by the main database to the backup database for processing.

In the embodiment of the application, after the management node obtains a plurality of detection results, whether the plurality of detection results pass detection needs to be judged, and when the plurality of detection results indicate that the detection passes, the service currently processed by the main database is switched to the backup database for processing.

The method provided by the embodiment of the application receives the database performance detection instructions carrying a plurality of pieces of performance information to be detected, determines the database cluster to be detected indicated by the database performance detection instructions, determines the main database and the backup database in the database cluster to be detected, performs performance detection on the main database and the backup database according to the plurality of pieces of performance information to be detected to obtain a plurality of detection results, switches the service currently processed by the main database to the backup database for processing when the plurality of detection results indicate that the detection is passed, performs performance detection on the main database and the backup database in the database cluster before the database is switched, switches the service currently processed by the main database to the backup database for processing when no problem exists in the performances of the main database and the backup database is detected, reduces the probability of switching failure, and solves the problems that the switching failure is very easy to occur and the switching efficiency is reduced after the switching of the existing database.

An embodiment of the present application provides a database switching method, as shown in fig. 2, including:

201. and receiving a database performance detection instruction, and determining a database cluster to be detected indicated by the database performance detection instruction.

In the embodiment of the application, the database performance detection instruction is sent by a client, wherein the client can be a database automation operation and maintenance platform, the database automation operation and maintenance platform is configured with a platform page so that a user can perform related operation on database clusters, the platform page is provided with a database performance detection button and a plurality of database cluster identifications, when the client detects that the user triggers the database performance detection button, the database cluster identifications which are currently checked are extracted from the database cluster identifications, the database clusters corresponding to the database cluster identifications which are currently checked are used as database clusters to be detected, and the database performance detection instruction is generated based on the database clusters to be detected and is sent to a management node. It should be noted that, in the embodiment of the present application, a database cluster identifier is defaulted, and in the actual application process, a plurality of database cluster identifiers may be defaulted, and a plurality of database clusters corresponding to the plurality of database cluster identifiers are used as the database clusters to be detected.

202. And determining a main database and a backup database in the database cluster to be detected, and performing performance detection on the main database and the backup database according to the plurality of pieces of performance information to be detected to obtain a plurality of detection results.

In the embodiment of the application, performance detection is performed on the main database and the backup database in parallel according to a plurality of pieces of performance information to be detected, so as to obtain a plurality of detection results, and the method specifically comprises the following steps:

when the to-be-detected performance information in the plurality of to-be-detected performance information indicates to detect the database state, reading a first database state of the main database and a second database state of the backup database, and generating a detection result according to the first database state and the second database state, wherein when the first database state and the second database state indicate to be normal, a detection result indicating that the detection is passed is generated, and when the first database state or the second database state indicates to be abnormal, a detection result indicating that the detection is not passed is generated; and/or the number of the groups of groups,

when the performance information to be detected in the plurality of performance information to be detected indicates to detect the high-availability progress state of the database cluster, reading the secure shell protocol ssh secret-free login permission of the database cluster, reading the master-slave replication state of the master database and the backup database, and generating a detection result according to the ssh secret-free login permission and the master-slave replication state, wherein when the ssh secret-free login permission and the master-slave replication state indicate normal, a detection result indicating that the detection is passed is generated, and when the ssh secret-free login permission or the master-slave replication state indicates abnormal, a detection result indicating that the detection is not passed is generated; and/or the number of the groups of groups,

when the performance information to be detected in the plurality of performance information to be detected indicates long transaction detection, reading a long transaction which is running in the main database, and generating a detection result according to the long transaction, wherein when the long transaction is not running in the main database, a detection result indicating that the detection is passed is generated, and when the long transaction is running in the main database, a detection result indicating that the detection is not passed is generated.

Further, in the practical application process, performance detection can be performed on the main database and the backup database according to a plurality of pieces of performance information to be detected, which have detection execution sequences, and the specific steps are as follows:

selecting performance information to be detected in the plurality of pieces of performance information to be detected according to the detection execution sequence, and performing performance detection on the main database and the backup database according to the performance information to be detected to obtain a first detection result;

When the first detection result indicates that the detection fails, ending the detection flow, generating a detection failure reminder, sending the detection failure reminder to the client, and when the first detection result indicates that the detection fails, continuing to select second performance information to be detected in the plurality of performance information to be detected according to the detection execution sequence, and performing performance detection on the main database and the backup database according to the second performance information to be detected to obtain a second detection result;

and when the second detection result indicates that the detection fails, ending the detection flow, generating a detection failure prompt, sending the detection failure prompt to the client, and when the second detection result indicates that the detection fails, continuing to select other performance information to be detected in the plurality of performance information to be detected according to the detection execution sequence, and performing performance detection on the main database and the backup database according to the other performance information to be detected until all the performance information to be detected in the plurality of performance information to be detected is traversed, so as to obtain the final detection result.

203. And when the detection results indicate that the detection is passed, switching the service currently processed by the main database to the backup database for processing.

In the embodiment of the application, when a plurality of detection results indicate that the detection is passed, the management node can directly switch the service currently processed by the main database to the backup database for processing, and it should be noted that if performance detection is performed on the main database and the backup database according to the detection execution sequence, only when the last detection result indicates that the detection is passed, the service currently processed by the main database can be switched to the backup database for processing.

Further, before the database is switched, the management node can also detect the user permission, and the specific contents are as follows: firstly, acquiring account information for initiating a database performance detection instruction, then acquiring a white list, detecting whether the white list comprises the account information, then generating a verification passing prompt when the white list comprises the account information, sending a client logged in with the account information through the verification passing prompt, and when a user sees that the detection of the user authority displayed by the client passes the prompt, manually triggering a database switching instruction generation inlet arranged at the client to generate a database switching instruction, sending the database switching instruction to a management node, and switching the service currently processed by a main database to a backup database for processing when the management node receives the database switching instruction sent by the client.

204. And in the process of switching the service currently processed by the main database to the backup database for processing, detecting the main database and the backup database.

In an embodiment of the present application, the management node may detect roles of the primary database and the backup data, namely, firstly, the read-only parameters of the main database and the backup database are inquired, the first initial parameter value corresponding to the read-only parameters of the main database and the second initial parameter value corresponding to the read-only parameters of the backup database are read, wherein the first initial parameter value indicates that the initial role of the main database is the role of the main database, and the second initial parameter value indicates that the initial role of the backup database is the role of the backup database, and then the first initial parameter value and the second initial parameter value are sent to a client side initiating a database performance detection instruction, such that the client-side annotates the master database with a master database description field based on the received first initial parameter value, and labeling the backup database with the backup database description field based on the received second initial parameter value, then the read-only parameters of the main database and the backup database are inquired at preset time intervals, when detecting that the read-only parameters of the main database and/or the backup database change, reading the current parameter values corresponding to the read-only parameters of the main database and/or the backup database, finally sending the current parameter values corresponding to the read-only parameters of the main database and/or the backup database to the client, so that the client uses the backup database description field to remark the main database based on the received current parameter value corresponding to the read-only parameter of the main database, and/or, re-labeling the backup database by adopting the description field of the main database based on the received current parameter value corresponding to the read-only parameter of the backup database.

Further, the management node may further detect whether the virtual IP address may be connected to the backup database, that is, first obtain a virtual internet protocol IP address of the backup database, then send a connection request to the backup database based on the virtual IP address at intervals of a preset time interval, receive a connection success identifier or a connection failure identifier returned by the backup database, and then send the connection success identifier or the connection failure identifier returned by the backup database to the client, where the client marks the backup database by using the connection success identifier or the connection failure identifier based on the received connection success identifier or the connection failure identifier returned by the backup database.

Further, the management node can also detect whether the backup database can be read or written, that is, detect the read-write state of the backup database, and obtain a detection result indicating the read-write state.

205. And after the database is switched, detecting the connection state of the backup data.

In this embodiment of the present application, the management node may detect a connection state of the backup data, that is, when the management node receives a connection state detection instruction, obtain an original application host list of the main database in an operation record of the main database, where the original application host list includes a plurality of server IP addresses connected to the main database before the database is switched, then obtain a current application host list of the backup database in the operation record of the backup database, where the current application host list includes a plurality of current server IP addresses connected to the backup database, then compare the plurality of server IP addresses included in the original application host list with the current host list, and finally determine that a plurality of application systems corresponding to the plurality of server IP addresses are connected to the backup database if it is determined that the current host list does not include at least one server IP address of the plurality of server IP addresses, generate a connection failure alert for the at least one server IP address, and send the connection failure alert for the at least one server IP address to the client that initiates the connection state detection instruction.

According to the method provided by the embodiment of the application, before the database is switched, the performances of the main database and the backup database are detected according to the plurality of pieces of performance information to be detected, the coverage parameters are comprehensive, and the probability of switching failure is reduced; in the process of database switching, process detection is carried out on the main database and the backup database, so that the switching process is clearer; and after the database is switched, the backup database is subjected to service detection, so that the switching reliability is improved.

Further, in order to perform database switching on a large number of database clusters, an embodiment of the present application further provides a database switching method, as shown in fig. 3, including:

301. when the received database performance detection instruction indicates performance detection on a plurality of database clusters, determining a main database and a backup database in each database cluster in the plurality of database clusters, and determining a plurality of pieces of performance information to be detected carried by the database performance detection instruction.

302. And performing performance detection on the main database and the backup database of the database clusters in parallel according to the performance information to be detected to obtain a plurality of detection results corresponding to each database cluster.

303. At least one target database cluster is determined in the plurality of database clusters, and the business currently processed by the main database of each target database cluster in the at least one target database cluster is switched to the backup database of the target database for processing based on the asynchronous processing thread.

Wherein, a plurality of detection results corresponding to at least one target database cluster indicate that the detection passes.

Specifically, in the practical application process, most companies in the industry mainly adopt a page switching mode to switch the main database and the standby database in a single database cluster, so that the switching efficiency is low, and aiming at the technical problem, the embodiment of the application provides a database switching method for a large number of data clusters.

Further, as shown in fig. 4A, as a specific implementation of the method shown in fig. 1, an embodiment of the present application provides a database switching device, including: a determining module 401, a detecting module 402 and a switching module 403.

The determining module 401 is configured to receive a database performance detection instruction, determine a database cluster to be detected indicated by the database performance detection instruction, where the database performance detection instruction carries a plurality of performance information to be detected;

the detection module 402 is configured to determine a main database and a backup database in a database cluster to be detected, perform performance detection on the main database and the backup database according to a plurality of performance information to be detected, and obtain a plurality of detection results;

the switching module 403 is configured to switch, when the multiple detection results indicate that the detection passes, a service currently processed by the primary database to the backup database for processing.

In a specific application scenario, the detection module 402 is further configured to: when the to-be-detected performance information in the plurality of to-be-detected performance information indicates to detect a database state, a first database state of the main database and a second database state of the backup database are read, and a detection result is generated according to the first database state and the second database state, wherein when the first database state and the second database state indicate normal, a detection result indicating that detection is passed is generated, and when the first database state or the second database state indicates abnormal, a detection result indicating that detection is failed is generated; and/or when the performance information to be detected in the plurality of performance information to be detected indicates to detect the high available process state of the database cluster, reading the secure shell protocol ssh secret-free login permission of the database cluster, and reading the master-slave replication state of the master database and the backup database, and generating a detection result according to the ssh secret-free login permission and the master-slave replication state, wherein when the ssh secret-free login permission and the master-slave replication state indicate normal, a detection result indicating that detection is passed is generated, and when the ssh secret-free login permission or the master-slave replication state indicate abnormal, a detection result indicating that detection is failed is generated; and/or when the performance information to be detected in the plurality of performance information to be detected indicates to detect the core parameter, reading a first core parameter of the main database and a second core parameter of the backup database, and generating a detection result according to the first core parameter and the second core parameter, wherein when the first core parameter is consistent with the second core parameter, a detection result indicating that the detection is passed is generated, and when the first core parameter is inconsistent with the second core parameter, a detection result indicating that the detection is not passed is generated; and/or when the performance information to be detected in the plurality of performance information to be detected indicates that long transaction detection is performed, reading the long transaction which is running in the main database, and generating a detection result according to the long transaction, wherein when the long transaction is not running in the main database, a detection result indicating that the detection is passed is generated, and when the long transaction is running in the main database, a detection result indicating that the detection is not passed is generated.

In a specific application scenario, as shown in fig. 4B, the apparatus further includes: a first detection module 404.

The first detection module 404 is configured to obtain account information that initiates a database performance detection instruction; acquiring a white list and detecting whether the white list comprises account information; when the white list is determined to comprise account information, generating a verification passing prompt, and sending the verification passing prompt to a client logged in with the account information; when a database switching instruction of the client is received, the service currently processed by the main database is switched to the backup database for processing, and the database switching instruction is initiated by a user of the client after receiving a verification passing prompt.

In a specific application scenario, as shown in fig. 4C, the apparatus further includes: a first query module 405, a first annotation module 406, a second query module 407, and a second annotation module 408.

The first query module 405 is configured to query read-only parameters of the primary database and the backup database, and read a first initial parameter value corresponding to the read-only parameter of the primary database and a second initial parameter value corresponding to the read-only parameter of the backup database, where the first initial parameter value indicates that an initial role of the primary database is a role of the primary database, and the second initial parameter value indicates that an initial role of the backup database is a role of the backup database;

The first labeling module 406 is configured to send the first initial parameter value and the second initial parameter value to a client that initiates a database performance detection instruction, so that the client uses a main database description field to label the main database based on the received first initial parameter value, and uses a backup database description field to label the backup database based on the received second initial parameter value;

the second query module 407 is configured to query read-only parameters of the primary database and the backup database at intervals of a preset time, and read current parameter values corresponding to the read-only parameters of the primary database and/or the backup database when detecting that the read-only parameters of the primary database and/or the backup database change;

the second labeling module 408 is configured to send the current parameter value corresponding to the read-only parameter of the primary database and/or the backup database to the client, so that the client uses the backup database description field to remark the primary database based on the received current parameter value corresponding to the read-only parameter of the primary database, and/or uses the primary database description field to remark the backup database based on the received current parameter value corresponding to the read-only parameter of the backup database.

In a specific application scenario, as shown in fig. 4D, the apparatus further includes: a first acquisition module 409, a connection module 410 and a sending module 411.

The first obtaining module 409 is configured to obtain a virtual internet protocol IP address of the backup database;

the connection module 410 is configured to send a connection request to the backup database at intervals of a preset time based on the virtual IP address, and receive a connection success identifier or a connection failure identifier returned by the backup database;

the sending module 411 is configured to send a connection success identifier or a connection failure identifier returned by the backup database to the client, where the client marks the backup database with the connection success identifier or the connection failure identifier based on the received connection success identifier or the connection failure identifier returned by the backup database.

In a specific application scenario, as shown in fig. 4E, the apparatus further includes: the second acquisition module 412, the third acquisition module 413, the comparison module 414, and the determination module 415.

The second obtaining module 412 is configured to receive a connection status detection instruction, and obtain a primary application host list of the primary database from an operation record of the primary database, where the primary application host list includes a plurality of server IP addresses connected to the primary database before the database is switched;

The third obtaining module 413 is configured to obtain, from an operation record of the backup database, a current application host list of the backup database, where the current application host list includes a plurality of current server IP addresses that are connected to the backup database currently;

the comparison module 414 is configured to compare a plurality of server IP addresses included in the original application host list with the current host list;

the judging module 415 is configured to determine that a plurality of application systems corresponding to the plurality of server IP addresses are connected to the backup database if it is determined that the current host list includes the plurality of server IP addresses; if the current host list is determined not to comprise at least one server IP address in the plurality of server IP addresses, generating a connection failure reminder of the at least one server IP address, and sending the connection failure reminder of the at least one server IP address to the client initiating the connection state detection instruction.

In a specific application scenario, as shown in fig. 5, the apparatus further includes: a first determination module 501, a second detection module 502 and a first switching module 503.

The first determining module 501 is configured to determine, when the received database performance detection instruction indicates performance detection on a plurality of database clusters, a primary database and a backup database in each database cluster in the plurality of database clusters, and determine a plurality of performance information to be detected carried by the database performance detection instruction;

The second detection module 502 is configured to perform performance detection on the primary database and the backup database of the plurality of database clusters in parallel according to the plurality of performance information to be detected, to obtain a plurality of detection results corresponding to each database cluster;

the first switching module 503 is configured to determine at least one target database cluster from the plurality of database clusters, and switch, based on the asynchronous processing thread, a service currently processed by a primary database of each target database cluster from the at least one target database cluster to a backup database of the target database for processing, where a plurality of detection results corresponding to the at least one target database cluster indicate that the detection is passed.

According to the device provided by the embodiment of the application, the to-be-detected database cluster indicated by the database performance detection instruction is determined by receiving the database performance detection instruction carrying the plurality of to-be-detected performance information through the determining module, the main database and the backup database are determined in the to-be-detected database cluster through the detecting module, the performance of the main database and the backup database is detected according to the plurality of to-be-detected performance information, a plurality of detection results are obtained, when the detection results indicate that the detection is passed, the service currently processed by the main database is switched to the backup database through the switching module for processing, the performance of the main database and the backup database in the database cluster is detected before the database is switched, and when no problem is detected in the performance of the main database and the backup database, the currently processed service of the main database is switched to the backup database for processing, so that the probability of switching failure is reduced, and the problem that the switching failure is extremely easy to occur after the switching of the existing database at present is solved.

In an exemplary embodiment, referring to fig. 6, there is also provided a computer device including a bus, a processor, a memory, and a communication interface, and may further include an input-output interface and a display device, where each functional unit may perform communication with each other through the bus. The memory stores a computer program and a processor for executing the program stored in the memory to perform the database switching method in the above embodiment.

A readable storage medium having stored thereon a computer program which when executed by a processor performs the steps of the database switching method.

From the above description of the embodiments, it will be clear to those skilled in the art that the present application may be implemented in hardware, or may be implemented by means of software plus necessary general hardware platforms. Based on such understanding, the technical solution of the present application may be embodied in the form of a software product, which may be stored in a non-volatile storage medium (may be a CD-ROM, a U-disk, a mobile hard disk, etc.), and includes several instructions for causing a computer device (may be a personal computer, a server, or a network device, etc.) to execute the method described in the respective implementation scenario of the present application.

Those skilled in the art will appreciate that the drawing is merely a schematic illustration of a preferred implementation scenario and that the modules or flows in the drawing are not necessarily required to practice the application.

Those skilled in the art will appreciate that modules in an apparatus in an implementation scenario may be distributed in an apparatus in an implementation scenario according to an implementation scenario description, or that corresponding changes may be located in one or more apparatuses different from the implementation scenario. The modules of the implementation scenario may be combined into one module, or may be further split into a plurality of sub-modules.

The above-mentioned inventive sequence numbers are merely for description and do not represent advantages or disadvantages of the implementation scenario.

The above embodiments are only exemplary embodiments of the present application and are not intended to limit the present application, the scope of which is defined by the claims. Various modifications and equivalent arrangements of this application will occur to those skilled in the art, and are intended to be within the spirit and scope of the application.

Claims

1. A database switching method, comprising:

2. The method for switching databases according to claim 1, wherein determining a primary database and a backup database in the database cluster to be detected, performing performance detection on the primary database and the backup database according to the plurality of performance information to be detected, to obtain a plurality of detection results, includes:

3. The database switching method according to claim 1, wherein the method further comprises:

4. The database switching method according to claim 1, wherein in a process of switching a service currently handled by the primary database to the backup database for processing, the method further comprises:

5. The database switching method according to claim 1, wherein in a process of switching a service currently handled by the primary database to the backup database for processing, the method further comprises:

obtaining a virtual Internet Protocol (IP) address of the backup database;

6. The database switching method according to claim 1, wherein after the service currently processed by the primary database is switched to the backup database for processing, the method further comprises:

7. The database switching method according to claim 1, wherein the method further comprises:

8. A database switching apparatus, comprising:

9. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor implements the steps of the method of any of claims 1 to 7 when the computer program is executed.

10. A computer readable storage medium, on which a computer program is stored, characterized in that the computer program, when being executed by a processor, implements the steps of the method of any of claims 1 to 7.