WO2020232895A1 - Dynamic sub-database routing method and device, server, and storage medium - Google Patents

Abstract

The present application provides a dynamic sub-database routing method, comprising: providing a route configuration table, wherein the route configuration table is used to record a correspondence between multiple platforms and multiple service groups, and record a port corresponding to each of the multiple service groups; upon reception of a service request transmitted from one of the multiple platforms, searching the route configuration table according to the platform, and determining a target service group from the multiple service groups and a port corresponding to the target service group, wherein the target service group is a service group corresponding to the platform among the multiple service groups recorded in the route configuration table; and transmitting the received service request to the port corresponding to the target service group. The present application also provides a device for implementing the dynamic sub-database routing method, a server, and a storage medium. The present application solves the technical problem in which a high-volume transaction cannot be handled flexibly.

Description

Dynamic sub-library routing method, device, server and storage medium

This application claims the priority of a Chinese patent application filed with the Chinese Patent Office on May 23, 2019. The application number is 201910436135.5. The invention title is "Dynamic sub-library routing method, device, server and storage medium". The entire content is incorporated by reference. In this application.

Technical field

This application relates to the field of computer technology, in particular to a dynamic database routing method, device, server and storage medium.

Background technique

The database runs as a single point, once a problem occurs, the entire system is paralyzed. The general database table splitting method and the program have a very high coupling degree, and it is not easy to expand and develop. However, generally speaking, Internet e-commerce transaction volume is large, concurrency is high, transaction time is very concentrated, and systems without sub-meters and sub-databases are difficult to carry.

Summary of the invention

In view of the above, it is necessary to propose a dynamic sub-database routing method, device, server and storage medium to solve the technical problem of not being able to flexibly handle large transactions.

The first aspect of the present application provides a dynamic database routing method, which is applied to a communication server, where the communication server is connected to an application server including multiple service groups, and the method includes:

Set up a routing configuration table, where the routing configuration table is used to record the correspondence between multiple platforms and the multiple service groups, and to record the port corresponding to each service group in the multiple service groups , Where different platforms correspond to different service groups;

When a service request sent by any one of the multiple platforms is received, the routing configuration table is retrieved according to the platform sending the service request, and a target service group and all service groups are determined from the multiple service groups. The port corresponding to the target service group, wherein the target service group is a service group corresponding to the platform that sends the service request among the multiple service groups recorded in the routing configuration table; and

Send the received service request to the port corresponding to the target service group.

Preferably, the method further includes:

Obtain the operating status of each service group in the plurality of service groups in a preset time period from the application server on a regular basis, wherein the operating status includes the time when the maximum number of threads is enabled for each service group; and

The routing configuration table is adjusted according to the operating status of each service group in the plurality of service groups within the preset time period.

Preferably, the adjusting the routing configuration table according to the operating status of each service group in the plurality of service groups within the preset time period includes:

Counting the total duration of each service group in the plurality of service groups when the maximum number of threads is activated within the preset time period to obtain a total duration corresponding to each service group in the plurality of service groups;

Determine whether the total duration corresponding to each service group exceeds the predetermined duration;

If the total duration corresponding to each of the multiple service groups is less than or equal to the predetermined duration, it is determined that there is no need to update the routing configuration table;

If the total duration corresponding to at least one of the multiple service groups is greater than the predetermined duration, it is determined that the routing configuration table needs to be updated, and when it is determined that the routing configuration table needs to be updated, in the routing configuration In the table, swap the service group corresponding to the longest total time with the service group corresponding to the shortest total time.

The second aspect of the present application provides a dynamic database routing method, applied to an application server including multiple service groups, the application server being connected to a communication server and a database server including multiple databases, the method includes:

Configure a target database for each of the multiple service groups, where the target database is one of the multiple databases, and each target database is used to store business data of multiple platforms, Each service group in the plurality of service groups corresponds to a port; and

Real-time detection of whether the ports corresponding to the multiple service groups receive the service request sent from the communication server, and when the port corresponding to a certain service group in the multiple service groups receives the service When requested, control the certain service group to execute the service request.

Preferably, the execution of the service request refers to reading the data requested by the service request from a target database corresponding to the certain service group, or storing the data requested by the service request to store/update /Update to the target database corresponding to the certain service group.

Preferably, the method further includes:

Calculate the operating status of each service group in the multiple service groups, where the operating status includes the time when the maximum number of threads is enabled for each service group, wherein each service group in the multiple service groups The corresponding maximum number of threads is the same or different.

A third aspect of the present application provides a dynamic database routing device, which runs in a communication server, and the communication server is connected to an application server including multiple service groups, and the device includes:

The setting module is used to set a routing configuration table, wherein the routing configuration table is used to record the correspondence between multiple platforms and the multiple service groups, and to record each service in the multiple service groups The port corresponding to the group, where different platforms correspond to different service groups;

The execution module is configured to, when a service request sent by any one of the multiple platforms is received, retrieve the routing configuration table according to the platform that sent the service request, and determine one from the multiple service groups A target service group and a port corresponding to the target service group, wherein the target service group is a service group corresponding to the platform that sends the service request among the multiple service groups recorded in the routing configuration table; and

The execution module is also used to send the received service request to the port corresponding to the target service group.

The fourth aspect of the present application provides a dynamic database routing device, which runs on an application server including multiple service groups, the application server is connected to a communication server and a database server including multiple databases, and the device includes:

The configuration module is used to configure a target database for each of the multiple service groups, where the target database is one of the multiple databases, and each target database is used to store multiple Business data of the platform, each of the multiple service groups corresponds to a port; and

The control module is used to detect in real time whether the respective ports corresponding to the multiple service groups receive the service request sent from the communication server, when the port corresponding to any one of the multiple service groups When the service request is received, the service group that has received the service request is controlled to execute the service request, where the execution of the service request refers to the service group corresponding to the service group that received the service request Read the data requested by the service request in the target database, or store/update the data requested to be stored/updated by the service request to the target corresponding to the service group that received the service request database.

A fifth aspect of the present application provides a server, the server includes a processor, and the processor is used to implement the dynamic database routing method when executing computer-readable instructions stored in a memory.

A sixth aspect of the present application provides a non-volatile readable storage medium having computer readable instructions stored thereon, and when the computer readable instructions are executed by a processor, the dynamic database routing method is implemented.

The method, device, server, and storage medium for dynamic database and table sharding described in the embodiments of the present application set a routing configuration table, wherein the routing configuration table records multiple platforms, the multiple service groups, and all Ports corresponding to each service group in the multiple service groups, where different platforms correspond to different service groups; receive service requests sent from the multiple platforms; when the multiple platforms are received When a service request is sent from a certain platform, the routing configuration table is retrieved according to the certain platform, and a target service group and the port corresponding to the target service group are determined from the multiple service groups, where: The target service group is a service group corresponding to the certain platform among multiple service groups recorded in the routing configuration table; and the received service request is sent to the port corresponding to the target service group , Can realize dynamic transaction routing, distribute business requests to different service group ports, and effectively solve the technical problem of not being able to flexibly handle large transactions.

In addition, a target database is configured for each of the multiple service groups, wherein the target database is one of the multiple databases, and each target database is used to store services of multiple platforms Data, each of the multiple service groups corresponds to a port; and real-time detection of whether the respective ports corresponding to the multiple service groups receive the service request sent from the communication server, when the When a port corresponding to a certain service group in a plurality of service groups receives the service request, the certain service group is controlled to execute the service request, wherein the execution of the service request refers to Read the data requested by the service request from the target database corresponding to each service group, or store/update the data requested by the service request to store/update to the target corresponding to the certain service group The database can realize dynamic sub-database, support massive transactions, flexible system processing, and can effectively support scenarios with large transaction concurrency.

Description of the drawings

FIG. 1 is an application environment architecture diagram of the dynamic database routing method provided in Embodiment 1 of the present application.

FIG. 2 is a flowchart of a dynamic database routing method provided in Embodiment 2 of the present application.

Fig. 3 is a flowchart of a dynamic database routing method provided in the third embodiment of the present application.

Fig. 4 is a structural diagram of a dynamic sub-library routing device provided in the fourth embodiment of the present application.

Fig. 5 is a structural diagram of a dynamic sub-library routing device provided in Embodiment 5 of the present application.

Fig. 6 is a schematic diagram of a communication server provided in the sixth embodiment of the present application.

FIG. 7 is a schematic diagram of an application server provided in Embodiment 7 of the present application.

The following specific embodiments will further illustrate this application in conjunction with the above-mentioned drawings.

Detailed ways

Example one

Refer to FIG. 1, which is an application environment architecture diagram of the dynamic database routing method provided in Embodiment 1 of this application. The dynamic sub-database routing method of the present application is applied in an environment composed of multiple servers communicating with each other. For example, in an environment composed of a communication server 3, an application server 4, and a database server 5.

In one embodiment, the communication server 3 and the application server 4 may establish a communication connection through a wired (for example, USB (Universal Serial Bus, Universal Serial Bus) or wireless manner. The application server 4 and the database server 5 may be Establish a communication connection in a wired or wireless way.

In an embodiment, the wireless method may be any type of traditional wireless communication, such as radio, wireless fidelity (WIFI), cellular, satellite, broadcast, and so on. Wireless communication technologies may include, but are not limited to, Global System for Mobile Communications (GSM), General Packet Radio Service (GPRS), Code Division Multiple Access (CDMA), Wideband Code Division Multiple Access (W-CDMA), CDMA2000, IMT Single Carrier (IMT Single Carrier), Enhanced Data Rates for GSM Evolution (EDGE), Long-Term Evolution Technology (Long-Term Evolution, LTE) , Advanced long-term evolution technology, Time-Division LTE (TD-LTE), High-Performance Radio Local Area Network (HiperLAN), High-Performance Radio Wide Area Network (HiperWAN) , Local Multipoint Distribution Service (LMDS), Worldwide Interoperability for Microwave Access (WiMAX), ZigBee Protocol (ZigBee), Bluetooth, Orthogonal Frequency Division Multiplexing (Flash Orthogonal) Frequency-Division Multiplexing, Flash-OFDM), High Capacity Spatial Division Multiple Access (HC-SDMA), Universal Mobile Telecommunications System (UMTS), Universal Mobile Telecommunications System, Time Division Dual Industrial (UMTS Time-Division Duplexing, UMTS-TDD), Evolved High Speed Packet Access (HSPA+), Time Division Synchronous Code Division Multiple Access (Time Division Multiple Access, TD-SCDMA), Evolution Data optimization (Evolution-Data Optimized , EV-DO), Digital Enhanced Cordless Telecommunications (DECT) and others.

Example two

FIG. 2 is a flowchart of a dynamic database routing method provided in Embodiment 2 of the present application. In this embodiment, the dynamic database routing method can be applied to a communication server. For a communication server that needs to perform dynamic database routing, the communication server can be directly integrated with the dynamic database database provided by the method of this application. The routing function may run on the communication server in the form of a software development kit (SDK).

As shown in FIG. 2, the dynamic database routing method specifically includes the following steps. According to different requirements, the order of the steps in the flowchart can be changed, and some steps can be omitted.

Step S1. The communication server sets up a routing configuration table, where the routing configuration table is used to record the correspondence between multiple platforms and multiple service groups, and record the location of each service group in the multiple service groups. Corresponding ports, where different platforms correspond to different service groups.

In this embodiment, the multiple platforms may be Internet e-commerce platforms, or other platforms that require a database. In one embodiment, in the routing configuration table, the multiple platforms may be represented by different codes.

For example, assuming that the multiple platforms include e-commerce platform A1, e-commerce platform A2, and e-commerce platform A3, the code "3001" can be used to represent the e-commerce platform A1 in the routing configuration table, and the code "3002" "Represents e-commerce platform A2, and the code "3003" represents e-commerce platform A3.

For example, in the routing configuration table, the code "3001" can be set to correspond to service group B1, and service group B1 corresponds to port 9001; the code "3002" to correspond to service group B2, and service group B2 corresponds to port 9002; set The code "3003" corresponds to service group B3, and service group B3 corresponds to port 9003. Therefore, a service group is configured for the three e-commerce platforms (ie, the e-commerce platforms A1, A2, A3) through the routing configuration table shown.

In this embodiment, the multiple service groups may be software program modules, respectively, running in an application server, and each service group is used to execute service requests of the corresponding platform.

In this embodiment, the application server configures a target database for each of the multiple service groups, and each target database is used to store business data of the multiple platforms. In this embodiment, the target database is one of multiple databases included in the database server.

In this embodiment, the business data of the multiple platforms may refer to data related to e-commerce transactions, such as the number of orders, the amount involved in each order, and other data.

For example, the application server may configure a target database D1 for the service group B1, a target database D2 for the service group B2, and a target database D3 for the service group B3. The target databases D1, D2, and D3 are respectively used to store the electricity The business data of the business platforms A1, A2, A3. In other words, the target database D1 is used to store the business data of the e-commerce platforms A1, A2, A3, and the target database D2 is used to store all the business data of the e-commerce platforms A1, A2, A3. The business data, the target database D3 is used to store the business data of the e-commerce platforms A1, A2, A3.

In an embodiment, the maximum number of threads corresponding to each of the multiple service groups may be the same or different. For example, the maximum number of threads of each service group in the plurality of service groups may all be 60, 70 or other values. In this embodiment, each thread number is used to respond to a service request sent by the platform corresponding to the service group.

In an embodiment, the application server also counts the operating status of each service group in the multiple service groups. Wherein, the operating status includes the time when the maximum number of threads is enabled for each service group. For example, the statistics show that the service group A1 has been using the maximum number of threads during the period from 01: 00 am on November 11, 2018 to 00: 00 am on November 12, 2018.

Step S2: The communication server receives service requests sent from the multiple platforms. When receiving a service request sent by a certain platform among the multiple platforms, the communication server retrieves the routing configuration table according to the certain platform, determines a target service group from the multiple service groups, and The port corresponding to the target service group sends the received service request to the port corresponding to the target service group. Wherein, the target service group is a service group corresponding to the certain platform among multiple service groups recorded in the routing configuration table.

In an embodiment, the communication server can detect the service request sent from the multiple platforms in real time. It should be noted that the certain platform is any one of the multiple platforms recorded in the routing configuration table.

For example, suppose that the communication server receives the service request sent by the e-commerce platform A1, and retrieves the routing configuration table according to the e-commerce platform A1 to determine that the target service group is the service group B1 and the service group B1 corresponds Port 9001. The communication server sends the received service request to the port 9001 corresponding to the service group B1.

In this embodiment, the application server detects in real time whether the ports corresponding to the multiple service groups receive the service request sent from the communication server. When a port corresponding to a certain service group (for example, the target service group) of the multiple service groups receives the service request, the application server controls the certain service group to execute the service request.

It should be noted that the certain service group may be any one of the multiple service groups.

In this embodiment, the execution of the service request refers to reading the data requested by the service request from the target database corresponding to the certain service group, or storing/updating the data requested by the service request The data is stored/updated to the target database corresponding to the certain service group. In other words, the service request may refer to a request to read data, a request to store data, or a request to update data.

In an embodiment, when the execution of the service request refers to reading the data requested by the service request from the target database corresponding to the certain service group (for example, the target service group) The application server controls the certain service group to return the read data to the communication server, and the communication server returns the read data to the certain platform. When the execution of the service request refers to storing/updating the stored/updated data requested by the service request to the target database corresponding to the certain service group (for example, the target service group), when After the certain service group stores/updates the stored/updated data requested by the service request to the target database corresponding to the certain service group, the application server also controls the certain service group to send a completion data The update notification is sent to the communication server, and the communication server returns the notification of completing the data update to the certain platform.

In this embodiment, when data in a certain database (for example, the target database) of the multiple databases included in the database server is updated, the database server also synchronously updates other databases in the multiple databases.

For example, suppose the service group B1 stores a transaction data in one of the multiple databases (for example, the target database D1), and the database server detects that there is a data update in the target database D1. Other databases in the multiple databases (for example, the target databases D2 and D3) are also updated synchronously, so as to realize the synchronous update of the data of each database. Even if the data in each of the multiple databases is consistent.

In an embodiment, the database server further determines whether to perform table splitting processing on the target database according to the data volume of the business data of the multiple platforms stored in the target database.

It should be noted that, after each target database is applied for a period of time, it is possible to determine whether to split the table according to the data volume of the stored business data of the multiple platforms. For example, in the first month of applying the target database, tables may not be divided, that is, data of all platforms are placed in the same common table. After the target database has been applied for one month, it is determined whether to split tables according to the data volume of the stored business data of the multiple platforms.

Specifically, the determining whether to perform table splitting processing on the target database according to the data volume of the business data of the multiple platforms stored in the target database includes (a1)-(a3):

(a1) Periodically (for example, every other day, 1st of every month, 15th of every month) analyze whether the data volume of the business data of each of the multiple platforms stored in the target database is greater than a preset Numerical value.

(a2) If the data volume of the business data of each of the multiple platforms is less than or equal to the preset value, it is determined not to partition the target database. If the data amount of the business data of at least one of the multiple platforms is greater than the preset value, it is determined to partition the target database.

(a3) When it is determined that the target database is divided into tables, a new database table is created, and the business data corresponding to the platform whose data amount of business data is greater than the preset value is stored in the newly created database table.

Step S3: The communication server regularly (for example, 00:00am every day) obtains from the application server each service group in the plurality of service groups in a preset time period (for example, the last day, the last week, the last month) Operating conditions within.

As mentioned earlier, the operating status includes the time when the maximum number of threads is enabled for each service group.

Step S4: The communication server adjusts the routing configuration table according to the operating status of each service group of the plurality of service groups within the preset time period.

In an embodiment, the adjusting the routing configuration table according to the operating status of each service group of the plurality of service groups within the preset time period includes (b1)-(b3):

(b1) Count the total duration of each service group in the plurality of service groups when the maximum number of threads is enabled within the preset time period, so as to count one for each service group in the plurality of service groups Total duration, to determine whether the total duration corresponding to each service group exceeds the predetermined duration.

(b2) If the total duration corresponding to each of the multiple service groups is less than or equal to the predetermined duration, it is determined that there is no need to update the routing configuration table. If the total duration corresponding to at least one of the multiple service groups is greater than the predetermined duration, it is determined that the routing configuration table needs to be updated.

(b3) When it is determined that the routing configuration table needs to be updated, in the routing configuration table, the service group corresponding to the longest total duration is swapped with the service group corresponding to the shortest total duration.

For example, if it is calculated in the step (b1) that the total duration corresponding to service group B1 is the longest and the total duration corresponding to service group B3 is the shortest, then in the routing configuration table, the adjustment setting is The service group B1 corresponds to the e-commerce platform A3, and the service group B3 corresponds to the e-commerce platform A1.

In summary, the dynamic database routing method described in the embodiments of the present application sets a routing configuration table, wherein the routing configuration table records multiple platforms, the multiple service groups, and the multiple The port corresponding to each service group in the service group, where different platforms correspond to different service groups; receive service requests sent from the multiple platforms; when one of the multiple platforms is received When a service request is sent by the platform, the routing configuration table is retrieved according to the certain platform, and a target service group and the port corresponding to the target service group are determined from the multiple service groups, wherein the target The service group is the service group corresponding to the certain platform among the multiple service groups recorded in the routing configuration table; and sending the received service request to the port corresponding to the target service group can be realized Dynamic transaction routing, which distributes business requests to different service group ports, effectively solves the technical problem of not being able to flexibly handle large transactions.

Example three

Fig. 3 is a flowchart of a routing method for dynamic database partitioning provided in the third embodiment of the present application.

In this embodiment, the routing method for dynamic database partitioning can be applied to an application server. For an application server that needs to perform a dynamic database partitioning routing method, the application server can be directly integrated with the method provided by this application. The function of dynamic sub-library routing, or run on the application server in the form of a software development kit (SDK).

As shown in FIG. 3, the routing method for dynamic database partitioning specifically includes the following steps. According to different requirements, the order of the steps in the flowchart can be changed, and some steps can be omitted.

Step S21: The application server configures a target database for each of the multiple service groups, where the target database is one of the multiple databases included in the database server. Each target database is used to store business data of the multiple platforms.

As mentioned above, the business data of the multiple platforms may refer to data related to e-commerce transactions, such as the number of orders, the amount involved in each order, and other data.

For example, the application server may configure a target database D1 for the service group B1, a target database D2 for the service group B2, and a target database D3 for the service group B3. The target databases D1, D2, and D3 are respectively used to store the electricity The business data of the business platforms A1, A2, A3. In other words, the target database D1 is used to store the business data of the e-commerce platforms A1, A2, A3, and the target database D2 is used to store all the business data of the e-commerce platforms A1, A2, A3. The business data, the target database D3 is used to store the business data of the e-commerce platforms A1, A2, A3.

In an embodiment, the maximum number of threads corresponding to each of the multiple service groups may be the same or different. For example, the maximum number of threads of each service group in the plurality of service groups may all be 60, 70 or other values. In this embodiment, each thread number is used to respond to a service request sent by the platform corresponding to the service group.

In an embodiment, the application server also counts the operating status of each service group in the multiple service groups. Wherein, the operating status includes the time when the maximum number of threads is enabled for each service group. For example, the statistics show that the service group A1 has been using the maximum number of threads during the period from 01: 00 am on November 11, 2018 to 00: 00 am on November 12, 2018.

Step S22: The application server detects in real time whether the ports corresponding to the multiple service groups receive the service request sent from the communication server. When a port corresponding to a certain service group (for example, the aforementioned target service group) of the multiple service groups receives the service request, the application server controls the certain service group to execute the service request . The execution of the service request refers to reading the data requested by the service request from the target database corresponding to the certain service group, or storing/update the data requested by the service request to store/update To the target database corresponding to the certain service group.

In other words, the service request may refer to a request to read data, a request to store data, or a request to update data.

In an embodiment, when the execution of the service request refers to reading the data requested by the service request from a target database corresponding to the certain service group (for example, the target service group), The application server controls the certain service group to return the read data to the communication server, and the communication server returns the read data to the certain platform. When the execution of the service request refers to storing/updating the stored/updated data requested by the service request to the target database corresponding to the certain service group (for example, the target service group), when After the certain service group stores/updates the stored/updated data requested by the service request to the target database corresponding to the certain service group, the application server also controls the certain service group to send a completion data The update notification is sent to the communication server, and the communication server returns the notification of completing the data update to the certain platform.

In summary, the dynamic database routing method described in the embodiment of the present application configures a target database for each of the multiple service groups, wherein the target database is the multiple databases Each target database is used to store business data of multiple platforms, and each service group in the multiple service groups corresponds to a port; and real-time detection of the respective ports corresponding to the multiple service groups Whether the service request sent from the communication server is received, when the port corresponding to a certain service group in the multiple service groups receives the service request, control the certain service group to execute the A business request, wherein the execution of the business request refers to reading the data requested by the business request from the target database corresponding to the certain service group, or storing/update the data requested by the business request Data storage/update to the target database corresponding to the certain service group can realize dynamic sub-database, support massive transactions, flexible system processing, and can effectively support scenarios with high transaction concurrency.

The above-mentioned figures 2 and 3 describe in detail the dynamic sub-database routing method of the present application. In the following, with reference to Figures 4 to 7, the functional modules of the software device for implementing the dynamic sub-database routing method and the realization of the dynamic sub-database routing are respectively described The hardware device architecture of the method is introduced.

Example four

Refer to FIG. 4, which is a structural diagram of a dynamic sub-library routing device provided in Embodiment 4 of the present application.

In some embodiments, the dynamic branch routing device 30 runs in a communication server. The communication server is connected to the application server through the network, and the application server is connected to the database server through the network. The dynamic sub-library routing device 30 may include multiple functional modules composed of program code segments. The program code of each program segment in the dynamic sub-library routing device 30 can be stored in the memory of the communication server and executed by the at least one processor to execute (see Figure 2 for details) dynamic sub-library routing.

In this embodiment, the dynamic branch routing device 30 can be divided into multiple functional modules according to the functions it performs. The functional modules may include: a setting module 301, a receiving module 302, and an executing module 303. The module referred to in this application refers to a series of computer-readable instruction segments that can be executed by at least one processor and can complete fixed functions, and are stored in a memory. In this embodiment, the functions of each module will be described in detail in subsequent embodiments.

The setting module 301 sets a routing configuration table, where the routing configuration table is used to record the correspondence between multiple platforms and multiple service groups, and to record the corresponding relationship between each of the multiple service groups. Port, where different platforms correspond to different service groups.

In this embodiment, the multiple platforms may be Internet e-commerce platforms, or other platforms that require a database. In one embodiment, in the routing configuration table, the multiple platforms may be represented by different codes.

For example, assuming that the multiple platforms include e-commerce platform A1, e-commerce platform A2, and e-commerce platform A3, the code "3001" can be used to represent the e-commerce platform A1 in the routing configuration table, and the code "3002" "Represents e-commerce platform A2, and the code "3003" represents e-commerce platform A3.

For example, in the routing configuration table, the setting module 301 can set the code "3001" to correspond to service group B1, and service group B1 to correspond to port 9001; to set code "3002" to correspond to service group B2, service group B2 to port 9002 Corresponding; the setting code "3003" corresponds to service group B3, and service group B3 corresponds to port 9003. Therefore, a service group is configured for the three e-commerce platforms (ie, the e-commerce platforms A1, A2, A3) through the routing configuration table shown.

In this embodiment, the multiple service groups may be software program modules, respectively, running in an application server, and each service group is used to execute service requests of the corresponding platform.

In this embodiment, the application server configures a target database for each of the multiple service groups, and each target database is used to store business data of the multiple platforms. In this embodiment, the target database is one of multiple databases included in the database server.

In this embodiment, the business data of the multiple platforms may refer to data related to e-commerce transactions, such as the number of orders, the amount involved in each order, and other data.

For example, the application server may configure a target database D1 for the service group B1, a target database D2 for the service group B2, and a target database D3 for the service group B3. The target databases D1, D2, and D3 are respectively used to store the electricity The business data of the business platforms A1, A2, A3. In other words, the target database D1 is used to store the business data of the e-commerce platforms A1, A2, A3, and the target database D2 is used to store all the business data of the e-commerce platforms A1, A2, A3. The business data, the target database D3 is used to store the business data of the e-commerce platforms A1, A2, A3.

In an embodiment, the maximum number of threads corresponding to each of the multiple service groups may be the same or different. For example, the maximum number of threads of each service group in the plurality of service groups may all be 60, 70 or other values. In this embodiment, each thread number is used to respond to a service request sent by the platform corresponding to the service group.

In an embodiment, the application server also counts the operating status of each service group in the plurality of service groups. Wherein, the operating status includes the time when the maximum number of threads is enabled for each service group. For example, it is calculated that the service group A1 has been enabled for the maximum number of threads during the period from 01: 00 am on 11 November 2018 to 00: 00 am on 11 November 2018.

The receiving module 302 receives service requests sent from the multiple platforms. When the receiving module 302 receives a service request sent by a certain platform among the multiple platforms, the execution module 303 retrieves the routing configuration table according to the certain platform, and determines one from the multiple service groups The target service group and the port corresponding to the target service group. The execution module 303 sends the received service request to the port corresponding to the target service group. Wherein, the target service group is a service group corresponding to the certain platform among multiple service groups recorded in the routing configuration table.

In an embodiment, the receiving module 302 can detect the service request sent from the multiple platforms in real time.

It should be noted that the certain platform is any one of the multiple platforms recorded in the routing configuration table.

For example, suppose the receiving module 302 receives the service request sent by the e-commerce platform A1, the execution module 303 retrieves the routing configuration table according to the e-commerce platform A1, and determines that the target service group is the service group B1 and the service group Port 9001 corresponding to B1. The execution module 303 sends the received service request to the port 9001 corresponding to the service group B1.

In this embodiment, the application server detects in real time whether the ports corresponding to the multiple service groups receive the service request sent from the communication server. When a port corresponding to a certain service group (for example, the target service group) of the multiple service groups receives the service request, the application server controls the certain service group to execute the service request.

It should be noted that the certain service group may be any one of the multiple service groups.

In this embodiment, the execution of the service request refers to reading the data requested by the service request from the target database corresponding to the certain service group, or storing/updating the data requested by the service request The data is stored/updated to the target database corresponding to the certain service group. In other words, the service request may refer to a request to read data, a request to store data, or a request to update data.

In an embodiment, when the execution of the service request refers to reading the data requested by the service request from the target database corresponding to the certain service group (for example, the target service group) , The application server controls the certain service group to return the read data to the communication server, and the execution module 303 returns the read data to the certain platform. When the execution of the service request refers to storing/updating the stored/updated data requested by the service request to the target database corresponding to the certain service group (for example, the target service group), when After the certain service group stores/updates the stored/updated data requested by the service request to the target database corresponding to the certain service group, the application server also controls the certain service group to send a completion data The update notification is sent to the communication server, and the execution module 303 returns the notification of completing the data update to the certain platform.

In this embodiment, when data in a certain database (for example, the target database) of the multiple databases included in the database server is updated, the database server also synchronously updates other databases in the multiple databases.

For example, suppose the service group B1 stores a transaction data in one of the multiple databases (for example, the target database D1), and the database server detects that there is a data update in the target database D1. Other databases in the multiple databases (for example, the target databases D2 and D3) are also updated synchronously, so as to realize the synchronous update of the data of each database. Even if the data in each of the multiple databases is consistent.

In an embodiment, the database server further determines whether to perform table splitting processing on the target database according to the data volume of the business data of the multiple platforms stored in the target database.

It should be noted that, after each target database is applied for a period of time, it is possible to determine whether to split the table according to the data volume of the stored business data of the multiple platforms. For example, in the first month of applying the target database, tables may not be divided, that is, data of all platforms are placed in the same common table. After the target database has been applied for one month, it is determined whether to split tables according to the data volume of the stored business data of the multiple platforms.

Specifically, the determining whether to perform table splitting processing on the target database according to the data volume of the business data of the multiple platforms stored in the target database includes (a1)-(a3):

(a1) Periodically (for example, every other day, 1st of every month, 15th of every month) analyze whether the data volume of the business data of each of the multiple platforms stored in the target database is greater than a preset Numerical value.

(a2) If the data volume of the business data of each of the multiple platforms is less than or equal to the preset value, it is determined not to partition the target database. If the data amount of the business data of at least one of the multiple platforms is greater than the preset value, it is determined to partition the target database.

(a3) When it is determined that the target database is divided into tables, a new database table is created, and the business data corresponding to the platform whose data amount of business data is greater than the preset value is stored in the newly created database table.

The execution module 303 regularly (for example, 00:00am every day) obtains from the application server each service group in the plurality of service groups within a preset time period (for example, the last day, the last week, the last month) Health status.

As mentioned earlier, the operating status includes the time when the maximum number of threads is enabled for each service group.

The execution module 303 adjusts the routing configuration table according to the operating status of each service group in the plurality of service groups within the preset time period.

In an embodiment, the adjusting the routing configuration table according to the operating status of each service group of the plurality of service groups within the preset time period includes (b1)-(b3):

(b1) Count the total duration of each service group in the plurality of service groups when the maximum number of threads is enabled within the preset time period, so as to count one for each service group in the plurality of service groups Total duration, to determine whether the total duration corresponding to each service group exceeds the predetermined duration.

(b2) If the total duration corresponding to each of the multiple service groups is less than or equal to the predetermined duration, it is determined that there is no need to update the routing configuration table. If the total duration corresponding to at least one of the multiple service groups is greater than the predetermined duration, it is determined that the routing configuration table needs to be updated.

(b3) When it is determined that the routing configuration table needs to be updated, in the routing configuration table, the service group corresponding to the longest total duration is swapped with the service group corresponding to the shortest total duration.

For example, if it is calculated in the step (b1) that the total duration corresponding to service group B1 is the longest and the total duration corresponding to service group B3 is the shortest, then in the routing configuration table, the adjustment setting is The service group B1 corresponds to the e-commerce platform A3, and the service group B3 corresponds to the e-commerce platform A1.

To sum up, the dynamic database routing device described in the embodiment of the present application sets a routing configuration table, wherein the routing configuration table records multiple platforms, the multiple service groups, and the multiple The port corresponding to each service group in the service group, where different platforms correspond to different service groups; receive service requests sent from the multiple platforms; when one of the multiple platforms is received When a service request is sent by the platform, the routing configuration table is retrieved according to the certain platform, and a target service group and the port corresponding to the target service group are determined from the multiple service groups, wherein the target The service group is the service group corresponding to the certain platform among the multiple service groups recorded in the routing configuration table; and sending the received service request to the port corresponding to the target service group can be realized Dynamic transaction routing, which distributes business requests to different service group ports, effectively solves the technical problem of not being able to flexibly handle large transactions.

Example five

Refer to FIG. 5, which is a structural diagram of a dynamic sub-library routing device provided in Embodiment 5 of the present application.

In some embodiments, the dynamic database routing device 40 runs in an application server. The application server is connected to the communication server and the database server through the network. The dynamic sub-library routing device 40 may include multiple functional modules composed of program code segments. The readable instruction codes of each program segment in the dynamic sub-library routing device 40 can be stored in the memory of the application server and executed by the at least one processor to execute the dynamic sub-library (see Figure 3 for details) The function of routing.

In this embodiment, the dynamic branching routing device 40 can be divided into multiple functional modules according to the functions it performs. The functional modules may include: a configuration module 401 and a control module 402. The module referred to in this application refers to a series of computer-readable instruction segments that can be executed by at least one processor and can complete fixed functions, and are stored in a memory.

The configuration module 401 configures a target database for each of the multiple service groups, where the target database is one of the multiple databases included in the database server. Each target database is used to store business data of the multiple platforms.

As mentioned above, the business data of the multiple platforms may refer to data related to e-commerce transactions, such as the number of orders, the amount involved in each order, and other data.

For example, the configuration module 401 may configure a target database D1 for the service group B1, a target database D2 for the service group B2, and a target database D3 for the service group B3. The target databases D1, D2, and D3 are respectively used to store the The business data of the e-commerce platforms A1, A2, A3. In other words, the target database D1 is used to store the business data of the e-commerce platforms A1, A2, A3, and the target database D2 is used to store all the business data of the e-commerce platforms A1, A2, A3. The business data, the target database D3 is used to store the business data of the e-commerce platforms A1, A2, A3.

In an embodiment, the maximum number of threads corresponding to each of the multiple service groups may be the same or different. For example, the maximum number of threads of each service group in the plurality of service groups may all be 60, 70 or other values. In this embodiment, each thread number is used to respond to a service request sent by the platform corresponding to the service group.

In an embodiment, the configuration module 401 also counts the operating status of each service group in the multiple service groups. Wherein, the operating status includes the time when the maximum number of threads is enabled for each service group. For example, it is calculated that the service group A1 has been enabled for the maximum number of threads during the period from 01: 00 am on 11 November 2018 to 00: 00 am on 11 November 2018.

The control module 402 detects in real time whether the respective ports corresponding to the multiple service groups receive the service request sent from the communication server. When a port corresponding to a certain service group (for example, the aforementioned target service group) of the multiple service groups receives the service request, the control module 402 controls the certain service group to execute the service request. The execution of the service request refers to reading the data requested by the service request from the target database corresponding to the certain service group, or storing/update the data requested by the service request to store/update To the target database corresponding to the certain service group.

In other words, the service request may refer to a request to read data, a request to store data, or a request to update data.

In an embodiment, when the execution of the service request refers to reading the data requested by the service request from a target database corresponding to the certain service group (for example, the target service group), The control module 402 controls the certain service group to return the read data to the communication server, and the communication server returns the read data to the certain platform. When the execution of the service request refers to storing/updating the stored/updated data requested by the service request to the target database corresponding to the certain service group (for example, the target service group), when After the certain service group stores/updates the stored/updated data requested by the service request to the target database corresponding to the certain service group, the control module 402 also controls the certain service group to send a completion The data update notification is sent to the communication server, and the communication server returns the notification of completion of the data update to the certain platform.

In summary, the dynamic database routing device described in the embodiment of the present application configures a target database for each of the multiple service groups, wherein the target database is the multiple databases Each target database is used to store business data of multiple platforms, and each service group in the multiple service groups corresponds to a port; and real-time detection of the respective ports corresponding to the multiple service groups Whether the service request sent from the communication server is received, when the port corresponding to a certain service group in the multiple service groups receives the service request, control the certain service group to execute the A business request, wherein the execution of the business request refers to reading the data requested by the business request from the target database corresponding to the certain service group, or storing/update the data requested by the business request Data storage/update to the target database corresponding to the certain service group can realize dynamic sub-database, support massive transactions, flexible system processing, and can effectively support scenarios with high transaction concurrency.

Example Six

Refer to FIG. 6, which is a schematic structural diagram of the communication server provided in the sixth embodiment of this application. In a preferred embodiment of the present application, the communication server 3 includes a memory 31, at least one processor 32, and at least one communication bus 33.

Those skilled in the art should understand that the structure of the communication server shown in FIG. 6 does not constitute a limitation of the embodiment of the present application. It may be a bus-type structure or a star structure. The communication server 3 may also include a graph Show more or less other hardware or software, or different component arrangements.

In some embodiments, the communication server 3 includes a terminal that can automatically perform numerical calculation and/or information processing in accordance with pre-set or stored computer-readable instructions. Its hardware includes but is not limited to a microprocessor, a dedicated Integrated circuits, programmable gate arrays, digital processors and embedded devices, etc.

It should be noted that the communication server 3 is only an example. If other existing or future electronic products can be adapted to this application, they should also be included in the scope of protection of this application and included here by reference. .

In some embodiments, the memory 31 is used to store program codes and various data, such as the dynamic sub-library routing device 30 installed in the communication server 3, and realizes high-speed and automatic operation during the operation of the communication server 3. Complete the program or data access. The memory 31 includes Read-Only Memory (ROM), Programmable Read-Only Memory (PROM), and Erasable Programmable Read-Only Memory (EPROM) , One-time Programmable Read-Only Memory (OTPROM), Electronically-Erasable Programmable Read-Only Memory (EEPROM), CD-ROM (Compact Disc Read- Only Memory, CD-ROM) or other optical disk storage, magnetic disk storage, tape storage, or any other non-volatile readable storage medium that can be used to carry or store data.

In some embodiments, the at least one processor 32 may be composed of integrated circuits, for example, may be composed of a single packaged integrated circuit, or may be composed of multiple integrated circuits with the same function or different functions, including one Or a combination of multiple central processing units (CPU), microprocessors, digital processing chips, graphics processors, and various control chips. The at least one processor 32 is the control core (Control Unit) of the communication server 3, which uses various interfaces and lines to connect the various components of the entire communication server 3, by running or executing programs stored in the memory 31 or Modules, and call data stored in the memory 31 to perform various functions of the communication server 3 and process data, for example, perform dynamic sub-library routing functions.

In some embodiments, the at least one communication bus 33 is configured to implement connection and communication between the memory 31 and the at least one processor 32 and the like.

Although not shown, the communication server 3 may also include a power source (such as a battery) for supplying power to various components. Preferably, the power source may be logically connected to the at least one processor 32 through a power management device, so as to be realized by the power management device. Manage functions such as charging, discharging, and power management. The power supply may also include one or more DC or AC power supplies, recharging devices, power failure detection circuits, power converters or inverters, power status indicators and other arbitrary components. The communication server 3 may also include various sensors, Bluetooth modules, Wi-Fi modules, etc., which will not be repeated here.

It should be understood that the described embodiments are for illustrative purposes only, and are not limited by this structure in the scope of the patent application.

The above-mentioned integrated unit implemented in the form of a software function module may be stored in a nonvolatile readable storage medium. The above-mentioned software function module includes a number of computer-readable instructions, which are used to make a computer device (which may be a personal computer, a terminal, or a network device, etc.) or a processor execute the various embodiments of the present application. Method part.

In a further embodiment, with reference to FIG. 4, the at least one processor 32 can execute the operating device of the communication server 3 and various installed applications (such as the dynamic sub-library routing device 30), etc., for example , The various modules mentioned above.

The memory 31 stores computer-readable instructions, and the at least one processor 32 can call the computer-readable instructions stored in the memory 31 to perform related functions. For example, the various modules described in FIG. 4 are computer-readable instructions stored in the memory 31 and executed by the at least one processor 32, so as to realize the functions of the various modules to achieve dynamic database routing. the goal of.

In an embodiment of the present application, the memory 31 stores a plurality of computer readable instructions, and the plurality of computer readable instructions are executed by the at least one processor 32 to implement dynamic database routing.

Specifically, for the specific implementation method of the at least one processor 32 on the foregoing computer-readable instructions, reference may be made to the description of the relevant steps in the embodiment corresponding to FIG. 2, which is not repeated here.

Example Seven

Refer to FIG. 7, which is a schematic structural diagram of the application server provided in the seventh embodiment of this application. In a preferred embodiment of the present application, the application server 4 includes a memory 41, at least one processor 42, and at least one communication bus 43.

Those skilled in the art should understand that the structure of the application server shown in FIG. 7 does not constitute a limitation of the embodiment of the present application. It may be a bus-type structure or a star structure. The application server 4 may also include a graph Show more or less other hardware or software, or different component arrangements.

In some embodiments, the application server 4 includes a terminal that can automatically perform numerical calculation and/or information processing in accordance with pre-set or stored computer-readable instructions, and its hardware includes, but is not limited to, a microprocessor, a dedicated Integrated circuits, programmable gate arrays, digital processors and embedded devices, etc.

It should be noted that the application server 4 is only an example, and other existing or future electronic products that can be adapted to this application should also be included in the scope of protection of this application and included here by reference .

In some embodiments, the memory 41 is used to store program codes and various data, such as a dynamic sub-library routing device 40 installed in the application server 4, and realizes high-speed and automatic operation during the operation of the application server 4. Complete the program or data access. The memory 41 includes read-only memory (Read-Only Memory, ROM), programmable read-only memory (Programmable Read-Only Memory, PROM), and erasable Programmable Read-Only Memory (EPROM) , One-time Programmable Read-Only Memory (OTPROM), Electronically-Erasable Programmable Read-Only Memory (EEPROM), CD-ROM (Compact Disc Read- Only Memory, CD-ROM) or other optical disk storage, magnetic disk storage, tape storage, or any other non-volatile readable storage medium that can be used to carry or store data.

In some embodiments, the at least one processor 42 may be composed of integrated circuits, for example, may be composed of a single packaged integrated circuit, or may be composed of multiple integrated circuits with the same function or different functions, including one Or a combination of multiple central processing units (CPU), microprocessors, digital processing chips, graphics processors, and various control chips. The at least one processor 42 is the control core (Control Unit) of the application server 4, which uses various interfaces and lines to connect the various components of the entire application server 4, and runs or executes programs stored in the memory 41 or Modules, and call the data stored in the memory 41 to perform various functions of the application server 4 and process data, for example, perform the function of dynamic sub-database routing.

In some embodiments, the at least one communication bus 43 is configured to implement connection and communication between the memory 41 and the at least one processor 42 and the like.

Although not shown, the application server 4 may also include a power source (such as a battery) for supplying power to various components. Preferably, the power source may be logically connected to the at least one processor 42 through a power management device, thereby being implemented by the power management device. Manage functions such as charging, discharging, and power management. The power supply may also include one or more DC or AC power supplies, recharging devices, power failure detection circuits, power converters or inverters, power supply status indicators and other arbitrary components. The application server 4 may also include various sensors, Bluetooth modules, Wi-Fi modules, etc., which will not be repeated here.

It should be understood that the described embodiments are for illustrative purposes only, and are not limited by this structure in the scope of the patent application.

The above-mentioned integrated unit implemented in the form of a software function module may be stored in a nonvolatile readable storage medium. The above-mentioned software function module includes a number of computer-readable instructions, which are used to make a computer device (which may be a personal computer, a terminal, or a network device, etc.) or a processor execute the various embodiments of the present application. Method part.

In a further embodiment, with reference to FIG. 5, the at least one processor 42 can execute the operating device of the application server 4 and various installed applications (such as the dynamic sub-library routing device 40), etc., for example , The various modules mentioned above.

The memory 41 stores computer readable instructions, and the at least one processor 42 can call the computer readable instructions stored in the memory 41 to perform related functions. For example, the various modules described in FIG. 5 are computer-readable instructions stored in the memory 41 and executed by the at least one processor 42 to realize the functions of the various modules to achieve dynamic database routing. the goal of.

In an embodiment of the present application, the memory 41 stores a plurality of computer-readable instructions, and the plurality of computer-readable instructions are executed by the at least one processor 42 to implement dynamic database routing.

Specifically, for the specific implementation method of the at least one processor 42 on the foregoing computer-readable instructions, reference may be made to the description of the relevant steps in the embodiment corresponding to FIG. 3, which is not repeated here.

In the several embodiments provided in this application, it should be understood that the disclosed device and method may be implemented in other ways. For example, the device embodiments described above are only illustrative. For example, the division of the modules is only a logical function division, and there may be other division methods in actual implementation.

The modules described as separate components may or may not be physically separated, and the components displayed as modules may or may not be physical units, that is, they may be located in one place, or they may be distributed on multiple network units. Some or all of the modules may be selected according to actual needs to achieve the objectives of the solutions of the embodiments.

In addition, the functional modules in the various embodiments of the present application may be integrated into one processing unit, or each unit may exist alone physically, or two or more units may be integrated into one unit. The above-mentioned integrated unit can be implemented in the form of hardware or in the form of hardware plus software functional modules.

For those skilled in the art, it is obvious that the present application is not limited to the details of the foregoing exemplary embodiments, and the present application can be implemented in other specific forms without departing from the spirit or basic characteristics of the application. Therefore, no matter from which point of view, the embodiments should be regarded as exemplary and non-limiting. The scope of this application is defined by the appended claims rather than the above description, and therefore it is intended to fall into the claims. All changes in the meaning and scope of the equivalent elements of are included in this application. Any reference signs in the claims should not be regarded as limiting the claims involved. In addition, it is obvious that the word "include" does not exclude other elements or, and the singular does not exclude the plural. Multiple units or devices stated in the device claims can also be implemented by one unit or device through software or hardware. Words such as first and second are used to denote names, but do not denote any specific order.

Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the application and not to limit them. Although the application has been described in detail with reference to the preferred embodiments, those of ordinary skill in the art should understand that the technical solutions of the application can be Modifications or equivalent replacements are made without departing from the spirit and scope of the technical solution of this application.

Claims (20)

1. A dynamic database routing method applied to a communication server connected to an application server including multiple service groups, characterized in that the method includes:

   Set up a routing configuration table, where the routing configuration table is used to record the correspondence between multiple platforms and the multiple service groups, and to record the port corresponding to each service group in the multiple service groups , Where different platforms correspond to different service groups;

   When a service request sent by any one of the multiple platforms is received, the routing configuration table is retrieved according to the platform sending the service request, and a target service group and all service groups are determined from the multiple service groups. The port corresponding to the target service group, wherein the target service group is a service group corresponding to the platform that sends the service request among the multiple service groups recorded in the routing configuration table; and

   Send the received service request to the port corresponding to the target service group.
2. 3. The dynamic routing method for database division according to claim 1, wherein the method further comprises:

   Obtain the operating status of each service group in the plurality of service groups in a preset time period from the application server on a regular basis, wherein the operating status includes the time when the maximum number of threads is enabled for each service group; and

   The routing configuration table is adjusted according to the operating status of each service group in the plurality of service groups within the preset time period.
3. The dynamic database routing method according to claim 2, wherein the adjusting the routing configuration table according to the operating status of each of the multiple service groups in the preset time period comprises :

   Counting the total time length of each service group in the plurality of service groups when the maximum number of threads is activated within the preset time period to obtain the total time length corresponding to each service group in the plurality of service groups;

   Determine whether the total duration corresponding to each service group exceeds the predetermined duration;

   If the total duration corresponding to each of the multiple service groups is less than or equal to the predetermined duration, it is determined that there is no need to update the routing configuration table;

   If the total duration corresponding to at least one of the multiple service groups is greater than the predetermined duration, it is determined that the routing configuration table needs to be updated; and

   When it is determined that the routing configuration table needs to be updated, in the routing configuration table, the service group corresponding to the longest total duration is swapped with the service group corresponding to the shortest total duration.
4. A dynamic database routing method, applied to an application server including multiple service groups, the application server being connected to a communication server and a database server including multiple databases, characterized in that the method includes:

   Configure a target database for each of the multiple service groups, where the target database is one of the multiple databases, and each target database is used to store business data of multiple platforms, Each service group in the plurality of service groups corresponds to a port; and

   Real-time detection of whether the ports corresponding to the multiple service groups receive the service request sent from the communication server, and when the port corresponding to a certain service group in the multiple service groups receives the service When requested, control the certain service group to execute the service request.
5. The dynamic database routing method according to claim 4, wherein the execution of the service request refers to reading the data requested by the service request from a target database corresponding to the certain service group, Or store/update the data requested to be stored/updated by the service request to the target database corresponding to the certain service group.
6. The dynamic routing method for database division according to claim 4, wherein the method further comprises:

   Calculate the operating status of each service group in the multiple service groups, where the operating status includes the time when the maximum number of threads is enabled for each service group, wherein each service group in the multiple service groups The corresponding maximum number of threads is the same or different.
7. A dynamic sub-library routing device running in a communication server connected to an application server including multiple service groups, characterized in that the device includes:

   The setting module is used to set a routing configuration table, wherein the routing configuration table is used to record the correspondence between multiple platforms and the multiple service groups, and to record each service in the multiple service groups The port corresponding to the group, where different platforms correspond to different service groups;

   The execution module is configured to, when a service request sent by any one of the multiple platforms is received, retrieve the routing configuration table according to the platform that sent the service request, and determine one from the multiple service groups A target service group and a port corresponding to the target service group, wherein the target service group is a service group corresponding to the platform that sends the service request among the multiple service groups recorded in the routing configuration table; and

   The execution module is also used to send the received service request to the port corresponding to the target service group.
8. A dynamic sub-database routing device runs in an application server including multiple service groups, the application server is connected to a communication server and a database server including multiple databases, characterized in that the device includes:

   The configuration module is used to configure a target database for each of the multiple service groups, where the target database is one of the multiple databases, and each target database is used to store multiple Business data of the platform, each of the multiple service groups corresponds to a port; and

   The control module is used to detect in real time whether the respective ports corresponding to the multiple service groups receive the service request sent from the communication server, when the port corresponding to any one of the multiple service groups When the service request is received, the service group that has received the service request is controlled to execute the service request, where the execution of the service request refers to the service group corresponding to the service group that received the service request Read the data requested by the service request in the target database, or store/update the data requested to be stored/updated by the service request to the target corresponding to the service group that received the service request database.
9. A communication server connected to an application server including multiple service groups, characterized in that the communication server includes a processor, and the processor executes computer-readable instructions stored in a memory to implement the following steps:

   Set up a routing configuration table, where the routing configuration table is used to record the correspondence between multiple platforms and the multiple service groups, and to record the port corresponding to each service group in the multiple service groups , Where different platforms correspond to different service groups;

   When a service request sent by any one of the multiple platforms is received, the routing configuration table is retrieved according to the platform sending the service request, and a target service group and all service groups are determined from the multiple service groups. The port corresponding to the target service group, wherein the target service group is a service group corresponding to the platform that sends the service request among the multiple service groups recorded in the routing configuration table; and

   Send the received service request to the port corresponding to the target service group.
10. 9. The communication server of claim 9, wherein the processor executes the computer-readable instructions stored in the memory and is further used to implement the following steps:

    Obtain the operating status of each service group in the plurality of service groups in a preset time period from the application server on a regular basis, wherein the operating status includes the time when the maximum number of threads is enabled for each service group; and

    The routing configuration table is adjusted according to the operating status of each service group in the plurality of service groups within the preset time period.
11. The communication server according to claim 10, wherein the adjusting the routing configuration table according to the operating status of each service group in the plurality of service groups within the preset time period comprises:

    Counting the total time length of each service group in the plurality of service groups when the maximum number of threads is activated within the preset time period to obtain the total time length corresponding to each service group in the plurality of service groups;

    Determine whether the total duration corresponding to each service group exceeds the predetermined duration;

    If the total duration corresponding to each of the multiple service groups is less than or equal to the predetermined duration, it is determined that there is no need to update the routing configuration table;

    If the total duration corresponding to at least one of the multiple service groups is greater than the predetermined duration, it is determined that the routing configuration table needs to be updated; and

    When it is determined that the routing configuration table needs to be updated, in the routing configuration table, the service group corresponding to the longest total duration is swapped with the service group corresponding to the shortest total duration.
12. An application server, the application server includes a plurality of service groups, the application server is connected to a communication server and a database server including a plurality of databases, wherein the server includes a processor, and the processor executes Stored computer readable instructions to implement the following steps:

    Configure a target database for each of the multiple service groups, where the target database is one of the multiple databases, and each target database is used to store business data of multiple platforms, Each service group in the plurality of service groups corresponds to a port; and

    Real-time detection of whether the ports corresponding to the multiple service groups receive the service request sent from the communication server, and when the port corresponding to a certain service group in the multiple service groups receives the service When requested, control the certain service group to execute the service request.
13. The application server of claim 12, wherein the execution of the service request refers to reading the data requested by the service request from a target database corresponding to the certain service group, or converting all The stored/updated data requested by the service request is stored/updated to the target database corresponding to the certain service group.
14. The application server of claim 12, wherein the processor executes the computer-readable instructions stored in the memory and is further configured to implement the following steps:

    Calculate the operating status of each service group in the multiple service groups, where the operating status includes the time when the maximum number of threads is enabled for each service group, wherein each service group in the multiple service groups The corresponding maximum number of threads is the same or different.
15. A non-volatile readable storage medium having computer readable instructions stored thereon, characterized in that, when the computer readable instructions are executed by a processor, the following steps are implemented:

    Set up a routing configuration table, where the routing configuration table is used to record the correspondence between multiple platforms and multiple service groups in the application server, and to record the correspondence between each service group in the multiple service groups , Where different platforms correspond to different service groups;

    When a service request sent by any one of the multiple platforms is received, the routing configuration table is retrieved according to the platform sending the service request, and a target service group and all service groups are determined from the multiple service groups. The port corresponding to the target service group, wherein the target service group is a service group corresponding to the platform that sends the service request among the multiple service groups recorded in the routing configuration table; and

    Send the received service request to the port corresponding to the target service group.
16. 15. The storage medium of claim 15, wherein the computer-readable instructions are further used to implement the following steps when executed by the processor:

    Obtain the operating status of each service group in the plurality of service groups in a preset time period from the application server on a regular basis, wherein the operating status includes the time when the maximum number of threads is enabled for each service group; and

    The routing configuration table is adjusted according to the operating status of each service group in the plurality of service groups within the preset time period.
17. 15. The storage medium of claim 16, wherein the adjusting the routing configuration table according to the operating status of each of the multiple service groups within the preset time period comprises:

    Counting the total time length of each service group in the plurality of service groups when the maximum number of threads is activated within the preset time period to obtain the total time length corresponding to each service group in the plurality of service groups;

    Determine whether the total duration corresponding to each service group exceeds the predetermined duration;

    If the total duration corresponding to each of the multiple service groups is less than or equal to the predetermined duration, it is determined that there is no need to update the routing configuration table;

    If the total duration corresponding to at least one of the multiple service groups is greater than the predetermined duration, it is determined that the routing configuration table needs to be updated; and

    When it is determined that the routing configuration table needs to be updated, in the routing configuration table, the service group corresponding to the longest total duration is swapped with the service group corresponding to the shortest total duration.
18. A non-volatile readable storage medium having computer readable instructions stored thereon, characterized in that, when the computer readable instructions are executed by a processor, the following steps are implemented:

    A target database is configured for each of the multiple service groups in the application server, where the target database is one of the multiple databases in the data server, and each target database is used to store multiple platforms Each of the service groups in the plurality of service groups corresponds to a port; and

    Real-time detection of whether the ports corresponding to the multiple service groups receive the service request sent from the communication server, and when the port corresponding to a certain service group in the multiple service groups receives the service request To control the certain service group to execute the service request.
19. The storage medium according to claim 18, wherein the execution of the service request refers to reading the data requested by the service request from a target database corresponding to the certain service group, or converting all The stored/updated data requested by the service request is stored/updated to the target database corresponding to the certain service group.
20. The storage medium of claim 18, wherein the computer-readable instructions are further used to implement the following steps when executed by the processor:

    Calculate the operating status of each service group in the multiple service groups, where the operating status includes the time when the maximum number of threads is enabled for each service group, wherein each service group in the multiple service groups The corresponding maximum number of threads is the same or different.

Images