CN107566475A - A kind of session failure transfer method and device - Google Patents
A kind of session failure transfer method and device Download PDFInfo
- Publication number
- CN107566475A CN107566475A CN201710749031.0A CN201710749031A CN107566475A CN 107566475 A CN107566475 A CN 107566475A CN 201710749031 A CN201710749031 A CN 201710749031A CN 107566475 A CN107566475 A CN 107566475A
- Authority
- CN
- China
- Prior art keywords
- database
- session
- node
- service
- established
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Landscapes
- Computer And Data Communications (AREA)
Abstract
The embodiment of the present invention provides a kind of session failure transfer method and device.Methods described includes：A session connection is established, the first database node in the session connection to Cluster Database；If judgement knows that first database node breaks down, then according to the first database service pre-established, by the Session Hand-off to the second database node, wherein described second database node is the normal node in the Cluster Database, first database service pre-established has failure transfer characteristic, and first database service is established according to the Cluster Database.The embodiment of the present invention realizes the real-time forwarding function of failure of session level.
Description
Technical field
The present invention relates to data-base cluster technical field, and in particular to a kind of session failure transfer method and device.
Background technology
Oracle 11G Clustering Grid Infrastructure (abbreviation GI), the bottom as data-base cluster
Technology is realized, by all kinds of resources for effectively managing cluster, it is possible to achieve dynamic IP management, load balancing, failure transfer
System.But for various reasons, the mainly oracle limitations of itself, existing Database Dynamic service is not under default situations
Real-time failure transfer can be provided in session-level, once so some clustered node breaks down, application and trouble can be caused
Occur.
Oracle 11G data-base cluster technology, the database service externally provided in default situations can not be in meetings
Talk about rank and real-time failure transfer is provided, once so some clustered node breaks down, be connected to the several of malfunctioning node
Just no longer responded according to storehouse session, especially for the utility cession using long connection, the generation of application system failure can be caused.Example
Such as, an application software with a Cluster Database when connecting, if some nodes break down in cluster, using soft
Part just breaks down, and can not use.
Therefore, a kind of method how is proposed, session can be transferred to other normal clustered nodes from the node of failure
On, turn into urgent problem to be solved.
The content of the invention
For in the prior art the defects of, the embodiments of the invention provide a kind of session failure transfer method and device.
In a first aspect, the embodiment of the present invention provides a kind of session failure transfer method, including：
A session connection is established, the first database node in the session connection to Cluster Database；
If judgement knows that first database node breaks down, the first database service that basis pre-establishes,
By the Session Hand-off to the second database node, wherein second database node is normal in the Cluster Database
Node, first database service pre-established has failure transfer characteristic, and first database service is root
Established according to the Cluster Database.
Second aspect, the embodiment of the present invention provide a kind of session failure transfer device, including：
Module is established, for establishing a session connection, the first database section in the session connection to Cluster Database
Point；
Shift module, if for judging to know that first database node breaks down, according to the pre-established
One database service, by the Session Hand-off to the second database node, wherein second database node is the cluster
Normal node in database, first database service pre-established have failure transfer characteristic, and described first
Database service is established according to the Cluster Database.
The third aspect, the embodiment of the present invention additionally provide a kind of computer equipment, including memory and processor, the place
Reason device and the memory complete mutual communication by bus；The memory storage has can be by the computing device
Programmed instruction, the processor call described program instruction to be able to carry out following method：
A session connection is established, the first database node in the session connection to Cluster Database；If judgement is known
First database node breaks down, then according to the first database service for pre-establishing, by the Session Hand-off to the
Two database nodes, wherein second database node is the normal node in the Cluster Database, it is described to pre-establish
The first database service there is failure transfer characteristic, and first database service is built according to the Cluster Database
Vertical.
Fourth aspect, the embodiment of the present invention provide a kind of computer-readable recording medium, are stored thereon with computer program,
The method when computer program is executed by processor for storing foregoing computer program.
Session failure transfer method and device provided in an embodiment of the present invention, taken by creating a brand-new database
Business, and particularly distributed rationally, to substitute existing default database service, the failure for realizing session level shifts in real time
Function.
Brief description of the drawings
In order to illustrate more clearly about the embodiment of the present invention or technical scheme of the prior art, below will be to embodiment or existing
There is the required accompanying drawing used in technology description to be briefly described, it should be apparent that, drawings in the following description are this hairs
Some bright embodiments, for those of ordinary skill in the art, on the premise of not paying creative work, can be with root
Other accompanying drawings are obtained according to these accompanying drawings.
Fig. 1 is the schematic flow sheet of session failure transfer method provided in an embodiment of the present invention；
Fig. 2 is the structural representation of the device of session failure provided in an embodiment of the present invention transfer；
Fig. 3 is the structured flowchart of computer equipment provided in an embodiment of the present invention.
Embodiment
To make the purpose, technical scheme and advantage of the embodiment of the present invention clearer, below in conjunction with the embodiment of the present invention
In accompanying drawing, the technical scheme in the embodiment of the present invention is clearly and completely described, it is clear that described embodiment is
Part of the embodiment of the present invention, rather than whole embodiments.Based on the embodiment in the present invention, those of ordinary skill in the art
The every other embodiment obtained under the premise of creative work is not made, belongs to the scope of protection of the invention.
Fig. 1 is the schematic flow sheet of session failure transfer method provided in an embodiment of the present invention, as shown in figure 1, the side
Method includes：
S101, a session connection is established, the first database node in the session connection to Cluster Database；
If S102, judgement know that first database node breaks down, according to the first database pre-established
Service, by the Session Hand-off to the second database node, wherein second database node is in the Cluster Database
Normal node, first database service pre-established has a failure transfer characteristic, and first database takes
Business is established according to the Cluster Database.
, it is necessary to have Cluster Database to support in client running, therefore, it is necessary to client and Cluster Database
In some database node communication, form a session, wherein, Cluster Database includes multiple database nodes, each
The data-base content stored in individual database node is identical, it is understood that to store a data on each computer
Storehouse, and this database is known as a database node.
For example, Cluster Database is deployed to database node 1 and database node 2, client can be with database node 1
Communication, can also be communicated with database node 2, and client communicates with any one database node all forms a meeting
Words.
Cluster Database can give tacit consent to an original database service automatically when configuration, but based on original
Database service, without failure transfer characteristic, therefore, needed in advance in Cluster Database before the embodiment of the present invention is performed
On the basis of establish a new database service, referred to as the first database service, and first database service has
Failure transfer characteristic.
On the premise of the first database service has failure transfer characteristic, server needs first to establish a session company
Connect, and the first database node in the session connection to Cluster Database, and then server has connected to session
First database node is judged that first database node breaks down if finding, according to first database
Service, it will the first database node of connection is transferred to by words can be with trouble-free second database node of proper communication.
The first database node and the second database node being related in embodiments of the present invention are used only to distinguish difference
The database node of state.
Concrete operations are as follows：
When some application software operation of client, it is necessary to remotely access Cluster Database, and it is connected to cluster number
According to Cluster Database overlay node 1 and node 2 in some node, such as the present embodiment in storehouse, it is assumed that what is attached to is section
Point 2, and assume that node 2 is malfunctioning node, node 1 is normal node.
Long-range connection：sqlplus test/test@137.32.78.106:1521/dbservice_TAF
Differentiated by following SQL statement, if be connected to node 2：
Input：select instance_number,instance_name,host_name from v$instance；
Computer returns to the result such as table 1 below, illustrates to be connected to node 2.
Table 1
| INSTANCE_NUMBER | INSTANCE_NAME | HOST_NAME |
| 2 | db2 | host2 |
Now, there occurs failure, session needs to re-connect node 2, at this moment, checks now session status, as follows
It is shown：
Input：select instance_number,instance_name,host_name from v$instance；
Computer returns to the result such as table 2 below, illustrates that session is connected to node 1 from the transfer of node 2.
Table 2
| INSTANCE_NUMBER | INSTANCE_NAME | HOST_NAME |
| 1 | db1 | host1 |
Following SQL statement is inputted, confirms whether session has failure transfer characteristic.
Input：select failover_type,failover_method,failed_over from v$session
Where username='TEST'；
Computer returns to result as shown in table 3 below, illustrates that the first database service has failure transfer characteristic.
Table 3
| FAILOVER_TYPE | FAILOVER_METHOD | FAILED_OVER |
| SELECT | BASIC | YES |
Failure transfer characteristic is had based on the first database service, event occurs in the Cluster Database node of session connection
Barrier, session can be transferred on trouble-free normal node from the node to break down automatically, and for a user, user is made
Client or application software do not have interrupts use because of the failure of database node.
Session failure transfer method provided in an embodiment of the present invention, by creating brand-new database service and distributing rationally
Parameter, the database service of original acquiescence is substituted, when the database node that can currently to connect breaks down, existing number
It will not be failed according to storehouse session, but be connected to other non-faulting nodes in real time, it is achieved thereby that the high availability of database service,
Ensure that upper layer application will not interrupt because of the failure of some node.
Alternatively, it is described pre-establish the first database service the step of include：
Using service management instrument, the first database service is created；
Start first database service；
The first database service configuration parameter is changed, wherein, the configuration parameter comprises at least-q parameter ,-p parameters
With-e parameters, wherein-q parameter be used for configure whether enable high availability perception, and be configured to TRUE represent enable ,-p parameters
For configuring transparent fault transition strategy, it is configured to BASIC and represents to enable mode standard ,-e parameters are used for config failure transfer
Type, it is configured to SELECT and represents that the existing select results of session will not lose because of node failure.
, it is necessary to pre-establish a new database service, new database service can on the basis of above-described embodiment
Be in the database service given tacit consent to originally carry out parameter modification, a new database service can also be re-established,
The embodiment of the present invention is the specific establishment step of i.e. the first database service exemplified by re-establishing a new database service
It is as follows：
First, using service management instrument srvctl increase a new database service dbservice_TAF, i.e., first
Database service, first database service are deployed to two nodes i.e. host1, host2 of cluster, naturally it is also possible to multiple
Node.
This example is set as follows：srvctl add service-d dbservice-s dbservice_TAF-r host1,
host2。
Then, start first database service, allow it to come into force in the cluster.It is as follows：srvctl start
service-d dbservice-s dbservice_TAF。
Then, the configuration parameter of first database service is changed, wherein：- q parameter be used for configure whether enable height can
Known (HA notification) with sexuality, TRUE represents to enable, and FALSE represents not enable；- P parameters are used for configuring transparent fault
Transition strategy TAF (Transparent Application Failover), BASIC represent to enable mode standard, NONE expressions
Do not enable；- e parameters are used for the type of config failure transfer, and SELECT represents that the existing select results of session will not be because of section
Point failure and lose, NONE or SESSION represent other implications.This example is set as follows：srvctl modify service-d
dbservice-s dbservice_TAF-q TRUE-P BASIC-e SELECT。
Session failure transfer method provided in an embodiment of the present invention, by creating brand-new database service and distributing rationally
Parameter, the database service of original acquiescence is substituted, when the database node that can currently to connect breaks down, existing number
It will not be failed according to storehouse session, but be connected to other non-faulting nodes in real time, it is achieved thereby that the high availability of database service,
Ensure that upper layer application will not interrupt because of the failure of some node.
Alternatively, if the judgement knows that first database node breaks down, according to the first number pre-established
Serviced according to storehouse, be specially to the second database node by the Session Hand-off：
If judgement knows that first database node breaks down, and is taken using the first database pre-established
Business, then according to polling dispatching pattern, by the Session Hand-off to the second database node.
On the basis of above-described embodiment, when the first database node for judging session connection breaks down, according to advance
The first database service established, and according to polling dispatching pattern, it will words turn from the first database node to break down
Move on to normal second database node.
For example, clustered deploy(ment) is to node 1, node 2 and node 3, it is assumed that node 2 breaks down, according to polling dispatching pattern,
Can node 2 by session from connection, node 1 can be transferred to, when another session occurs, and node 2 is also there occurs failure,
Session is then transferred to node 3 from node 2.
Session failure transfer method provided in an embodiment of the present invention, by creating brand-new database service and distributing rationally
Parameter, the database service of original acquiescence is substituted, when the database node that can currently to connect breaks down, existing number
It will not be failed according to storehouse session, but be connected to other non-faulting nodes in real time, it is achieved thereby that the high availability of database service,
Ensure that upper layer application will not interrupt because of the failure of some node.
Alternatively, it is described to establish a session connection, in addition to：When establishing a session connection, the session is got
Relevant parameter, the relevant parameter comprise at least session id and database nodename.
On the basis of above-described embodiment, when session connects with database node, server is got and the connection
The related parameter of session, for example, session id and database nodename, can also include application software title, host name etc.,
Wherein session id has unique ID number for each client.
For example, it is the node 2 that session id 1 is connected in original session, due to the failure of node 2, the originally session of session
ID1 is transferred on normal node 1 with regard to failure, and this process does not have any influence for a user, can normally make
Use application software.
Session failure transfer method provided in an embodiment of the present invention, by creating brand-new database service and distributing rationally
Parameter, the database service of original acquiescence is substituted, when the database node that can currently to connect breaks down, existing number
It will not be failed according to storehouse session, but be connected to other non-faulting nodes in real time, it is achieved thereby that the high availability of database service,
Ensure that upper layer application will not interrupt because of the failure of some node.
Fig. 2 is the structural representation of the device of session failure provided in an embodiment of the present invention transfer, as shown in Fig. 2 described
Device includes establishing module 10 and shift module 20, wherein：
Establish module 10 to be used to establish a session connection, the first database section in the session connection to Cluster Database
Point；
If shift module 20 is used to judge to know that first database node breaks down, according to the pre-established
One database service, by the Session Hand-off to the second database node, wherein second database node is the cluster
Normal node in database, first database service pre-established have failure transfer characteristic, and described first
Database service is established according to the Cluster Database.
, it is necessary to have Cluster Database to support in client running, therefore, it is necessary to client and Cluster Database
In some database node communication, form a session.
Cluster Database can give tacit consent to an original database service automatically when configuration, but based on original
Database service, without failure transfer characteristic, therefore, needed in advance in Cluster Database before the embodiment of the present invention is performed
On the basis of establish a new database service, referred to as the first database service, and first database service has
Failure transfer characteristic.
On the premise of the first database service has failure transfer characteristic, establishing module 10 needs first to establish a session
Connection, and the first database node in the session connection to Cluster Database, and then shift module 20 to session
First database node of connection is judged that first database node breaks down if finding, according to described first
Database service, it will the first database node of connection is transferred to by words can be with trouble-free second database of proper communication
Node.
Session failure transfer device provided in an embodiment of the present invention, by creating brand-new database service and distributing rationally
Parameter, the database service of original acquiescence is substituted, when the database node that can currently to connect breaks down, existing number
It will not be failed according to storehouse session, but be connected to other non-faulting nodes in real time, it is achieved thereby that the high availability of database service,
Ensure that upper layer application will not interrupt because of the failure of some node.
Alternatively, it is described pre-establish the first database service the step of include：
Using service management instrument, the first database service is created；
Start first database service；
The first database service configuration parameter is changed, wherein, the configuration parameter comprises at least-q parameter ,-p parameters
With-e parameters, wherein-q parameter be used for configure whether enable high availability perception, and be configured to TRUE represent enable ,-p parameters
For configuring transparent fault transition strategy, it is configured to BASIC and represents to enable mode standard ,-e parameters are used for config failure transfer
Type, it is configured to SELECT and represents that the existing select results of session will not lose because of node failure.
, it is necessary to pre-establish a new database service, i.e. the first database service on the basis of above-described embodiment,
Specific establishment step is as follows：
First, using service management instrument srvctl increase a new database service dbservice_TAF, i.e., first
Database service, first database service are deployed to two nodes i.e. host1, host2 of cluster, naturally it is also possible to multiple
Node.
This example is set as follows：srvctl add service-d dbservice-s dbservice_TAF-r host1,
host2。
Then, start first database service, allow it to come into force in the cluster.It is as follows：srvctl start
service-d dbservice-s dbservice_TAF。
Then, the configuration parameter of first database service is changed, wherein：- q parameter be used for configure whether enable height can
Known (HA notification) with sexuality, TRUE represents to enable, and FALSE represents not enable；- P parameters are used for configuring transparent fault
Transition strategy TAF (Transparent Application Failover), BASIC represent to enable mode standard, NONE expressions
Do not enable；- e parameters are used for the type of config failure transfer, and SELECT represents that the existing select results of session will not be because of section
Point failure and lose, NONE or SESSION represent other implications.This example is set as follows：srvctl modify service-d
dbservice-s dbservice_TAF-q TRUE-P BASIC-e SELECT。
Session failure transfer device provided in an embodiment of the present invention, by creating brand-new database service and distributing rationally
Parameter, the database service of original acquiescence is substituted, when the database node that can currently to connect breaks down, existing number
It will not be failed according to storehouse session, but be connected to other non-faulting nodes in real time, it is achieved thereby that the high availability of database service,
Ensure that upper layer application will not interrupt because of the failure of some node.
Alternatively, the shift module 20 is specially：
If judgement knows that first database node breaks down, and is taken using the first database pre-established
Business, then according to polling dispatching pattern, by the Session Hand-off to the second database node.
On the basis of above-described embodiment, shift module 20 judges that the first database node of session connection breaks down,
According to the first database service pre-established, and according to polling dispatching pattern, it will talk about from the first data to break down
Storehouse node is transferred to normal second database node.
For example, clustered deploy(ment) is to node 1, node 2 and node 3, it is assumed that node 2 breaks down, according to polling dispatching pattern,
Can node 2 by session from connection, node 1 can be transferred to, when another session occurs, and node 2 is also there occurs failure,
Session is then transferred to node 3 from node 2.
Session failure transfer device provided in an embodiment of the present invention, by creating brand-new database service and distributing rationally
Parameter, the database service of original acquiescence is substituted, when the database node that can currently to connect breaks down, existing number
It will not be failed according to storehouse session, but be connected to other non-faulting nodes in real time, it is achieved thereby that the high availability of database service,
Ensure that upper layer application will not interrupt because of the failure of some node.
Alternatively, it is described to establish module 10, in addition to：When establishing a session connection, the correlation of the session is got
Parameter, the relevant parameter comprise at least session id and database nodename.
On the basis of above-described embodiment, when session connects with database node, it is described establish module 10 get with
The related parameter of the session of the connection, for example, session id and database nodename, can also include application software title,
Host name etc..
Session failure transfer device provided in an embodiment of the present invention, by creating brand-new database service and distributing rationally
Parameter, the database service of original acquiescence is substituted, when the database node that can currently to connect breaks down, existing number
It will not be failed according to storehouse session, but be connected to other non-faulting nodes in real time, it is achieved thereby that the high availability of database service,
Ensure that upper layer application will not interrupt because of the failure of some node.
The structured flowchart of Fig. 3 computer equipments provided in an embodiment of the present invention, as shown in figure 3, the computer equipment bag
Include：Processor (processor) 301, memory (memory) 302 and bus 303；
Wherein, the processor 301 and the memory 302 complete mutual communication by the bus 303；
The processor 301 is used to call the programmed instruction in the memory 302, to perform above-mentioned each method embodiment
The method provided, such as including：A session connection is established, the first database section in the session connection to Cluster Database
Point；
If judgement knows that first database node breaks down, the first database service that basis pre-establishes,
By the Session Hand-off to the second database node, wherein second database node is normal in the Cluster Database
Node, first database service pre-established has failure transfer characteristic, and first database service is root
Established according to the Cluster Database.
The embodiment of the present invention discloses a kind of computer program product, and the computer program product is non-transient including being stored in
Computer program on computer-readable recording medium, the computer program include programmed instruction, when described program instructs quilt
When computer performs, computer is able to carry out the method that above-mentioned each method embodiment is provided, such as including：Establish session company
Connect, the first database node in the session connection to Cluster Database；If the first database node hair is known in judgement
Raw failure, then according to the first database service pre-established, by the Session Hand-off to the second database node, wherein described
Second database node is the normal node in the Cluster Database, and first database service pre-established has event
Hinder transfer characteristic, and first database service is established according to the Cluster Database.
The embodiment of the present invention provides a kind of non-transient computer readable storage medium storing program for executing, the non-transient computer readable storage
Medium storing computer instructs, and the computer instruction makes the computer perform the side that above-mentioned each method embodiment is provided
Method, such as including：A session connection is established, the first database node in the session connection to Cluster Database；If judge
Know that first database node breaks down, then according to the first database service pre-established, by the Session Hand-off
To the second database node, wherein second database node is the normal node in the Cluster Database, it is described advance
The first database service established has failure transfer characteristic, and first database service is according to the company-data
What storehouse was established.
One of ordinary skill in the art will appreciate that：Realizing all or part of step of above method embodiment can pass through
Programmed instruction related hardware is completed, and foregoing program can be stored in a computer read/write memory medium, the program
Upon execution, the step of execution includes above method embodiment；And foregoing storage medium includes：ROM, RAM, magnetic disc or light
Disk etc. is various can be with the medium of store program codes.
The embodiments such as the test equipment of display device described above are only schematical, wherein described as separation
The unit of part description can be or may not be it is physically separate, can be as the part that unit is shown or
It can not be physical location, you can with positioned at a place, or can also be distributed on multiple NEs.Can be according to reality
Border needs to select some or all of module therein to realize the purpose of this embodiment scheme.Those of ordinary skill in the art
In the case where not paying performing creative labour, you can to understand and implement.
Through the above description of the embodiments, those skilled in the art can be understood that each embodiment can
Realized by the mode of software plus required general hardware platform, naturally it is also possible to pass through hardware.Based on such understanding, on
The part that technical scheme substantially in other words contributes to prior art is stated to embody in the form of software product, should
Computer software product can store in a computer-readable storage medium, such as ROM/RAM, magnetic disc, CD, including some fingers
Make to cause a computer equipment (can be personal computer, server, or network equipment etc.) to perform each implementation
Method described in some parts of example or embodiment.
Device and system embodiment described above is only schematical, wherein described be used as separating component explanation
Unit can be or may not be physically separate, can be as the part that unit is shown or may not be
Physical location, you can with positioned at a place, or can also be distributed on multiple NEs.Can be according to the actual needs
Some or all of module therein is selected to realize the purpose of this embodiment scheme.Those of ordinary skill in the art are not paying
In the case of performing creative labour, you can to understand and implement.
Claims (10)
- A kind of 1. session failure transfer method, it is characterised in that including：A session connection is established, the first database node in the session connection to Cluster Database；If judgement knows that first database node breaks down, according to the first database service pre-established, by institute Session Hand-off is stated to the second database node, wherein second database node is the normal section in the Cluster Database Point, first database service pre-established has failure transfer characteristic, and first database service is basis What the Cluster Database was established.
- 2. according to the method for claim 1, it is characterised in that it is described pre-establish the first database service the step of wrap Include：Using service management instrument, the first database service is created；Start first database service；The first database service configuration parameter is changed, wherein, the configuration parameter comprises at least-q parameter ,-p parameters and-e Parameter, wherein whether-q parameter is used for configuring enables high availability perception, and is configured to TRUE and represents to enable ,-p parameters are used for Transparent fault transition strategy is configured, BASIC is configured to and represents to enable mode standard ,-e parameters are used for the class of config failure transfer Type, it is configured to SELECT and represents that the existing select results of session will not lose because of node failure.
- 3. according to the method for claim 1, it is characterised in that if the judgement knows that first database node occurs Failure, according to the first database service pre-established, it is specially to the second database node by the Session Hand-off：If judgement knows that first database node breaks down, and using the first database service pre-established, Then according to polling dispatching pattern, by the Session Hand-off to the second database node.
- 4. according to the method for claim 1, it is characterised in that it is described to establish a session connection, in addition to：Establishing for a moment During words connection, the relevant parameter of the session is got, the relevant parameter comprises at least session id and database nodename.
- A kind of 5. session failure transfer device, it is characterised in that including：Module is established, for establishing a session connection, the first database node in the session connection to Cluster Database；Shift module, if for judging to know that first database node breaks down, according to the first number pre-established Serviced according to storehouse, by the Session Hand-off to the second database node, wherein second database node is the company-data Normal node in storehouse, first database service pre-established have failure transfer characteristic, and first data Storehouse service is established according to the Cluster Database.
- 6. device according to claim 5, it is characterised in that it is described pre-establish the first database service the step of wrap Include：Using service management instrument, the first database service is created；Start first database service；The first database service configuration parameter is changed, wherein, the configuration parameter comprises at least-q parameter ,-p parameters and-e Parameter, wherein whether-q parameter is used for configuring enables high availability perception, and is configured to TRUE and represents to enable ,-p parameters are used for Transparent fault transition strategy is configured, BASIC is configured to and represents to enable mode standard ,-e parameters are used for the class of config failure transfer Type, it is configured to SELECT and represents that the existing select results of session will not lose because of node failure.
- 7. device according to claim 5, it is characterised in that the shift module is specially：If judgement knows that first database node breaks down, and using the first database service pre-established, Then according to polling dispatching pattern, by the Session Hand-off to the second database node.
- 8. device according to claim 5, it is characterised in that it is described to establish module, in addition to：Establishing a session connection When, the relevant parameter of the session is got, the relevant parameter comprises at least session id and database nodename.
- 9. a kind of computer equipment, it is characterised in that including memory and processor, the processor and the memory pass through Bus completes mutual communication；The memory storage has can be by the programmed instruction of the computing device, the processor Described program instruction is called to be able to carry out the method as described in Claims 1-4 is any.
- 10. a kind of computer-readable recording medium, is stored thereon with computer program, it is characterised in that the computer program quilt The method as described in Claims 1-4 is any is realized during computing device.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710749031.0A CN107566475B (en) | 2017-08-28 | 2017-08-28 | Session failover method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710749031.0A CN107566475B (en) | 2017-08-28 | 2017-08-28 | Session failover method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107566475A true CN107566475A (en) | 2018-01-09 |
| CN107566475B CN107566475B (en) | 2020-08-04 |
Family
ID=60977355
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710749031.0A Active CN107566475B (en) | 2017-08-28 | 2017-08-28 | Session failover method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107566475B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109586951A (en) * | 2018-11-07 | 2019-04-05 | 北京达佳互联信息技术有限公司 | Implement method, apparatus, electronic equipment and the readable storage medium storing program for executing of failure transfer |
| CN110413472A (en) * | 2018-04-26 | 2019-11-05 | 中移(苏州)软件技术有限公司 | A kind of method and apparatus of cluster management |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103780417A (en) * | 2012-10-23 | 2014-05-07 | 上海盛大网络发展有限公司 | Database failure transfer method based on cloud hard disk and device thereof |
| CN104036043A (en) * | 2014-07-01 | 2014-09-10 | 浪潮(北京)电子信息产业有限公司 | High availability method of MYSQL and managing node |
| CN104794026A (en) * | 2015-04-29 | 2015-07-22 | 上海新炬网络信息技术有限公司 | Cluster instance and multi-data-source binding failover method |
| EP2980707A1 (en) * | 2014-07-31 | 2016-02-03 | Deutsche Telekom AG | Method for creating a database clone of a distributed database, system for creating a database clone of a distributed database, program and computer program product |
-
2017
- 2017-08-28 CN CN201710749031.0A patent/CN107566475B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103780417A (en) * | 2012-10-23 | 2014-05-07 | 上海盛大网络发展有限公司 | Database failure transfer method based on cloud hard disk and device thereof |
| CN104036043A (en) * | 2014-07-01 | 2014-09-10 | 浪潮(北京)电子信息产业有限公司 | High availability method of MYSQL and managing node |
| EP2980707A1 (en) * | 2014-07-31 | 2016-02-03 | Deutsche Telekom AG | Method for creating a database clone of a distributed database, system for creating a database clone of a distributed database, program and computer program product |
| CN104794026A (en) * | 2015-04-29 | 2015-07-22 | 上海新炬网络信息技术有限公司 | Cluster instance and multi-data-source binding failover method |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110413472A (en) * | 2018-04-26 | 2019-11-05 | 中移(苏州)软件技术有限公司 | A kind of method and apparatus of cluster management |
| CN109586951A (en) * | 2018-11-07 | 2019-04-05 | 北京达佳互联信息技术有限公司 | Implement method, apparatus, electronic equipment and the readable storage medium storing program for executing of failure transfer |
| CN109586951B (en) * | 2018-11-07 | 2020-04-17 | 北京达佳互联信息技术有限公司 | Method, device, electronic equipment and readable storage medium for implementing fault transfer |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107566475B (en) | 2020-08-04 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106301876B (en) | Physical machine upgrade method, business migration method and device | |
| CN112671882B (en) | Same-city double-activity system and method based on micro-service | |
| CN108881512B (en) | CTDB virtual IP balance distribution method, device, equipment and medium | |
| CN107231399A (en) | The expansion method and device of High Availabitity server cluster | |
| CN105760214A (en) | Equipment state and resource information monitoring method, related equipment and system | |
| CN102088490B (en) | Data storage method, device and system | |
| WO2019210580A1 (en) | Access request processing method, apparatus, computer device, and storage medium | |
| CN105681077A (en) | Fault processing method, device and system | |
| CN102970379A (en) | Method for realizing load balance among multiple servers | |
| CN106936925A (en) | Load-balancing method and system | |
| CN108023967A (en) | A kind of management equipment in data balancing method, apparatus and distributed memory system | |
| CN109981468A (en) | Link state maintaining method and device | |
| CN110489225A (en) | A kind of service expansion method, device and equipment based on message queue | |
| CN107122229A (en) | A kind of virtual machine restoration methods and device | |
| CN103516918A (en) | Method and device for recovering resource failures | |
| CN109981454A (en) | The broadcast controlling method and device of dynamic routing broadcasting packet | |
| CN109254876A (en) | The management method and device of database in cloud computing system | |
| CN110535924A (en) | A kind of rail traffic server communications method and system | |
| CN107566475A (en) | A kind of session failure transfer method and device | |
| JP2010541100A (en) | How to implement highly available data parallel operations on a computational grid | |
| CN104518995B (en) | Interchanger virtualization system based on distributed structure/architecture | |
| CN106385330A (en) | Network function virtualization composer realization method and device | |
| CN106293911A (en) | Dispatching System, method | |
| CN112448848A (en) | Automatic capacity expansion method based on micro-service | |
| CN114338670B (en) | Edge cloud platform and network-connected traffic three-level cloud control platform with same |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |