CN113778738A - Database fault rapid positioning method and device - Google Patents

Database fault rapid positioning method and device Download PDF

Info

Publication number
CN113778738A
CN113778738A CN202111101938.9A CN202111101938A CN113778738A CN 113778738 A CN113778738 A CN 113778738A CN 202111101938 A CN202111101938 A CN 202111101938A CN 113778738 A CN113778738 A CN 113778738A
Authority
CN
China
Prior art keywords
fault
database
indexes
server
positioning
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202111101938.9A
Other languages
Chinese (zh)
Inventor
陈建华
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Shanghai Zhongtongji Network Technology Co Ltd
Original Assignee
Shanghai Zhongtongji Network Technology Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Shanghai Zhongtongji Network Technology Co Ltd filed Critical Shanghai Zhongtongji Network Technology Co Ltd
Priority to CN202111101938.9A priority Critical patent/CN113778738A/en
Publication of CN113778738A publication Critical patent/CN113778738A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/0703—Error or fault processing not based on redundancy, i.e. by taking additional measures to deal with the error or fault not making use of redundancy in operation, in hardware, or in data representation
    • G06F11/0793—Remedial or corrective actions
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/0703—Error or fault processing not based on redundancy, i.e. by taking additional measures to deal with the error or fault not making use of redundancy in operation, in hardware, or in data representation
    • G06F11/0706—Error or fault processing not based on redundancy, i.e. by taking additional measures to deal with the error or fault not making use of redundancy in operation, in hardware, or in data representation the processing taking place on a specific hardware platform or in a specific software environment
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/0703—Error or fault processing not based on redundancy, i.e. by taking additional measures to deal with the error or fault not making use of redundancy in operation, in hardware, or in data representation
    • G06F11/0766—Error or fault reporting or storing
    • G06F11/0769—Readable error formats, e.g. cross-platform generic formats, human understandable formats
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/30—Monitoring
    • G06F11/34—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment
    • G06F11/3409—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment for performance assessment

Abstract

The invention relates to a method and a device for quickly positioning database faults, wherein the method comprises the steps of collecting server indexes in a server, database indexes in a database and system performance indexes in a monitoring system; positioning a fault point according to a preset routing inspection index standard; judging the fault type to determine a solution and processing the fault. The technical scheme provided by the invention can automatically collect each key index and can check the key indexes of all databases through a visual interface. And fault handling can be recommended to remove faults by one key, and self-service and standardization of fault handling are realized.

Description

Database fault rapid positioning method and device
Technical Field
The invention belongs to the technical field of internet, and particularly relates to a method and a device for quickly positioning database faults.
Background
In the related art, when a database fails, database management personnel need to log in the database and various monitoring systems to check the condition of the database, and the database failure is located by experience. When a fault is located, the user needs to log in a server for installing a database to operate each time, so that the performance of data is affected, the safety of the server cannot be guaranteed, a lot of time is wasted to see the problem, and the fault recovery time is prolonged. Meanwhile, the service development of a plurality of systems combined analysis, particularly companies, needs to be checked more and more quickly, and more databases are needed. If a problem occurs with a batch of databases, a lot of time is wasted.
Disclosure of Invention
In view of the above, an object of the present invention is to overcome the deficiencies of the prior art, and provide a method and an apparatus for fast locating a database fault, so as to solve the problem of time waste during locating a database fault in the prior art.
In order to achieve the purpose, the invention adopts the following technical scheme: a method for quickly positioning database faults comprises the following steps:
collecting server indexes in a server, database indexes in a database and system performance indexes in a monitoring system;
positioning a fault point according to a preset routing inspection index standard;
judging the fault type to determine a solution and processing the fault.
Further, the method also comprises the following steps:
and displaying on a visual page after the fault point is positioned.
The embodiment of the application provides a quick positioner of database fault, includes:
the acquisition module is used for acquiring server indexes in the server, database indexes in the database and system performance indexes in the monitoring system;
the positioning module is used for positioning a fault point according to a preset routing inspection index standard;
and the processing module is used for judging the fault type, determining a solution and processing the fault.
Further, the method also comprises the following steps:
and the display module is used for displaying on the visual page after the fault point is positioned.
Further, the processing module comprises:
and the knowledge base is preset with a solution corresponding to the fault.
Further, the visual page is provided with a barrier removing button.
By adopting the technical scheme, the invention can achieve the following beneficial effects:
the invention provides a method and a device for quickly positioning database faults, wherein the method comprises the steps of collecting server indexes in a server, database indexes in a database and system performance indexes in a monitoring system; positioning a fault point according to a preset routing inspection index standard; judging the fault type to determine a solution and processing the fault. The technical scheme provided by the application has the following advantages:
1, the overhead on a server can be reduced;
2, protecting the server without exposing the access authority of the server;
3, reducing the fault duration;
4, reducing a fault processing threshold;
5, the automatic acquisition service reduces the labor cost;
and 6, visually displaying the database performance.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
FIG. 1 is a schematic diagram illustrating steps of a method for rapidly locating a database fault according to the present invention;
FIG. 2 is a schematic flow chart of a method for rapidly locating a database fault according to the present invention;
fig. 3 is a schematic structural diagram of the database fault fast positioning device of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the technical solutions of the present invention will be described in detail below. It is to be understood that the described embodiments are merely exemplary of the invention, and not restrictive of the full scope of the invention. All other embodiments, which can be derived by a person skilled in the art from the examples given herein without any inventive step, are within the scope of the present invention.
A specific method for quickly locating a database fault provided in the embodiment of the present application is described below with reference to the accompanying drawings.
As shown in fig. 1, the method for quickly locating a database fault provided in the embodiment of the present application includes:
s101, collecting server indexes in a server, database indexes in a database and system performance indexes in a monitoring system;
s102, positioning a fault point according to a preset inspection index standard;
and S103, judging the fault type to determine a solution and performing fault processing.
The working principle of the database fault rapid positioning method is as follows: as shown in fig. 2, the system is provided with a one-key troubleshooting function, and the server index in the server, the database index in the database, and the system performance index in the monitoring system are acquired in real time; then comparing and positioning fault points according to preset routing inspection index standards with server indexes, database indexes and system performance indexes; and judging the fault type after the positioning is successful to determine a solution and perform fault processing.
In some embodiments, further comprising:
and displaying on a visual page after the fault point is positioned.
Specifically, the one-key troubleshooting service removing server, the database and the monitoring system collect key indexes, locate fault points according to formulated routing inspection indexes, and display the fault points through a one-key troubleshooting visual page. And a standard solution is provided through a knowledge base of one-key fault removal, and faults are solved through a fault removal button provided by a one-key fault removal page.
As shown in fig. 3, an embodiment of the present application provides a database fault fast positioning apparatus, including:
the acquisition module 301 is configured to acquire a server index in a server, a database index in a database, and a system performance index in a monitoring system;
the positioning module 302 is used for positioning a fault point according to a preset inspection index standard;
and the processing module 303 is configured to judge a fault type to determine a solution and perform fault processing.
The working principle of the rapid database fault positioning device provided by the application is that the acquisition module 301 acquires a server index in a server, a database index in a database and a system performance index in a monitoring system; the positioning module 302 positions a fault point according to a preset inspection index standard; the processing module 303 determines a fault type determination solution and performs fault processing.
The embodiment of the application provides computer equipment, which comprises a processor and a memory connected with the processor;
the memory is used for storing a computer program, and the computer program is used for executing the database fault quick positioning method provided by any one of the above embodiments;
the processor is used to call and execute the computer program in the memory.
In summary, the present invention provides a method and an apparatus for fast locating a database fault, where the method includes collecting a server index in a server, a database index in a database, and a system performance index in a monitoring system; positioning a fault point according to a preset routing inspection index standard; judging the fault type to determine a solution and processing the fault. The technical scheme provided by the invention can automatically collect each key index and can check the key indexes of all databases through a visual interface. And fault handling can be recommended to remove faults by one key, and self-service and standardization of fault handling are realized.
It is to be understood that the embodiments of the method provided above correspond to the embodiments of the apparatus described above, and the corresponding specific contents may be referred to each other, which is not described herein again.
As will be appreciated by one skilled in the art, embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, optical storage, and the like) having computer-usable program code embodied therein.
The present application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the application. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
The above description is only for the specific embodiments of the present invention, but the scope of the present invention is not limited thereto, and any person skilled in the art can easily conceive of the changes or substitutions within the technical scope of the present invention, and all the changes or substitutions should be covered within the scope of the present invention. Therefore, the protection scope of the present invention shall be subject to the protection scope of the appended claims.

Claims (6)

1. A method for quickly positioning database faults is characterized by comprising the following steps:
collecting server indexes in a server, database indexes in a database and system performance indexes in a monitoring system;
positioning a fault point according to a preset routing inspection index standard;
judging the fault type to determine a solution and processing the fault.
2. The method of claim 1, further comprising:
and displaying on a visual page after the fault point is positioned.
3. A database fault quick positioning device is characterized by comprising:
the acquisition module is used for acquiring server indexes in the server, database indexes in the database and system performance indexes in the monitoring system;
the positioning module is used for positioning a fault point according to a preset routing inspection index standard;
and the processing module is used for judging the fault type, determining a solution and processing the fault.
4. The apparatus of claim 3, further comprising:
and the display module is used for displaying on the visual page after the fault point is positioned.
5. The method of claim 3, wherein the processing module comprises:
and sharing a knowledge base, and presetting a solution corresponding to the fault.
6. The apparatus of claim 4,
the visual page is provided with a fault removal button.
CN202111101938.9A 2021-09-18 2021-09-18 Database fault rapid positioning method and device Pending CN113778738A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202111101938.9A CN113778738A (en) 2021-09-18 2021-09-18 Database fault rapid positioning method and device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202111101938.9A CN113778738A (en) 2021-09-18 2021-09-18 Database fault rapid positioning method and device

Publications (1)

Publication Number Publication Date
CN113778738A true CN113778738A (en) 2021-12-10

Family

ID=78852322

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202111101938.9A Pending CN113778738A (en) 2021-09-18 2021-09-18 Database fault rapid positioning method and device

Country Status (1)

Country Link
CN (1) CN113778738A (en)

Similar Documents

Publication Publication Date Title
CN109039740B (en) Method and equipment for processing operation and maintenance monitoring alarm
CN108763957B (en) Database security audit system, method and server
CN107451040B (en) Method and device for positioning fault reason and computer readable storage medium
CN109343987A (en) IT system fault diagnosis and restorative procedure, device, equipment, storage medium
CN112631913B (en) Method, device, equipment and storage medium for monitoring operation faults of application program
CN106355357B (en) Power distribution network fault processing method and information processing system
CN108599977B (en) System and method for monitoring system availability based on statistical method
CN111722058A (en) Power information system fault detection method, device and medium based on knowledge graph
CN112529223A (en) Equipment fault repair method and device, server and storage medium
CN109815124B (en) MBSE-based interlocking function defect analysis method and device and interlocking system
CN111865673A (en) Automatic fault management method, device and system
CN110704313B (en) JAVA virtual machine memory leakage detection method and device
CN106533812B (en) Application server
CN113778738A (en) Database fault rapid positioning method and device
CN112363860A (en) Batch processing operation abnormal interruption detection method and device
CN113285824B (en) Method and device for monitoring security of network configuration command
CN115204617A (en) Power grid operation plan processing method, device, equipment and storage medium
CN115567366A (en) Method and device for analyzing network fault influence, storage medium and electronic equipment
CN114064711A (en) Rule base-based device exception handling method and device and storage medium
CN113342596A (en) Distributed monitoring method, system and device for equipment indexes
CN108062471B (en) Risk processing method and device in cloud computing network operation process
CN113626288A (en) Fault processing method, system, device, storage medium and electronic equipment
CN110807037B (en) Data modification method and device, electronic equipment and storage medium
CN111915275A (en) Application operation process management method, device and system
TW201743272A (en) Data processing device, data processing method, and data processing program

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination