A Monitoring Method and Device for a Database Arbitration Process

Through real-time inspection of the database arbitration process and preset keyword monitoring, the problem of inability to monitor the arbitration process status in the existing technology is solved, ensuring the stability and reliability of the database.

CN116225817BActive Publication Date: 2025-08-05NETSUNION CLEARING CORP
View PDF 1 Cites 0 Cited by

Patent Information

Application Number
CN202111464701.7
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2021-12-03
Publication Date
2025-08-05
Estimated Expiration
2041-12-03

AI Technical Summary

Technical Problem

The existing technology cannot monitor the status of the database arbitration process in a timely manner, resulting in business risks and affecting the stability and availability of the database.

Method used

By receiving inspection instructions, the status check of the arbitration process is carried out, and the running status of the arbitration process is monitored using preset keywords, including real-time monitoring of security protocols, data backup and startup status, real-time inspection and monitoring of the arbitration process.

Benefits of technology

Real-time monitoring of the arbitration process is realized, avoiding the inability to respond in time after a failure, greatly ensuring the stability and reliability of database arbitration.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN116225817B_ABST
    Figure CN116225817B_ABST
Patent Text Reader

Abstract

The present invention discloses a method and device for monitoring a database arbitration process. The method comprises: receiving a check instruction; performing a status check on the arbitration process according to the check instruction and determining a check result; and monitoring the operating status of the arbitration process based on preset keywords and the check result. The present invention performs real-time inspection and monitoring of the arbitration process, utilizing the inspection result and preset keywords to monitor the operating status of the arbitration process. The method is simple to operate, achieves real-time monitoring of the arbitration process, avoids the inability to respond promptly to failures, and significantly ensures the stability of database arbitration.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the field of information security, and in particular to a method and device for monitoring a database arbitration process. Background Art

[0002] Databases require high year-round availability, and their high availability relies on arbitration services. The database arbitration service is the fundamental guarantee for database switching. If arbitration process failures cannot be monitored and reported promptly, it can pose a significant risk to the business. Therefore, real-time monitoring of the arbitration process is crucial. Summary of the Invention

[0003] In view of this, an embodiment of the present invention provides a method and apparatus for monitoring a database arbitration process, which solves the problem in the prior art that arbitration process status information cannot be determined in a timely manner.

[0004] In order to achieve the above object, the present invention provides the following technical solutions:

[0005] In a first aspect, an embodiment of the present invention provides a method for monitoring a database arbitration process, comprising: receiving a check instruction; performing a status check on the arbitration process according to the check instruction and determining a check result; and monitoring the running status of the arbitration process according to preset keywords and the check result.

[0006] In one embodiment, a status check is performed on the arbitration process according to the check instruction to determine the check result, including: monitoring the security protocol status of the arbitration node to determine the connection status monitoring result of the security protocol, the arbitration process includes one or more arbitration nodes, and the arbitration process is used to arbitrate the target database combination; monitoring the data backup status of the target database combination to determine the backup status monitoring result; wherein the target database combination includes a primary database and its corresponding standby database; monitoring the startup status of the arbitration process to determine the startup status monitoring result; and combining the connection status monitoring result, the backup status monitoring result, and the startup status monitoring result to determine the check result.

[0007] In one embodiment, the running status of the arbitration process is monitored according to preset keywords and the inspection results, including: searching for a first preset keyword in the connection status monitoring result, and when the first preset keyword is found, determining that the connection status monitoring result is normal; when the connection status monitoring result is normal, searching for a second preset keyword in the backup status monitoring result, and when the second preset keyword is found, determining that the backup status monitoring result is normal; when the backup status monitoring result is normal, searching for a third preset keyword in the startup status monitoring result, and when the third preset keyword is found, determining that the startup status monitoring result is normal; when the startup status monitoring result is normal, determining that the arbitration process is running normally.

[0008] In one embodiment, the method for monitoring a database arbitration process provided by an embodiment of the present invention further includes: when a first preset keyword is not found in the connection status monitoring result, or when a second preset keyword is not found in the backup status monitoring result, or when a third preset keyword is not found in the startup status monitoring result, determining that the arbitration process is operating abnormally.

[0009] In one embodiment, when the running state of the arbitration process is abnormal, the database arbitration process monitoring method provided by the embodiment of the present invention further includes: determining the fault type of the arbitration process according to the inspection result; and determining a corresponding response strategy according to the fault type.

[0010] In one embodiment, the fault type of the arbitration process is determined based on the inspection result, including: when the first preset keyword is not found in the connection status monitoring result, determining that the fault type is a security protocol failure; when the second preset keyword is not found in the backup status monitoring result, determining that the fault type is a data backup failure; when the third preset keyword is not found in the startup status monitoring result, determining that the fault type is the arbitration process startup failure.

[0011] In one embodiment, after determining the inspection result, the monitoring method further includes: storing the inspection result in the log of the arbitration process; monitoring the running status of the arbitration process based on the preset keyword and the inspection result includes: searching for the preset keyword in the log, and determining the running status of the arbitration process based on the search result.

[0012] In a second aspect, an embodiment of the present invention provides a monitoring device for a database arbitration process, comprising: a receiving module for receiving an inspection instruction; an inspection module for performing a status inspection on the arbitration process according to the inspection instruction and determining an inspection result; and a monitoring module for monitoring the running status of the arbitration process according to preset keywords and the inspection result.

[0013] In a third aspect, an embodiment of the present invention provides an electronic device comprising: at least one processor, and a memory communicatively connected to the at least one processor, wherein the memory stores instructions executable by the at least one processor, and the instructions are executed by the at least one processor to enable the at least one processor to execute the method for monitoring the database arbitration process of the first aspect of the embodiment of the present invention.

[0014] In a fourth aspect, an embodiment of the present invention provides a computer-readable storage medium storing computer instructions for causing a computer to execute the method for monitoring a database arbitration process according to the first aspect of the embodiment of the present invention.

[0015] At least one of the above technical solutions adopted in the embodiments of the present application can achieve the following beneficial effects:

[0016] The database arbitration process monitoring method and device provided by the present invention perform real-time inspection and monitoring of the arbitration process, and use the inspection results and preset keywords to monitor the running status of the arbitration process. The operation is simple, and the real-time monitoring of the arbitration process is achieved, thereby avoiding the inability to respond in time after a failure, and greatly ensuring the stability of the database arbitration. BRIEF DESCRIPTION OF THE DRAWINGS

[0017] In order to more clearly illustrate the specific embodiments of the present invention or the technical solutions in the prior art, the following briefly introduces the drawings required for use in the specific embodiments or the description of the prior art. Obviously, the drawings described below are some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative work.

[0018] Figure 1 A flowchart of a method for monitoring a database arbitration process provided by an embodiment of the present invention;

[0019] Figure 2 A flowchart of a specific example of a method for monitoring a database arbitration process provided by an embodiment of the present invention;

[0020] Figure 3 A flowchart of another specific example of a method for monitoring a database arbitration process provided by an embodiment of the present invention;

[0021] Figure 4 A module composition diagram of a specific example of a monitoring device for a database arbitration process provided by an embodiment of the present invention;

[0022] Figure 5 A diagram showing the composition of a specific example of an electronic device provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0023] The technical solution of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the embodiments described are only some embodiments of the present invention, not all embodiments. All other embodiments obtained by ordinary technicians in this field based on the embodiments of the present invention without making any creative efforts shall fall within the scope of protection of the present invention.

[0024] In the description of the present invention, it should be noted that the terms "center," "upper," "lower," "left," "right," "vertical," "horizontal," "inner," and "outer," etc., indicating orientations or positional relationships, are based on the orientations or positional relationships shown in the accompanying drawings and are intended solely to facilitate and simplify the description of the present invention. They are not intended to indicate or imply that the devices or components referred to must have, be constructed, or operate in a specific orientation, and therefore should not be construed as limitations on the present invention. Furthermore, the terms "first," "second," and "third" are used for descriptive purposes only and should not be construed as indicating or implying relative importance.

[0025] In the description of the present invention, it should be noted that, unless otherwise expressly specified or limited, the terms "installed," "connected," and "connected" should be understood in a broad sense. For example, they can refer to fixed connections, detachable connections, or integral connections; mechanical connections or electrical connections; direct connections or indirect connections through an intermediate medium; internal connections between two components; wireless connections or wired connections. Those skilled in the art will understand the specific meanings of the above terms in the present invention based on specific circumstances.

[0026] In addition, the technical features involved in the different embodiments of the present invention described below can be combined with each other as long as they do not conflict with each other.

[0027] Example 1

[0028] The embodiment of the present invention provides a monitoring method for a database arbitration process, which is applied to an arbitration scheduling device to ensure the stability and reliability of a database arbitration service. Figure 1 As shown, the following steps are included:

[0029] Step S1: Receive an inspection instruction.

[0030] The clearing platform is a national-level financial infrastructure, requiring 99.99% year-round availability. Real-time business data is stored in a MySQL database, and must be kept stable 24 / 7. The clearing database has numerous instances and a massive daily transaction volume. Database arbitration services are fundamental to ensuring successful database migrations, making arbitration monitoring technology crucial. Failures in the arbitration process, without timely monitoring and alerting, can pose significant risks to the business, potentially leading to business losses. Therefore, inspecting and monitoring the database arbitration process is crucial.

[0031] The check instruction can be a direct instruction sent from the outside, or a timed check instruction set to periodically check the database arbitration process. It should be noted that this embodiment does not specifically limit the generation method of the check instruction, and can be set according to actual needs. The present invention is not limited to this.

[0032] Step S3: Check the status of the arbitration process according to the check instruction and determine the check result.

[0033] In this embodiment, after receiving the check instruction, the arbitration process is checked for status, mainly to check whether the current arbitration process is in a normal operating state, and the check result is determined. The SQL statement of the arbitration process can be checked, which is run with MySQL permissions and is not subject to system permission management constraints.

[0034] Of course, in actual applications, the above-mentioned inspection methods are not limited to use. Other inspection methods can also be used to inspect the arbitration process, such as writing a monitoring program based on programming languages such as Perl and Python, or configuring a supervisor system service. However, both of these solutions require additional software installation, and the software usage permission must be root. In actual use, they are greatly restricted by system permission management constraints and are less user-friendly.

[0035] After determining the inspection results, they can be stored in the arbitration process log to facilitate subsequent search and processing of the results. In practical applications, they can also be directly stored in other external storage devices, as long as the corresponding inspection results can be quickly and easily found later. Specifically, monitoring the operating status of the arbitration process based on preset keywords and inspection results includes searching the log for preset keywords and determining the operating status of the arbitration process based on the search results. In this embodiment, a shell script is used to filter the health status value of the log content, and the most recent content is always filtered. This operation is simple, and the program script can be executed locally. Abnormal conditions are recorded in the log, and can be investigated based on the log content.

[0036] Step S5: Monitor the running status of the arbitration process based on preset keywords and inspection results. Preset keywords for checking the status of the arbitration process are set in advance. The running status of the arbitration process is monitored based on the preset keywords and inspection results. This ensures that the running status of the arbitration process is determined in real time, allowing for timely response to any problems.

[0037] The database arbitration process monitoring method provided by the present invention performs real-time inspection and monitoring of the arbitration process, and uses the inspection results and preset keywords to monitor the running status of the arbitration process. The operation is simple, and the real-time monitoring of the arbitration process is achieved, thereby avoiding the inability to respond in time after a failure, and greatly ensuring the stability of the database arbitration.

[0038] In a specific embodiment, if Figure 2 As shown, performing a status check on the arbitration process according to the check instruction and determining the check result includes the following steps:

[0039] Step S31: monitor the security protocol status of the arbitration node and determine the connection status monitoring result of the security protocol. The arbitration process includes one or more arbitration nodes, and the arbitration process is used to arbitrate the target database combination.

[0040] Taking the above-mentioned SQL statement-based arbitration process check as an example, we can first check whether the security protocol of each arbitration node is logged in. In this embodiment, the security protocol can be SSH, a security protocol built on the application layer. SSH is a relatively reliable protocol designed to provide security for remote login sessions and other network services. Utilizing the SSH protocol can effectively prevent information leakage during remote management. When used correctly, SSH can mitigate network vulnerabilities. The arbitration process includes one or more arbitration nodes and is used to arbitrate the target database combination.

[0041] In actual applications, other security protocols can also be used. This embodiment only needs to check the status of the security protocol. For the above-mentioned SSH security protocol, monitoring can be achieved by the following code:

[0042] masterha_check_ssh--global_conf= / etc / masterha / masterha_default.conf--conf= / etc / masterha / app1.conf>ssh_result.log

[0043] Determine the connection status monitoring result of the security protocol at this time and output the result.

[0044] Step S33: monitoring the data backup status of the target database combination and determining the backup status monitoring result; wherein the target database combination includes the primary database and its corresponding standby database.

[0045] The target database combination of each arbitration process needs to perform real-time data backup, where the target database combination includes the primary database and its corresponding standby database. This embodiment requires monitoring the current data backup status, which can be achieved through the following code:

[0046] masterha_check_repl--global_conf= / etc / masterha / masterha_default.conf--conf= / etc / masterha / app1.conf>repl_result.log

[0047] Determine the data backup status monitoring results at this time and output the results.

[0048] Step S35: Monitor the startup status of the arbitration process and determine the startup status monitoring result.

[0049] The running status of each arbitration process itself will also affect the final inspection results. In this embodiment, it is necessary to monitor the startup status of the current arbitration process itself. The startup status of the arbitration process can be monitored using the following code:

[0050] masterha_check_status--global_conf= / etc / masterha / masterha_default.conf--conf= / etc / masterha / app1.conf>result.log

[0051] Determine the monitoring result of the startup status of the arbitration process at this time and output the result.

[0052] Step S37: combining the connection status monitoring result, the backup status monitoring result, and the startup status monitoring result to determine the inspection result.

[0053] In a specific embodiment, monitoring the running status of the arbitration process according to the preset keywords and the inspection results includes the following steps:

[0054] Step S51: Search the connection status monitoring results for a first preset keyword. If the first preset keyword is found, the connection status monitoring results are determined to be normal. For example, the connection status monitoring results can be searched using the following command: Cat ssh_result.log | grep 'All SSH connection tests passed successfully' | wc –L; where the content within the single quotes is the first preset keyword.

[0055] Step S53: If the connection status monitoring result is normal, search the backup status monitoring result for a second preset keyword. If the second preset keyword is found, the backup status monitoring result is determined to be normal. Search the backup status monitoring result using the following keyword: Cat repl_result.log | grep 'MySQL Replication Health is OK' | wc – L; the content within the single quotes is the second preset keyword.

[0056] Step S55: If the backup status monitoring result is normal, search the startup status monitoring result for a third preset keyword. If the third preset keyword is found, the startup status monitoring result is determined to be normal. Search the startup status monitoring result using the following keyword: Cat result.log | grep 'running' | wc -L; the content within single quotes is the third preset keyword.

[0057] It should be noted that, in this embodiment, the determination of the above-mentioned keywords may be in other forms, and the present invention is not limited thereto.

[0058] Step S57: When the startup status monitoring result is normal, it is determined that the arbitration process is running normally.

[0059] Step S59: When the first preset keyword is not found in the connection status monitoring result, or when the second preset keyword is not found in the backup status monitoring result, or when the third preset keyword is not found in the startup status monitoring result, it is determined that the arbitration process is running abnormally.

[0060] In a specific embodiment, if Figure 3 As shown, when the running state of the arbitration process is abnormal, the database arbitration process monitoring method provided by this embodiment further includes the following steps:

[0061] Step S01: Determine the fault type of the arbitration process based on the inspection result. In this embodiment, the arbitration process can be warned and processed accordingly by determining different fault types.

[0062] Specifically, in one embodiment, the above step S01 further includes the following steps:

[0063] (1) When the first preset keyword is not found in the connection status monitoring result, the fault type is determined to be a security protocol fault.

[0064] (2) When the second preset keyword is not found in the backup status monitoring result, the fault type is determined to be a data backup fault.

[0065] (3) When the third preset keyword is not found in the startup status monitoring result, the fault type is determined to be an arbitration process startup failure.

[0066] Step S03: Determine the corresponding response strategy according to the fault type. Different alarms are issued according to different fault types and corresponding response strategies are determined to achieve timely warning and timely response to the fault.

[0067] The database arbitration process monitoring method provided by the present invention performs real-time inspection and monitoring of the arbitration process, and uses the inspection results and preset keywords to monitor the running status of the arbitration process. The operation is simple, and the real-time monitoring of the arbitration process is achieved, thereby avoiding the inability to respond in time after a failure, and greatly ensuring the stability of the database arbitration.

[0068] Example 2

[0069] The embodiment of the present invention provides a monitoring device for a database arbitration process, such as Figure 4 As shown, including:

[0070] Receiving module 1 is used to receive the inspection instruction; this module executes the method described in step S1 above, which will not be described in detail here.

[0071] The checking module 2 is used to check the status of the arbitration process according to the checking instruction and determine the checking result. This module executes the method described in the above step S3 and will not be described in detail here.

[0072] The monitoring module 3 is used to monitor the running status of the arbitration process according to the preset keywords and the inspection results. This module executes the method described in the above step S5 and will not be described in detail here.

[0073] The database arbitration process monitoring device provided by the present invention performs real-time inspection and monitoring of the arbitration process, and uses the inspection results and preset keywords to monitor the running status of the arbitration process. The operation is simple, and the real-time monitoring of the arbitration process is achieved, thereby avoiding the inability to respond in time after a failure, and greatly ensuring the stability of the database arbitration.

[0074] In a specific embodiment, the above-mentioned inspection module further includes: a first inspection sub-module, which is used to monitor the security protocol status of the arbitration node and determine the connection status monitoring result of the security protocol, the arbitration process includes one or more arbitration nodes, and the arbitration process is used to arbitrate the target database combination; a second inspection sub-module, which is used to monitor the data backup status of the target database combination and determine the backup status monitoring result; wherein the target database combination includes a primary database and its corresponding standby database; a third inspection sub-module, which is used to monitor the startup status of the arbitration process and determine the startup status monitoring result; the connection status monitoring result, the backup status monitoring result, and the startup status monitoring result are combined to determine the inspection result.

[0075] In a specific embodiment, the above-mentioned monitoring module also includes: a first monitoring sub-module, which is used to search for a first preset keyword in the connection status monitoring result, and when the first preset keyword is found, determine that the connection status monitoring result is normal; a second monitoring sub-module, which is used to search for a second preset keyword in the backup status monitoring result when the connection status monitoring result is normal, and when the second preset keyword is found, determine that the backup status monitoring result is normal; a third monitoring sub-module, which is used to search for a third preset keyword in the startup status monitoring result when the backup status monitoring result is normal, and when the third preset keyword is found, determine that the startup status monitoring result is normal; and a fourth monitoring sub-module, which is used to determine that the arbitration process is running normally when the startup status monitoring result is normal.

[0076] In a specific embodiment, it also includes: a fifth monitoring sub-module, which is used to determine that the arbitration process is running abnormally when the first preset keyword is not found in the connection status monitoring result, or when the second preset keyword is not found in the backup status monitoring result, or when the third preset keyword is not found in the startup status monitoring result.

[0077] In a specific embodiment, the fifth monitoring submodule further includes: a fault determination module for determining the fault type of the arbitration process according to the inspection result; and a response strategy determination module for determining a corresponding response strategy according to the fault type.

[0078] In a specific embodiment, the above-mentioned fault determination module also includes: a first judgment submodule, which is used to determine that the fault type is a security protocol failure when the first preset keyword is not found in the connection status monitoring result; a second judgment submodule, which is used to determine that the fault type is a data backup failure when the second preset keyword is not found in the backup status monitoring result; and a third judgment submodule, which is used to determine that the fault type is an arbitration process startup failure when the third preset keyword is not found in the startup status monitoring result.

[0079] In a specific embodiment, it further includes: a storage module for storing the inspection results in the log of the arbitration process; a search submodule for searching for preset keywords in the log and determining the running status of the arbitration process according to the search results.

[0080] The database arbitration process monitoring device provided by the present invention performs real-time inspection and monitoring of the arbitration process, and uses the inspection results and preset keywords to monitor the running status of the arbitration process. The operation is simple, and the real-time monitoring of the arbitration process is achieved, thereby avoiding the inability to respond in time after a failure, and greatly ensuring the stability of the database arbitration.

[0081] Example 3

[0082] An embodiment of the present invention provides an electronic device, such as Figure 5 As shown, the system includes: at least one processor 401, such as a CPU (Central Processing Unit), at least one communication interface 403, a memory 404, and at least one communication bus 402. The communication bus 402 is used to implement connection and communication between these components. The communication interface 403 may include a display screen and a keyboard. Optionally, the communication interface 403 may also include a standard wired interface or a wireless interface. The memory 404 may be a high-speed RAM (Ramdom Access Memory) or a non-volatile memory, such as at least one disk storage device. The memory 404 may optionally be at least one storage device located remote from the processor 401. The processor 401 may execute the database arbitration process monitoring method of Example 1. The memory 404 stores a set of program codes, and the processor 401 calls the program codes stored in the memory 404 to execute the database arbitration process monitoring method of Example 1.

[0083] The communication bus 402 may be a peripheral component interconnect (PCI) bus or an extended industry standard architecture (EISA) bus. The communication bus 402 may be divided into an address bus, a data bus, a control bus, etc. For ease of representation, Figure 5 The fact that only one line is used does not mean that there is only one bus or one type of bus.

[0084] Among them, the memory 404 may include a volatile memory (English: volatile memory), such as a random-access memory (English: random-access memory, abbreviated: RAM); the memory may also include a non-volatile memory (English: non-volatile memory), such as a flash memory (English: flash memory), a hard disk drive (English: hard disk drive, abbreviated: HDD) or a solid-state drive (English: solid-state drive, abbreviated: SSD); the memory 404 may also include a combination of the above types of memory.

[0085] The processor 401 may be a central processing unit (CPU), a network processor (NP), or a combination of a CPU and a NP.

[0086] The processor 401 may further include a hardware chip. The hardware chip may be an application-specific integrated circuit (ASIC), a programmable logic device (PLD), or a combination thereof. The PLD may be a complex programmable logic device (CPLD), a field-programmable gate array (FPGA), a generic array logic (GAL), or any combination thereof.

[0087] Optionally, the memory 404 is further configured to store program instructions. The processor 401 may call the program instructions to implement the method for monitoring the database arbitration process in the first embodiment of the present application.

[0088] An embodiment of the present invention further provides a computer-readable storage medium having computer-executable instructions stored thereon, the computer-executable instructions being capable of executing the method for monitoring a database arbitration process of Example 1. The storage medium may be a magnetic disk, an optical disk, a read-only memory (ROM), a random access memory (RAM), a flash memory, a hard disk drive (HDD), or a solid-state drive (SSD); the storage medium may also include a combination of the aforementioned types of memory.

[0089] Obviously, the above embodiments are merely examples for clarity of explanation and are not intended to limit the implementation methods. Those skilled in the art will appreciate that other variations or modifications can be made based on the above description. It is not necessary and impossible to enumerate all implementation methods here. Obvious variations or modifications arising therefrom remain within the scope of protection of the present invention.

Claims

1. A method for monitoring a database arbitration process, characterized in that: include: Receive inspection instructions; Performing a status check on the arbitration process according to the check instruction and determining a check result; Monitoring the running status of the arbitration process according to preset keywords and the inspection results; Performing a status check on the arbitration process according to the check instruction and determining a check result includes: Monitoring the security protocol status of the arbitration node to determine a connection status monitoring result of the security protocol, wherein the arbitration process includes one or more arbitration nodes, and the arbitration process is used to arbitrate the target database combination; Monitoring the data backup status of a target database combination and determining a backup status monitoring result; wherein the target database combination includes a primary database and its corresponding standby database; Monitoring the startup status of the arbitration process and determining a startup status monitoring result; The connection status monitoring result, the backup status monitoring result, and the startup status monitoring result are combined to determine an inspection result.

2. The method for monitoring a database arbitration process according to claim 1, wherein: Monitoring the running status of the arbitration process according to the preset keywords and the inspection results includes: searching for a first preset keyword in the connection status monitoring result, and determining that the connection status monitoring result is normal when the first preset keyword is found; When the connection status monitoring result is normal, searching for a second preset keyword in the backup status monitoring result, and when the second preset keyword is found, determining that the backup status monitoring result is normal; When the backup status monitoring result is normal, searching for a third preset keyword in the startup status monitoring result, and when the third preset keyword is found, determining that the startup status monitoring result is normal; When the startup status monitoring result is normal, it is determined that the arbitration process is running normally.

3. The method for monitoring a database arbitration process according to claim 2, wherein: Also includes: When the first preset keyword is not found in the connection status monitoring result, or when the second preset keyword is not found in the backup status monitoring result, or when the third preset keyword is not found in the startup status monitoring result, it is determined that the arbitration process is running abnormally.

4. The method for monitoring a database arbitration process according to claim 3, wherein: When the running state of the arbitration process is abnormal, the monitoring method further includes: determining a failure type of the arbitration process according to the inspection result; A corresponding response strategy is determined according to the fault type.

5. The method for monitoring a database arbitration process according to claim 4, wherein: Determining the failure type of the arbitration process according to the inspection result includes: When the first preset keyword is not found in the connection status monitoring result, determining that the fault type is a security protocol fault; When the second preset keyword is not found in the backup status monitoring result, determining that the fault type is a data backup fault; When the third preset keyword is not found in the startup status monitoring result, it is determined that the fault type is the arbitration process startup failure.

6. The method for monitoring a database arbitration process according to claim 1, wherein: After determining the inspection result, the monitoring method further includes: storing the inspection result in a log of the arbitration process; The monitoring the running status of the arbitration process according to the preset keyword and the inspection result includes: searching the preset keyword in the log, and determining the running status of the arbitration process according to the search result.

7. A monitoring device for a database arbitration process, characterized in that: include: A receiving module, configured to receive an inspection instruction; A checking module, configured to check the status of the arbitration process according to the checking instruction and determine the checking result; Performing a status check on the arbitration process according to the check instruction and determining a check result includes: monitoring the security protocol status of the arbitration node to determine a connection status monitoring result of the security protocol, the arbitration process including one or more arbitration nodes, the arbitration process being used to arbitrate a target database combination; monitoring the data backup status of the target database combination to determine a backup status monitoring result; wherein the target database combination includes a primary database and its corresponding standby database; monitoring the startup status of the arbitration process to determine a startup status monitoring result; and combining the monitoring results to determine a check result; A monitoring module is used to monitor the running status of the arbitration process according to preset keywords and the inspection results.

8. A computer-readable storage medium, characterized in that The computer-readable storage medium stores computer instructions, and when the computer instructions are executed by a processor, the method for monitoring a database arbitration process according to any one of claims 1 to 6 is implemented.

9. An electronic device, characterized in that: include: A memory and a processor, wherein the memory and the processor are communicatively connected to each other, the memory stores computer instructions, and the processor executes the method for monitoring a database arbitration process according to any one of claims 1 to 6 by executing the computer instructions.

Citation Information

Patent Citations

  • Method and device for monitoring environment state of server and computer equipment

    CN109768896A