CN116450612A - Configuration information management method, device, medium and equipment - Google Patents

Configuration information management method, device, medium and equipment Download PDF

Info

Publication number
CN116450612A
CN116450612A CN202310417153.5A CN202310417153A CN116450612A CN 116450612 A CN116450612 A CN 116450612A CN 202310417153 A CN202310417153 A CN 202310417153A CN 116450612 A CN116450612 A CN 116450612A
Authority
CN
China
Prior art keywords
database
configuration information
information
managed
managed database
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
CN202310417153.5A
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.)
Ping An E Wallet Electronic Commerce Co Ltd
Original Assignee
Ping An E Wallet Electronic Commerce 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 Ping An E Wallet Electronic Commerce Co Ltd filed Critical Ping An E Wallet Electronic Commerce Co Ltd
Priority to CN202310417153.5A priority Critical patent/CN116450612A/en
Publication of CN116450612A publication Critical patent/CN116450612A/en
Pending legal-status Critical Current

Links

Classifications

    • 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/21—Design, administration or maintenance of databases
    • 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/21—Design, administration or maintenance of databases
    • G06F16/214—Database migration support
    • 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/25—Integrating or interfacing systems involving database management systems
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
    • G06F21/60—Protecting data
    • G06F21/62—Protecting access to data via a platform, e.g. using keys or access control rules
    • G06F21/6218—Protecting access to data via a platform, e.g. using keys or access control rules to a system of files or objects, e.g. local or distributed file system or database
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F2221/00—Indexing scheme relating to security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
    • G06F2221/21—Indexing scheme relating to G06F21/00 and subgroups addressing additional information or applications relating to security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
    • G06F2221/2141—Access rights, e.g. capability lists, access control lists, access tables, access matrices
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
    • Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management

Abstract

The application discloses a configuration information management method, a device medium and equipment, wherein the method comprises the following steps: reading connection configuration information of a managed database stored in a resource configuration table according to the timing task trigger signal; based on the connection configuration information, sending an attribute configuration information acquisition request to a managed database, and receiving attribute configuration feedback information of the attribute configuration information acquisition request; and managing the attribute configuration information of the managed database stored in the resource configuration table according to the attribute configuration feedback information. According to the method and the device, the connection configuration information of the managed database stored in the resource configuration table is read every preset period according to the timing task trigger signal, the attribute configuration information is acquired according to the connection configuration information, and the configuration information in the resource configuration table is managed, so that the attribute configuration information of the managed database is automatically managed, the accuracy and timeliness of acquiring the attribute configuration information are improved, and meanwhile, the working efficiency is also improved.

Description

Configuration information management method, device, medium and equipment
Technical Field
The present invention belongs to the technical field of data processing, and in particular, relates to a method, an apparatus, a medium, and a device for managing configuration information.
Background
The configuration management database is used for storing various configuration information for managing devices in the enterprise network architecture, and is closely associated with all service support and service delivery flows. In practical application, configuration information in a network architecture is continuously changed due to online and offline or upgrading of equipment and services, and the configuration information needs to be synchronized into a configuration management database in time so that an operation and maintenance platform can operate according to the configuration information.
The existing method for acquiring the configuration information of the equipment in the network architecture by the configuration management database is a manual input method, and the manual input method has the following problems: the method comprises the following steps of (1) manual input, large error and low accuracy; the manual input workload is large, and the efficiency is low; (3) The newly added or migrated assets cannot be updated in time, the timeliness is poor, and the information is inaccurate.
Disclosure of Invention
In view of this, the invention provides a configuration information management method, a device, a medium and equipment, and mainly aims to solve the problems of low accuracy, low efficiency and poor timeliness of the existing configuration information management method that configuration information of a managed database is manually input.
According to one aspect of the present application, there is provided a configuration information management method applied to a configuration management database, the method comprising:
responding to the timing task trigger signal, and reading the connection configuration information of the managed database stored in the resource configuration table;
based on the connection configuration information, sending an attribute configuration information acquisition request to the managed database, and receiving attribute configuration feedback information of the attribute configuration information acquisition request;
and managing the attribute configuration information of the managed database stored in the resource configuration table according to the attribute configuration feedback information.
Optionally, the connection configuration information includes a name, an account number, a password, an IP address and a connection port of the database, and the attribute configuration information includes a connection state, a role and version information of the database; the sending an attribute configuration information acquisition request to the managed database based on the connection configuration information, receiving attribute configuration feedback information of the attribute configuration information acquisition request, including:
acquiring the type of the managed database from a preset database type table according to the name of the managed database;
based on the account number and the password of the managed database and an interface matched with the type of the managed database, sending a connection request to an IP address and a connection port of the managed database;
and after receiving the feedback information of the connection request, sending an access right acquisition request and a version information acquisition request to the IP address and the connection port of the managed database, and receiving the feedback information of the access right acquisition request and the feedback information of the version information acquisition request.
Optionally, the managing the attribute configuration information of the managed database stored in the resource configuration table according to the attribute configuration feedback information includes:
and modifying the connection state of the managed database in the resource configuration table according to the feedback information of the connection request, modifying the role of the managed database in the resource configuration table according to the feedback information of the access right acquisition request, and modifying the version information of the managed database in the resource configuration table according to the feedback information of the version information acquisition request.
Optionally, the modifying the role of the managed database in the resource configuration table according to the feedback information of the access right acquisition request includes:
if the feedback information of the access right acquisition request is the read-write right, the role of the managed database is the main database; and if the feedback information of the access right acquisition request is read-only right, the role of the managed database is standby database.
Optionally, the configuration information management method further includes:
responding to a database newly-added signal, acquiring installation information of a newly-added database, and reading connection configuration information of a newly-added managed database from the installation information of the newly-added database; and/or the number of the groups of groups,
responding to a database migration completion signal, acquiring database migration information, and reading connection configuration information of a newly added managed database from the database migration information;
and adding the connection configuration information of the newly added managed database in the resource configuration table.
Optionally, the configuration information management method further includes: and if the attribute configuration information of the managed database is not stored in the resource configuration table, adding the attribute configuration information of the unmanaged database in the resource configuration table.
Optionally, the method further comprises: based on the IP address of the managed database, a server information acquisition request is sent to a server corresponding to the managed database, feedback information of the server information acquisition request is received, and server information corresponding to the managed database is added in the resource configuration table according to the feedback information of the server information acquisition request.
According to another aspect of the present application, there is provided a configuration information management apparatus applied to a configuration management database, including:
the first connection configuration information acquisition module is used for responding to the timing task trigger signal and reading the connection configuration information of the managed database stored in the resource configuration table;
the attribute configuration information acquisition module is used for sending an attribute configuration information acquisition request to the managed database based on the connection configuration information and receiving attribute configuration feedback information of the attribute configuration information acquisition request;
and the management module is used for managing the attribute configuration information of the managed database stored in the resource configuration table according to the attribute configuration feedback information.
Optionally, the connection configuration information includes a name, an account number, a password, an IP address and a connection port of the database, and the attribute configuration information includes a connection state, a role and version information of the database; the sending an attribute configuration information acquisition request to the managed database based on the connection configuration information, receiving attribute configuration feedback information of the attribute configuration information acquisition request, including:
acquiring the type of the managed database from a preset database type table according to the name of the managed database;
based on the account number and the password of the managed database and an interface matched with the type of the managed database, sending a connection request to an IP address and a connection port of the managed database;
and after receiving the feedback information of the connection request, sending an access right acquisition request and a version information acquisition request to the IP address and the connection port of the managed database, and receiving the feedback information of the access right acquisition request and the feedback information of the version information acquisition request.
Optionally, the managing the attribute configuration information of the managed database stored in the resource configuration table according to the attribute configuration feedback information includes:
and modifying the connection state of the managed database in the resource configuration table according to the feedback information of the connection request, modifying the role of the managed database in the resource configuration table according to the feedback information of the access right acquisition request, and modifying the version information of the managed database in the resource configuration table according to the feedback information of the version information acquisition request.
Optionally, the modifying the role of the managed database in the resource configuration table according to the feedback information of the access right acquisition request includes:
if the feedback information of the access right acquisition request is the read-write right, the role of the managed database is the main database; and if the feedback information of the access right acquisition request is read-only right, the role of the managed database is standby database.
Optionally, the configuration information management device further includes:
the second connection configuration information module is used for responding to the database newly-added signal, acquiring the installation information of the newly-added database and reading the connection configuration information of the newly-added managed database from the installation information of the newly-added database; and/or the number of the groups of groups,
responding to a database migration completion signal, acquiring database migration information, and reading connection configuration information of a newly added managed database from the database migration information;
and the adding module is used for adding the connection configuration information of the newly added managed database in the resource configuration table.
Optionally, if the attribute configuration information of the managed database is not stored in the resource configuration table, adding the attribute configuration information of the unmanaged database in the resource configuration table.
Optionally, the configuration information management device further includes: the server information acquisition module is used for sending a server information acquisition request to a server corresponding to the managed database based on the IP address of the managed database, receiving feedback information of the server information acquisition request, and adding the server information corresponding to the managed database in the resource configuration table according to the feedback information of the server information acquisition request.
According to another aspect of the present application, there is provided a storage medium having stored therein at least one executable instruction for causing a processor to perform operations corresponding to the above configuration information management method.
According to another aspect of the present application, there is provided a computer device comprising: the device comprises a processor, a memory, a communication interface and a communication bus, wherein the processor, the memory and the communication interface complete communication with each other through the communication bus;
the memory is used for storing at least one executable instruction, and the executable instruction enables the processor to execute the operation corresponding to the configuration information management method.
By means of the technical scheme, the configuration information management method, the device, the medium and the equipment provided by the application are used for reading the connection configuration information of the managed database stored in the resource configuration table every other preset period according to the timing task trigger signal, acquiring the attribute configuration information according to the connection configuration information, and managing the configuration information in the resource configuration table according to the acquired attribute configuration information, so that the attribute configuration information of the managed database is automatically managed, the accuracy and timeliness of acquiring the attribute configuration information are improved, and meanwhile, the working efficiency is also improved.
The foregoing description is only an overview of the present invention, and is intended to be implemented in accordance with the teachings of the present invention in order that the same may be more clearly understood and to make the same and other objects, features and advantages of the present invention more readily apparent.
Drawings
Various other advantages and benefits will become apparent to those of ordinary skill in the art upon reading the following detailed description of the preferred embodiments. The drawings are only for purposes of illustrating the preferred embodiments and are not to be construed as limiting the invention. Also, like reference numerals are used to designate like parts throughout the figures. In the drawings:
fig. 1 shows a flowchart of a configuration information management method provided in an embodiment of the present application;
FIG. 2 is another flow chart of a configuration information management method according to an embodiment of the present application;
FIG. 3 is a flowchart illustrating a configuration information management method according to an embodiment of the present application;
FIG. 4 is a flowchart illustrating a configuration information management method according to an embodiment of the present application;
fig. 5 shows a block diagram of a configuration information management apparatus provided in an embodiment of the present application;
fig. 6 shows a schematic structural diagram of a computer device according to an embodiment of the present application.
In the figure: 502-a first connection configuration information acquisition module; 504-an attribute configuration information acquisition module; 506-a management module; 602-a processor; 604-a communication interface; 606-memory; 608-a communication bus; 610-procedure.
Detailed Description
The invention will be described in detail hereinafter with reference to the drawings in conjunction with embodiments. It should be noted that, without conflict, the embodiments of the present invention and features of the embodiments may be combined with each other.
In order to further describe the technical means and effects adopted for achieving the preset aim of the invention, the following detailed description refers to the specific implementation, structure, characteristics and effects according to the application of the invention with reference to the accompanying drawings and preferred embodiments. In the following description, different "an embodiment" or "an embodiment" do not necessarily refer to the same embodiment. Furthermore, the particular features, structures, or characteristics of one or more embodiments may be combined in any suitable manner.
Aiming at the problems of low accuracy, low efficiency and poor timeliness of the existing configuration information management method which adopts manual entry of configuration information of a managed database, the embodiment of the application provides a configuration information management method which is applied to the configuration management database, as shown in figure 1, and the method comprises the following steps:
102: responding to the timing task trigger signal, and reading the connection configuration information of the managed database stored in the resource configuration table;
specifically, a Configuration Management Database (CMDB) is a heart in an enterprise network architecture, and is used for managing various configuration information of devices in the enterprise network architecture, so that an operation and maintenance platform can perform corresponding operations according to the configuration information.
The managed database is a database storing business service data under the same network architecture as the configuration management database, and includes databases not limited to storing data of commodity services, insurance claims, financial services, logistics management, medical services and the like.
The configuration management database manages configuration information through a resource configuration table, the resource configuration table reflects the mapping relation between the managed database and configuration information corresponding to the managed database, the operation and maintenance platform reads the configuration information of a certain managed database from the resource configuration table to perform corresponding operation, the configuration information of the managed database is stored in the resource configuration table, the configuration information comprises connection configuration information and attribute configuration information, and the connection configuration information is information required when the configuration management database is connected with the managed database through a preset interface, such as an account number, a password, an IP (Internet protocol) and a port of the database. The attribute configuration information represents attribute information of the managed database, such as a host, version, and the like.
The configuration information management method comprises application scenes such as insurance business, product updating, claim settlement operation, public service, financial service, logistics management and the like.
In this embodiment, after the configuration management data receives the timing task trigger signal, the connection configuration information of each managed database is read from the resource configuration table, the attribute configuration information of each managed database is obtained according to the connection configuration information, the attribute configuration information of the managed database is obtained every preset time interval through the timing task trigger signal, the attribute configuration information of the managed database is automatically obtained, the manual entry is replaced, and the accuracy and the working efficiency are improved.
In another embodiment of the present invention, in one embodiment, the configuration information management method further includes:
responding to the database newly-added signal, acquiring the installation information of the newly-added database, and reading the connection configuration information of the newly-added managed database from the installation information of the newly-added database; and/or the number of the groups of groups,
responding to the database migration completion signal, acquiring database migration information, and reading the connection configuration information of the newly added managed database from the database migration information;
and adding the connection configuration information of the newly added managed database in the resource configuration table.
In this embodiment, under the condition that the new database and the configuration management database belong to the same network architecture platform, a new database signal sent to the configuration management database is set in an installation program of the new database, in the process of installing the new database, the new database signal is sent to the configuration management database, after the configuration management database obtains the new database signal, the installation information of the new database is read by a preset interface, the installation information of the new database includes connection configuration information of the new database, that is, the connection configuration information of the new managed database is obtained, and the connection configuration information of the new managed database is added in a resource configuration table.
When the database is migrated, namely when some data is migrated from the original database to the new database, after the database is migrated successfully, the original database sends the connection configuration information of the new database to the configuration management database through a preset interface, namely the connection configuration information of the managed database which is newly added through a migration mode is obtained, and the connection configuration information of the newly added managed database is added into the resource configuration table.
Compared with the prior art, the configuration information management method provided by the application acquires the connection configuration information of the newly added managed database according to the newly added signal or the database migration completion signal, acquires the attribute configuration information according to the connection configuration information of the newly added managed database, and improves the timeliness of the configuration management database for acquiring the configuration information of the newly added database and the migration database.
104: based on the connection configuration information, sending an attribute configuration information acquisition request to a managed database, and receiving attribute configuration feedback information of the attribute configuration information acquisition request;
in this embodiment, attribute configuration feedback information from the managed databases is obtained according to the connection configuration information, that is, attribute configuration information of each managed database is obtained.
In another embodiment of the present invention, for further limitation and explanation, as shown in fig. 2, the connection configuration information includes a name, an account number, a password, an IP address, and a connection port of the database, and the attribute configuration information includes a connection state, a role, and version information of the database; based on the connection configuration information, sending an attribute configuration information acquisition request to the managed database, and receiving attribute configuration feedback information of the attribute configuration information acquisition request, wherein the method comprises the following steps:
202: acquiring the type of the managed database from a preset database type table according to the name of the managed database;
204: based on the account number and the password of the managed database and an interface matched with the type of the managed database, sending a connection request to the IP address and the connection port of the managed database;
206: after receiving the feedback information of the connection request, sending an access right acquisition request and a version information acquisition request to the IP address and the connection port of the managed database, and receiving the feedback information of the access right acquisition request and the feedback information of the version information acquisition request.
In this embodiment, the managed database has multiple types, for example MySQL, noSQL, etc., the managed database is set with a name when being built, the name and type of the managed database are filled in a preset database type table, different types of database interfaces are set in the configuration management database, and a request is sent to the managed database through the database interfaces. Firstly, a connection request is sent to an IP address and a connection port of a managed database through an interface matched with the managed database, an account number and a password of the managed database are contained in the connection request, after the managed database receives the connection request, information of the managed database is checked, feedback information of the connection request, such as connection success or connection failure, is sent after the feedback information of the connection success is received, the configuration management database continues to send an access right acquisition request and a version information acquisition request to the IP address and the connection port of the managed database respectively, after the managed database receives the two requests, access right and version information of the managed database are acquired, and feedback information of the access right acquisition request and feedback information of the version information acquisition request are sent to the managed database, so that the managed database modifies attribute configuration information according to the feedback information.
106: and managing the attribute configuration information of the managed database stored in the resource configuration table according to the attribute configuration feedback information.
Specifically, the attribute configuration feedback information and the attribute configuration information stored in the resource configuration table are compared, and the attribute configuration information in the resource configuration table is modified according to the comparison result.
In this embodiment, for further limitation and explanation, as shown in fig. 3, managing attribute configuration information of a managed database stored in a resource configuration table according to attribute configuration feedback information includes:
302: modifying the connection state of the managed database in the resource configuration table according to the feedback information of the connection request;
304: modifying roles of the managed database in the resource configuration table according to the feedback information of the access right acquisition request;
306: and modifying version information of the managed database in the resource configuration table according to the feedback information of the version information acquisition request.
In this embodiment, if the feedback information of the connection request is connection success, the connection state of the managed database in the resource configuration table is read, if the connection state is online, no modification is made, if the connection state is offline, the offline in the resource configuration table is changed to the online state, and if the feedback information of the connection request is connection failure, the connection state of the managed database in the resource configuration table is read, if the connection state is offline, no modification is made, and if the connection state is offline, the online state in the resource configuration table is changed to the offline state. If the access right is read-write, the role of the management database is a main database, if the access right is read-only, the role of the management database is a standby database, and if the recorded role is different from the feedback information acquired according to the request, the role in the resource configuration table is modified into the feedback information acquired according to the request. And reading version information of the managed database recorded in the resource configuration table, and if the recorded version information is different from the version information acquired according to the request, modifying the version information in the resource configuration table into the version information acquired according to the request. The real-time configuration information of the managed database is obtained, and the operation and maintenance platform is convenient to use.
In one embodiment, modifying the role of the managed database in the resource configuration table according to the feedback information of the access rights acquisition request includes:
if the feedback information of the access right acquisition request is the read-write right, the role of the managed database is the main database; and if the feedback information of the access right acquisition request is read-only right, the role of the managed database is to be a standby database.
In this embodiment, the read-write authority of the managed database represents the role of the managed database, if the managed database is the read-write authority, this is indicated as the master database, and if the managed database is the read-only authority, this is indicated as the backup database, and the role of the managed database is modified in the resource allocation table according to the read-write authority.
In one embodiment, the configuration information management method further includes: if the attribute configuration information of the managed database is not stored in the resource configuration table, adding the attribute configuration information of the unmanaged database in the resource configuration table.
In this embodiment, if the managed database is a newly added database or a migrated database, only the connection configuration information of the newly added managed database is stored in the resource configuration table, and the attribute configuration information is not stored, so after the attribute configuration information of the newly added managed database is obtained, the attribute configuration information of the newly added managed database is added in the resource configuration table, thereby improving the timeliness of obtaining the configuration information of the newly added database and the migrated database by the configuration management database.
Compared with the prior art, the configuration information management method provided by the application has the advantages that the connection configuration information of the managed database stored in the resource configuration table is read every preset period according to the timing task trigger signal, the attribute configuration information is acquired according to the connection configuration information, the configuration information in the resource configuration table is managed according to the acquired attribute configuration information, the attribute configuration information of the managed database is automatically managed, the accuracy and timeliness of acquiring the attribute configuration information are improved, and meanwhile the working efficiency is also improved.
In one embodiment, as shown in fig. 4, the configuration information management method further includes:
402: based on the IP address of the managed database, sending a server information acquisition request to a server corresponding to the managed database;
404: receiving feedback information of a server information acquisition request;
406: and adding server information corresponding to the managed database in the resource configuration table according to the feedback information of the server information acquisition request.
The existing configuration management database only contains configuration information corresponding to the managed database, only the configuration information is insufficient, and sometimes the operation and maintenance platform also needs server information corresponding to the managed database, for example, when the server is abnormal, the operation and maintenance platform can know the name of the server, the machine room number where the server is located and the like through the server information. Therefore, in this embodiment, based on the IP address of the managed database, a server information acquisition request is sent to the server corresponding to the managed database, the server information is obtained, and the obtained server information is stored in the resource configuration table, so that the operation and maintenance platform can conveniently acquire the server information corresponding to the managed database. The server information includes: hostname, the number of the machine room where the server is located, the security process, etc.
Further, as an implementation of the method shown in fig. 1, an embodiment of the present invention provides a configuration information management apparatus, which is applied to a configuration management database, as shown in fig. 5, where the apparatus includes:
a first connection configuration information obtaining module 502, configured to read connection configuration information of a managed database stored in a resource configuration table in response to a timing task trigger signal;
an attribute configuration information acquisition module 504, configured to send an attribute configuration information acquisition request to a managed database based on the connection configuration information, and receive attribute configuration feedback information of the attribute configuration information acquisition request;
and the management module 506 is configured to manage attribute configuration information of the managed database stored in the resource configuration table according to the attribute configuration feedback information.
Compared with the prior art, the configuration information management device has the advantages that connection configuration information of a managed database stored in a resource configuration table is read every preset period according to a timing task trigger signal, attribute configuration information is acquired according to the connection configuration information, the configuration information in the resource configuration table is managed according to the acquired attribute configuration information, the attribute configuration information of the managed database is automatically managed, the accuracy and timeliness of acquiring the attribute configuration information are improved, and meanwhile, the working efficiency is improved.
In one embodiment, the connection configuration information includes a name, an account number, a password, an IP address, and a connection port of the database, and the attribute configuration information includes a connection state, a role, and version information of the database; based on the connection configuration information, sending an attribute configuration information acquisition request to the managed database, and receiving attribute configuration feedback information of the attribute configuration information acquisition request, wherein the method comprises the following steps:
acquiring the type of the managed database from a preset database type table according to the name of the managed database;
based on the account number and the password of the managed database and an interface matched with the type of the managed database, sending a connection request to the IP address and the connection port of the managed database;
after receiving the feedback information of the connection request, sending an access right acquisition request and a version information acquisition request to the IP address and the connection port of the managed database, and receiving the feedback information of the access right acquisition request and the feedback information of the version information acquisition request.
In one embodiment, managing attribute configuration information of a managed database stored in a resource configuration table according to attribute configuration feedback information includes:
and modifying the connection state of the managed database in the resource configuration table according to the feedback information of the connection request, modifying the role of the managed database in the resource configuration table according to the feedback information of the access right acquisition request, and modifying the version information of the managed database in the resource configuration table according to the feedback information of the version information acquisition request.
In one embodiment, modifying the role of the managed database in the resource configuration table according to the feedback information of the access rights acquisition request includes:
if the feedback information of the access right acquisition request is the read-write right, the role of the managed database is the main database; and if the feedback information of the access right acquisition request is read-only right, the role of the managed database is to be a standby database.
In one embodiment, the configuration information management apparatus further includes:
the second connection configuration information module is used for responding to the database newly-added signal, acquiring the installation information of the newly-added database and reading the connection configuration information of the newly-added managed database from the installation information of the newly-added database; and/or the number of the groups of groups,
responding to the database migration completion signal, acquiring database migration information, and reading the connection configuration information of the newly added managed database from the database migration information;
and the adding module is used for adding the connection configuration information of the newly added managed database in the resource configuration table.
In one embodiment, if the attribute configuration information of the managed database is not stored in the resource configuration table, the attribute configuration information of the unmanaged database is added in the resource configuration table.
In one embodiment, the configuration information management apparatus further includes: the server information acquisition module is used for sending a server information acquisition request to a server corresponding to the managed database based on the IP address of the managed database, receiving feedback information of the server information acquisition request, and adding the server information corresponding to the managed database in the resource configuration table according to the feedback information of the server information acquisition request.
According to an embodiment of the present invention, there is provided a storage medium storing at least one executable instruction for performing the configuration information management method in any of the above-described method embodiments.
Fig. 6 is a schematic structural diagram of a computer device according to an embodiment of the present invention, and the specific embodiment of the present invention is not limited to the specific implementation of the computer device.
As shown in fig. 6, the computer device may include: a processor 602, a communication interface (Communications Interface), a memory 606, and a communication bus 608.
Wherein: processor 602, communication interface 604, and memory 606 perform communication with each other via communication bus 608.
Communication interface 604 is used to communicate with network elements of other devices, such as clients or other servers.
The processor 602 is configured to execute the program 610, and may specifically perform relevant steps in the above-described modification method embodiment of the data query statement.
In particular, program 610 may include program code including computer-operating instructions.
The processor 602 may be a central processing unit CPU or a specific integrated circuit ASIC (Application Specific Integrated Circuit) or one or more integrated circuits configured to implement embodiments of the present invention. The one or more processors included in the computer device may be the same type of processor, such as one or more CPUs; but may also be different types of processors such as one or more CPUs and one or more ASICs.
A memory 606 for storing a program 610. The memory 606 may comprise high-speed RAM memory or may further comprise non-volatile memory (non-volatile memory), such as at least one disk memory.
The program 610 may be specifically operable to cause the processor 602 to:
reading connection configuration information of a managed database stored in a resource configuration table according to the timing task trigger signal;
based on the connection configuration information, sending an attribute configuration information acquisition request to a managed database, and receiving attribute configuration feedback information of the attribute configuration information acquisition request;
and managing the attribute configuration information of the managed database stored in the resource configuration table according to the attribute configuration feedback information.
The above embodiments are only exemplary embodiments of the present application and are not intended to limit the present application, the scope of which is defined by the claims. Various modifications and equivalent arrangements may be made to the present application by those skilled in the art, which modifications and equivalents are also considered to be within the scope of the present application.

Claims (10)

1. A method for managing configuration information, applied to a configuration management database, comprising:
responding to the timing task trigger signal, and reading the connection configuration information of the managed database stored in the resource configuration table;
based on the connection configuration information, sending an attribute configuration information acquisition request to the managed database, and receiving attribute configuration feedback information of the attribute configuration information acquisition request;
and managing the attribute configuration information of the managed database stored in the resource configuration table according to the attribute configuration feedback information.
2. The configuration information management method according to claim 1, wherein the connection configuration information includes a name, an account number, a password, an IP address, and a connection port of the database, and the attribute configuration information includes a connection state, a role, and version information of the database; the sending an attribute configuration information acquisition request to the managed database based on the connection configuration information, receiving attribute configuration feedback information of the attribute configuration information acquisition request, including:
acquiring the type of the managed database from a preset database type table according to the name of the managed database;
based on the account number and the password of the managed database and an interface matched with the type of the managed database, sending a connection request to an IP address and a connection port of the managed database;
and after receiving the feedback information of the connection request, sending an access right acquisition request and a version information acquisition request to the IP address and the connection port of the managed database, and receiving the feedback information of the access right acquisition request and the feedback information of the version information acquisition request.
3. The configuration information management method according to claim 2, wherein said managing the attribute configuration information of the managed database stored in the resource configuration table according to the attribute configuration feedback information includes:
and modifying the connection state of the managed database in the resource configuration table according to the feedback information of the connection request, modifying the role of the managed database in the resource configuration table according to the feedback information of the access right acquisition request, and modifying the version information of the managed database in the resource configuration table according to the feedback information of the version information acquisition request.
4. The configuration information management method according to claim 3, wherein said modifying the roles of said managed database in said resource configuration table according to the feedback information of the access right acquisition request comprises:
if the feedback information of the access right acquisition request is the read-write right, the role of the managed database is the main database; and if the feedback information of the access right acquisition request is read-only right, the role of the managed database is standby database.
5. The configuration information management method according to claim 1, wherein the method further comprises:
responding to a database newly-added signal, acquiring installation information of a newly-added database, and reading connection configuration information of a newly-added managed database from the installation information of the newly-added database; and/or the number of the groups of groups,
responding to a database migration completion signal, acquiring database migration information, and reading connection configuration information of a newly added managed database from the database migration information;
and adding the connection configuration information of the newly added managed database in the resource configuration table.
6. The configuration information management method according to claim 5, wherein the method further comprises:
and if the attribute configuration information of the managed database is not stored in the resource configuration table, adding the attribute configuration information of the unmanaged database in the resource configuration table.
7. The configuration information management method according to claim 3, wherein the method further comprises:
based on the IP address of the managed database, a server information acquisition request is sent to a server corresponding to the managed database, feedback information of the server information acquisition request is received, and server information corresponding to the managed database is added in the resource configuration table according to the feedback information of the server information acquisition request.
8. A configuration information management apparatus, characterized by being applied to a configuration management database, comprising:
the first connection configuration information acquisition module is used for responding to the timing task trigger signal and reading the connection configuration information of the managed database stored in the resource configuration table;
the attribute configuration information acquisition module is used for sending an attribute configuration information acquisition request to the managed database based on the connection configuration information and receiving attribute configuration feedback information of the attribute configuration information acquisition request;
and the management module is used for managing the attribute configuration information of the managed database stored in the resource configuration table according to the attribute configuration feedback information.
9. A storage medium having stored therein at least one executable instruction for causing a processor to perform operations corresponding to the configuration information management method of any one of claims 1-7.
10. A computer device, comprising: the device comprises a processor, a memory, a communication interface and a communication bus, wherein the processor, the memory and the communication interface complete communication with each other through the communication bus;
the memory is configured to store at least one executable instruction, where the executable instruction causes the processor to perform operations corresponding to the configuration information management method according to any one of claims 1 to 7.
CN202310417153.5A 2023-04-11 2023-04-11 Configuration information management method, device, medium and equipment Pending CN116450612A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202310417153.5A CN116450612A (en) 2023-04-11 2023-04-11 Configuration information management method, device, medium and equipment

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202310417153.5A CN116450612A (en) 2023-04-11 2023-04-11 Configuration information management method, device, medium and equipment

Publications (1)

Publication Number Publication Date
CN116450612A true CN116450612A (en) 2023-07-18

Family

ID=87121633

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202310417153.5A Pending CN116450612A (en) 2023-04-11 2023-04-11 Configuration information management method, device, medium and equipment

Country Status (1)

Country Link
CN (1) CN116450612A (en)

Similar Documents

Publication Publication Date Title
US8336047B2 (en) Provisioning virtual resources using name resolution
US20100115070A1 (en) Method for generating manipulation requests of an initialization and administration database of server cluster, data medium and corresponding a server cluster, data medium and corresponding service cluster
US9015294B2 (en) System and method for assigning addresses to information handling systems
US7953827B2 (en) System and method for dynamic allocation of information handling system network addresses
CN103067463A (en) Centralized management system and centralized management method for user root permission
US7761552B2 (en) Root node for integrating NAS of different user name spaces
CN103634144A (en) Method, system and equipment for managing multi-IDC (internet data center) cluster configuration file
US11226982B2 (en) Synchronization of offline instances
CN109213604B (en) Data source management method and device
CN109522043B (en) Method and device for managing configuration data and storage medium
CN112217656A (en) Method and device for synchronizing configuration information of network equipment in SD-WAN (secure digital-to-Wide area network) system
US20150089499A1 (en) Topology management method and system of virtual machines
CN112256439B (en) Service directory dynamic updating system and method based on cloud computing resource pool
CN102272751A (en) Data integrity in a database environment through background synchronization
CN111818145B (en) File transmission method, device, system, equipment and storage medium
CN104104582A (en) Data storage path management method, client and server
CN110532123B (en) Fault transfer method and device of HBase system
CN115686374A (en) Information acquisition method, information acquisition device, storage system, information acquisition device, and storage medium
US9160705B2 (en) Identifier management
CN111274004B (en) Process instance management method and device and computer storage medium
CN110798358B (en) Distributed service identification method and device, computer readable medium and electronic equipment
CN116450612A (en) Configuration information management method, device, medium and equipment
CN114866416A (en) Multi-cluster unified management system and deployment method
CN114205329A (en) Equipment coding method and device
US9305000B1 (en) Creating and publishing service level representations of applications from operational representations

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