WO2021169264A1

WO2021169264A1 - Automatic scheduling method and apparatus for database access layer middleware

Info

Publication number: WO2021169264A1
Application number: PCT/CN2020/117425
Authority: WO
Inventors: 陈繁
Original assignee: 平安科技（深圳）有限公司
Priority date: 2020-02-24
Filing date: 2020-09-24
Publication date: 2021-09-02
Also published as: CN111339194A

Abstract

An automatic scheduling method and apparatus for database access layer middleware, a computer device, and a storage medium, relating to the technical field of big data. The automatic scheduling method for the database access layer middleware comprises: receiving a scheduling request, wherein the scheduling request comprises configuration information, and an object to be stored of the configuration information is a first synchronization node (S10); storing the configuration information to the first synchronization node (S20); utilizing the first synchronization node to synchronously update configuration information of the remaining synchronization nodes except the first synchronization node in a database resource available area (S30); generating or modifying the database access layer middleware in the database resource available area according to the configuration information (S40); and scheduling, according to the configuration information, the database access layer middleware by using a pacemaker (S50). By using the method, automatic scheduling of the database access layer middleware can be achieved under a cross-region and cross-computer-room distributed architecture.

Description

Automatic dispatching method and device of database access layer middleware

This application claims the priority of a Chinese patent application filed with the Chinese Patent Office on February 24, 2020, the application number is 202010112926.5, and the invention title is "Automatic scheduling method and device for database access layer middleware", the entire content of which is incorporated by reference Incorporated in this application.

Technical field

This application relates to the field of big data technology, and in particular to an automatic scheduling method and device for database access layer middleware.

Background technique

Database access layer middleware is a kind of database middleware, which exists as database access, proxy, and load balancing. It focuses on the database access layer and realizes the proxy function from the user to the database.

For the database, automatic scheduling is completed by the database access layer middleware, which means that the database access layer middleware has a good back-end database load and balanced scheduling capabilities, but it has little or no capacity. The ability to automatically schedule. The inventor realized that the traditional database access layer middleware dealt with a few or more than a dozen computer devices located in the same computer room or database resource available area, and could not achieve a cross-regional and cross-computer room distributed architecture. Automatic scheduling of middleware in the lower database access layer.

technical problem

In view of this, the embodiments of the present application provide an automatic scheduling method, device, computer equipment, and storage medium for database access layer middleware to solve the current inability to achieve database access under a cross-regional and cross-computer room distributed architecture. The problem of automatic scheduling of entry-level middleware.

Technical solutions

In the first aspect, an embodiment of the present application provides an automatic scheduling method for database access layer middleware, including: receiving a scheduling request, wherein the scheduling request includes configuration information, and the object to be stored of the configuration information is the first Synchronization node; storing the configuration information in the first synchronization node; using the first synchronization node to remove the remaining synchronization nodes of the first synchronization node from the database resource available area to synchronize the configuration information Update; According to the configuration information, generate or modify the database access layer middleware in the available area of the database resources; according to the configuration information, use pacemaker to schedule the database access layer middleware.

In a second aspect, an embodiment of the present application provides an automatic scheduling device for database access layer middleware, including: a receiving module for receiving a scheduling request, wherein the scheduling request includes configuration information, and the configuration information is pending The storage object is the first synchronization node; the storage module is used to store the configuration information in the first synchronization node; the synchronization update module is used to use the first synchronization node to remove the database resource available area The remaining synchronization nodes of the first synchronization node perform the synchronization update of the configuration information; the middleware configuration module is used to generate or modify the database access layer middleware in the available area of the database resources according to the configuration information; middleware The scheduling module is configured to use pacemaker to schedule the database access layer middleware according to the configuration information.

In a third aspect, a computer device includes a memory, a processor, and a computer program that is stored in the memory and can run on the processor, and the processor implements the database access layer when the computer program is executed. The steps of an automatic scheduling method for middleware, wherein the method includes: receiving a scheduling request, wherein the scheduling request includes configuration information, and the object to be stored of the configuration information is the first synchronization node; storing the configuration information To the first synchronization node; use the first synchronization node to remove the remaining synchronization nodes of the first synchronization node from the database resource available area, and perform the synchronization update of the configuration information; according to the configuration information, The database resource available area generates or modifies database access layer middleware; according to the configuration information, pacemaker is used to schedule the database access layer middleware.

In a fourth aspect, an embodiment of the present application provides a computer-readable storage medium, including: a computer program that, when executed by a processor, realizes the steps of the automatic scheduling method of the database access layer middleware, wherein: The method includes the following steps: receiving a scheduling request, where the scheduling request includes configuration information, and the object to be stored of the configuration information is a first synchronization node; storing the configuration information in the first synchronization node; The first synchronization node removes the remaining synchronization nodes of the first synchronization node from the database resource available area, and performs the synchronization update of the configuration information; according to the configuration information, the database is generated or modified in the database resource available area Access layer middleware; according to the configuration information, use pacemaker to schedule the database access layer middleware.

Beneficial effect

In the embodiment of the present application, a scheduling request is first received, where the scheduling request includes configuration information, and the object to be stored for the configuration information is the first synchronization node, which can realize the function of receiving configuration information through any synchronization node; then the configuration information is stored To the first synchronization node, use the first synchronization node to remove the remaining synchronization nodes of the database resource available area from the first synchronization node, and perform the synchronization update of the configuration information. When any synchronization node receives the scheduling request, according to the configuration information Synchronously update the remaining synchronization nodes in the available area of the database resource, so that the remaining synchronization nodes can obtain the latest configuration information in near real time; then, according to the configuration information, generate or modify the database access layer middleware in the available area of the database resource. The database access layer middleware for the configuration information realizes the quick configuration function, modify the database access layer middleware or directly generate the database access layer middleware; finally, according to the configuration information, use pacemaker to schedule the database access layer middleware , It can automatically manage and coordinate the allocation and scheduling of resources in the background, and realize the automatic scheduling of middleware in the database access layer under a cross-regional and cross-computer room distributed architecture.

Description of the drawings

Fig. 1 is a flowchart of an automatic scheduling method for database access layer middleware in an embodiment of the present application.

Fig. 2 is a schematic block diagram of an automatic scheduling device for database access layer middleware in an embodiment of the present application.

Fig. 3 is a schematic diagram of a computer device in an embodiment of the present application.

Embodiments of the present invention

In order to better understand the technical solutions of the present application, the following describes the embodiments of the present application in detail with reference to the accompanying drawings.

Fig. 1 shows a flow chart of the automatic scheduling method of the database access layer middleware in this embodiment. The automatic scheduling method of database access layer middleware can be applied to an automatic scheduling system, and can realize automatic scheduling of database access layer middleware under a cross-regional and cross-computer room distributed architecture. The automatic dispatch system can be specifically applied to computer equipment, where the computer equipment is a device that can perform human-computer interaction with users, including but not limited to devices such as computers, smart phones, and tablets. As shown in Figure 1, the automatic scheduling method of the database access layer middleware includes.

S10: Receive a scheduling request, where the scheduling request includes configuration information, and the to-be-stored object of the configuration information is the first synchronization node.

Among them, the subject receiving the scheduling request is the scheduling system, which is a system based on a distributed architecture and includes one or more database resource available areas; wherein, one database resource available area includes one or more synchronization nodes . Understandably, the scheduling system is implemented on the basis of cross-regional and cross-machine rooms (corresponding to different database resource available areas), and can be implemented through any synchronization node (a synchronization node can specifically refer to a computer in the database resource available area). The device) receives the scheduling request, and uses the synchronization node as the object to be stored for configuration information. The synchronization node is also referred to as the first synchronization node.

In one embodiment, the scheduling request initiated by the scheduling system is initiated by the scheduling system, and the scheduling system receives the scheduling request and uses the synchronization node receiving the scheduling request as the object to be stored for configuration information, which can realize the function of receiving configuration information through any synchronization node .

Further, before step S10, that is, before the step of receiving a scheduling request, it specifically includes.

S11: Receive an interface call request.

Wherein, the interface call request refers to a request to call an application programming interface, and the interface call request may specifically be issued by the dispatch initiating system.

S12: Provide an access call of the application programming interface according to the interface call request, where the application programming interface is used to generate configuration information.

Among them, Application Programming Interface (API for short) is some pre-defined functions. The purpose is to provide applications and developers with the ability to access a set of routines based on certain software or hardware without having to access the source code, or Understand the details of the internal working mechanism.

Among them, the configuration information may specifically refer to related parameter information such as the configuration of the database access layer, the configuration of the database resource available area, the configuration of the synchronization node, and the configuration of the central processing unit.

Understandably, the scheduling system includes application programming interfaces open to the outside world. In one embodiment, users can directly call these application programming interfaces through the scheduling initiation system, and use preset rules, such as an input sequence arranged according to certain rules. Write the relevant parameter information of the configuration to generate configuration information.

Understandably, the scheduling system adopts an open application programming interface, which can improve the efficiency of obtaining configuration information and save unnecessary time. You only need to care about the relevant parameter information written in the configuration. In addition, you can also unify the input format, Standardize, and further improve the efficiency of obtaining configuration information.

S13: Enable the monitoring mode to monitor whether a scheduling request is initiated.

In an embodiment, the scheduling system will monitor the scheduling request. Specifically, the synchronization nodes in the available area of the database resource will enable the monitoring mode, and realize the automatic scheduling of the database access layer middleware in time according to the received scheduling request. .

In steps S11-S13, before the step of receiving the scheduling request, the application programming interface of the scheduling system is called, which can improve the efficiency of obtaining configuration information; in addition, the monitoring mode is enabled for all synchronization nodes, which can be used in different regions. , Realize the function of receiving scheduling requests in real time under the actual scenarios of different computer rooms.

S20: Store the configuration information in the first synchronization node.

In one embodiment, after receiving the scheduling request, the configuration information will be stored. The specific storage object is the first synchronization node. The first synchronization node may refer to any computer device in the available area of the database resource. A synchronization node stores configuration information to achieve the purpose of distributed synchronization update.

S30: Using the first synchronization node, remove the remaining synchronization nodes of the database resource available area from the first synchronization node, and perform synchronization update of the configuration information.

Among them, the scheduling system includes one or more database resource available areas, and one database resource available area includes one or more synchronization nodes.

In an embodiment, after the first synchronization node stores the configuration information, the configuration information of the remaining synchronization nodes except the first synchronization node in all the available areas of the database resources will be synchronized and updated, which can be used when any synchronization node receives the scheduling request. , According to the configuration information, all synchronization nodes in the available area of the database resource are synchronized and updated, so that each synchronization node can obtain the latest configuration information in near real time.

Further, in step S30, the first synchronization node is used to remove the remaining synchronization nodes from the first synchronization node in the available area of the database resource to perform the synchronization update of the configuration information, which specifically includes the following steps.

S31: Use consul to scan the remaining synchronization nodes in the database resource available area to obtain the storage location of the synchronization node in the database resource available area excluding the first synchronization node.

Among them, consul is a service grid (responsible for network calls, current limiting, fuse and monitoring between services) solution, it is a distributed, highly available system. It provides a fully functional control plane, the main features are: service discovery, health check, key-value storage, secure service communication, and multiple data centers.

Understandably, when the first synchronization node stores configuration information, the storage location of the first synchronization node is known. Therefore, when consul is used to scan the available area of database resources, the storage location of the first synchronization node can be excluded and the database The remaining synchronization nodes in the resource available area are scanned. Of course, all synchronization nodes may also be scanned.

In an embodiment, the storage location of the first synchronization node is removed, and the storage location of the remaining synchronization nodes except the first synchronization node in the database resource available area is determined by consul scanning, so as to implement subsequent implementations based on the storage location in the first synchronization node. The purpose of the configuration information update to remove the remaining synchronization nodes of the first synchronization node is to make the remaining synchronization nodes removed from the first synchronization node also store the same configuration information as the first synchronization node.

S32: Based on the storage location of the remaining synchronization nodes except the first synchronization node in the database resource available area, use consul to send the configuration information to the remaining synchronization nodes in the database resource available area, and configure the remaining synchronization nodes in the database resource available area Sync updates.

In an embodiment, the first synchronization node uses consul to communicate with the remaining synchronization nodes, and sends configuration information to the remaining synchronization nodes in the database resource available area, and stores the configuration information in each corresponding storage location determined by the scan. , Among them, the configuration information is stored in consul. When the synchronization update is performed, the configuration information can be directly obtained from consul. Understandably, with the help of consul, after the configuration information is obtained at the first synchronization node, the configuration information of the remaining synchronization nodes in the database resource available area can be synchronized in near real time. For example, a computer device in the database resource available area in Shanghai (The first synchronization node) After receiving the scheduling request, it will update the configuration information of the remaining synchronization nodes in the available areas of the database resources in Beijing and Shenzhen in near real time.

In steps S31-S32, a specific implementation manner of using the first synchronization node to synchronize the configuration information of the remaining synchronization nodes in the database resource available area is provided. By using consul, the configuration information can be obtained at the first synchronization node. , Synchronously update the configuration information of the synchronization node in the available zone of the database resource in near real time.

S40: Generate or modify database access layer middleware in the available area of the database resource according to the configuration information.

In one embodiment, the database access layer middleware will be instantiated according to the configuration information. When there is no database access layer middleware in the available area of the database resource corresponding to each synchronization node, the database access layer middleware will be generated according to the configuration information. When the database access layer middleware already exists in the database resource available area corresponding to each synchronization node, the database access layer middleware is modified according to the configuration information.

Further, in step S40, according to the configuration information, the database access layer middleware is generated or modified in the database resource available area, which specifically includes the following steps.

S41: Use the observation mechanism of consul-template to monitor all synchronization nodes, where all synchronization nodes include the first synchronization node and the remaining synchronization nodes.

Among them, consul-template is based on the extensible tool provided by consul. The observation mechanism of consul-template can dynamically modify the templates in some configuration files by monitoring data changes in consul. It is often used for dynamic dynamics on reverse proxy servers. Configure the client reverse proxy information in a healthy state.

In one embodiment, in order to realize near real-time generation or modification of database access layer middleware, all synchronization nodes are monitored, so that when configuration information is updated, the database access layer middleware can be instantiated according to the configuration information. Specifically, in this embodiment, the extensible tool consul-template provided by consul is used as the monitoring tool.

S42: When monitoring and determining that the historical configuration information of all synchronization nodes is different from the currently stored configuration information, modify the configuration of the data access layer middleware in the database resource available area according to the configuration information, or add new database access Layer middleware.

Understandably, when the historical configuration information of all synchronization nodes is not the same as the currently stored configuration information, it means that the configuration information is successfully synchronized to all synchronization nodes, indicating that the scheduling system needs to make changes in scheduling. At this time, it will be added according to the configuration information. Or generated database access layer middleware to facilitate subsequent automatic scheduling of newly added or generated database access layer middleware database access layer middleware.

In steps S41-S42, a specific implementation method for generating or modifying database access layer middleware in the available area of database resources based on configuration information is provided. The database access layer middleware is implemented by using the observation mechanism of consul-template. Generation or modification provides an important basis for subsequent scheduling based on the generated or modified database access layer middleware.

S50: According to the configuration information, use pacemaker to schedule the database access layer middleware.

Among them, pacemaker is a cluster resource manager. It uses the message and member management capabilities provided by the cluster infrastructure to detect and recover from node or resource level failures to achieve maximum availability of cluster services (also known as resources).

In an embodiment, using pacemaker can complete resource scheduling according to configuration information, and can also realize automatic background management and coordinate resource allocation and scheduling, and realize the function of managing database access layer middleware.

Specifically, the configuration information written through the application programming interface may be specifically as follows.

db/nginx/nxy6m0sz:{"region": "in", "network_type": "classical", "listeners": [{"Instance_idx": 1, "Instance_name": "nxy6m0sz_1", "limit_memory": 1.0, "limit_cpu": 0.5, "create_time": "2019-05-09 02:21:48", "hosts": {"master": "CNSZ081825", "slave": "CNSZ081823"}, "CIDR": "10.25.88.216", "listener_port": 3605}], "ng_site": "INA", "db_type": "mysql", "rss": [{"enable": "True", "rs_instance_id": 52210, "ip": "10.25.88.1", "site": "INA", "create_time": "2019-05-09 02:21:48", "rs_name": "myq8814c", "port": 3008}, {"enable": "True", "rs_instance_id": 51545, "ip": "10.25.88.78", "site": "INB", "create_time": "2019-05-09 02:21:48", "rs_name": "myq8814c", "port": 3008}]}. From the configuration information, we can see the configuration of the database access layer middleware (db/nginx/nxy6m0sz), which also includes such as the database resource available area and machine configuration, There are also some configurations such as CPU limitations. In an embodiment, pacemaker will schedule the database access layer middleware according to the configuration information.

Further, in step S50, according to the configuration information, pacemaker is used to schedule the database access layer middleware, which specifically includes the following steps.

S51: Determine resource scheduling information from the configuration information through field matching.

Understandably, what determines the scheduling in the configuration information is the specific resource scheduling information, such as "limit_memory": 1.0, "limit_cpu": 0.5 indicates the limit of the storage ratio and the limit of the CPU operation ratio, which can be determined by field matching, and the configuration information such as the creation time create_time is not directly used for resource scheduling and is not used as a resource Scheduling information.

S52: According to the resource scheduling information, use pacemaker to schedule the database access layer middleware.

In one embodiment, according to the resource scheduling information, pacemaker is used to implement resource scheduling, and the available area of database resources can be used more reasonably, and automatic scheduling of database access layer middleware can be realized in a cross-regional and cross-computer room scenario.

In steps S51-S52, a specific implementation manner for scheduling database access layer middleware is provided, which can realize reasonable scheduling of database access layer middleware.

Understandably, through the execution of steps S10-S50, the scheduling system can realize automatic scheduling of database access layer middleware under a cross-regional and cross-computer room distributed architecture.

It should be understood that the size of the sequence number of each step in the foregoing embodiment does not mean the order of execution. The execution sequence of each process should be determined by its function and internal logic, and should not constitute any limitation on the implementation process of the embodiment of the present application.

Based on the automatic scheduling method of the database access layer middleware provided in the embodiment, the embodiment of the present application further provides an embodiment of a device that implements each step and method in the above method embodiment.

Fig. 2 shows the principle block diagram of the automatic scheduling device of the database access layer middleware corresponding to the automatic scheduling method of the database access layer middleware in the embodiment. As shown in FIG. 2, the automatic scheduling device of the database access layer middleware includes a receiving module 10, a storage module 20, a synchronization update module 30, a middleware configuration module 40 and a middleware scheduling module 50. Among them, the implementation functions of the receiving module 10, the storage module 20, the synchronization update module 30, the middleware configuration module 40, and the middleware scheduling module 50 correspond to the steps corresponding to the automatic scheduling method of the database access layer middleware in the embodiment one by one. To avoid repetition, this embodiment will not go into details one by one.

The receiving module 10 is configured to receive a scheduling request, where the scheduling request includes configuration information, and the to-be-stored object of the configuration information is the first synchronization node.

The storage module 20 is used to store the configuration information in the first synchronization node.

The synchronization update module 30 is configured to use the first synchronization node to remove the remaining synchronization nodes from the database resource available area except for the first synchronization node to perform synchronization update of configuration information.

In an embodiment, after the first synchronization node stores the configuration information, the configuration information of the remaining synchronization nodes excluding the first synchronization node in all database resource available areas will be synchronized and updated, and the scheduling request can be received at any synchronization node Next, all synchronization nodes in the available area of the database resource are synchronized and updated according to the configuration information, so that each synchronization node can obtain the latest configuration information in near real time.

The middleware configuration module 40 is used to generate or modify database access layer middleware in the database resource available area according to the configuration information.

The middleware scheduling module 50 is configured to use pacemaker to schedule the database access layer middleware according to the configuration information.

Optionally, the device further includes a preprocessing module, and the preprocessing module is specifically configured to: receive an interface call request. According to the interface call request, the access call of the application programming interface is provided, where the application programming interface is used to generate configuration information.

Enable monitoring mode to monitor whether a scheduling request is initiated.

Optionally, the synchronization update module 30 is further specifically configured to use consul to scan the remaining synchronization nodes in the database resource available area to obtain the storage locations of the remaining synchronization nodes in the database resource available area except the first synchronization node.

Based on the storage location of the remaining synchronization nodes except the first synchronization node in the database resource available area, use consul to send the configuration information to the remaining synchronization nodes in the database resource available area, and synchronize the configuration information of the remaining synchronization nodes in the database resource available area. renew.

Optionally, the middleware configuration module 40 is further specifically configured to monitor all synchronization nodes using the observation mechanism of consul-template, where all synchronization nodes include the first synchronization node and the remaining synchronization nodes.

When the monitoring determines that the historical configuration information of all synchronization nodes is not the same as the currently stored configuration information, modify the configuration of the data access layer middleware in the database resource available area according to the configuration information, or add a new database access layer middleware Pieces.

Optionally, the middleware scheduling module 50 is further specifically configured to: determine resource scheduling information from the configuration information through field matching; and use pacemaker to schedule the database access layer middleware according to the resource scheduling information.

This embodiment provides a computer-readable storage medium with a computer program stored on the computer-readable storage medium. When the computer program is executed by a processor, the automatic scheduling method of the database access layer middleware in the embodiment is realized. In order to avoid repetition, I will not repeat them here. Alternatively, when the computer program is executed by the processor, the function of each module/unit in the automatic scheduling device of the database access layer middleware in the embodiment is realized. In order to avoid repetition, it will not be repeated here. Wherein, the computer-readable storage medium may be non-volatile or volatile.

Fig. 3 is a schematic diagram of a computer device provided by an embodiment of the present application. As shown in FIG. 3, the computer device 60 of this embodiment includes a processor 61, a memory 62, and a computer program 63 stored in the memory 62 and running on the processor 61. When the computer program 63 is executed by the processor 61 The automatic scheduling method of the database access layer middleware in the embodiment is realized. Alternatively, when the computer program 63 is executed by the processor 61, the functions of each model/unit in the automatic scheduling device of the database access layer middleware corresponding to the automatic scheduling method of the database access layer middleware in the embodiment are implemented one-to-one.

The computer device 60 may be a computing device such as a desktop computer, a notebook, a palmtop computer, and a cloud server. The computer device 60 may include, but is not limited to, a processor 61 and a memory 62. Those skilled in the art can understand that FIG. 3 is only an example of the computer device 60, and does not constitute a limitation on the computer device 60. It may include more or less components than those shown in the figure, or a combination of certain components, or different components. For example, computer equipment may also include input and output devices, network access devices, buses, and so on.

The so-called processor 61 may be a central processing unit (Central Processing Unit, CPU), it can also be other general-purpose processors, Digital Signal Processors (DSP), Application Specific Integrated Circuits (ASICs), Field-Programmable Gate Arrays (Field-Programmable Gate Arrays, FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. The general-purpose processor may be a microprocessor or the processor may also be any conventional processor or the like.

The memory 62 may be an internal storage unit of the computer device 60, such as a hard disk or memory of the computer device 60. The memory 62 may also be an external storage device of the computer device 60, such as a plug-in hard disk, a smart memory card (Smart Media Card, SMC), and a secure digital (Secure Digital, SD) card, flash card (Flash Card), etc. Further, the memory 62 may also include both an internal storage unit of the computer device 60 and an external storage device. The memory 62 is used to store computer programs and other programs and data required by the computer equipment. The memory 62 can also be used to temporarily store data that has been output or will be output.

The above are only specific implementations of this application, but the protection scope of this application is not limited to this. Any person skilled in the art can easily think of changes or substitutions within the technical scope disclosed in this application. Should be covered within the scope of protection of this application. Therefore, the protection scope of this application should be subject to the protection scope of the claims.

Claims

An automatic scheduling method for database access layer middleware, wherein the method includes:

Receiving a scheduling request, where the scheduling request includes configuration information, and the to-be-stored object of the configuration information is the first synchronization node;

Storing the configuration information in the first synchronization node;

Using the first synchronization node to remove the remaining synchronization nodes of the database resource available area from the first synchronization node, and perform the synchronization update of the configuration information;

Generate or modify database access layer middleware in the available area of the database resource according to the configuration information;

According to the configuration information, pacemaker is used to schedule the database access layer middleware.
The method according to claim 1, wherein before said receiving a scheduling request, further comprising:

Receive interface call request;

Providing an access call of an application programming interface according to the interface call request, wherein the application programming interface is used to generate the configuration information;

Enable the monitoring mode to monitor whether the scheduling request is initiated.
The method according to claim 1, wherein the using the first synchronization node to remove the remaining synchronization nodes of the database resource available area from the first synchronization node to perform the synchronization update of the configuration information comprises:

Using consul to scan the remaining synchronization nodes in the database resource available area to obtain the storage locations of the remaining synchronization nodes in the database resource available area excluding the first synchronization node;

Based on the storage location of the remaining synchronization nodes in the database resource available area excluding the first synchronization node, consul is used to send the configuration information to the remaining synchronization nodes in the database resource available area, and the database resource The remaining synchronization nodes in the available zone perform synchronization update of the configuration information.
The method according to claim 1, wherein the generating or modifying database access layer middleware in the available area of the database resource according to the configuration information comprises:

Monitor all synchronization nodes by adopting a consul-template observation mechanism, where all synchronization nodes include the first synchronization node and the remaining synchronization nodes;

When it is determined through monitoring that the historical configuration information of all synchronization nodes is not the same as the currently stored configuration information, the configuration of the data access layer middleware is performed in the available area of the database resource according to the configuration information Modify or add the database access layer middleware.
The method according to any one of claims 1 to 4, wherein the using pacemaker to schedule the database access layer middleware according to the configuration information comprises:

Determine resource scheduling information from the configuration information through field matching;

According to the resource scheduling information, the pacemaker is used to schedule the database access layer middleware.
An automatic scheduling device for database access layer middleware, which includes:

A receiving module, configured to receive a scheduling request, where the scheduling request includes configuration information, and the to-be-stored object of the configuration information is the first synchronization node;

A storage module, configured to store the configuration information in the first synchronization node;

A synchronization update module, configured to use the first synchronization node to remove the remaining synchronization nodes from the database resource available area except for the first synchronization node to perform synchronization update of the configuration information;

A middleware configuration module, configured to generate or modify database access layer middleware in the database resource available area according to the configuration information;

The middleware scheduling module is configured to use pacemaker to schedule the database access layer middleware according to the configuration information.
The device according to claim 6, wherein the device further comprises a pre-processing module, and the pre-processing module is specifically configured to:

Receive interface call request;

Providing an access call of an application programming interface according to the interface call request, wherein the application programming interface is used to generate the configuration information;

Enable the monitoring mode to monitor whether the scheduling request is initiated.
The device according to claim 6, wherein the synchronization update module is specifically configured to:

Using consul to scan the remaining synchronization nodes in the database resource available area to obtain the storage locations of the remaining synchronization nodes in the database resource available area excluding the first synchronization node;

Based on the storage location of the remaining synchronization nodes in the database resource available area excluding the first synchronization node, consul is used to send the configuration information to the remaining synchronization nodes in the database resource available area, and the database resource The remaining synchronization nodes in the available zone perform synchronization update of the configuration information.
The device according to claim 6, wherein the middleware configuration module is specifically used for:

Monitor all synchronization nodes by adopting a consul-template observation mechanism, where all synchronization nodes include the first synchronization node and the remaining synchronization nodes;

When it is determined through monitoring that the historical configuration information of all synchronization nodes is not the same as the currently stored configuration information, the configuration of the data access layer middleware is performed in the available area of the database resource according to the configuration information Modify or add the database access layer middleware.
The device according to any one of claims 6-9, wherein the middleware scheduling module is specifically further configured to:

Determine resource scheduling information from the configuration information through field matching;

According to the resource scheduling information, the pacemaker is used to schedule the database access layer middleware.
A computer device, wherein the computer device includes a memory and a processor, the memory and the processor are connected to each other, and the memory is used to store a computer program configured to be executed by the processor , The computer program is configured to execute an automatic scheduling method for database access layer middleware:

Wherein, the method includes:

Receiving a scheduling request, where the scheduling request includes configuration information, and the to-be-stored object of the configuration information is the first synchronization node;

Storing the configuration information in the first synchronization node;

Using the first synchronization node to remove the remaining synchronization nodes of the database resource available area from the first synchronization node, and perform the synchronization update of the configuration information;

Generate or modify database access layer middleware in the available area of the database resource according to the configuration information;

According to the configuration information, pacemaker is used to schedule the database access layer middleware.
The computer device according to claim 11, wherein before the receiving the scheduling request, further comprising:

Receive interface call request;

Providing an access call of an application programming interface according to the interface call request, wherein the application programming interface is used to generate the configuration information;

Enable the monitoring mode to monitor whether the scheduling request is initiated.
The computer device according to claim 11, wherein said using said first synchronization node to remove the remaining synchronization nodes of said first synchronization node from the available area of database resources to perform synchronization update of said configuration information, comprising :

Using consul to scan the remaining synchronization nodes in the database resource available area to obtain the storage locations of the remaining synchronization nodes in the database resource available area excluding the first synchronization node;

Based on the storage location of the remaining synchronization nodes in the database resource available area excluding the first synchronization node, consul is used to send the configuration information to the remaining synchronization nodes in the database resource available area, and the database resource The remaining synchronization nodes in the available zone perform synchronization update of the configuration information.
11. The computer device according to claim 11, wherein said generating or modifying database access layer middleware in said database resource available area according to said configuration information comprises:

Monitor all synchronization nodes by adopting a consul-template observation mechanism, where all synchronization nodes include the first synchronization node and the remaining synchronization nodes;

When it is determined through monitoring that the historical configuration information of all synchronization nodes is not the same as the currently stored configuration information, the configuration of the data access layer middleware is performed in the available area of the database resource according to the configuration information Modify or add the database access layer middleware.
The computer device according to any one of claims 11-14, wherein the scheduling of the database access layer middleware by using pacemaker according to the configuration information comprises:

Determine resource scheduling information from the configuration information through field matching;

According to the resource scheduling information, the pacemaker is used to schedule the database access layer middleware.
A computer-readable storage medium, the computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, it is used to implement an automatic scheduling method for database access layer middleware, the method includes the following step:

Receiving a scheduling request, where the scheduling request includes configuration information, and the to-be-stored object of the configuration information is the first synchronization node;

Storing the configuration information in the first synchronization node;

Using the first synchronization node to remove the remaining synchronization nodes of the database resource available area from the first synchronization node, and perform the synchronization update of the configuration information;

Generate or modify database access layer middleware in the available area of the database resource according to the configuration information;

According to the configuration information, pacemaker is used to schedule the database access layer middleware.
The computer-readable storage medium according to claim 16, wherein before the receiving the scheduling request, further comprising:

Receive interface call request;

Providing an access call of an application programming interface according to the interface call request, wherein the application programming interface is used to generate the configuration information;

Enable the monitoring mode to monitor whether the scheduling request is initiated.
The computer-readable storage medium according to claim 16, wherein the first synchronization node is used to remove the remaining synchronization nodes of the database resource available area from the first synchronization node to synchronize the configuration information Updates, including:

Using consul to scan the remaining synchronization nodes in the database resource available area to obtain the storage locations of the remaining synchronization nodes in the database resource available area excluding the first synchronization node;

Based on the storage location of the remaining synchronization nodes in the database resource available area excluding the first synchronization node, consul is used to send the configuration information to the remaining synchronization nodes in the database resource available area, and the database resource The remaining synchronization nodes in the available zone perform synchronization update of the configuration information.
The computer-readable storage medium according to claim 16, wherein said generating or modifying database access layer middleware in said database resource available area according to said configuration information comprises:

Monitor all synchronization nodes by adopting a consul-template observation mechanism, where all synchronization nodes include the first synchronization node and the remaining synchronization nodes;

When it is determined through monitoring that the historical configuration information of all synchronization nodes is not the same as the currently stored configuration information, the configuration of the data access layer middleware is performed in the available area of the database resource according to the configuration information Modify or add the database access layer middleware.
The computer-readable storage medium according to any one of claims 16-19, wherein the scheduling of the database access layer middleware by using pacemaker according to the configuration information comprises:

Determine resource scheduling information from the configuration information through field matching;

According to the resource scheduling information, the pacemaker is used to schedule the database access layer middleware.