WO2016095644A1 - High availability solution method and device for database - Google Patents

Abstract

The present invention relates to the field of computers. Provided in an embodiment of the present invention are a high availability solution method and device for a database, the method comprising: converting an LVS IP address to an IP address of a corresponding database after receiving the LVS IP address transmitted from a client such that a corresponding database driver can search a connection corresponding to the IP address according to the converted IP address of the corresponding database so as to reuse the connection, thus addressing the problem that when the LVS is used in conjunction with the corresponding database, a new connection needs to be established because the database driver cannot search the connection corresponding to the LVS IP address, further effectively reducing performance overhead generated when the client accesses the database, avoiding the problem that when a large number of concurrent requests exist for the corresponding database, service cannot be provided because all service connections are occupied.

Description

Database high availability solution and device Technical field

The present invention relates to the field of computers, and in particular, to a high availability solution and apparatus for a database.

Background technique

MongoDB is a non-relational database (NoSQL) that is very popular in the IT industry. Its flexible data storage method is favored by current IT practitioners. With the rise of the Internet Web2.0 website, NoSQL has set off a boom in China, and the most powerful one is MongoDB. More and more industry companies have put MongoDB into the actual application environment, and many startup teams have used MongoDB as their preferred database to create a lot of mobile Internet applications.

In the current MongoDB database, the client and the database are directly connected. When the client requests a service from the MongoDB database, it directly sends a connection request to the IP address of the corresponding MongoDB database, and obtains the required data after the connection is established.

When the client accesses the MongoDB database for the first time, it establishes a connection for the client and saves the established connection in the connection manager of the MongoDB driver. When the client accesses for the second time, it can be in the connection manager. The saved connections are multiplexed.

However, when the data nodes of the MongoDB database change, the existing connections cannot be reused, and the connection to the data nodes needs to be re-established due to the connection failure, resulting in a large amount of performance consumption and repeated operations. There is currently no effective technology to solve this technical problem.

Summary of the invention

In view of the above problems, the present invention has been made in order to provide a highly available solution and corresponding apparatus for a database that overcomes the above problems or at least partially solves the above problems.

According to an aspect of the present invention, a highly available solution for a database is provided, comprising:

Receiving the IP address and port number of the incoming LVS (Linux Virtual Server) of the client, and parsing the LVS IP address and port number into the IP address and port number of the corresponding database through the LVS;

Detecting, in the connection manager, a connection corresponding to an IP address and a port number of the corresponding database;

When there is a connection corresponding to the IP address and the port number of the corresponding database, returning the connection to the client;

The connection is used by the client to access the corresponding database.

According to another aspect of the present invention, there is also provided a high availability solution for a database, comprising:

The conversion module is adapted to receive the incoming LVS IP address and port number of the client, and parse the LVS IP address and port number into an IP address and a port number of the corresponding database by using the LVS;

a connection management module, configured to detect whether a connection corresponding to an IP address and a port number of the corresponding database exists in the connection manager;

a result returning module adapted to return the connection to the client when there is a connection corresponding to an IP address and a port number of the corresponding database;

The connection is used by the client to access the corresponding database.

The beneficial effects of the invention are:

The embodiment of the present invention provides a high-availability solution and device for a database. After receiving an incoming LVS IP address, the LVS IP address is converted into an IP address of a corresponding database, so that the corresponding database driver can obtain a corresponding response according to the conversion. The IP address of the database is searched for the corresponding connection in the connection manager, and the connection is reused. This solves the problem that when the LVS is combined with the corresponding database, the database driver cannot find the connection corresponding to the LVS IP address and needs to re-establish the connection. The problem, in turn, is very effective in reducing the performance overhead incurred when the client accesses the database, and avoids the problem that the corresponding database cannot provide services due to the full number of concurrent connections when there are a large number of concurrent requests.

According to still another aspect of the present invention, there is provided a computer program comprising computer readable code, when said computer readable code is run on a computing device, causing said computing device to perform a high database as described above A workaround is available.

According to still another aspect of the present invention, a computer readable medium storing the above computer program is provided.

The above description is only an overview of the technical solutions of the present invention, and the above-described and other objects, features and advantages of the present invention can be more clearly understood. Specific embodiments of the invention are set forth below.

DRAWINGS

Various other advantages and benefits will become apparent to those skilled in the art from a The drawings are only for the purpose of illustrating the preferred embodiments and are not to be construed as limiting. Throughout the drawings, the same reference numerals are used to refer to the same parts. In the drawing:

1 is a schematic diagram of an access structure of a client and a database according to an embodiment of the present invention;

2 is a schematic flowchart of a high availability solution method of a MongoDB database according to an embodiment of the present invention;

3 is a detailed architectural diagram of an access system of an existing MongoDB database;

4 is a schematic structural diagram of an improved access system of a MongoDB database according to an embodiment of the present invention;

FIG. 5 is a schematic flowchart of a high availability solution of a MongoDB database according to an embodiment of the present invention; FIG.

FIG. 6 is a schematic structural diagram of a high availability solution device for a database according to an embodiment of the present invention; FIG.

Figure 7 is a schematic block diagram of a computing device for performing a highly available solution for a database in accordance with the present invention;

Fig. 8 schematically shows a storage unit for holding or carrying program code implementing a highly available solution of a database according to the invention.

detailed description

The invention is further described below in conjunction with the drawings and specific embodiments.

Embodiments of the present invention provide a solution for making a database highly available, which can be implemented by establishing a connection control device (also referred to as an intermediate layer) between a client and a database or by improving the connection manager. Wherein, the connection control device can be implemented by a server deployed between the client and the database.

LVS is a virtual server cluster system, in which IP load balancing technology is the most efficient in the implementation of load scheduler. In the present invention, the deployment of the MongoDB database cluster adopts the LVS+MongoDB approach. FIG. 1 is a schematic diagram of an access structure of a client and a database provided by the present invention.

It should be understood that the present invention does not limit the type of database, as long as a database to which the following scheme of the present invention can be applied to achieve high availability is applicable. In addition, the connection control device is not limited to being implemented by a server, and those skilled in the art may implement the connection control device in other manners on the basis of reading the present invention, which are all included in the scope of the present invention. .

Hereinafter, the technical solution of the present invention will be described by taking the MongoDB database as an example:

Embodiment 1

The embodiment of the invention provides a high availability solution of the MongoDB database. It can be improved by the connection manager, so that the IP address of the LVS can also reuse the existing connection in the connection manager, so that the access system of the MongoDB database is highly available.

FIG. 2 is a flowchart of a high availability solution of a MongoDB database provided by this embodiment. The method specifically includes steps S202 to S206.

S202: Receive the LVS IP address and port number of the incoming client, and resolve the LVS IP address and port number to the MongoDB IP address and port number through the LVS.

S204: Detect whether there is a connection corresponding to the MongoDB IP address and port number in the connection manager.

S206: When there is a connection corresponding to the MongoDB IP address and port number, the connection is returned to the client.

Among them, the connection is used for the client to connect to the MongoDB database.

The embodiment of the present invention provides a high-availability solution for the MongoDB database. After receiving the incoming LVS IP address of the client, the LVS IP address is converted into a corresponding MongoDB IP address, so that the MongDB driver can obtain the MongoDB IP according to the conversion. The address in the connection manager finds the corresponding connection, and then multiplexes the connection, which solves the problem that when the LVS is combined with the MongoDB database, the MongDB driver cannot find the connection corresponding to the LVS IP address and needs to re-establish the connection. It effectively reduces the performance overhead incurred when the client accesses the MongoDB database, and avoids the problem that the MongoDB database cannot have a full number of concurrent requests due to the full number of MongoDB service connections.

Embodiment 2

This embodiment is a specific application scenario of the foregoing first embodiment. Through the embodiment, the method provided by the present invention can be more clearly and specifically illustrated.

In order to explain the improvement of the present invention more clearly, before explaining the present embodiment, the architecture of the access system of the existing MongoDB database will be first described. Figure 3 shows the detailed architecture of the access system of the existing MongoDB database, including:

Client, LVS, MongoDB driver and MongoDB database.

The following describes the client, LVS, MongoDB driver and MongoDB database.

The client is the device that initiates access to the MongoDB database, and can be a client or other terminal with front-end services.

For example, when an APP built in the user's mobile phone needs to retrieve background data, an access request may be initiated to the MongoDB database;

Or, when the user conducts a network game, the server of the online game needs to retrieve data of multiple users in the MongoDB database.

LVS is a virtual server cluster system, which can be responsible for load balancing of cluster servers of MongoDB database. It can allocate access requests from different clients to different nodes in the cluster server of MongoDB database, so that some of the cluster servers in MongoDB database A node does not crash due to excessive load.

The MongoDB driver is responsible for establishing a connection between the client and the nodes in the cluster server of the MongoDB database, and saving the available connections for reuse when the client accesses the MongoDB database again. Among them, the MongoDB driver includes a connection manager for saving the established connection.

It should be noted that when the MongoDB driver saves the connection in the connection manager, it is saved according to the correspondence between the IP address of the node in the cluster server of the MongoDB database (hereinafter referred to as MongoDB IP address) and the connection.

The MongoDB database is a relational database that can be used to store more complex data types. In this embodiment, the MongoDB database can be deployed on a server or deployed on a cluster server. Each server used to deploy the MongoDB database can be considered as a database node.

However, since the LVS is used in the access system of the MongoDB database shown in FIG. 3, after receiving the access request from the client, the LVS transmits the LVS IP address to the MongoDB driver, and the MongoDB IP address is saved in the connection manager. Correspondence with the connection, so for this client, even if the connection is saved in the connection manager, the connection cannot be found and reused because the LVS IP cannot be recognized. Therefore, the MongoDB driver needs to re-establish the connection for the client. In the access system of the MongoDB database, it takes a lot of computing resources to establish a connection each time. When the concurrent access to the MongoDB database is too high, it may cause the MongoDB service. The problem is that the connection is full and the service cannot be provided.

In order to solve the above problem, the embodiment of the present invention provides a solution, as shown in FIG. 4, which is an architecture diagram of an improved access system of the MongoDB database provided by the embodiment of the present invention, between the client and the MongoDB database. By adding a conversion module, you can use the connection in the Multiplex Connection Manager by converting the incoming LVS IP address to the MongoDB IP address. Therefore, the calculation amount of the access system of the MongoDB database is greatly reduced, and the downtime caused by concurrency is avoided to the utmost extent. Those skilled in the art will appreciate that the conversion module can be driven independently of MongoDB or reside in a MongoDB driver. Further, if the conversion module resides in the MongoDB driver, it can also be independent of the connection manager or in the connection manager. Although the conversion module shown in FIG. 4 is located in the MongoDB driver and is independent of the connection manager, the invention is not limited thereto.

In order to more clearly illustrate the present invention, the following is a detailed description of a method for a client to access a MongoDB database under the improved access framework of the MongoDB database.

FIG. 5 is a flowchart of a high-availability solution specific method of a MongoDB database according to an embodiment of the present invention. The method is applicable to the apparatus shown in FIG. 4, and the method includes steps S501 to S506.

First, in step S501, the client initiates an access request to the MongoDB database through the LVS.

Among them, the access request for the MongoDB database can be a request for a service that can be provided by any MongoDB database.

E.g:

When the client is a browser, the user may log in to the website corresponding to the network storage, initiate a query or download a request for personal data;

When the client is a game program, it is possible to obtain the attribute information, the number of battles, etc. of the character of the user in the game. Upon request.

Specifically, when the client initiates an access request to the MongoDB database through the LVS, the LVS is responsible for performing a load balancing operation, and shifting the user's request to its assigned LVS IP address and port number.

After receiving the user's access request to the MongoDB database, the LVS forwards the request of the user to the corresponding LVS IP address and port number, and performs step S502 to drive the access request carrying the LVS IP address and port number to the MongoDB driver.

Wherein, when the client establishes a connection with the node of the cluster server of the MongoDB database, the IP address and the port number are two necessary elements, and in addition, the user name, password, and the like associated with the access request may be included.

After receiving the incoming LVS IP address, the MongoDB driver performs step S503, and MongoDB converts the above LVS IP address and port number into a MongoDB IP address and port number through LVS.

The operation performed in this step S503 is completed by the conversion module shown in FIG. 4. In the prior art, when the LVS IP address is passed into the MongoDB driver, the MongoDB driver cannot query the connection according to the connection manager, and a new connection is established for the request for the LVS IP address. A new connection establishment process.

In the embodiment of the present invention, the correspondence between the LVS IP address and the MongoDB IP address is stored in the LVS. Therefore, the conversion module can resolve the LVS IP address to the MongoDB IP address through the LVS.

After the conversion of the MongoDB IP address and the port number corresponding to the LVS IP address and the port number, step S504 is executed, and the MongoDB driver detects whether the connection corresponding to the MongoDB IP address and port number is stored in the connection manager.

If the connection corresponding to the MongoDB IP address and port number is stored in the connection manager, step S505 is executed to return the connection to the client, and the client performs read and write operations according to the connection.

If the connection corresponding to the MongoDB IP address and port number is not stored in the connection manager, step S506 is executed to initiate a process of establishing a new connection for the incoming LVS IP address and port number.

The method for establishing a new connection for the incoming LVS IP address and port number may include the following steps:

(1) Create a first connection corresponding to the incoming LVS IP address, port number, and register the first connection in the connection manager.

(2) Check if the incoming LVS IP address matches the IP address of MongoDB.

The method for detecting whether the incoming LVS IP address matches the IP address of MongoDB may be:

Obtain the IP addresses of all the nodes in MongoDB, and determine whether the incoming LVS IP address is in it. If not, it means no match.

In this embodiment, since the incoming LVS IP address does not match, step (3) can be performed at this time.

(3) Delete the first connection created above.

(4) Obtain the IP address and port number of all available data nodes in MongoDB.

(5) Detecting whether there is a connection in the connection manager corresponding to the IP address and port number of the above-mentioned available data node.

In this embodiment, if there is a corresponding connection, the connection is returned to the client, and if not, step (6) is performed.

(6) Create a second connection corresponding to the IP address and port number of each available data node, and register the second connection in the connection manager.

(7) Returning the second connection corresponding to the client service to the client according to the preset condition.

Wherein, since the database generally adopts a master-slave structure, the step (7) can be performed as follows:

When the client service is a data write operation or a data modification operation, returning a second connection corresponding to the primary data node to the client;

When the client service is a data read operation, a second connection corresponding to the primary data node or from the data node is returned to the client according to the read priority policy.

After the new connection is established for the MongoDB IP address and the port number in the step S506, the method may further include the following steps:

The new connection (ie, the second connection in the above steps) is saved to the connection manager for reuse by the client next time.

Further, during the use of the MongoDB database, a node in the cluster server is unusable due to a machine failure, etc., which affects the multiplexing of connections in the connection manager, and therefore returns the connection to the client. After the end, the method further includes:

Testing whether a data node in the connection is available;

If the connection is ok, establish a connection between the client and the data node;

If the connection is not available, the data node is added to the blacklist and the connection manager re-establishes a new connection for the client.

Wherein, when the data node in the test connection is available, the method of pinging the data node may be used to observe whether the data is returned normally.

Further, if the data node resumes the available state, it is removed from the blacklist.

The embodiment of the present invention provides a high-availability solution for the MongoDB database. After receiving the incoming LVS IP address of the client, the LVS IP address is converted into a corresponding MongoDB IP address, so that the MongDB driver can obtain the MongoDB IP according to the conversion. The address in the connection manager finds the corresponding connection, and then reuses the connection, which solves the problem that the MongDB driver cannot find the LVS IP when the LVS is combined with the MongoDB database. The connection corresponding to the address needs to re-establish the connection problem, which effectively reduces the performance overhead incurred when the client accesses the MongoDB database, and avoids the large number of concurrent requests of the MongoDB database. Service problem.

Embodiment 3

FIG. 6 is a structural block diagram of a high availability solution device for a database according to an embodiment of the present invention. The device 600 includes:

The conversion module 610 is adapted to receive an incoming LVS IP address and a port number of the client, and parse the LVS IP address and the port number into an IP address and a port number of the corresponding database by using a Linux virtual server LVS;

The connection management module 620 is configured to detect whether a connection corresponding to an IP address and a port number of the corresponding database exists in the connection manager.

The result returning module 630 is adapted to return the connection to the client when there is a connection corresponding to the IP address and the port number of the corresponding database;

The above connection is used for the client to access the corresponding database.

Optionally, the apparatus 600 further includes:

The first creating module 640 is configured to: when there is no connection corresponding to the IP address and the port number of the corresponding database, create a first connection corresponding to the LVS IP address and the port number, and register the first connection in the connection manager. .

Optionally, the device further includes an address matching module 650, where the address matching module specifically includes:

The determining unit 651 is adapted to determine whether the LVS IP address matches the IP address of the corresponding database after establishing the first connection corresponding to the LVS IP address and the port number in the connection manager;

The deleting unit 652 is configured to delete the first connection after the determining unit 651 determines that the matching is not performed.

Optionally, the device further includes a second creating module 660, where the second creating module 660 includes:

The obtaining unit 661 is configured to obtain an IP address and a port number of all available data nodes in the corresponding database after determining that the incoming LVS IP address does not match the IP address of the corresponding database;

The detecting unit 662 is adapted to detect whether there is a connection in the connection manager corresponding to an IP address and a port number of the available data node;

The creating unit 663 is adapted to, when not present, create a second connection corresponding to an IP address and a port number of each of the available data nodes, and register the second connection in the connection manager;

Optionally, the second creating module 660 further includes:

The returning unit 664 is adapted to return the second connection corresponding to the client service to the client according to the preset condition.

Optionally, the database is a master-slave structure, and the returning unit 664 is adapted to return the second connection corresponding to the client service to the client in the following manner:

When the client service is a data write operation or a data modification operation, returning a second connection corresponding to the primary data node to the client;

When the client service is a data read operation, the second connection corresponding to the primary data node or from the data node is returned to the client according to the read priority policy.

Optionally, the device 600 further includes a test module 670, the test module 670 includes:

The testing unit 671 is adapted to test whether the returned data node corresponding to the second connection is available after returning the second connection corresponding to the client service to the client according to the preset condition;

The recording unit 672 is adapted to add the data node to the preset blacklist when the data node is unavailable.

It should be understood by those skilled in the art that the foregoing apparatus 600 can apply/execute various methods described herein, and specific details thereof are not described herein.

According to any one of the preferred embodiments or the combination of the preferred embodiments, the embodiment of the present invention can achieve the following beneficial effects:

The embodiment of the present invention provides a high-availability solution for a database. After receiving an incoming LVS IP address, the LVS IP address is converted into an IP address of a corresponding database, so that the corresponding database driver can be converted according to the corresponding database. The IP address finds the corresponding connection in the connection manager, and then multiplexes the connection, which solves the problem that when the LVS is combined with the corresponding database, the database driver cannot find the connection corresponding to the LVS IP address and needs to re-establish the connection. In addition, the performance overhead incurred when the client accesses the database is effectively reduced, and the problem that the corresponding database cannot provide the service due to the full number of concurrent connections is avoided.

In the description provided herein, numerous specific details are set forth. However, it is understood that the embodiments of the invention may be practiced without these specific details. In some instances, well-known methods, structures, and techniques are not shown in detail so as not to obscure the understanding of the description.

Similarly, the various features of the invention are sometimes grouped together into a single embodiment, in the above description of the exemplary embodiments of the invention, Figure, or a description of it. However, the method disclosed is not to be interpreted as reflecting the intention that the claimed invention requires more features than those recited in the claims. Rather, as the following claims reflect, inventive aspects reside in less than all features of the single embodiments disclosed herein. Therefore, the claims following the specific embodiments are hereby explicitly incorporated into the embodiments, and each of the claims as a separate embodiment of the invention.

Those skilled in the art will appreciate that the modules in the devices of the embodiments can be adaptively changed and placed in one or more devices different from the embodiment. The modules or units or components in the embodiments may be combined into one module or unit or component, and further, they may be divided into multiple sub-modules or sub-units. Or subcomponents. In addition to such features and/or at least some of the processes or units being mutually exclusive, any combination of the features disclosed in the specification, including the accompanying claims, the abstract and the drawings, and any methods so disclosed, or All processes or units of the device are combined. Each feature disclosed in this specification (including the accompanying claims, the abstract and the drawings) may be replaced by alternative features that provide the same, equivalent or similar purpose.

In addition, those skilled in the art will appreciate that, although some embodiments described herein include certain features that are included in other embodiments and not in other features, combinations of features of different embodiments are intended to be within the scope of the present invention. Different embodiments are formed and formed. For example, in the following claims, any one of the claimed embodiments can be used in any combination.

The various component embodiments of the present invention may be implemented in hardware, or in a software module running on one or more processors, or in a combination thereof. Those skilled in the art will appreciate that some or all of the functionality of some or all of the high availability resolution devices of the database in accordance with embodiments of the present invention may be implemented in practice using a microprocessor or digital signal processor (DSP). The invention can also be implemented as a device or device program (e.g., a computer program and a computer program product) for performing some or all of the methods described herein. Such a program implementing the invention may be stored on a computer readable medium or may be in the form of one or more signals. Such signals may be downloaded from an Internet website, provided on a carrier signal, or provided in any other form.

For example, Figure 7 illustrates a computing device that can implement a highly available solution for a database. The computing device traditionally includes a computer program product or computer readable medium in the form of a processor 710 and a memory 720. Memory 720 can be an electronic memory such as a flash memory, EEPROM (Electrically Erasable Programmable Read Only Memory), EPROM, hard disk, or ROM. Memory 720 has a storage space 730 that stores program code 731 for performing any of the method steps described above. For example, storage space 730 storing program code may include various program code 731 for implementing various steps in the above methods, respectively. The program code can be read from or written to one or more computer program products. These computer program products include program code carriers such as hard disks, compact disks (CDs), memory cards or floppy disks. Such a computer program product is typically a portable or fixed storage unit such as that shown in FIG. The storage unit may have storage segments, storage spaces, and the like that are similarly arranged to memory 720 in the computing device of FIG. The program code can be compressed, for example, in an appropriate form. Typically, the storage unit includes computer readable code 731' for performing the method steps of the present invention, ie, code that can be read by a processor, such as 710, that when executed by the computing device causes the computing device to execute Each of the steps in the method described above.

"an embodiment," or "an embodiment," or "an embodiment," In addition, Please note that the examples of the words "in one embodiment" are not necessarily all referring to the same embodiment.

It is to be noted that the above-described embodiments are illustrative of the invention and are not intended to be limiting, and that the invention may be devised without departing from the scope of the appended claims. In the claims, any reference signs placed between parentheses shall not be construed as a limitation. The word "comprising" does not exclude the presence of the elements or steps that are not recited in the claims. The word "a" or "an" The invention can be implemented by means of hardware comprising several distinct elements and by means of a suitably programmed computer. In the unit claims enumerating several means, several of these means can be embodied by the same hardware item. The use of the words first, second, and third does not indicate any order. These words can be interpreted as names.

In addition, it should be noted that the language used in the specification has been selected for the purpose of readability and teaching, and is not intended to be construed or limited. Therefore, many modifications and changes will be apparent to those skilled in the art without departing from the scope of the invention. The disclosure of the present invention is intended to be illustrative, and not restrictive, and the scope of the invention is defined by the appended claims.

Claims (16)

A highly available solution for databases, including: Receiving the LVS IP address and port number of the incoming client, and parsing the LVS IP address and port number into the IP address and port number of the corresponding database through the Linux virtual server LVS; Detecting, in the connection manager, a connection corresponding to an IP address and a port number of the corresponding database; When there is a connection corresponding to the IP address and the port number of the corresponding database, returning the connection to the client; The connection is used by the client to access the corresponding database. The method of claim 1, wherein when there is no connection corresponding to an IP address and a port number of the corresponding database, the method further comprises: Creating a first connection corresponding to the LVS IP address, port number, and registering the first connection in the connection manager. The method of claim 2, wherein after the first connection corresponding to the LVS IP address and port number is established in the connection manager, the method further comprises: Determining whether the LVS IP address matches an IP address of the corresponding database; When it is determined that there is no match, the first connection is deleted. The method of claim 3, wherein after determining that the LVS IP address does not match the IP address of the corresponding database, the method further comprises: Obtaining an IP address and a port number of all available data nodes in the corresponding database; Detecting, in the connection manager, whether a connection corresponding to an IP address and a port number of the available data node exists; When not present, a second connection corresponding to the IP address, port number of each of the available data nodes is created, and the second connection is registered in the connection manager. The method of claim 4 wherein the method further comprises: Returning the second connection corresponding to the client service to the client according to a preset condition. The method of claim 5, wherein the database is a master-slave structure, and the step of returning the second connection corresponding to the client service to the client according to a preset condition further comprises : When the client service is a data write operation or a data modification operation, returning a second connection corresponding to the primary data node to the client; and When the client service is a data read operation, a second connection corresponding to the primary data node or from the data node is returned to the client according to the read priority policy. The method according to claim 5 or 6, wherein, after the second connection corresponding to the client service is returned to the client according to a preset condition, the method further comprises: Testing whether the returned data node corresponding to the second connection is available; If the data node is unavailable, the data node is added to a preset blacklist. A highly available solution for a database, including: The conversion module is adapted to receive the incoming LVS IP address and port number of the client, and parse the LVS IP address and port number into an IP address and a port number of the corresponding database by using the LVS; a connection management module, configured to detect whether a connection corresponding to an IP address and a port number of the corresponding database exists in the connection manager; a result returning module adapted to return the connection to the client when there is a connection corresponding to an IP address and a port number of the corresponding database; The connection is used by the client to access the corresponding database. The apparatus of claim 8 wherein said apparatus further comprises: a first creating module, configured to: when there is no connection corresponding to the IP address and the port number of the corresponding database, create a first connection corresponding to the LVS IP address and the port number, and register the first connection In the connection manager. The device of claim 9, wherein the device further comprises an address matching module, the address matching module comprising: a determining unit, configured to determine whether the LVS IP address matches an IP address of the corresponding database after establishing a first connection corresponding to the LVS IP address and a port number in the connection manager; And a deleting unit, configured to delete the first connection after the determining unit determines that the matching is not performed. The device of claim 10, wherein the device further comprises a second creation module, the second creation module comprising: An obtaining unit, configured to acquire an IP address and a port number of all available data nodes in the corresponding database after determining that the LVS IP address does not match the IP address of the corresponding database; a detecting unit, configured to detect whether a connection corresponding to an IP address and a port number of the available data node exists in the connection manager; And a creating unit adapted to, when not present, create a second connection corresponding to an IP address and a port number of each of the available data nodes, and register the second connection in the connection manager. The apparatus of claim 11, wherein the second creation module further comprises: And returning, the unit is adapted to return the second connection corresponding to the client service to the client according to a preset condition. The apparatus according to claim 12, wherein said database is a master-slave structure, and said returning unit is adapted to return said second connection corresponding to said client service to said client in a manner as follows : When the client service is a data write operation or a data modification operation, returning a second connection corresponding to the primary data node to the client; and When the client service is a data read operation, a second connection corresponding to the primary data node or from the data node is returned to the client according to the read priority policy. The device of claim 12 or 13, wherein the device further comprises a test module, the test module comprising: a test unit, configured to test whether the returned data node corresponding to the second connection is available after returning the second connection corresponding to the client service to the client according to a preset condition; And a recording unit, configured to add the data node to a preset blacklist when the data node is unavailable. A computer program comprising computer readable code, when said computer readable code is run on a computing device, causing said computing device to perform a high availability solution of the database of any one of claims 1 to 7. A computer readable medium storing the computer program of claim 15.

Images