CN112035243A - Data query method, device, terminal and medium - Google Patents
Data query method, device, terminal and medium Download PDFInfo
- Publication number
- CN112035243A CN112035243A CN201910482467.7A CN201910482467A CN112035243A CN 112035243 A CN112035243 A CN 112035243A CN 201910482467 A CN201910482467 A CN 201910482467A CN 112035243 A CN112035243 A CN 112035243A
- Authority
- CN
- China
- Prior art keywords
- server
- data query
- query
- configuration information
- instance
- 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
Links
- 238000000034 method Methods 0.000 title claims abstract description 47
- 238000004590 computer program Methods 0.000 claims description 14
- 238000012423 maintenance Methods 0.000 abstract description 23
- 238000010586 diagram Methods 0.000 description 13
- 238000004891 communication Methods 0.000 description 6
- 230000008569 process Effects 0.000 description 5
- 238000005516 engineering process Methods 0.000 description 4
- 230000006870 function Effects 0.000 description 4
- 230000003287 optical effect Effects 0.000 description 4
- 238000012545 processing Methods 0.000 description 4
- 230000004044 response Effects 0.000 description 3
- 230000000644 propagated effect Effects 0.000 description 2
- 238000013515 script Methods 0.000 description 2
- 239000004065 semiconductor Substances 0.000 description 2
- 230000003068 static effect Effects 0.000 description 2
- 238000004364 calculation method Methods 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000013480 data collection Methods 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 239000000835 fiber Substances 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 239000013307 optical fiber Substances 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/46—Multiprogramming arrangements
- G06F9/50—Allocation of resources, e.g. of the central processing unit [CPU]
- G06F9/5005—Allocation of resources, e.g. of the central processing unit [CPU] to service a request
- G06F9/5027—Allocation of resources, e.g. of the central processing unit [CPU] to service a request the resource being a machine, e.g. CPUs, Servers, Terminals
- G06F9/505—Allocation of resources, e.g. of the central processing unit [CPU] to service a request the resource being a machine, e.g. CPUs, Servers, Terminals considering the load
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2471—Distributed queries
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Software Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Mathematical Physics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Computational Linguistics (AREA)
- Probability & Statistics with Applications (AREA)
- Fuzzy Systems (AREA)
- Information Transfer Between Computers (AREA)
Abstract
The application discloses a data query method, a device, a terminal and a medium, wherein the method comprises the steps of sending a data query request message to a server, wherein the data query request message is used for acquiring configuration information of an array load balancer server to be queried from a database; and/or obtaining instance state information from the snmp interface; and receiving the configuration information and/or the instance state information sent by the query server. According to the method and the device, the data query is input by the operation and maintenance personnel on the query page of the client, so that the background query server can read the configuration information and/or the instance state information of the array load balancing server from the database and/or the snmp interface according to the data query request message and return the configuration information and/or the instance state information to the client, the operation and maintenance personnel can efficiently and accurately master the configuration information and the real-time state of the running instances of all the array load balancing servers, the operation and maintenance efficiency is improved, and the operation and maintenance cost is reduced.
Description
Technology neighborhood
The present application relates generally to the field of computer technologies, and in particular, to a data query method, apparatus, terminal, and medium.
Background
At present, for enterprises or organizations with very large data traffic, an optimized data platform needs to be built in order to improve the flexibility, safety, stability and high efficiency of data traffic. For example, the array load balancing server is used as a framework mode of the reverse proxy to distribute the service request so as to ensure the stable operation of the background server. For the above-mentioned built architecture mode, in the actual operation process, maintenance personnel are required to query and manage data such as configuration information of the array load balancing server, so as to ensure the safe operation of the platform.
For array load balancing servers distributed in different network areas, in the process of data query and maintenance, the area of equipment to be queried usually needs to be judged manually, and then configuration information is queried by logging in a bastion machine, so that the query efficiency is low, and the operation and maintenance cost is high.
Disclosure of Invention
In view of the above-mentioned drawbacks and deficiencies of the prior art, it is desirable to provide a data query method, a terminal and a medium to improve data query efficiency.
In a first aspect, an embodiment of the present application provides a data query method, where the method includes:
sending a data query request message to a query server, so that the query server responds to the data query request message and acquires configuration information of an array load balancer server to be queried from a database; and/or acquiring instance state information corresponding to the array load balancer server to be queried from the snmp interface;
and receiving the configuration information and/or the instance state information returned by the query server.
In a second aspect, an embodiment of the present application provides a data query method, where the method includes:
receiving a data query request message sent by a client;
responding to the data query request message, and acquiring configuration information of an array load balancer server to be queried from a database; and/or acquiring instance state information corresponding to the array load balancer server to be queried from the snmp interface;
and returning the configuration information and/or the instance state information to the client.
In a third aspect, an embodiment of the present application provides a data query apparatus, including:
the system comprises a sending module, a receiving module and a sending module, wherein the sending module is used for sending a data query request message to a server, so that the query server responds to the data query request message and acquires configuration information of an array load balancer server to be queried from a database; and/or acquiring instance state information corresponding to the array load balancer server to be queried from the snmp interface;
and the receiving module is used for receiving the configuration information and/or the instance state information sent by the query server.
In a fourth aspect, an embodiment of the present application provides a data query apparatus, including:
the receiving module is used for receiving a data query request message sent by a client;
the query module is used for responding to the data query request message and acquiring the configuration information of the array load balancer server to be queried from the database; and/or acquiring instance state information corresponding to the array load balancer server to be queried from the snmp interface;
and the sending module is used for returning the configuration information and/or the instance state information to the client.
In a fifth aspect, an embodiment of the present application provides a terminal, which includes a memory, a processor, and a computer program stored on the memory and executable on the processor, and when the processor executes the program, the data query method according to the first aspect is implemented.
In a sixth aspect, an embodiment of the present application provides a computer-readable storage medium, on which a computer program is stored, the computer program being used to implement the data query method according to the first aspect or the second aspect.
To sum up, according to the data query method, the data query device, the terminal and the medium provided in the embodiments of the present application, the operation and maintenance staff inputs a data query request through a query page of the client, so that the query server in the background can obtain configuration information and/or instance state information of a corresponding array load balancing server from the database and/or the snmp interface according to the received data query request message, and return the configuration information and/or the instance state information to the client, so that the operation and maintenance staff can read the configuration information and the instance state information of all array load balancing servers from the database or the snmp interface by using the client and the query server, thereby improving the management and query efficiency of the array load balancing server information and reducing the operation and maintenance cost.
Drawings
Other features, objects and advantages of the present application will become more apparent upon reading of the following detailed description of non-limiting embodiments thereof, made with reference to the accompanying drawings in which:
FIG. 1 is a schematic structural diagram of a data query system according to an embodiment of the present application
FIG. 2 is a schematic diagram of a data collection site and a database according to an embodiment of the present application;
FIG. 3 is a flowchart illustrating a data query method according to an embodiment of the present application;
FIG. 4 is a flowchart illustrating a data query method according to another embodiment of the present application;
FIG. 5 is a flowchart illustrating a data query method according to another embodiment of the present application;
FIG. 6 is a schematic diagram of a client page display according to an embodiment of the present application;
FIG. 7 is a schematic structural diagram of a data query device according to an embodiment of the present application;
FIG. 8 is a schematic structural diagram of a data query device according to yet another embodiment of the present application;
fig. 9 is a schematic structural diagram of a computer system according to an embodiment of the present application.
Detailed Description
The present application will be described in further detail with reference to the following drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the relevant application and are not limiting of the application. It should be noted that, for the convenience of description, only the portions relevant to the application are shown in the drawings.
It should be noted that the embodiments and features of the embodiments in the present application may be combined with each other without conflict. The present application will be described in detail below with reference to the embodiments with reference to the attached drawings.
It can be understood that the data query of the embodiment of the application is applied to a scene of a data architecture mode built by a plurality of array load balancing servers. For example, in one architectural mode, a client, a cache server, a plurality of array load balancing servers, each of which may be located in a different area, and a plurality of web application servers may be included. The array load balancing server is used for receiving the data access request of the client, distributing the data access request of the client to the web application servers with processing capacity according to the current idle states of all the web application servers, and returning the acquired data to the client. Each array load balancing server located in different areas has its own configuration, including configuration information such as names of multiple instances, instances ip, instance ports, group names of multiple instances, service vip, service names, protocols, service ports, and the like, which are hung on one or more application servers.
In the above application scenario, in order to ensure normal operation of the data service mode, each array load balancing server needs to be maintained, for example, to query or modify configuration information thereof. If the area of each array load balancing server is preliminarily judged according to the address of the array load balancing server, then a bastion machine is logged in, the password of the array load balancing server to be maintained is inquired, and then a management page is logged in according to the inquired password, so that the management operations of inquiring or modifying the configuration information of the array load balancing server and the like are completed.
It can be understood that the above configuration information management and maintenance process requires multiple login operations by the maintenance personnel, which results in low efficiency and high cost. In order to improve the maintenance efficiency of the array load balancing server and reduce the maintenance cost, the embodiment of the application provides a data query system which can be developed based on the python language by using technologies such as jquery, mysql and the like, as shown in fig. 1. The system comprises:
the system comprises a plurality of array load balancing servers, a data acquisition server, a database, a query server and a client. The data acquisition server is respectively connected with the array load balancing server arranged in each area, and is used for acquiring the configuration information of the array at regular time and storing the configuration information in the database. The client is used for receiving the data query request message input by the maintenance personnel, sending the data query request message to the query server, receiving a query result returned by the query server, and displaying the query result according to a preset mode. The query server can be used for responding to the query request message after a maintainer inputs the query request message at the client, accurately and efficiently reading the required configuration information from the database and returning the configuration information to the client.
For example, as shown in fig. 2, when the data acquisition server is used to acquire configuration information of an array device, different scripts for configuration acquisition may be written to synchronize the array device with the data acquisition server (data acquisition point) at regular time, and then the data acquisition point calculates the configuration information and stores the configuration information in the database. For example, the configuration data of the array device is periodically backed up through the crontab every morning, that is, the configuration data is centrally packaged, a configuration file is generated, and the configuration file is remotely uploaded to the data acquisition server. After receiving the configuration file, the data acquisition server reads the configuration file by compiling the running script, reads information such as a station instance name, an instance ip, an instance port, a group name, a service vip, a service name, a protocol, a service port and the like related to each array device in the file through keyword matching, sorts and summarizes the information, and stores the information into a table corresponding to a database.
Based on the above system, for convenience of understanding and explanation, a data query method, an apparatus, a terminal, a server, and a medium provided in the embodiments of the present application are explained in detail below with reference to fig. 3 to 6.
Fig. 3 is a schematic flowchart of a data query method provided in an embodiment of the present application, and as shown in fig. 3, the method includes:
s310, the client sends a data query request message to the query server.
S320, the query server receives the data query request message sent by the client.
S330, the query server responds to the data query request message, reads the configuration information of the array load balancer server to be queried from the database, and/or acquires the state information of the instance of the array load balancer server to be queried from the snmp interface;
s340, the query server returns the read configuration information and/or state information to the client.
And S350, receiving the read configuration information and/or the read state information returned by the query server.
Specifically, in this embodiment, the maintenance staff may input, according to the current need, the association information and/or the instance status request information of the array load balancer server that needs to be queried in the web page of the client. For example, maintenance personnel may input associated information such as an array load balancing server name, a vip, or a background instance that needs to be queried in a webpage of a client. The query server may query the configuration information of the array load balancer server according to the content carried in the data query request message, or query the state of the background instance of the array load balancer server, or may perform synchronous query on the configuration information and the state information.
After the maintainer inputs the associated information and/or the instance name and the state query of the array load balancing server to be queried in the webpage of the client, the query server can read the configuration information of the array load balancing server to be queried from the database according to the input information, obtain the current state information of the instance from the snmp interface and return the current state information to the client, and the client can display the returned configuration information, so that the maintainer can efficiently and accurately obtain the configuration information of the array load balancing server to be queried or the current state information of the instance thereon.
Fig. 4 is a schematic flowchart illustrating a data query method according to another embodiment of the present application, and as shown in fig. 4, the method may include:
s410, the client sends a data query request message to the query server.
S420, the query server receives the data query request message sent by the client.
S430, the query server responds to the data query request message, and reads the configuration information of the array load balancer server to be queried from the database;
s440, the query server returns the configuration information to the client.
S450, receiving the configuration information returned by the query server.
S460, the client displays the configuration information in a preset format.
Specifically, as shown in fig. 4, a maintainer may input associated information, such as an array load balancing server name, a vip, or a background instance, that needs to be queried in a web page of a client, and after receiving the information input by the maintainer, the client may generate a data query request message and send the data query request message to a query server. The data query request message carries the associated information of the array load balancing server to be queried. The data query request message includes the association information of the array load balancer server to be queried, and the data query request message is used for enabling the query server to respond to the data query request message and read the configuration information of the array load balancer server to be queried from the database.
After receiving the data query request message, the query server analyzes the data query request message to obtain the associated information of the array load balancing server to be queried. And further responding to the message, and reading static configuration information of the array load balancing server to be inquired from the database according to the association information. Such as the name of the instance, the ip of the instance, the port of the instance, the name of the group to which the array load balancing server belongs, the vip of the service, the name of the service, the protocol, the port of the service, and so on. And then returning the inquired configuration information to the client of the client.
After receiving the configuration information returned by the query server, the client can analyze the configuration information and display the configuration information in a preset format. As shown in fig. 6, may be arranged into a list format presentation.
It can be understood that the database in the embodiment of the present application stores configuration information of all array load balancing servers, and the configuration information is stored by a data acquisition server deployed in the system. In order to ensure the security of data, a data acquisition point is set in the system, so that the configuration information of the array load balancing servers to be queried, which are deployed in various areas, can be reported to the data acquisition server in real time, and the data acquisition server can perform sorting calculation on the configuration information and effectively store the configuration information in a database in a preset mode, thereby facilitating the query of the query server.
After the maintainer inputs the name and other information of the array load balancing server to be queried in the webpage of the client, the query server can read other configuration information of the array load balancing server to be queried from the database according to the input information and return the configuration information to the client, and the client can arrange and display the returned configuration information, so that the maintainer can efficiently and accurately acquire the configuration information of the array load balancing server to be queried, and the configuration information can be conveniently managed and modified.
It is understood that the query in the above embodiments is static information of the array load balancing server configuration. Further, in order to realize real-time query of the instance state of the array device, a snmp interface on the array device is developed, that is, the interface is used for real-time acquisition of the instance state information.
Fig. 5 is a schematic flow chart of a data query method according to another embodiment of the present application, as shown in the figure, the method includes:
s510, the client sends a data query request message to the query server.
S520, the query server receives the data query request message sent by the client.
S530, the query server responds to the data query request message and reads the number of the instance from the database.
And S540, the query server calculates the identification information of the example based on the number.
S550, the query server reads the state information of the instance from the snmp interface based on the identification information.
S560, returning the status information to the client.
S570, the client receives the status information.
S580, the client displays the status information in a preset format.
Specifically, in this embodiment, the data query request message carries status query information of an instance running on the array load balancer server to be queried. For example, the identifier information that represents the instance information, such as the name of the instance or the instance IP, is carried with the information indicating the state query of the instance, such as binary information.
After receiving a data query request message including instance state query, the query server analyzes the data query request message, further responds to the message, and reads the number of the instance to be queried from the database according to the name of the instance to be queried or the IP of the instance.
It can be understood that the number is a number corresponding to the to-be-queried instance on the array load balancing server, that is, in the data processing mode construction of the array load balancing server, the instances running on each array device are all provided with unique corresponding numbers.
In the embodiment of the application, the numbers corresponding to all the instances hung on each array load balancing server can be collected in advance through the data acquisition server, uploaded and stored in the database.
After the query server reads the number corresponding to the instance from the database, the Object Identifier (OID) of the instance may be further calculated based on the number. Then, according to the calculated OID, the current state of the to-be-queried instance, such as whether the to-be-queried instance is connected or not, can be acquired from the snmp interface. And finally, assigning the acquired current state, wherein if the communication is 1 and the non-communication is 0, the state information is generated and returned to the client. After receiving the state information, the client can analyze the state information and then display the state information.
After the maintenance personnel inputs the instance name, the state query and other information of the array load balancing server to be queried in the webpage of the client, the query server can read the number of the instance of the array load balancing server to be queried from the database according to the input information, the identification information of the instance to be queried is calculated according to the number, finally, the current state information of the instance is obtained from the snmp interface according to the identification information and is returned to the client, and the client can display the returned configuration information, so that the maintenance personnel can accurately obtain the current state information of the instance of the array load balancing server to be queried in real time, and the fault removal of the maintenance personnel is facilitated.
Fig. 7 is a schematic structural diagram of a data query apparatus according to an embodiment of the present application, and as shown in fig. 7, the apparatus 700 includes:
the sending module 710 is configured to send a data query request message to a server, so that the query server responds to the data query request message and obtains configuration information of an array load balancer server to be queried from a database; and/or acquiring instance state information corresponding to the array load balancer server to be queried from the snmp interface;
a receiving module 720, configured to receive the configuration information and/or the instance status information sent by the query server.
Further, in the data query apparatus provided in the embodiment of the present application, the instance state information is obtained by the server from the snmp interface according to the instance identification information, and the instance identification information is obtained by the server reading the number corresponding to the instance from the database based on the data query request message; the configuration information in the database is uploaded by a data acquisition point in a preset period.
Further, the data query apparatus provided in the embodiment of the present application further includes a display module 730, configured to display the configuration information and/or the instance status information in a preset format.
Fig. 8 is a schematic structural diagram of a data query apparatus according to another embodiment of the present application, and as shown in fig. 8, the apparatus 800 includes:
a receiving module 810, configured to receive a data query request message sent by a client, where the data query request message includes associated information of an array load balancer server to be queried;
an obtaining module 820, configured to, in response to the data query request message, obtain configuration information of an array load balancer server to be queried from a database; and/or acquiring instance state information corresponding to the array load balancer server to be queried from the snmp interface;
a sending module 830, configured to return the configuration information and/or the instance status information to the client.
The configuration information in the database is uploaded by the data acquisition point in a preset period.
Further, in the data query apparatus provided in the embodiment of the present application, the obtaining module is further configured to obtain, from the snmp interface, instance status information of operation of the array load balancer server corresponding to the query request message in response to the data query request message.
Further, in the data query apparatus provided in the embodiment of the present application, the obtaining module includes:
a reading unit 821, configured to read the number of the instance from a database based on the data query request message;
a calculating unit 822, which calculates the identifier of the instance based on the number;
the obtaining unit 823 reads the instance status information from the snmp interface based on the identification information.
On the other hand, embodiments of the present application further provide a terminal, where the terminal is loaded with a client, and the client includes a memory, a processor, and a computer program stored on the memory and executable on the processor, and when the processor executes the computer program, the processor implements the data query method as described above.
On the other hand, the embodiment of the present application further provides a query server, which includes a memory, a processor, and a computer program stored on the memory and executable on the processor, and the processor implements the data query method as above when executing the program.
Referring now to FIG. 9, shown is a block diagram of a computer system 900 suitable for use in implementing a server or terminal according to embodiments of the present application.
As shown in fig. 9, the computer system 900 includes a Central Processing Unit (CPU)901 that can perform various appropriate actions and processes in accordance with a program stored in a Read Only Memory (ROM)902 or a program loaded from a storage section 903 into a Random Access Memory (RAM) 903. In the RAM 903, various programs and data necessary for the operation of the system 900 are also stored. The CPU 901, ROM 902, and RAM 903 are connected to each other via a bus 904. An input/output (I/O) interface 905 is also connected to bus 904.
The following components are connected to the I/O interface 909: an input portion 906 including a keyboard, a mouse, and the like; an output section 907 including components such as a Cathode Ray Tube (CRT), a Liquid Crystal Display (LCD), and the like, and a speaker; a storage portion 908 including a hard disk and the like; and a communication section 909 including a network interface card such as a LAN card, a modem, or the like. The communication section 909 performs communication processing via a network such as the internet. The drive 910 is also connected to the I/O interface 905 as necessary. A removable medium 911 such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, or the like is mounted on the drive 910 as necessary, so that a computer program read out therefrom is mounted into the storage section 908 as necessary.
In particular, the process described above with reference to fig. 1 may be implemented as a computer software program according to embodiments of the data query disclosed herein. For example, embodiments of the data queries disclosed herein include a computer program product comprising a computer program tangibly embodied on a machine-readable medium, the computer program containing program code for performing the method of FIG. 1. In such an embodiment, the computer program may be downloaded and installed from a network through the communication section 909, and/or installed from the removable medium 911.
It should be noted that the computer readable medium shown in the present invention can be a computer readable signal medium or a computer readable storage medium or any combination of the two. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples of the computer readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the present application, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.
In this application, however, a computer readable signal medium may include a propagated data signal with computer readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to: wireless, wire, fiber optic cable, RF, etc., or any suitable combination of the foregoing.
The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various data query embodiments of the present application. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
The units or modules described in the embodiments of the present application may be implemented by software or hardware. The described units or modules may also be provided in a processor, and may be described as: a processor comprises a sending module, a receiving module and a display module. The names of the units or modules do not form a limitation on the units or modules, for example, the sending module may also be described as "sending a data query request message to a query server, so that the query server obtains configuration information of the array load balancer server to be queried from a database in response to the data query request message; and/or obtaining status information of the instance of the array load balancer server to be queried from the snmp interface.
As another aspect, the present application also provides a computer-readable storage medium, which may be the computer-readable storage medium included in the foregoing device in the foregoing embodiment; or it may be a separate computer readable storage medium not incorporated into the device. The computer readable storage medium stores one or more programs for use by one or more processors in performing the method of determining a data query described herein, and in particular:
sending a data query request message to a query server, so that the query server responds to the data query request message and acquires configuration information of an array load balancer server to be queried from a database; and/or acquiring state information of the instance of the array load balancer server to be queried from the snmp interface;
and receiving the configuration information and/or the state information returned by the query server.
In summary, according to the data query method, the data query device, the data query terminal, and the data query medium provided in the embodiments of the present application, an operation and maintenance worker inputs a data query request message through a query page of a client, so that a background query server can obtain configuration information and/or instance state information of a corresponding array load balancing server from a database and/or a snmp interface according to the received data query request message, and return the configuration information and/or instance state information to the client, and thus the operation and maintenance worker can efficiently and accurately grasp the configuration information and the instance state information of all array load balancing servers by using a query platform, thereby improving query efficiency and reducing operation and maintenance costs.
The above description is only a preferred embodiment of the application and is illustrative of the principles of the technology employed. It will be appreciated by persons skilled in the art that the scope of the application referred to in the present application is not limited to the particular combination of features described above, but also covers other arrangements formed by any combination of the above features or their equivalents without departing from the spirit of the application. For example, the above features may be replaced with (but not limited to) features having similar functions disclosed in the present application.
Claims (12)
1. A method for data query, the method comprising:
sending a data query request message to a query server, so that the query server responds to the data query request message and acquires configuration information of an array load balancer server to be queried from a database; and/or acquiring state information of the instance of the array load balancer server to be queried from the snmp interface;
and receiving the configuration information and/or the state information returned by the query server.
2. The data query method according to claim 1, wherein the status information is obtained by the query server from a snmp interface based on identification information of an instance of the array load balancer server to be queried, the identification information being calculated by the query server based on a number of the instance, the number being read by the query server from the database based on the data query request message.
3. The data query method according to claim 1 or 2, wherein the configuration information in the database is uploaded by the data acquisition server at a preset period.
4. A data query method according to any one of claims 1 to 3, wherein after receiving the configuration information and/or the status information returned by the query server, the method further comprises:
and displaying the configuration information and/or the state information in a preset format.
5. A method for data query, the method comprising:
receiving a data query request message sent by a client;
responding to the data query request message, and acquiring configuration information of an array load balancer server to be queried from a database; and/or acquiring state information of the instance of the array load balancer server to be queried from the snmp interface;
and returning the configuration information and/or the state information to the client.
6. The data query method according to claim 5, wherein the obtaining the status information of the instance of the array load balancer server to be queried from the snmp interface comprises:
reading the number of the instance of the array load balancer server to be queried from the database based on the data query request message;
calculating identification information of the instance based on the number;
and acquiring the state information from the snmp interface based on the identification information.
7. A data query apparatus, characterized in that the apparatus comprises:
the system comprises a sending module, a query module and a query module, wherein the sending module is used for sending a data query request message to a query server so that the query server responds to the data query request message and acquires configuration information of an array load balancer server to be queried from a database; and/or acquiring state information of the instance of the array load balancer server to be queried from the snmp interface;
and the receiving module is used for receiving the configuration information and/or the state information returned by the query server.
8. The data query apparatus of claim 7, further comprising:
and the display module is used for displaying the configuration information and/or the state information in a preset format.
9. A data query apparatus, characterized in that the apparatus comprises:
the receiving module is used for receiving a data query request message sent by a client;
the query module is used for responding to the data query request message and acquiring the configuration information of the array load balancer server to be queried from a database; and/or acquiring state information of the instance of the array load balancer server to be queried from the snmp interface;
and the sending module is used for returning the configuration information and/or the state information to the client.
10. The data query apparatus of claim 9, wherein the query module comprises:
a reading unit, configured to read, based on the data query request message, a number of an instance of the array load balancer server to be queried from the database;
the calculating unit is used for calculating and obtaining the identification information of the instance based on the number;
and the acquisition unit is used for acquiring the state information from the snmp interface based on the identification information.
11. A terminal comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the data query method according to any one of claims 1-4 when executing the program.
12. A computer-readable storage medium on which a computer program for implementing the data query method according to any one of claims 1 to 4 is stored; or implementing a data query method as claimed in claim 5 or 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910482467.7A CN112035243A (en) | 2019-06-04 | 2019-06-04 | Data query method, device, terminal and medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910482467.7A CN112035243A (en) | 2019-06-04 | 2019-06-04 | Data query method, device, terminal and medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112035243A true CN112035243A (en) | 2020-12-04 |
Family
ID=73576672
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910482467.7A Pending CN112035243A (en) | 2019-06-04 | 2019-06-04 | Data query method, device, terminal and medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112035243A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115086136A (en) * | 2021-03-10 | 2022-09-20 | 北京国基科技股份有限公司 | Data acquisition and processing method and device based on simple network management protocol |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2016176650A1 (en) * | 2015-04-30 | 2016-11-03 | Amazon Technologies, Inc. | Managing load balancers associated with auto-scaling groups |
| US20160323187A1 (en) * | 2015-04-30 | 2016-11-03 | Amazon Technologies, Inc. | Managing load balancers associated with auto-scaling groups |
| CN107666401A (en) * | 2016-07-28 | 2018-02-06 | 平安科技（深圳）有限公司 | A kind of configuration information obtaining method and terminal |
| CN109241092A (en) * | 2018-10-15 | 2019-01-18 | 北京金山云网络技术有限公司 | Data query method, system and computer equipment |
-
2019
- 2019-06-04 CN CN201910482467.7A patent/CN112035243A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2016176650A1 (en) * | 2015-04-30 | 2016-11-03 | Amazon Technologies, Inc. | Managing load balancers associated with auto-scaling groups |
| US20160323187A1 (en) * | 2015-04-30 | 2016-11-03 | Amazon Technologies, Inc. | Managing load balancers associated with auto-scaling groups |
| CN107666401A (en) * | 2016-07-28 | 2018-02-06 | 平安科技（深圳）有限公司 | A kind of configuration information obtaining method and terminal |
| CN109241092A (en) * | 2018-10-15 | 2019-01-18 | 北京金山云网络技术有限公司 | Data query method, system and computer equipment |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115086136A (en) * | 2021-03-10 | 2022-09-20 | 北京国基科技股份有限公司 | Data acquisition and processing method and device based on simple network management protocol |
| CN115086136B (en) * | 2021-03-10 | 2023-07-14 | 北京国基科技股份有限公司 | Data acquisition and processing method and device based on simple network management protocol |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105915633B (en) | Automatic operation and maintenance system and method | |
| CN113987074A (en) | Distributed service full-link monitoring method and device, electronic equipment and storage medium | |
| CN106874135B (en) | Method, device and equipment for detecting machine room fault | |
| CN110347694B (en) | Equipment monitoring method, device and system based on Internet of things | |
| CN114024972B (en) | Long connection communication method, system, device, equipment and storage medium | |
| CN108897854A (en) | A kind of monitoring method and device of overtime task | |
| CN110851468A (en) | Method and device for making simulation response to test request of client | |
| CN107766509A (en) | A kind of method and apparatus of webpage static backup | |
| CN114024834A (en) | Fault positioning method and device, electronic equipment and readable storage medium | |
| CN117608825A (en) | Resource management method based on multi-cloud management platform and related equipment | |
| CN107704357B (en) | Log generation method and device | |
| CN105467907A (en) | Automatic inspection system and method | |
| CN106874371A (en) | A kind of data processing method and device | |
| CN112035243A (en) | Data query method, device, terminal and medium | |
| CN115951923B (en) | Subscription event management method, display system, device and storage medium | |
| CN108847949A (en) | Message informing method, device, electronic equipment and storage medium based on cloud platform | |
| CN114490100A (en) | Message queue telemetry transmission load balancing method and device and server | |
| CN112163708A (en) | Monitoring management system and method based on intelligent display terminal | |
| CN111010290A (en) | Service log processing method and device, electronic equipment and storage medium | |
| CN114125024B (en) | Audio transmission method, electronic device and readable storage medium | |
| CN105490846A (en) | Server virtualization management system and method | |
| CN113419745A (en) | Application instance number management method and device, electronic equipment and computer readable medium | |
| CN106411601A (en) | System and method for batch configuration of cloud terminal time | |
| CN108696549B (en) | Load balancing method, device and system | |
| CN111597156A (en) | Civil aviation data processing method and device, electronic equipment and storage medium |
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 |