WO2016184175A1

WO2016184175A1 - Database processing method and apparatus

Info

Publication number: WO2016184175A1
Application number: PCT/CN2016/073373
Authority: WO
Inventors: 吴秋鹏; 丁岩
Original assignee: 中兴通讯股份有限公司
Priority date: 2015-05-21
Filing date: 2016-02-03
Publication date: 2016-11-24
Also published as: CN106293887A

Abstract

A database processing method and apparatus. The method comprises: a proxy client receiving a processing request sent by a service application, wherein the processing request is used to request for processing of data in a database (S102); the proxy client determining a data service end used to execute the processing request, wherein the service application accesses the database via the proxy client and the data service end (S104); the proxy client sending the processing request to the determined data service end (S106); the determined data service end processing the data in the database according to the processing request (S108); the determined data service end sending a processing result to the proxy client (S110); and the proxy client sending the received processing result to the service application (S112). The method solves the problem existing in the relevant art that a service is interrupted because a database access logic is abnormal, thereby achieving the effect of ensuring the normal operation of the service.

Description

Database processing method and device

Technical field

The present invention relates to the field of communications, and in particular to a database processing method and apparatus.

Background technique

Enterprise application software will have a large number of database access operations. In the software logic architecture, it will generally act as a separate layer, that is, the data access layer. The business logic layer (that is, the business application) calls the database access layer to access the resources in the database. Decouple business logic and database access logic to separate low-level data access logic from high-level business logic.

However, there are two problems in the related art for accessing the patterns of resources in the database:

First, because the business logic (ie, business application) directly calls the database access logic, if the database access object is flawed internally or the program is not robust, the business logic will also crash when a serious exception occurs. If the application software is deployed at a single point, the entire software service will be interrupted. If the application software is distributed, although other service nodes can still serve externally, the throughput of the entire system will be reduced by one node.

Secondly, if there is a problem with the database access layer to fix the upgrade, the entire business software must be stopped, resulting in business interruption.

The industry has adopted a Service-oriented Architecture (SOA) to encapsulate database access into a data service in the form of a service for service application calls. However, this solution has a greater impact on the original application service. First, the calling method is directly called from the local, and becomes a Web service call, which greatly transforms the original business code. Secondly, if the data service is abnormal or crashes, the business application will still be abnormal. Therefore, there is a problem in the related art that business services are interrupted due to database access logic abnormalities.

In view of the problem that the business service is interrupted due to database access logic anomalies in the related art, an effective solution has not been proposed yet.

Summary of the invention

The invention provides a database processing method and device, so as to at least solve the problem that the business service is interrupted due to database access logic abnormality existing in the related art.

According to an aspect of the embodiments of the present invention, a database processing method includes: receiving, by a proxy client, a processing request sent by a service application, where the processing request is used to request processing of data in the database; Determining a data server for executing the foregoing processing request, wherein the service application accesses the database through the proxy client and the data server; the proxy client sends the processing request to the determined data server; The data server processes the data in the database according to the processing request; the determined data server sends the processing result to the proxy client; the proxy client receives the above The processing result is sent to the above business application.

Optionally, the foregoing proxy client determines, by at least one of the following manners, that the data server for executing the foregoing processing request includes: the proxy client determines the data server according to the predetermined configuration; and the proxy client is configured according to the size of the data server load Determining a data server, wherein the proxy client selects a data server with the least load.

Optionally, after the proxy client determines the data server according to the predetermined configuration, the method further includes: after the data server is abnormal according to the predetermined configuration, the proxy client selects another data server in a normal running state.

Optionally, after the proxy client selects another data server in a normal running state, the method further includes: after the data server determined according to the predetermined configuration returns to normal, the proxy client reselects the foregoing determining according to the predetermined configuration. The data server acts as a data server that performs the above processing request.

Optionally, the receiving, by the proxy client, the foregoing processing request sent by the service application, the proxy client receiving the processing request by using an interface, where the interface includes at least one of the following: an interface of an entry parameter including information of service data, The interface of the access parameter database access request, the information of the service data is used to indicate the data that the service application needs to process.

Optionally, the above interface is a local interface.

Optionally, the proxy client sending the processing request to the determined data server includes: the proxy client encoding the processing request into a request packet according to a predetermined communication protocol; and the proxy client sending the request packet to the request packet The data server identified above.

Optionally, the foregoing determined data server sends the foregoing processing result to the proxy client, where the data server returns the processing result to the proxy client according to a predetermined communication protocol.

According to another aspect of the present invention, a database processing apparatus is provided, including: a receiving module, wherein the receiving module is applied to a proxy client, and is configured to receive a processing request sent by a service application, where the processing request is used for Requesting to process data in the foregoing database; determining a module, wherein the determining module is applied to the proxy client, and is configured to determine a data server for executing the processing request, wherein the service application passes the proxy client and the foregoing data The server accesses the database; the first sending module, the first sending module is applied to the proxy client, and is configured to send the processing request to the determined data server; the processing module, the processing module is applied to the determined data server The second sending module is configured to apply the processing result to the proxy client, where the second sending module is applied to the determined data server. Three transmission module, the above third transmission mode Applied to the agent client, transmits to the service application is provided above the processing result received.

Optionally, the determining module includes: a first determining unit, configured to determine a data server according to a predetermined configuration; and a second determining unit, configured to determine a data server according to a size of a data server load, where the proxy client selects The least loaded data server.

Optionally, the determining module further includes: a first selecting unit, configured to be a data service determined according to a predetermined configuration. After the terminal is abnormal, select another data server that is in normal operation.

Optionally, the determining module further includes: a second selecting unit, configured to reselect the data server determined according to the predetermined configuration as the data service for executing the processing request after the data server determined according to the predetermined configuration returns to normal end.

Optionally, the receiving module includes: a receiving unit, configured to receive the processing request by using an interface, where the interface includes at least one of the following: an interface that includes information of service data, an interface of an access parameter database access request, and the foregoing The information of the service data is used to indicate the data that the above business application needs to process.

Optionally, the above interface is a local interface.

Optionally, the first sending module includes: an encoding unit configured to encode the processing request into a request message according to a predetermined communication protocol; and the sending unit is configured to send the request message to the determined data server.

Optionally, the foregoing second sending module includes: a returning unit, configured to return the processing result to the proxy client according to a predetermined communication protocol.

According to the embodiment of the present invention, the proxy client receives a processing request sent by the service application, where the processing request is used to request processing of data in the database; and the proxy client determines a data server for executing the processing request. The service application accesses the database through the proxy client and the data server; the proxy client sends the processing request to the determined data server; and the determined data server performs the request in the database according to the processing request. The data is processed; the determined data server sends the processing result to the proxy client; and the proxy client sends the received processing result to the service application. Thereby, the data access logic is encapsulated into a data service system, and the proxy client in the data service system can be directly called by the business application, shielding the complexity of the data service, and the execution request can be determined by the proxy client. Data server, and the number of data servers can be more than two, thus ensuring that when a data server is abnormal, other data servers can be used to execute processing requests to ensure normal operation of the service and reduce the impact. The problem that the business service is interrupted due to the database access logic abnormality existing in the related art is solved, thereby achieving the effect of ensuring the normal operation of the service service.

DRAWINGS

The drawings described herein are intended to provide a further understanding of the invention, and are intended to be a part of the invention. In the drawing:

1 is a flow chart of a database processing method according to an embodiment of the present invention;

2 is a block diagram showing the structure of a database processing apparatus according to an embodiment of the present invention;

FIG. 3 is a structural block diagram of a determining module 24 in a database processing apparatus according to an embodiment of the present invention; FIG.

4 is a block diagram 1 of a preferred structure of the determining module 24 in the database processing apparatus according to an embodiment of the present invention;

5 is a block diagram 2 of a preferred structure of the determining module 24 in the database processing apparatus according to an embodiment of the present invention;

FIG. 6 is a structural block diagram of a receiving module 22 in a database processing apparatus according to an embodiment of the present invention;

FIG. 7 is a structural block diagram of a first transmitting module 26 in a database processing apparatus according to an embodiment of the present invention;

FIG. 8 is a structural block diagram of a second sending module 210 in a database processing apparatus according to an embodiment of the present invention;

9 is a schematic diagram showing a basic flow of a service application calling data service according to an embodiment of the present invention;

FIG. 10 is a schematic diagram of a communication flow according to an embodiment of the present invention; FIG.

11 is a schematic structural diagram of a data service system when a single application scenario is performed according to an embodiment of the present invention;

FIG. 12 is a schematic structural diagram of a data service system in a distributed application scenario according to an embodiment of the present invention; FIG.

FIG. 13 is a block diagram showing the structure of a data service system according to an embodiment of the present invention.

detailed description

The invention will be described in detail below with reference to the drawings in conjunction with the embodiments. It should be noted that the embodiments in the present application and the features in the embodiments may be combined with each other without conflict.

It is to be understood that the terms "first", "second" and the like in the specification and claims of the present invention are used to distinguish similar objects, and are not necessarily used to describe a particular order or order.

In this embodiment, a database processing method is provided. FIG. 1 is a flowchart of a database processing method according to an embodiment of the present invention. As shown in FIG. 1, the process includes the following steps:

Step S102, the proxy client receives a processing request sent by the service application, where the processing request is used to request processing of data in the database;

Step S104, the proxy client determines a data server for executing a processing request, wherein the service application accesses the database through the proxy client and the data server;

Step S106, the proxy client sends the processing request to the determined data server;

Step S108, the determined data server processes the data in the database according to the processing request;

Step S110, the determined data server sends the processing result to the proxy client.

Step S112, the proxy client sends the received processing result to the service application.

In this embodiment, the data access logic is encapsulated into a data service system, and the data service system is divided into a proxy client and a data server. The proxy client is integrated and directly invoked by the business application, and the proxy client and the data server can be Communicate via the network. Through the above steps, the proxy client in the data service system can be directly called by the business application, shielding the complexity of the data service, and the data server executing the processing request can be determined by the proxy client, and the data server is The number can be more than two, which ensures that when a data server is abnormal, other can be used. The data server executes the processing request to ensure the normal operation of the service and reduces the impact, thereby solving the problem that the service service is interrupted due to the database access logic abnormality in the related technology, thereby achieving the effect of ensuring the normal operation of the service service.

In an optional embodiment, the proxy client may determine, by at least one of the following methods, a data server for executing a processing request: the proxy client determines a data server according to a predetermined configuration; and the proxy client is configured according to the data server. The size of the load determines the data server, where the proxy client selects the data server with the least load. Therefore, when the proxy client determines the data server, there may be multiple determination manners. One way is to determine the data server according to the predetermined configuration, that is, each proxy client may have a pre-configured data server. The pre-configured data server is the default configured data server. The default configured data server can be one or more. The proxy client can use the default configured data service to process the database accordingly. In another mode, when the proxy client does not have a data server configured by default, the proxy client may select a data server according to a predetermined rule, and the predetermined rule may have multiple types, for example, the data with the smallest load may be selected. The server can select the data server with the strongest processing capability, or randomly select the data server in the idle state. Of course, the above manner of determining the data server is only an example, and the manner of determining the data server is not limited to the above manner.

It can be seen from the foregoing embodiment that the proxy client can determine the data server according to the predetermined configuration. In an actual application, the data server determined according to the predetermined configuration may be abnormal, and the data server determined according to the predetermined configuration is abnormal. After that, the proxy client needs to select another data server for executing the processing request. In an optional embodiment, after the data server is abnormal according to the predetermined configuration, the proxy client selects other normal operations. The status of the data server. When selecting other data server, the selection principle can be consistent with the predetermined rule in the above embodiment, that is, the data server with the least load can be selected, and the data server with the strongest processing capability can be selected, or can be randomly selected. In the idle data server, of course, there may be other selection methods. For example, if the proxy client polls other data servers in a predetermined order, and finds the idle and working data server, the idle and A data server that works fine. Since the data server can execute the processing request, the data server encapsulates the database access logic and is deployed separately. The data server can establish and maintain a database connection with one or more databases; and the number of data servers can be two. Or more, multiple data servers can form a cluster. When determining the abnormality of the data server, there may be various determination methods, such as when the data server is abnormal in heartbeat or the network is interrupted.

In an optional embodiment, after the proxy client selects another data server in a normal running state, the method further includes: when the data server determined according to the predetermined configuration returns to normal, the proxy client reselects The data server determined according to the predetermined configuration is used as a data server that executes the processing request. Therefore, it is guaranteed that the data server connected to other proxy clients is not occupied for a long time.

In an optional embodiment, the receiving, by the proxy client, the processing request sent by the service application comprises: the proxy client receiving the processing request through the interface, wherein the interface comprises at least one of the following: the interface of the entry parameter including the information of the service data The interface of the access parameter database access request, the information of the service data is used to indicate data that the service application needs to process. The information of the foregoing service data may include a uniquely identified data service ID and a service parameter, and the service parameter may be a query condition, or may be a service data that needs to be inserted into a database, etc.; the above-mentioned entry parameter database access request may be a standard structured Query Language (SQL).

In an optional embodiment, the foregoing interface may be a local interface, that is, the service application invokes the proxy client in a local interface manner.

In an optional embodiment, when the proxy client sends the processing request to the determined data server, the processing request may first be encoded into the request message according to the predetermined communication protocol; and then the request message is sent to the request message. The data server identified above.

In an optional embodiment, after receiving the processing request sent by the proxy client, the data server may convert the database into the SQL access database for database operation or directly according to the previously configured database connection information and data service logic. Forwarding the database access request; and returning the database operation result to the proxy client according to the internal communication protocol, wherein the data server returns the operation result in the manner of the response message when returning the operation result. The proxy client can obtain and parse the response packet returned by the data server, and return the response result to the service application.

Through the description of the above embodiments, those skilled in the art can clearly understand that the method according to the above embodiment can be implemented by means of software plus a necessary general hardware platform, and of course, by hardware, but in many cases, the former is A better implementation. Based on such understanding, the technical solution of the present invention in essence or the contribution to the related art can be embodied in the form of a software product stored in a storage medium (such as ROM/RAM, disk, CD-ROM). The instructions include a number of instructions for causing a terminal device (which may be a cell phone, computer, server, or network device, etc.) to perform the methods of various embodiments of the present invention.

In the embodiment, a database processing device is also provided, which is used to implement the above-mentioned embodiments and preferred embodiments, and has not been described again. As used below, the term "module" may implement a combination of software and/or hardware of a predetermined function. Although the apparatus described in the following embodiments is preferably implemented in software, hardware, or a combination of software and hardware, is also possible and contemplated.

2 is a structural block diagram of a database processing apparatus according to an embodiment of the present invention. As shown in FIG. 2, the apparatus includes a receiving module 22, a determining module 24, a first sending module 26, a processing module 28, a second sending module 210, and a The three sending module 212, wherein the receiving module 22, the determining module 24, the first sending module 26, and the third sending module 212 are applied to the proxy client, and the processing module 28 and the second sending module 210 are applied to the data server. The device is described below:

The receiving module 22 is configured to receive a processing request sent by the service application, where the processing request is used to request processing of data in the database; and the determining module 24 is configured to determine a data server for executing the processing request, where The service application accesses the database through the proxy client and the data server; the first sending module 26 is configured to send the processing request to the determined data server; the processing module 28 is configured to process the data in the database according to the processing request; The second sending module 210 is configured to send the processing result to the proxy client, and the third sending module 212 is configured to send the received processing result to the service application.

FIG. 3 is a structural block diagram of a determining module 24 in a database processing apparatus according to an embodiment of the present invention. As shown in FIG. 3, the determining module 24 includes a first determining unit 32 and a second determining unit 34, and the determining module 24 is provided below. Be explained:

The first determining unit 32 is configured to determine the data server according to the predetermined configuration; the second determining unit 34 is configured to determine the data server according to the size of the data server load, wherein the proxy client selects the data server with the least load.

4 is a block diagram of a preferred structure of the determining module 24 in the database processing apparatus according to the embodiment of the present invention. As shown in FIG. 4, the determining module 24 includes a first selecting unit 42 in addition to the unit shown in FIG. The determination module 24 will be described below.

The first selecting unit 42 is connected to the first determining unit 32, and is configured to select another data server in a normal running state after the data server terminal determined according to the predetermined configuration is abnormal.

FIG. 5 is a block diagram of a preferred structure of the determining module 24 in the database processing apparatus according to the embodiment of the present invention. As shown in FIG. 5, the determining module 24 includes a second selecting unit 52 in addition to the unit shown in FIG. The determination module 24 will be described below.

The second selecting unit 52 is connected to the first selecting unit 42 and configured to reselect the data server determined according to the predetermined configuration as the data server performing the processing request after the data server determined according to the predetermined configuration returns to normal. .

FIG. 6 is a structural block diagram of a receiving module 22 in a database processing apparatus according to an embodiment of the present invention. As shown in FIG. 6, the receiving module 22 includes a receiving unit 62, and the receiving unit 62 will be described below.

The receiving unit 62 is configured to receive a processing request by using an interface, where the interface includes at least one of the following: an interface that includes information of service data, an interface of an access parameter database access request, and information of the service data is used to indicate the foregoing service. Apply the data that needs to be processed.

In an optional embodiment, the above interface is a local interface.

FIG. 7 is a structural block diagram of a first sending module 26 in a database processing apparatus according to an embodiment of the present invention. As shown in FIG. 7, the first transmitting module 26 includes an encoding unit 72 and a transmitting unit 74, and the first sending is performed below. Module 26 is described.

The encoding unit 72 is configured to encode the processing request into the request message according to a predetermined communication protocol; the transmitting unit 74 is connected to the encoding unit 72, and is configured to send the request message to the determined data server.

FIG. 8 is a structural block diagram of a second sending module 210 in a database processing apparatus according to an embodiment of the present invention. As shown in FIG. 8, the second sending module 210 includes a returning unit 82, which is described below.

Returning unit 82 is arranged to return the processing result to the proxy client in accordance with a predetermined communication protocol.

The following takes the information of the service data as the data service ID and the service parameter, and the above-mentioned entry parameter database access request is an example of the SQL, and the present invention is described:

FIG. 9 is a schematic diagram of a basic process of invoking a data service by a service application according to an embodiment of the present invention. As shown in FIG. 9, the process includes the following steps:

Step S902, the service application locally invokes an interface in the proxy client, and transmits the data service ID and the service parameter.

Step S904, the proxy client encodes the data service ID and the service parameter into a request message, and then sends the data message to the data server.

Step S906, after receiving the request message sent by the proxy client, the data server decodes the data service ID and the service. Parameters, converted to standard SQL according to the configuration, and access to the database through the database connection (Java DataBase Connectivity Java, JDBC for short) or Open DataBase Connectivity (ODBC) to execute the SQL, the SQL execution results are encoded into response messages Send to the proxy client.

Step S908, the proxy client receives the response packet sent by the data server, and decodes the SQL execution result and returns the result to the service application.

Through this embodiment, the data access logic is encapsulated into a data service system, and the data service system is divided into a proxy client and a data server. The proxy client is integrated and directly invoked by the business software, shielding the complexity of the data service. The data server is deployed in a cluster. When the data server connected to the proxy client is abnormal, or the data server is downgraded, the proxy client automatically switches to other normal data servers in the cluster, so that there is no business application. influences.

The following describes the communication flow and basic processing flow of the data service system in the Java language scenario:

FIG. 10 is a schematic diagram of a communication process according to an embodiment of the present invention. As shown in FIG. 10, the process includes the following steps:

In step S1002, when the business application needs to access the database, the unified java interface of the proxy client is invoked, and the data service ID and the service parameter, such as the query condition or the inserted service data, are uniquely identified.

In step S1004, the proxy client encodes the above parameters into a request message according to an internal protocol, and sends the request to the data server of the default connection (the data server determined according to the predetermined configuration as described above).

Step S1006: After receiving the data service request message, the data server first decodes the request, extracts the data service ID and the service parameter in the request, and searches for a corresponding configuration of the corresponding data service ID in the data service configuration, including the database connection information. The mapping between the SQL corresponding to the data service and the Java object, etc., the connection of the database is taken out from the database connection pool through the database connection information, and the SQL and business parameters are executed through the JDBC driver.

In step S1008, the data server obtains the SQL execution result returned by the database.

In step S1010, the data server encodes the SQL execution result returned by the database into a response message by using an internal protocol, and sends the response message to the proxy client.

Step S1012: After receiving the response message, the proxy client decodes the SQL execution result, and according to the mapping relationship between the data service and the java object, the SQL execution result is deserialized into a java object and returned to the service application.

The data service method of the present invention can be applied to a business application whether it is a single-node single-node application or a distributed application deployed as a multi-node.

11 is a schematic structural diagram of a data service system when a single-application application scenario is performed according to an embodiment of the present invention. As shown in FIG. 11, when a service application is a single-node single node, a data service needs to have a proxy client integrated by a service application, and two deployments are performed. One or more data servers are used as a cluster. The proxy client configures all data server connection information in the cluster. The connection information includes the data server IP and the listening port. Before starting the application, all the data servers need to be started. When the application is started, the default data server configured on the proxy client connection (the same data server as determined according to the predetermined configuration) is provided, and the data server is provided through the data server. . If the proxy client detects an abnormality in the default data server, polls the next data server in the cluster to connect. After the connection is successful, the new data server is used to provide the service application. data service.

FIG. 12 is a schematic structural diagram of a data service system in a distributed application scenario according to an embodiment of the present invention. As shown in FIG. 12, when a service application is a multi-node distributed deployment scenario, the basic application is similar to a single-node service application, and the difference is that each The business application of each node integrates a proxy client, and deploys a data server for each business application. The proxy client configuration of each business application is connected by default to its own data server (ie, the proxy client of each business application). The end connection is a data server determined according to a predetermined configuration, and all data servers form a cluster. When the application of each node starts, the proxy client connects to the default data server. When an abnormality occurs in the data server connected to the proxy client of a business application, the proxy client polls the next data server in the cluster to connect, and uses the new data server to provide data services to the business application after the connection is successful. At the same time, the proxy client periodically checks whether the default data server is restored to normal. If it returns to normal, all connections of the non-default data server are interrupted, the default data server is reconnected, and the data service is provided. To ensure that the data server of other nodes is not occupied for a long time.

FIG. 13 is a block diagram showing the structure of a data service system according to an embodiment of the present invention. As shown in FIG. 13, the system includes two major components: a proxy client 132 and a data server 134. The following respectively describe the modules of the two major components:

The proxy client 132 includes an application interface layer 1321 and a proxy client communication module 1322. The application interface layer 1321 and the proxy client communication module 1322 are described below:

Application interface layer 1321:

According to the implementation of SQL type, the interface is divided into the following two categories:

1) Data query interface: the input parameter is the data service ID and parameter set, and the return value type is a collection object. Each element in the set is a javabean object, corresponding to a row of records of the data query. The mapping relationship between the field returned by the data query and the javabean attribute is obtained by the proxy client communication module from the data server. Applicable to call data services that encapsulate the data query language, such as SELECT statements.

2) Data manipulation interface: the input parameter is the data service ID and parameters, and the return value is the number of affected rows.

Applicable to call data services that encapsulate the data manipulation language, such as INSERT, UPDATE, DELETE statements.

According to the needs of different businesses, more types of interfaces can be customized.

Proxy client communication module 1322:

When the proxy client 132 is started, the proxy client communication module 1322 reads the default data server (the same data server determined according to the predetermined configuration) connection information and other data server connection information in the cluster from the configuration file. The default data server 134 is connected, and the mapping between the SQL execution result and the return javabean is obtained from the data server 134 through an internal protocol. When the service application invokes the proxy client interface, the proxy client communication module 1322 encodes the data service ID and the service parameter of the interface into the parameter into a request message according to the JSON format, and sends the data to the connected data server 134, and blocks the reception and return. Response message or timeout. After receiving the response message, the response result is decoded, and the supply interface layer is encapsulated into a java object according to different interface types, and returned to the service application.

When the data server 134 is abnormal, the proxy client communication module 1322 polls all data servers configured for the connection. Use this data server if it can connect properly.

If in the distributed application deployment scenario, the proxy client communication module 1322 periodically detects whether the default data server 134 is restored to normal. If the connection is normal, the data server is disconnected, and the default data server 134 is used. The default data server used by other proxy connections is not used for a long time.

The data server 134 includes a data server communication module 1341, a data service and SQL conversion module 1342, a SQL execution module 1343, a database connection module 1344, and a configuration module 1345. The following describes each module:

Data server communication module 1341:

When the data server 134 is started, the data server communication module 1341 serves as a socket server to listen to the port, and initializes the thread pool. Each time a data service request is received, a thread is obtained from the thread pool to execute subsequent processing logic.

The data server communication module 1341 decodes the data service ID and the service parameters from the request message after receiving the request message, and passes it to the data service and SQL conversion module 1342 for processing, and returns the data service and the SQL conversion module 1342. The coded message is sent to the proxy client 132.

Data Service and SQL Conversion Module 1342:

According to the correspondence between the data service ID and the SQL cached in the configuration module, the data service request is converted into SQL, and the SQL execution module 1343 is called to execute the SQL.

The SQL execution module 1343: obtains the database information corresponding to the data service ID from the configuration module 1345, retrieves the connection of the database from the database connection module 1344, executes the SQL using the JDBC interface, sequentially injects the service parameters, and returns the execution result to the upper module.

Database connection module 1344: When the data server 134 starts, according to the database connection information of the configuration module 1345, the database connection pool and the JDBC driver are used to connect the single or multiple databases.

The configuration module 1345: configures the listening port, the data service ID, the SQL, the correspondence between the data service ID and the SQL, the database connection information, the correspondence between the data service ID and the database connection information, and the SQL execution result of the data server 134 in the configuration file. And return the mapping relationship of javabean. When the data server 134 is started, the configuration module 1345 reads all configuration information and caches it.

The embodiments of the present invention relate to methods and apparatus for providing highly available data services. Among them, the data service is divided into a proxy client and a data server. The data access logic is configured in the data server and deployed into a cluster, and the proxy client and the business application are deployed together, and the proxy client is integrated and directly invoked by the business application. When an exception occurs on the data server, the proxy client automatically switches to another data server that is running normally in the cluster. The invention encapsulates the database access logic by configuring the SQL, and reduces the workload of developing the data access layer; for the business application, the proxy client is directly invoked locally, and does not involve network communication, database connection, etc., and the development cost is low. It is more advantageous to provide a highly available data service solution, avoiding a single point of failure at the data service layer, and also upgrading and maintaining the data server without affecting the business application.

It should be noted that each of the foregoing modules may be implemented by software or hardware. For the latter, The following manner is implemented, but is not limited thereto: the above modules are all located in the same processor; or, the above modules are respectively located in multiple processors.

Embodiments of the present invention also provide a storage medium. Optionally, in the embodiment, the foregoing storage medium may be configured to store program code for performing the following steps:

S1. The proxy client receives a processing request sent by the service application, where the processing request is used to request processing of data in the database.

S2. The proxy client determines a data server for executing a processing request, where the service application accesses the database through the proxy client and the data server;

S3, the proxy client sends the processing request to the determined data server;

S4. The data server determined by the foregoing processes the data in the database according to the processing request;

S5. The determined data server sends the processing result to the proxy client.

S6. The proxy client sends the received processing result to the service application.

Optionally, in the embodiment, the foregoing storage medium may include, but is not limited to, a USB flash drive, a Read-Only Memory (ROM), and a Random Access Memory (RAM). A variety of media that can store program code, such as a hard disk, a disk, or an optical disk.

For example, the specific examples in this embodiment may refer to the examples described in the foregoing embodiments and the optional embodiments, and details are not described herein again.

It will be apparent to those skilled in the art that the various modules or steps of the present invention described above can be implemented by a general-purpose computing device that can be centralized on a single computing device or distributed across a network of multiple computing devices. Alternatively, they may be implemented by program code executable by the computing device such that they may be stored in the storage device by the computing device and, in some cases, may be different from the order herein. The steps shown or described are performed, or they are separately fabricated into individual integrated circuit modules, or a plurality of modules or steps thereof are fabricated as a single integrated circuit module. Thus, the invention is not limited to any specific combination of hardware and software.

The above description is only the preferred embodiment of the present invention, and is not intended to limit the present invention, and various modifications and changes can be made to the present invention. Any modifications, equivalent substitutions, improvements, etc. made within the spirit and scope of the present invention are intended to be included within the scope of the present invention.

Industrial applicability

Through the embodiment of the present invention, the data access logic is encapsulated into a data service system, and the proxy client in the data service system can be directly invoked by the business application, shielding the complexity of the data service, and can be represented by the proxy client. The end determines the data server that executes the processing request, and the number of the data server can be more than two, thereby ensuring that when a data server is abnormal, the other data server can be used to execute the processing request to ensure the positive of the service service. Frequently, the impact is reduced, thereby solving the problem of the business service interruption caused by the database access logic abnormality in the related technology, thereby achieving the effect of ensuring the normal operation of the business service.

Claims

A database processing method, comprising:

The proxy client receives a processing request sent by the service application, where the processing request is used to request processing of data in the database;

Determining, by the proxy client, a data server for executing the processing request, wherein the service application accesses the database through the proxy client and the data server;

The proxy client sends the processing request to the determined data server;

The determined data server processes the data in the database according to the processing request;

The determined data server sends the processing result to the proxy client;

The proxy client sends the received processing result to the service application.
The method according to claim 1, wherein the proxy client determines, by at least one of the following methods, that the data server for executing the processing request comprises:

Determining, by the proxy client, a data server according to a predetermined configuration;

The proxy client determines the data server according to the size of the data server load, wherein the proxy client selects the data server with the least load.
The method of claim 2, wherein after the proxy client determines the data server according to the predetermined configuration, the method further comprises:

After the data server is determined to be abnormal according to the predetermined configuration, the proxy client selects another data server in a normal running state.
The method according to claim 3, wherein after the proxy client selects another data server in a normal running state, the method further includes:

After the data server determined according to the predetermined configuration returns to normal, the proxy client reselects the data server determined according to the predetermined configuration as a data server that executes the processing request.
The method of claim 1, wherein the receiving, by the proxy client, the processing request sent by the service application comprises:

The proxy client receives the processing request through an interface, where the interface includes at least one of: an entry parameter includes an interface of information of service data, an interface of an entry parameter database access request, and information of the service data is used Indicates the data that the business application needs to process.
The method of claim 5 wherein the interface is a local interface.
The method of claim 1, wherein the proxy client sends the processing request to the determined data server comprises:

The proxy client encodes the processing request into a request message according to a predetermined communication protocol;

The proxy client sends the request message to the determined data server.
The method of claim 1, wherein the determining, by the determined data server, the sending of the processing result to the proxy client comprises:

The data server returns the processing result to the proxy client according to a predetermined communication protocol.
A database processing device comprising:

a receiving module, the receiving module is configured to be used in a proxy client, and configured to receive a processing request sent by a service application, where the processing request is used to request processing of data in the database;

Determining a module, the determining module being applied to the proxy client, configured to determine a data server for executing the processing request, wherein the business application accesses the proxy through the proxy client and the data server database;

a first sending module, where the first sending module is applied to the proxy client, and is configured to send the processing request to the determined data server;

a processing module, the processing module being applied to the determined data server, configured to process data in the database according to the processing request;

a second sending module, where the second sending module is applied to the determined data server, and is configured to send the processing result to the proxy client;

And a third sending module, where the third sending module is applied to the proxy client, and is configured to send the received processing result to the service application.
The apparatus of claim 9, wherein the determining module comprises:

a first determining unit, configured to determine a data server according to a predetermined configuration;

The second determining unit is configured to determine the data server according to the size of the data server load, wherein the proxy client selects the data server with the least load.
The apparatus of claim 10, wherein the determining module further comprises:

The first selection unit is configured to select another data server in a normal running state after the data server terminal determined according to the predetermined configuration is abnormal.
The apparatus of claim 11, wherein the determining module further comprises:

And a second selecting unit, configured to: after the data server determined according to the predetermined configuration returns to normal, reselect the data server determined according to the predetermined configuration as a data server that executes the processing request.
The apparatus of claim 9, wherein the receiving module comprises:

a receiving unit, configured to receive the processing request by using an interface, where the interface includes at least one of: an interface of an entry parameter including information of service data, an interface of an entry parameter database access request, and information of the service data is used Indicates the data that the business application needs to process.
The apparatus of claim 13 wherein the interface is a local interface.
The apparatus of claim 9, wherein the first transmitting module comprises:

a coding unit, configured to encode the processing request into a request message according to a predetermined communication protocol;

And a sending unit, configured to send the request message to the determined data server.
The apparatus of claim 9, wherein the second transmitting module comprises:

And returning to the unit, configured to return the processing result to the proxy client according to a predetermined communication protocol.