CN106570021A - Database connection establishment method and device - Google Patents
Database connection establishment method and device Download PDFInfo
- Publication number
- CN106570021A CN106570021A CN201510651597.0A CN201510651597A CN106570021A CN 106570021 A CN106570021 A CN 106570021A CN 201510651597 A CN201510651597 A CN 201510651597A CN 106570021 A CN106570021 A CN 106570021A
- Authority
- CN
- China
- Prior art keywords
- request
- user
- master library
- connection
- standby storehouse
- 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.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
Abstract
The invention discloses a database connection establishment method and device. The method includes that a proxy server is connected to a primary library of database management systems, and a user is connected to the primary library through the proxy server. The number of the database management systems is at least 2, one of the database management systems is a primary library and a secondary library for the other of the database management systems. When the primary library meets a restart condition and a request of the user is in an idle state, a connection to the primary library is switched into a connection to the secondary library of the primary library. The database connection establishment method and device can effectively relieve influence on the user due to flash of a user connection.
Description
Technical field
The application belongs to technical field of data processing, specifically, is related to a kind of database connection establishment side
Method and device.
Background technology
Data base management system is mainly used in foundation, operation and maintenance database, and database is carried out
Unified management and control, user realizes the access to database by data base management system.
User requires connect to data base administration by access of the data base management system to database
In system, database connects namely refers to the connection with data base management system.
But, after user is connected to data base management system, because of mechanical disorder, number
There is BUG according to base management system, or the reason such as database promotion and demotion, data base management system can
Can need to restart, and data base management system is restarted, the connection of user and data base management system is just
Can disconnect, there is a problem of that user connects flash.And user connection flash can cause one it is unavailable
Time point, cause user's request to be processed so that Consumer's Experience is poor.
The content of the invention
In view of this, technical problems to be solved in this application there is provided a kind of database connection establishment side
Method and system, for solving the problems, such as to affect user because user connects flash.
In order to solve above-mentioned technical problem, this application discloses a kind of database connection establishment method, including：
Proxy server is connected with the master library of data base management system so that user by proxy server with
The master library connection；Wherein, the data base management system at least includes two, each other mutual master library
With standby storehouse；
In the case where the master library meets and restarts condition, the request for waiting the user is in idle condition
When, the connection with the master library is switched to the connection with the standby storehouse of the master library.
Preferably, when the request of the wait user is in idle condition, by the company with the master library
Connect to switch to includes with the connection in the standby storehouse of the master library：
Idle condition is in the request of the user, the master library is obtained same with the standby storehouse of the master library
Step delay situation；
When synchronization delay in the master library and the standby storehouse is less than or equal to first threshold, will be with the master
The connection in storehouse switches to the connection with the standby storehouse.
Preferably, when the request of the user is the request that cannot be processed, methods described also includes：
When the request of the user is the request that cannot be processed, the connection with the master library is disconnected；
It is described to wait the request of the user to include in idle condition：
When the request of the user is in unknown transaction status, from user described in the master library acquisition request
Request transaction status；
In the request of the user request of transaction status or the user is in wait result set
During state, wait the affairs to exit or the request of the user at the end of, determine the user please
Ask in idle condition.
Preferably, the connection by with the master library switch to the connection in the standby storehouse of the master library it
Afterwards, methods described also includes：
When receiving the request of user, the request of the user is hung up；
After waiting the master library consistent with the standby storehouse synchronization, or the request of the user hangs up first
After Preset Time, the request of the user is sent to the standby storehouse, ask the standby storehouse to perform.
Preferably, it is described in the case where the master library meets and restarts condition, wait the request of the user
In idle condition when, the connection with the master library is switched to the connection bag with the standby storehouse of the master library
Include：
Meet in the master library and restart condition, and receive master library described in health detection Programmable detection and institute
In the case of the connection convert requests sent when stating the synchronization delay in standby storehouse less than first threshold, wait described
When the request of user is in idle condition, the connection with the master library is switched to into the company with the standby storehouse
Connect.
Preferably, the connection by with the master library switch to the connection in the standby storehouse of the master library it
Afterwards, methods described also includes：
When receiving the request of the user, the request of the user is hung up；
Send after the master library is consistent with the standby storehouse synchronization when the health detection program is received
Connection release request, or the user request hang up the first Preset Time after, by the user
Request send to the standby storehouse, ask the standby storehouse to perform.
Preferably, in the case where the master library meets and restarts condition, the request for waiting the user is in
During idle condition, the connection with the master library is switched to be included with the connection in the standby storehouse of the master library：
In the case where the master library meets and restarts condition, in preset time range, the user is waited
Request be in idle condition when, by the connection with the master library switch to and for storehouse connection；
If the stand-by period exceeds the preset time range, methods described also includes：
Disconnect the connection with the master library.
A kind of database connection establishment method, including：
After user is connected by proxy server with master library, detect that the master library is standby with the master library
The synchronization delay situation in storehouse；Wherein, the data base management system is mutual each other at least including two
Master library and standby storehouse；
When the master library is less than first threshold with the standby storehouse synchronization delay, send out to the proxy server
Connection handover request is sent, in order to the proxy server when the master library meets and restarts condition, is judged
Whether the request of the user is in idle condition；When waiting the request of the user to be in idle condition,
Connection with the master library is switched to into the connection with the standby storehouse.
Preferably, when the master library is less than first threshold with the standby storehouse synchronization delay, to the agency
Server is sent after connection handover request, and methods described also includes：
By the whole connection cut-outs in the master library；
The master library is set for a reading mode；
The master library it is synchronous with the standby storehouse it is consistent after, it is read-write mode to arrange the standby storehouse, and to
The proxy server sends connection release request, and in order to the proxy server company is being received
After connecing releasing request, the request of the user for hanging up is sent to the standby storehouse, ask the standby storehouse
Perform.
A kind of database connection establishment device, including：
Connection establishment module, for setting up the connection with data base management system master library so that user passes through
Proxy server is connected with master library；Wherein, the data base management system at least includes master library and standby storehouse,
The master library and the standby storehouse standby storehouse mutual each other；
Connection handover module, in the case of meeting and restarting condition in the master library, waits the user
Request be in idle condition when, the connection with the master library is switched to the company with the standby storehouse of the master library
Connect.
Preferably, the connection handover module includes：
Synchronous acquisition module, for being in idle condition in the request of the user, obtain the master library with
The synchronization delay situation in the standby storehouse of the master library；
Connection switching submodule, in the synchronization delay in the master library and the standby storehouse less than or equal to the
During one threshold value, the connection with the master library is switched to into the connection with the standby storehouse.
Preferably, also include：
First flash module, for when the request of the user is the request that cannot be processed, disconnecting and institute
State the connection of master library；
State determining module, for when the request of the user is in unknown transaction status, from the master
The transaction status of the request of user described in the acquisition request of storehouse；The user request in transaction status or
The request of user described in person waits the affairs to exit or the user in when waiting result set state
Request at the end of, determine the user request be in idle condition.
Preferably, also include：
First request suspension module, when receiving the request of user, the request of the user is hung up；
First request processing module, after waiting the master library consistent with the standby storehouse synchronization, or
The request of the user is hung up after the first Preset Time, and the request of the user is sent to described standby
Storehouse, asks the standby storehouse to perform.
Preferably, it is described connection handover module specifically for：
Meet in the master library and restart condition, and receive master library described in health detection Programmable detection and institute
In the case of the connection convert requests sent when stating the synchronization delay in standby storehouse less than first threshold, wait described
When the request of user is in idle condition, the connection with the master library is switched to into the company with the standby storehouse
Connect.
Preferably, also include：
Second request suspension module, for during the request for receiving the user, by the request of the user
Hang up；
Second request processing module, for when receive the health detection program the master library with it is described
Preset for the synchronous consistent connection release request for sending afterwards in storehouse, or the request hang-up first of the user
After time, the request of the user is sent to the standby storehouse, ask the standby storehouse to perform.
Preferably, it is described connection handover module specifically for：The situation for restarting condition is met in the master library
Under, in preset time range, when waiting the request of the user to be in idle condition, will be with the master
The connection in storehouse switches to the connection with the standby storehouse；
Described device also includes：
Second flash module, for the stand-by period exceed the preset time range when, disconnect with it is described
The connection of master library.
A kind of database connection establishment device, including：
State detection module, after being connected with master library by proxy server in user, detection data
The master library of base management system and the synchronization delay situation for storehouse；Wherein, the data base management system is at least
Including two, mutual master library and standby storehouse each other；
Handover trigger module, for when the master library is less than first threshold with the standby storehouse synchronization delay,
Connection handover request is sent to the proxy server, it is full in the master library in order to the proxy server
When lumping weight opens condition, judge the request of the user whether in idle condition；Wait asking for the user
Ask in idle condition when, by the connection with the master library switch to and the standby storehouse connection.
Compared with prior art, the application can be obtained including following technique effect：
Proxy server is set up after being connected with the master library of data base management system so that user is by agency
Server is connected with master library, and when master library meets and restarts condition, proxy server is waiting the request of user
In idle condition when, can by the connection with master library switch to and standby storehouse connection so that user passes through
Proxy server realizes the connection with standby storehouse, even if master library needs to restart, because user passes through agency service
Device is connected with standby storehouse, with normal process user's request, therefore very big impact can will not be caused to user,
Avoid problem caused by user's connection flash.
Certainly, implementing arbitrary product of the application must be not necessarily required to while reaching all the above skill
Art effect.
Description of the drawings
Accompanying drawing described herein is used for providing further understanding of the present application, constitutes of the application
Point, the schematic description and description of the application is used to explain the application, does not constitute to the application's
Improper restriction.In the accompanying drawings：
Fig. 1 is a kind of structural representation of database connection establishment system of the embodiment of the present application；
Fig. 2 is the flow chart of database connection establishment method one embodiment of the embodiment of the present application；
Fig. 3 is the database connection establishment system another kind structural representation of the embodiment of the present application；
Fig. 4 is the flow chart of another embodiment of the database connection establishment method of the embodiment of the present application；
Fig. 5 is the signaling diagram of another embodiment of the database connection establishment method of the embodiment of the present application；
Fig. 6 is the structural representation of database connection establishment device one embodiment of the embodiment of the present application；
Fig. 7 is the structural representation of another embodiment of the database connection establishment device of the embodiment of the present application
Figure；
Fig. 8 is the structural representation of another embodiment of the database connection establishment device of the embodiment of the present application
Figure；
Fig. 9 is the structural representation of another embodiment of the database connection establishment device of the embodiment of the present application
Figure.
Specific embodiment
Presently filed embodiment is described in detail below in conjunction with drawings and Examples, thereby to the application
How application technology means come solve technical problem and reach technology effect realize that process can fully understand
And implement according to this.
The technical scheme that the embodiment of the present application is provided is restarted for solving data base management system, causes user
It is connected the problem of flash with data base management system.
Data base management system is mainly used in foundation, operation and maintenance database, and database is united
One management and control, user realizes the access to database by data base management system.
In a practical application, the invention relates to data base management system may refer to
Relational database management system, such as MySQL, MySQL is saved the data in different tables,
Rather than all data are placed in a big warehouse, which adds speed and improve flexibly
Property.SQL (Structured Query Language, structuralized query language that MySQL is used
Speech) language is the most frequently used standardized language for accessing database.In MySQL, user
Request be all based on sql like language realization, the request of user can include inquiry request, delete
Except and increase etc. update request etc..
User is actual with the connection of data base management system to refer to user side, namely client and data depositary management
The connection of reason system.
As described in the background art, user's connection flash, can cause a disabled time point, make
User request cannot normal process, it is so as to affect Consumer's Experience, such as many for game, video etc.
Media data, user's connection flash, will cause game or video etc. to interrupt so that Consumer's Experience is bad.
Therefore user's connection flash problem, becomes those skilled in the art's technical problem in the urgent need to address.
Inventor has found that user's connection flash is often as data base administration through a series of research
Restarting for system is caused, and data base management system has BUG, machine hardware failure or lifting
The operation of the maintainabilities such as level, may need to restart data base management system, therefore, connect to solve user
Connect the problem of flash, it is proposed that the technical scheme of the application, in the embodiment of the present application, data base administration
System at least includes two, each other mutual master library and standby storehouse, in order to when any one storehouse is broken down,
Substituted by another storehouse.User is connected by proxy server with data base management system, namely user elder generation
It is connected with proxy server, proxy server is again by the authentication information of user, such as user name and password
Send to data base management system etc. information, set up the connection with data base management system, so as to realize using
Family and the connection of data base management system, the request of user is also forwarded to data depositary management via proxy server
Reason system.
A kind of structural representation of the database connection establishment system of the embodiment of the present application application can be such as Fig. 1
Shown in, including proxy server 101, user 102, master library 103 and standby storehouse 104.Agency's clothes
Business device sets up the connection with data base management system master library so that user is connected by proxy server with master library
After connecing, when the master library meets and restarts condition, judge the request of the user whether in idle shape
State；When waiting the request of the user to be in idle condition, will switch to and institute with the connection of the master library
State the connection in the standby storehouse of master library.When master library needs to restart, it is in by request of the proxy server in user
When under idle condition, by the connection with the master library switch to and the standby storehouse connection, realize user with
The connection in standby storehouse, even if so as to master library is restarted, being connected because user sets up with standby storehouse, it is right not result in
The impact of user, and switch over when the request of user is in idle condition, Europe user is not interfered with yet,
Problem caused by so as to solve user's connection flash.
Below in conjunction with accompanying drawing, technical scheme is described in detail.
A kind of stream of database connection establishment method one embodiment that Fig. 2 is provided for the embodiment of the present application
Go out figure, the method can include following step：
201：Proxy server is connected with the master library of data base management system so that user passes through the generation
Reason server is connected with master library.
Wherein, the data base management system at least includes two, each other mutual master library and standby storehouse.
Proxy server is connected with any one data base management system, and any one data base management system is
As current master library, standby storehouse of another data base management system as current master library.
For convenience connection is managed and is controlled, the present embodiment passes through proxy server (Proxy)
Database establishment of connection is realized, user sends user authentication information to proxy server, agency
User authentication information is forwarded to data base management system by server again, with foundation and data base administration
The connection of system.
Proxy server is set up after being connected with master library, that is, realize the connection of user and master library.
202：In the case where the master library meets and restarts condition, the request of the user is waited in sky
During not busy state, the connection with the master library is switched to into the connection with standby storehouse.
Standby storehouse namely refer to the standby storehouse of presently described master library.
In the present embodiment, restarting condition can have the machine hardware failure of BUG, master library including master library
Or master library needs to carry out the operation of the maintainabilities such as promotion and demotion.
Master library meets and restarts after condition, i.e., can be restarted, caused by user's connection flash
Problem.First determine whether the request of user whether in idle condition in the present embodiment.
Idle condition refer to master library current slot do not exist the request of the user for processing or
The request of user described in person is not in affairs.
When the request of user is under busy state, mainly includes in state in affairs or wait result
Collection state.
Affairs refer to the program execution unit that access and may update the data various data item in storehouse, bag
Continuous one group of database manipulation is included, issued transaction is suffered from extensively in various data base management systems
General application, many sync database operations are required for using issued transaction greatly.Such as, in personnel's pipe
In reason system, a personnel are deleted, need the basic document of deletion personnel, also to be deleted and personnel's phase
The information of pass, such as mailbox, article etc., these data base manipulation statements just constitute an affairs.
In MySQL, affairs can be a SQL statement, one group of SQL statement or whole program.
The state in affairs of the request of user, shows in busy state.
Result set refers to and the request of user sent to data base management system, data base management system
Perform feedack after the request of the user.For example, in MySQL, the request of user is
During data inquiry request, MySQL can return the result set of a Query Result to user.
If the request of user is located in waiting result set state, that is, the request for showing user to process
In busy state.
Wherein, in the case where master library meets and restarts condition, it can be determined that whether the request of the user is located
After idle condition, if the request of user is in idle condition, can perform will be with the master library
Connection switch to and operation that the standby storehouse is connected
If the request of the user is under busy state, the request of user can be waited in sky
When under not busy state, then perform the connection with the master library is switched to and the standby storehouse is connected operation.
And wait the request of the user to include following several possible situations in idle condition：
When the request of the user is in unknown transaction status, from user described in the master library acquisition request
Request transaction status；
In the request of the user request of state or the user in affairs is in wait result
During collection state, wait the affairs to exit or the user request process at the end of, determine the use
The request at family is in idle condition.Namely affairs exit cause the request of user to be not in affairs or
At the end of obtaining the request process that result set causes user, then can determine the request of user in idle shape
State,
If proxy server cannot know the request of active user whether in affairs, namely non-county magistrate
During business state, can be with the transaction status of the request of user described in acquisition request, can be by sending one
Ping (Packet Internet Groper, the Internet packets detector) messages are to master library obtaining the user
Request transaction status, determine the request of the user whether in affairs.If at the request of user
The state in affairs, then can wait the affairs to exit, namely wait the request of the user in sky
Not busy state；When the affairs are exited, namely the request of user, when being not in affairs, the request of user is
In idle condition.
Wherein, if user's request is the request that proxy server cannot be processed, such as in MySQL,
Proxy server cannot process the SQL statement do not supported, such as prepare command, use level env
Deng then can directly disconnecting the connection with the master library, i.e. user's connection flash.
In addition, waiting the request of the user in idle condition, time restriction can also be carried out, if
Stand-by period is longer, may there is failure condition, or master library prepares to restart, and has not had abundance
Connection is switched to standby storehouse by the time.Therefore, in the present embodiment, the request of the user is waited in the free time
During state, if the stand-by period is in preset time range, in the request of the user idle condition is in
When, the connection with the master library is switched to into the connection with the standby storehouse；If the stand-by period is beyond described pre-
If time range, the connection with the master library is disconnected.
In by the present embodiment, when the master library of user's connection meets and restarts condition, if at the request of user
In idle condition, or the request of user be in busy state when, the request that can wait user is in
During idle condition, you can so that the connection with the master library to be switched to the connection with the standby storehouse, realize using
Family and the connection for storehouse.So even master library is restarted, also user will not be impacted, it is to avoid user
Problem caused by connection flash.
Wherein, the connection with the master library is switched to into the connection with the standby storehouse, can is by connecting
Realize from the address that standby storehouse is revised as in the address of master library ground connection location.Certainly, when needing to carry out user authentication,
User authentication information can be sent to standby storehouse, after standby storehouse certification passes through, resettle the connection with standby storehouse.
After proxy server is connected with standby storehouse, this becomes current master library for storehouse, such that it is able to continue
Judge whether current master library meets and restart condition.
Due to master library and standby storehouse need to carry out it is real-time synchronous, to ensure uniformity.And simultaneously operating is unavoidable
There is delay situation, if exist synchronization delay it is more serious in the case of, will with the connection of master library switching
To the connection with standby storehouse, may result in subsequent user request cannot normal process, accordingly, as again
One embodiment, after the request for waiting user is in idle condition, obtains the master library standby with described
The synchronization delay situation in storehouse；Synchronization delay in the master library and the standby storehouse is less than or equal to first threshold
When, then the connection with the master library is switched to into the connection with the standby storehouse.
Wherein, the first threshold is more than or equal to 0.
After due to the connection with the master library to be switched to the connection with the standby storehouse, master library can with standby storehouse
Can also there is synchronization delay, it is consistent without Complete Synchronization, if now agency service carry receive user please
When asking, then can be by the request temporary suspension (hang is lived) of user.Wait the master library standby with described
After storehouse is synchronous consistent, then the request of the user is sent to the standby storehouse, ask the standby storehouse to perform.
Wherein, if the request of user is hung up more than the first Preset Time, directly the request of user can be sent
To the standby storehouse, the standby storehouse is asked to perform, without the need for continuing waiting for, in order to avoid cause user's request to process prolong
When.
In the embodiment of the present application, master library can be obtained by proxy server and sentenced with the delay situation in standby storehouse
It is disconnected, and in order to improve detection performance, the workload of proxy server is reduced, health detection can also be passed through
Program, detects to master library with the delay situation in standby storehouse, then will delay situation that detection is obtained send to
Proxy server.The health detection program can be arranged in third party device, it is possible to achieve with agency's clothes
The communication of business device, master library and standby storehouse.
Certainly, health detection program can prolonged with being judged with the delay situation in standby storehouse according to master library
Late situation is met after certain condition, then is triggered proxy server and be attached switching.
Accordingly, as another embodiment, as shown in figure 3, for the database of the embodiment of the present application application
Another kind of structural representation of connection establishment system, including proxy server 101, user 102, master library
103rd, standby storehouse 104 and health detection program 105.
With reference to shown in Fig. 4, to the connection establishment method of the embodiment of the present application, another embodiment is carried out
It is discussed in detail, the method can include following step：
401：Proxy server is connected with the master library of data base management system so that user is by acting on behalf of clothes
Business device is connected with master library.
Wherein, the data base management system at least includes two, each other mutual master library and standby storehouse.
402：Judge whether the master library meets and restart condition, if it is, execution step 403.
If it is not, then proceeding to judge.
403：Judge whether to receive synchronously prolonging for master library described in health detection Programmable detection and the standby storehouse
The connection convert requests sent when late less than first threshold, if it is, execution step 404.
Wherein, proxy server can ask master library described in health detection Programmable detection same with the standby storehouse
Step delay situation.
Health detection program can also master library described in real-time detection and the standby storehouse synchronization delay situation, and
Send when the master library is less than first threshold with the synchronization delay in the standby storehouse and be connected convert requests.
Certainly, as another embodiment, health detection program can also by the master library for detecting with
The synchronization delay situation in the standby storehouse is sent to proxy server, by proxy server determine the master library with
Whether the synchronization delay in the standby storehouse is less than first threshold.
404：Whether the request for judging the user is in idle condition, if it is, execution step 406,
If not, execution step 405.
405：The request for waiting the user is in idle condition.
Waiting the request of the user can include following several possible situations in idle condition：
When the request of the user is in unknown transaction status, from user described in the master library acquisition request
Request transaction status；
In the request of the user request of transaction status or the user is in wait result set
During state, wait the affairs to exit or the request of the user at the end of, determine the user please
Ask in idle condition.
Wherein, if user's request is the request that proxy server cannot be processed, such as in MySQL,
Proxy server cannot process the SQL statement do not supported, such as prepare command, use level env
Deng then can directly disconnecting the connection with the master library, i.e. user's connection flash.
In addition, waiting the request of the user in idle condition, time restriction can also be carried out, if
Stand-by period is longer, may there is handling failure situation, or master library is ready for restarting, without abundance
Time connection is switched to into standby storehouse.Therefore, in the present embodiment, the request of the user is waited in sky
During not busy state, if the stand-by period is in preset time range, in the request of the user idle shape is in
During state, the connection with the master library is switched to into the connection with the standby storehouse；If the stand-by period is beyond described
Preset time range, disconnects the connection with the master library.
406：Connection with the master library is switched to into the connection with the standby storehouse.
407：When receiving the request of the user, the request of the user is hung up.
Connection with the master library is switched to after the connection with the standby storehouse, if receiving asking for user
Ask, you can be performed by standby storehouse.But in order to avoid the process mistake that master library is caused with standby storehouse synchronization delay,
The scheme in the present embodiment can also be adopted, temporarily hangs up the request of user.
408：Receive the health detection program to send out after the master library is consistent with the standby storehouse synchronization
After the connection release request sent, or request first Preset Time of hang-up of the user, by the use
The request at family is sent to the standby storehouse, asks the standby storehouse to perform.
Health detection program can carry out real-time detection to the synchronizing relay of master library and standby storehouse, if master library with
After standby storehouse synchronization is consistent, connection release request, now, agency service can be sent to proxy server
Device can send the request of user to standby storehouse, and the standby storehouse of request performs.
Additionally, the process of the request in order to not delay user, in the request of user the first Preset Time is hung up
Afterwards, it is also possible to directly the request of the user is sent to the standby storehouse, the standby storehouse is asked to perform.
Wherein, the connection with master library is switched to the connection with standby storehouse in proxy server for health detection program
Afterwards, disconnect with the connection of master library to be further ensured that, health detection program can further be cut off
(kill) the whole connections in master library, it is a reading mode (read-only) then to arrange master library；Work as master
Storehouse it is synchronous with standby storehouse it is consistent after, then it is read-write mode (read-write) to arrange standby storehouse, then i.e. can be with
Connection release request is sent to proxy server.Proxy server receive the connection release request it
Afterwards, the request of the user for hanging up is sent to the standby storehouse, asks the standby storehouse to perform.
In addition, after proxy server is connected with standby storehouse, after standby storehouse satisfaction restarts condition, waiting stand-by
When the request at family is in idle condition, you can so that the connection as master library will be switched with the connection in standby storehouse.
As shown in figure 5, database connection establishment method another embodiment provided for the embodiment of the present application
Signaling diagram, the method can include following step：
501：Proxy server sets up the connection with data base management system master library so that user passes through generation
Reason server is connected with the master library.
Wherein, the data base management system at least includes master library and standby storehouse, the master library and the standby storehouse
Standby storehouse mutual each other.
502：Health detection program master library and the synchronization delay situation for storehouse.
503：Health detection program when the master library is less than first threshold with the standby storehouse synchronization delay,
Connection handover request is sent to the proxy server.
504：Proxy server treats asking for the user in the case where the master library meets and restarts condition
Ask in idle condition when, by the connection with the master library switch to and the standby storehouse connection.
505：Proxy server receives the request of the user.
506：The request of the user is hung up.
507：Health detection program when the master library is synchronous with the standby storehouse consistent, to proxy server
Send connection release request.
Wherein, health detection program will switch to standby with described in proxy server with the connection of the master library
After the connection in storehouse, in order to the connection for carrying out ensureing proxy server and master library disconnects, can also carry out as
Lower operation：
By whole connections cut-out (kill) in the master library；
The master library is set for a reading mode (read-only)；
The master library it is synchronous with the standby storehouse it is consistent after, it is read-write mode to arrange the standby storehouse
(read-write), so as to again to proxy server transmission connection release request.
507：Proxy server sends the request of the user to standby storehouse, and the standby storehouse of request performs.
In the embodiment of the present application, data base management system at least includes master library and standby storehouse, by agency service
Device, after realizing the connection of user and data base management system master library, if master library satisfaction restarts condition,
If the now request of user is in idle condition, and master library it is less with the delay in standby storehouse when, then can by with
The connection of master library switches to the connection with standby storehouse, if the request of user is in busy state, can wait
Treat that the request of user switches to the connection with standby storehouse after idle condition, then by the connection with master library.
Master library can be detected with the synchronization delay situation in standby storehouse by proxy server, it is also possible to by health detection
Program is detected, when proxy server receives the connection handover request of health detection program, then shown
Master library is less with the synchronization delay in standby storehouse, when receiving the connection release request of health detection program, then table
Bright master library is synchronized consistent with standby storehouse, and now, receiving the request of user can directly ask standby storehouse
Perform.The request of the user received before master library is consistent with standby storehouse synchronization can temporarily be suspended, until
Master library is synchronous with standby storehouse consistent.
The embodiment of the present application solves the problems, such as that user connects flash, realizes anti-flash function, improves
Consumer's Experience.
A kind of knot of database connection establishment device one embodiment that Fig. 6 is provided for the embodiment of the present application
Structure schematic diagram, the device can be applied particularly to the database connection establishment system as shown in Fig. 1 or Fig. 3
Proxy server in, the device can include：
Connection establishment module 601, for setting up the connection with data base management system master library so that user
It is connected with master library by proxy server.
Wherein, the data base management system at least includes master library and standby storehouse, the master library and the standby storehouse
Standby storehouse mutual each other.
Connection handover module 602, in the case of meeting and restarting condition in the master library, waits described
When the request of user is in idle condition, the connection with the master library is switched to into the company with the standby storehouse
Connect.
Idle condition refers to the request that there is no the user for processing in current slot in standby storehouse.
When the request of user is under busy state, mainly include state or wait result set shape in affairs
State.
Waiting the request of the user can include following several possible situations in idle condition：
When the request of the user is in unknown transaction status, from user described in the master library acquisition request
Request transaction status；
In the request of the user request of transaction status or the user is in wait result set
During state, wait the affairs to exit or the request of the user at the end of, determine the user please
Ask in idle condition.
Wherein, if user's request is the request that proxy server cannot be processed, such as in MySQL,
Proxy server cannot process the SQL statement do not supported, such as prepare command, use level env
Deng then can directly disconnecting the connection with the master library, i.e. user's connection flash.
Accordingly, as another embodiment, as illustrated, the device can also include：
First flash module, for when the request of the user is the request that cannot be processed, disconnecting and institute
State the connection of master library；
State determining module, for when the request of the user is in unknown transaction status, from the master
The transaction status of the request of user described in the acquisition request of storehouse；The user request in transaction status or
The request of user described in person waits the affairs to exit or the user in when waiting result set state
Request at the end of, determine the user request be in idle condition.
In addition, waiting the request of the user in idle condition, time restriction can also be carried out, if
Stand-by period is longer, may there is failure condition, or master library prepares to restart, and has not had abundance
Connection is switched to standby storehouse by the time.
Therefore, the connection handover module can be specifically for：The feelings for restarting condition are met in the master library
Under condition, in preset time range, when waiting the request of the user to be in idle condition, will with it is described
The connection of master library switches to the connection with the standby storehouse；
Then the device can also include：
Second flash module, for the stand-by period exceed the preset time range when, disconnect with it is described
The connection of master library.
Due to master library standby storehouse mutual each other with standby storehouse, master library and standby storehouse need to carry out it is real-time synchronous, with
Ensure uniformity.And simultaneously operating has unavoidably delay situation, if more serious there is synchronization delay
In the case of, the connection with master library is switched to into the connection with standby storehouse, may result in the request of subsequent user
Cannot normal process, accordingly, as another embodiment, as shown in Figure 7, implement with shown in Fig. 6
Example difference is that the connection handover module 602 can include：
Synchronous acquisition module 701, for being in idle condition in the request of the user, obtains the master
Storehouse and the synchronization delay situation for storehouse；
Connection switching submodule 702, be less than for the synchronization delay in the master library and the standby storehouse etc.
When first threshold, the connection with the master library is switched to into the connection with the standby storehouse.
After due to the connection with the master library to be switched to the connection with the standby storehouse, master library can with standby storehouse
Can also there is synchronization delay, it is consistent without Complete Synchronization, if now agency service carry receive user please
When asking, then the request temporary suspension (hang is lived) of user can be treated that the master library is same with the standby storehouse
After step is consistent, the request of the user is sent to the standby storehouse, ask the standby storehouse to perform.Therefore,
As another embodiment, as shown in fig. 7, the device can also include：
First request suspension module 603, for during the request for receiving user, by the request of the user
Hang up；
First request processing module 604, after waiting the master library consistent with the standby storehouse synchronization,
Or the request of the user is hung up after the first Preset Time, and the request of the user is sent to described
Standby storehouse, asks the standby storehouse to perform.
In addition, the delay situation in master library and standby storehouse, can also by health detection program, to master library with it is standby
The delay situation in storehouse carries out detection acquisition, and health detection program can be with according to master library and the delay feelings for storehouse
Condition is judged, after delay situation meets certain condition, then is triggered proxy server and is attached and cut
Change.
Accordingly, as another embodiment, as described in Figure 8, exist with embodiment illustrated in fig. 6 difference
In connecting handover module 602 in the device specifically can be specifically for：
Meet in the master library and restart condition, and receive master library described in health detection Programmable detection and institute
In the case of the connection convert requests sent when stating the synchronization delay in standby storehouse less than first threshold, wait described
When the request of user is in idle condition, the connection with the master library is switched to into the company with the standby storehouse
Connect.
The device can also include：
Second request suspension module 605, for during the request for receiving the user, by the user's
Request is hung up；
Second request processing module 606, for when receive the health detection program the master library with
The connection release request for the synchronous consistent transmission afterwards in storehouse, or the request hang-up first of the user
After Preset Time, the request of the user is sent to the standby storehouse, ask the standby storehouse to perform.
A kind of another embodiment of database connection establishment device that Fig. 9 is provided for the embodiment of the present application
Structural representation, the device can be applied particularly to the health of the database connection establishment system shown in Fig. 3
In detection program, the device can include：
State detection module 901, after being connected with master library by proxy server in user, detection
Data base management system master library and the synchronization delay situation for storehouse；Wherein, the data base management system is extremely
Include master library and standby storehouse, the master library and the standby storehouse standby storehouse mutual each other less；
Handover trigger module 902, for being less than first threshold with the standby storehouse synchronization delay in the master library
When, connection handover request is sent to the proxy server, in order to the proxy server in the master
When storehouse satisfaction restarts condition, judge the request of the user whether in idle condition；Wait the user
Request when being in idle condition, the connection with the master library is switched to and the connection for storehouse.
Additionally, the device can also include：
Connection cut-out module, for will switch to and institute with the connection of the master library in the proxy server
After stating the connection in standby storehouse, by the whole connection cut-outs in the master library；
First mode setup module, for arranging the master library for a reading mode；
Second mode setup module, for after the master library is consistent with the standby storehouse synchronization, arranging institute
It is read-write mode to state standby storehouse, and sends connection release request to the proxy server, in order to the generation
Reason server after the connection release request is received, by hang up the user request send to
The standby storehouse, asks the standby storehouse to perform.
Additionally, the embodiment of the present application additionally provides database connection establishment system, Fig. 1 is specifically may refer to
And the structural representation shown in Fig. 3, will not be described here.
In a typical configuration, computing device include one or more processors (CPU), input/
Output interface, network interface and internal memory.
Internal memory potentially includes the volatile memory in computer-readable medium, random access memory
And/or the form, such as read-only storage (ROM) or flash memory (flash such as Nonvolatile memory (RAM)
RAM).Internal memory is the example of computer-readable medium.
Computer-readable medium includes that permanent and non-permanent, removable and non-removable media can be by
Any method or technique is realizing information Store.Information can be computer-readable instruction, data structure,
The module of program or other data.The example of the storage medium of computer includes, but are not limited to phase transition internal memory
(PRAM), static RAM (SRAM), dynamic random access memory (DRAM),
Other kinds of random access memory (RAM), read-only storage (ROM), electrically erasable
Read-only storage (EEPROM), fast flash memory bank or the read-only storage of other memory techniques, read-only optical disc
Device (CD-ROM), digital versatile disc (DVD) or other optical storages, magnetic cassette tape, magnetic
The storage of band magnetic rigid disk or other magnetic storage apparatus or any other non-transmission medium, can be used for storage can be with
The information being accessed by a computing device.Define according to herein, computer-readable medium does not include non-temporary
The data-signal and carrier wave of computer readable media (transitory media), such as modulation.
As in specification and claim some vocabulary used in censuring specific components.This area skill
Art personnel are, it is to be appreciated that hardware manufacturer may call same component with different nouns.This explanation
Book and claim not in the way of the difference of title is used as distinguishing component, but with component in function
On difference be used as distinguish criterion.Such as " the bag in specification in the whole text and claim mentioned in
Containing " it is an open language, therefore should be construed to " include but be not limited to "." substantially " referring to receive
Error range in, those skilled in the art can solve the technical problem in the range of certain error,
Basically reach the technique effect.Additionally, " coupling " word here is comprising any direct and indirectly electrical
Coupling means.Therefore, if a first device is coupled to a second device described in text, described is represented
One device can directly be electrically coupled to the second device, or by other devices or couple means indirectly
It is electrically coupled to the second device.Specification subsequent descriptions are to implement the better embodiment of the application,
So the description is for the purpose of the rule for illustrating the application, to be not limited to the model of the application
Enclose.The protection domain of the application ought be defined depending on the claims person of defining.
Also, it should be noted that term " including ", "comprising" or its any other variant be intended to it is non-
Exclusiveness is included, so that not only will including those including the commodity or system of a series of key elements
Element, but also including other key elements being not expressly set out, or also include for this commodity or be
The intrinsic key element of system.In the absence of more restrictions, limited by sentence "including a ..."
Key element, it is not excluded that also there is other identical element in the commodity or system including the key element.
Described above illustrates and describes some preferred embodiments of the application, but as it was previously stated, should manage
Solution the application is not limited to form disclosed herein, is not to be taken as the exclusion to other embodiment,
And can be used for various other combinations, modification and environment, and can be in utility model contemplated scope described herein
It is interior, it is modified by the technology or knowledge of above-mentioned teaching or association area.And those skilled in the art are carried out
Change and change without departing from spirit and scope, then all should be in the application claims
In protection domain.
Claims (17)
1. a kind of database connection establishment method, it is characterised in that include：
Proxy server is connected with the master library of data base management system so that user by proxy server with
The master library connection；Wherein, the data base management system at least includes two, each other mutual master library
With standby storehouse；
In the case where the master library meets and restarts condition, the request for waiting the user is in idle condition
When, the connection with the master library is switched to the connection with the standby storehouse of the master library.
2. the method for claim 1, it is characterised in that the request of the wait user
In idle condition when, the connection with the master library is switched to the connection bag with the standby storehouse of the master library
Include：
Idle condition is in the request of the user, the master library is obtained same with the standby storehouse of the master library
Step delay situation；
When synchronization delay in the master library and the standby storehouse is less than or equal to first threshold, will be with the master
The connection in storehouse switches to the connection with the standby storehouse.
3. the method for claim 1, it is characterised in that in the request of the user for cannot
During the request of process, methods described also includes：
When the request of the user is the request that cannot be processed, the connection with the master library is disconnected；
It is described to wait the request of the user to include in idle condition：
When the request of the user is in unknown transaction status, from user described in the master library acquisition request
Request transaction status；
In the request of the user request of transaction status or the user is in wait result set
During state, wait the affairs to exit or the request of the user at the end of, determine the user please
Ask in idle condition.
4. the method as described in any one of claims 1 to 3, it is characterised in that it is described will be with the master
The connection in storehouse is switched to after the connection with the standby storehouse of the master library, and methods described also includes：
When receiving the request of user, the request of the user is hung up；
After waiting the master library consistent with the standby storehouse synchronization, or the request of the user hangs up first
After Preset Time, the request of the user is sent to the standby storehouse, ask the standby storehouse to perform.
5. the method for claim 1, it is characterised in that it is described meet in the master library restart
In the case of condition, when waiting the request of the user to be in idle condition, by the connection with the master library
Switch to includes with the connection in the standby storehouse of the master library：
Meet in the master library and restart condition, and receive master library described in health detection Programmable detection and institute
In the case of the connection convert requests sent when stating the synchronization delay in standby storehouse less than first threshold, wait described
When the request of user is in idle condition, the connection with the master library is switched to into the company with the standby storehouse
Connect.
6. method as claimed in claim 5, it is characterised in that the connection by with the master library
After switching to the connection with the standby storehouse of the master library, methods described also includes：
When receiving the request of the user, the request of the user is hung up；
Send after the master library is consistent with the standby storehouse synchronization when the health detection program is received
Connection release request, or the user request hang up the first Preset Time after, by the user
Request send to the standby storehouse, ask the standby storehouse to perform.
7. the method for claim 1, it is characterised in that meet in the master library and restart condition
In the case of, when waiting the request of the user to be in idle condition, will switch with the connection of the master library
Extremely include with the connection in the standby storehouse of the master library：
In the case where the master library meets and restarts condition, in preset time range, the user is waited
Request when being in idle condition, the connection with the master library is switched to and the connection for storehouse；
If the stand-by period exceeds the preset time range, methods described also includes：
Disconnect the connection with the master library.
8. a kind of database connection establishment method, it is characterised in that include：
After user is connected by proxy server with master library, detect that the master library is standby with the master library
The synchronization delay situation in storehouse；Wherein, the data base management system is mutual each other at least including two
Master library and standby storehouse；
When the master library is less than first threshold with the standby storehouse synchronization delay, send out to the proxy server
Connection handover request is sent, in order to the proxy server when the master library meets and restarts condition, is judged
Whether the request of the user is in idle condition；When waiting the request of the user to be in idle condition,
Connection with the master library is switched to into the connection with the standby storehouse.
9. method as claimed in claim 8, it is characterised in that same with the standby storehouse in the master library
When step postpones less than first threshold, send after connection handover request to the proxy server, the side
Method also includes：
By the whole connection cut-outs in the master library；
The master library is set for a reading mode；
The master library it is synchronous with the standby storehouse it is consistent after, it is read-write mode to arrange the standby storehouse, and to
The proxy server sends connection release request, and in order to the proxy server company is being received
After connecing releasing request, the request of the user for hanging up is sent to the standby storehouse, ask the standby storehouse
Perform.
10. a kind of database connection establishment device, it is characterised in that include：
Connection establishment module, for setting up the connection with data base management system master library so that user passes through
Proxy server is connected with master library；Wherein, the data base management system at least includes master library and standby storehouse,
The master library and the standby storehouse standby storehouse mutual each other；
Connection handover module, in the case of meeting and restarting condition in the master library, waits the user
Request be in idle condition when, the connection with the master library is switched to the company with the standby storehouse of the master library
Connect.
11. devices as claimed in claim 10, it is characterised in that the connection handover module includes：
Synchronous acquisition module, for being in idle condition in the request of the user, obtain the master library with
The synchronization delay situation in the standby storehouse of the master library；
Connection switching submodule, in the synchronization delay in the master library and the standby storehouse less than or equal to the
During one threshold value, the connection with the master library is switched to into the connection with the standby storehouse.
12. devices as claimed in claim 10, it is characterised in that also include：
First flash module, for when the request of the user is the request that cannot be processed, disconnecting and institute
State the connection of master library；
State determining module, for when the request of the user is in unknown transaction status, from the master
The transaction status of the request of user described in the acquisition request of storehouse；The user request in transaction status or
The request of user described in person waits the affairs to exit or the user in when waiting result set state
Request at the end of, determine the user request be in idle condition.
13. devices as described in any one of claim 10～12, it is characterised in that also include：
First request suspension module, when receiving the request of user, the request of the user is hung up；
First request processing module, after waiting the master library consistent with the standby storehouse synchronization, or
The request of the user is hung up after the first Preset Time, and the request of the user is sent to described standby
Storehouse, asks the standby storehouse to perform.
14. devices as claimed in claim 10, it is characterised in that the connection handover module is concrete
For：
Meet in the master library and restart condition, and receive master library described in health detection Programmable detection and institute
In the case of the connection convert requests sent when stating the synchronization delay in standby storehouse less than first threshold, wait described
When the request of user is in idle condition, the connection with the master library is switched to into the company with the standby storehouse
Connect.
15. devices as claimed in claim 14, it is characterised in that also include：
Second request suspension module, for during the request for receiving the user, by the request of the user
Hang up；
Second request processing module, for when receive the health detection program the master library with it is described
Preset for the synchronous consistent connection release request for sending afterwards in storehouse, or the request hang-up first of the user
After time, the request of the user is sent to the standby storehouse, ask the standby storehouse to perform.
16. devices as claimed in claim 10, it is characterised in that the connection handover module is concrete
For：In the case where the master library meets and restarts condition, in preset time range, the use is waited
When the request at family is in idle condition, the connection with the master library is switched to into the connection with the standby storehouse；
Described device also includes：
Second flash module, for the stand-by period exceed the preset time range when, disconnect with it is described
The connection of master library.
17. a kind of database connection establishment devices, it is characterised in that include：
State detection module, after being connected with master library by proxy server in user, detection data
The master library of base management system and the synchronization delay situation for storehouse；Wherein, the data base management system is at least
Including two, mutual master library and standby storehouse each other；
Handover trigger module, for when the master library is less than first threshold with the standby storehouse synchronization delay,
Connection handover request is sent to the proxy server, it is full in the master library in order to the proxy server
When lumping weight opens condition, judge the request of the user whether in idle condition；Wait asking for the user
Ask in idle condition when, by the connection with the master library switch to and the standby storehouse connection.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510651597.0A CN106570021A (en) | 2015-10-10 | 2015-10-10 | Database connection establishment method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510651597.0A CN106570021A (en) | 2015-10-10 | 2015-10-10 | Database connection establishment method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106570021A true CN106570021A (en) | 2017-04-19 |
Family
ID=58507809
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510651597.0A Pending CN106570021A (en) | 2015-10-10 | 2015-10-10 | Database connection establishment method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106570021A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110019257A (en) * | 2017-08-18 | 2019-07-16 | 北京京东尚科信息技术有限公司 | Master/slave data library delay time processing method, device, medium and electronic equipment |
| CN112199440A (en) * | 2020-08-31 | 2021-01-08 | 阿里巴巴集团控股有限公司 | Database control method, database control system, database switching method, electronic equipment and storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1848989A (en) * | 2005-04-04 | 2006-10-18 | 中兴通讯股份有限公司 | System for automatic switching database in imputation position register and method thereof |
| CN101556585A (en) * | 2008-04-08 | 2009-10-14 | 阿里巴巴集团控股有限公司 | Database mode switching method and device |
| CN102968457A (en) * | 2012-10-30 | 2013-03-13 | 北京奇虎科技有限公司 | Switching method and system between databases |
| CN103473328A (en) * | 2013-09-17 | 2013-12-25 | 中电长城网际系统应用有限公司 | MYSQL (my structured query language)-based database cloud and construction method for same |
| CN103716281A (en) * | 2012-09-28 | 2014-04-09 | 联想(北京)有限公司 | Control method, electronic device and server |
-
2015
- 2015-10-10 CN CN201510651597.0A patent/CN106570021A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1848989A (en) * | 2005-04-04 | 2006-10-18 | 中兴通讯股份有限公司 | System for automatic switching database in imputation position register and method thereof |
| CN101556585A (en) * | 2008-04-08 | 2009-10-14 | 阿里巴巴集团控股有限公司 | Database mode switching method and device |
| CN103716281A (en) * | 2012-09-28 | 2014-04-09 | 联想(北京)有限公司 | Control method, electronic device and server |
| CN102968457A (en) * | 2012-10-30 | 2013-03-13 | 北京奇虎科技有限公司 | Switching method and system between databases |
| CN103473328A (en) * | 2013-09-17 | 2013-12-25 | 中电长城网际系统应用有限公司 | MYSQL (my structured query language)-based database cloud and construction method for same |
Non-Patent Citations (2)
| Title |
|---|
| 张长富 李匀: "《PowerBuilder 8参考手册》", 30 April 2002 * |
| 马乐: "《数据库原理及实例教程》", 31 January 2012 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110019257A (en) * | 2017-08-18 | 2019-07-16 | 北京京东尚科信息技术有限公司 | Master/slave data library delay time processing method, device, medium and electronic equipment |
| CN112199440A (en) * | 2020-08-31 | 2021-01-08 | 阿里巴巴集团控股有限公司 | Database control method, database control system, database switching method, electronic equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10187423B2 (en) | Health monitor based distributed denial of service attack mitigation | |
| CN105024855B (en) | Distributed type assemblies manage system and method | |
| CN106599061B (en) | SQLite-based embedded database synchronization method | |
| CN108712501B (en) | Information sending method and device, computing equipment and storage medium | |
| WO2015188579A1 (en) | Distributed virtual firewall apparatus and method, and firewall controller | |
| CN105516266B (en) | A kind of business monitoring method, system and relevant device | |
| JP2009260966A5 (en) | ||
| CN107247793A (en) | The mirror image synchronization method and mirror image synchronization system in Docker mirror images warehouse | |
| WO2018121334A1 (en) | Web application service providing method, apparatus, electronic device and system | |
| CN109495383B (en) | Data processing method, device, communication system and network equipment | |
| CN106844558A (en) | Intelligent answer method and system | |
| WO2017185615A1 (en) | Method for determining service status of service processing device and scheduling device | |
| CN103780428A (en) | Centralized resource management method and system applied to cloud architecture | |
| CN111865632A (en) | Switching method of distributed data storage cluster and switching instruction sending method and device | |
| CN106570021A (en) | Database connection establishment method and device | |
| CN104539462B (en) | It is a kind of to switch to method and device of the calamity for application example | |
| CN105939203B (en) | List item synchronous method and device | |
| CN103810038A (en) | Method and device for transferring virtual machine storage files in HA cluster | |
| WO2019080386A1 (en) | Network service management method and system | |
| CN111427704A (en) | Remote monitoring method, device and equipment for configuration instruction and storage medium | |
| CN116302716A (en) | Cluster deployment method and device, electronic equipment and computer readable medium | |
| CN115640169A (en) | Method, system, device and storage medium for ensuring that a master cluster stops providing services | |
| CN113505011A (en) | Permission synchronization method and device, electronic equipment and storage medium | |
| CN114301763A (en) | Distributed cluster fault processing method and system, electronic device and storage medium | |
| WO2020238057A1 (en) | Redis-based mqtt cluster monitoring method, apparatus, and storage medium |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170419 |