CN106202075A - A kind of method and device of data base's active-standby switch - Google Patents
A kind of method and device of data base's active-standby switch Download PDFInfo
- Publication number
- CN106202075A CN106202075A CN201510213694.1A CN201510213694A CN106202075A CN 106202075 A CN106202075 A CN 106202075A CN 201510213694 A CN201510213694 A CN 201510213694A CN 106202075 A CN106202075 A CN 106202075A
- Authority
- CN
- China
- Prior art keywords
- data base
- data
- current
- standby
- base
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Hardware Redundancy (AREA)
- Mobile Radio Communication Systems (AREA)
Abstract
The embodiment provides the method and device of a kind of data base's active-standby switch, including: monitor the operation of the first data base as current MDL, when described first data base's operation exception being detected, send for cutting main request to the second data base as current standby data base;Obtain when described second data base detects the data consistent in described second data base and described first data base, described second data base's successful switch is the feedback data reported during current MDL, obtains described second data base finally from the data exchange information of described first database synchronization according to described feedback data;Send, to described first data base, the master comprising described data exchange information and cut standby request, make described first database root according to described data exchange information judge to be synchronized to the data of described second data base there is not loss of data time, switch to current standby data base.
Description
Technical field
The present invention relates to database field, particularly to the method and device of a kind of data base's active-standby switch.
Background technology
In present-day data storehouse is applied, database concurrency degree is high, data growth rate is current database sector soon
Business two major features.At short notice, it is understood that there may be mass data is newly-increased or revises.Along with data bulk level is passed
Increase, from byte, kilobytes, Mbytes till now ten thousand Mbytes, in conjunction with the good spy extending transversely of data base
Property, distributed data base based on data base is widely used.Simultaneously in order to improve data base's disaster tolerance
Property, each database provider all proposes corresponding strategy, wherein leader follower replication strategy, and its core concept is main
Data base externally provides service, reads MDL from data base at set intervals and runs generated binary system
Daily record, and perform relevant action in binary log, thus ensure master-slave database data consistent.Work as data
There is the machine of delaying in storehouse main frame, and needs recover application within a short period of time, it is necessary to use and serve as master data from machine
How storehouse (i.e. active-standby switch), judge from machine data base the most consistent with host data database data, how relatively
In short time, slave database data recovery is become consistent, become a technical barrier of industry.
Leader follower replication is standby host duplicate host binary log, writes daily record time delay and network lead to owing to there is main frame
The factors such as news time delay, therefore certainly exist the nonsynchronous phenomenon of active and standby daily record.And current industry does not has yet automatically
Change the instrument comparing data base's standby machine data consistency, can only understand main by manually performing database statement
Whether standby host data are consistent, especially can only be by checking data base when main frame is delayed machine and needed to do active-standby switch
Binary log can determine active and standby binary log difference condition, manually corresponding daily record is extracted from main frame
Out, it is reduced into associated databases statement and is inserted into standby host execution, the data syn-chronization of standby machine can be realized.
This process is the most loaded down with trivial details, and cost of labor is higher, response speed is slow, error rate is high.
Summary of the invention
The invention provides the method and device of a kind of data base's active-standby switch, its purpose is to solve data
Storehouse active-standby switch process is loaded down with trivial details, and the problem that cost of labor is higher, response speed is slow, error rate is high.
In order to achieve the above object, a kind of method that The embodiment provides data base's active-standby switch,
It is applied to manage server, including:
Monitor the operation of the first data base as current MDL, when described first data base's fortune being detected
When row is abnormal, send for cutting main request to the second data base as current standby data base;
Obtain when described second data base detects the data in described second data base and described first data base
Unanimously, described second data base's successful switch is the feedback data reported during current MDL, according to described
Feedback data obtains described second data base finally from the data exchange information of described first database synchronization;
Send, to described first data base, the master comprising described data exchange information and cut standby request, make described first
According to described data exchange information, database root judges that the data being synchronized to described second data base do not exist data
During loss, switch to current standby data base.
Further, described monitoring includes as the step of the operation of the first data base of current MDL:
Obtain the heartbeat message that described first data base periodically reports, do not receive described when the interval scheduled time
During heartbeat message, it is determined that described first data base's operation exception.
Further, after the step when described first data base's operation exception being detected, described method is also wrapped
Include:
The heartbeat message reported according to the most described first data base, obtains in described first data base and uses
Current binary log position primary importance in record data execution action;
Wherein, while sending for cutting main request to described second data base, by described first data base's
Current binary log position primary importance sends to described second data base.
Further, described second data base is obtained finally from described first data base according to described feedback data
In the step of the data exchange information synchronized:
Obtain described second data base according to described feedback data finally to enter from the two of described first data syn-chronization
The iog location second position processed;
Wherein, to described first data base send main cut standby request while, by described second data base
After send to described first data base from the binary log position second position of described first database synchronization.
Further, the heartbeat message reported according to the most described first data base, obtain described first
In data base, the step for the current binary log position primary importance that records data execution action is concrete
Including:
Obtain the binary log position the 3rd recording data execution action in last described heartbeat message
Position;
Whether the link between detection and described first data base exists:
If existing, then send the request obtaining current binary log position to described first data base, from institute
State and the feedback message of the first data base obtains current binary log position primary importance;If not existing, then
Last described heartbeat message will record position, binary log position the 3rd mark of data execution action
It is designated as current binary log position primary importance.
Embodiments of the invention additionally provide a kind of method of data base's active-standby switch, are applied to as current main
First data base of data base, including:
Receive the master sent when a management server detects described first data base's operation exception and cut standby request;
Cut standby request obtains from described master and switch to master data as current the second data base for data base
During storehouse, finally from the data exchange information of described first database synchronization;
Judge whether the data being synchronized to described second data base exist loss according to described data exchange information,
When judging that data do not exist loss, then switch to current standby data base;When judging that data exist loss,
Prompting handoff failure.
Further, described reception one manages transmission when server detects described first data base's operation exception
Before the main step cutting standby request, described method also includes:
Periodically report heartbeat message to described management server, make described management server believe according to described heart beating
Breath detects described first data base whether operation exception.
Further, described cutting standby request from described master obtains as current the second data base for data base
When switching to MDL, finally from the step of the data exchange information of described first database synchronization:
Cut standby request from described master and obtain described second data base finally from described first database synchronization
The binary log position second position.
Further, the described data being synchronized to described second data base according to the judgement of described data exchange information
The step whether existence is lost, including: obtain the binary system day after described first database recovery normal heartbeat
Position, will position the 4th;
Described 4th position is compared with the described second position, if described 4th position is less than or equal to described
The second position, it is determined that the data being synchronized to described second data base do not exist loss, switches to current standby number
According to storehouse;If described 4th position is more than the described second position, it is determined that be synchronized to the number of described second data base
Lose according to existing, there are differences with the data of described first data base, point out handoff failure.
Further, described when judging that data exist loss, after the step of prompting handoff failure, described
Method also includes:
Detect the beginning file of differentiation SQL script between described first data base and described second data base;
In the data of described first data base, from binary log position, the second position begins stepping through, until institute
There is journal file, generate the SQL statement of each affairs, and be redirected to target text file.
Embodiments of the invention additionally provide a kind of method of data base's active-standby switch, are applied to as the most standby
Second data base of data base, including:
Obtain what management server sent when monitoring first data base's exception as current MDL
For cutting main request;
From described for cutting the current data information obtaining described first data base main request, with described second number
Compare according to the current data information in storehouse, it is judged that data are the most consistent;When data consistent, then switch to
Current MDL, when data are inconsistent, prompting switches to the failure of current MDL.
Further, from described for cutting the current data information obtaining described first data base main request, with
The step that the current data information of described second data base compares includes:
From described for cutting first, the current binary log position obtaining described first data base main request
Put;
Obtain described second data base and replicate the current binary log position of data from described first data base
5th position;
Described primary importance is compared with described 5th position, if described primary importance is equal to the described 5th
Position, it is determined that the current data information of described first data base it is believed that with the current number of described second data base
The data consistent of breath, switches to current MDL;If described primary importance is less than described 5th position, then
Determine that the current data information of described first data base differs with the current data information of described second data base
Causing, prompting switches to the failure of current MDL.
Embodiments of the invention additionally provide the device of a kind of data base's active-standby switch, are applied to manage server,
Described device includes:
Monitoring modular, for monitoring the operation of the first data base as current MDL, when detecting
When stating first data base's operation exception, send for cutting main request to the second data base as current standby data base;
First acquisition module, for obtaining when described second data base detects described second data base and described the
Data consistent in one data base, described second data base's successful switch is report during current MDL anti-
Feedback data, obtain described second data base finally from described first database synchronization according to described feedback data
Data exchange information;
First data transmission blocks, comprises described data exchange information for sending to described first data base
Master cuts standby request, makes described first database root judge to be synchronized to described second number according to described data exchange information
When there is not loss of data according to the data in storehouse, switch to current standby data base.
Further, described monitoring modular includes:
First monitoring submodule, for obtaining the heartbeat message that described first data base periodically reports, works as interval
When the scheduled time does not receives described heartbeat message, it is determined that described first data base's operation exception.
Further, described device also includes:
First log acquisition module, for the heartbeat message reported according to the most described first data base,
Obtain in described first data base for recording first, the current binary log position of data execution action
Put;
Wherein, described monitoring modular is while sending for cutting main request to described second data base, by described
The current binary log position primary importance of the first data base sends to described second data base.
Further, described first acquisition module includes:
First log acquisition unit, for obtaining described second data base finally from institute according to described feedback data
State the binary log position second position of the first data syn-chronization;
Wherein, described first data transmission blocks to described first data base send main cut standby request while,
Described second data base is finally sent out from the binary log position second position of described first database synchronization
Deliver to described first data base.
Further, described first log acquisition module also includes:
Second daily record acquiring unit, is used for obtaining in last described heartbeat message record data execution action
Position, binary log position the 3rd;
Whether the first detector unit, exist for the link between detection and described first data base:
If existing, then send the request obtaining current binary log position to described first data base, from institute
State and the feedback message of the first data base obtains current binary log position primary importance;If not existing, then
Last described heartbeat message will record position, binary log position the 3rd mark of data execution action
It is designated as current binary log position primary importance.
Further, being applied to the first data base as current MDL, described device includes:
First receiver module, sends out for receiving when a management server detects described first data base's operation exception
The master sent cuts standby request;
Second acquisition module, for cutting, from described master, the second number obtained standby request as current standby data base
When switching to MDL according to storehouse, finally from the data exchange information of described first database synchronization;
First discrimination module, for judging to be synchronized to described second data base's according to described data exchange information
Whether data exist loss, when judging that data do not exist loss, then switch to current standby data base;When sentencing
When disconnected data exist loss, point out handoff failure.
Further, described first receiver module includes:
First reports submodule, for periodically reporting heartbeat message to described management server, makes described management
Server detects described first data base whether operation exception according to described heartbeat message.
Further, described second acquisition module includes:
First obtains submodule, obtains described second data base finally from institute for cutting standby request from described master
State the binary log position second position of the first database synchronization.
Further, described first discrimination module includes:
Second obtains submodule, the binary log after obtaining described first database recovery normal heartbeat
Position, position the 4th;
First differentiates submodule, for described 4th position is compared with the described second position, if described
4th position is less than or equal to the described second position, it is determined that the data being synchronized to described second data base do not exist
Lose, switch to current standby data base;If described 4th position is more than the described second position, it is determined that synchronize
Data to described second data base exist loses, and there are differences with the data of described first data base, prompting
Handoff failure.
Further, described device also includes:
First detection module, is used for detecting differentiation between described first data base and described second data base
The beginning file of SQL script;
First generation module, for from the data of described first data base, from binary log position second
Position begins stepping through, until all journal files, generates the SQL statement of each affairs, and is redirected to mesh
Mark text.
The embodiment provides the device of a kind of data base's active-standby switch, be applied to as current standby number
According to second data base in storehouse, described device includes:
3rd acquisition module, for obtaining management server when monitoring the first number as current MDL
Main request is cut according to the standby of transmission during the exception of storehouse;
Second discrimination module, is used for from described for cutting the current data obtaining described first data base main request
Information, compares with the current data information of described second data base, it is judged that data are the most consistent;Work as number
According to time consistent, then switching to current MDL, when data are inconsistent, prompting switches to current master data
Storehouse failure.
Further, described second discrimination module includes:
3rd obtains submodule, for from described standby cut main request obtains described first data base when the first two
System iog location primary importance;
4th obtains submodule, replicates data for obtaining described second data base from described first data base
Current position, binary log position the 5th;
Second differentiates submodule, for described primary importance is compared with described 5th position, if described
Primary importance is equal to described 5th position, it is determined that the current data information of described first data base and described the
The data consistent of the current data information of two data bases, switches to current MDL;If described primary importance
Less than described 5th position, it is determined that the current data information of described first data base and described second data base
Current data information inconsistent, prompting switch to current MDL failure.
The such scheme of the present invention at least includes following beneficial effect:
The method and device of data base's active-standby switch that the present invention provides, can efficiently identify standby machine data
Storehouse is inconsistent, and carries out active-standby switch;By host data base constantly to standby host database synchronization binary system day
Will, can effectively ensure data consistency and the accuracy of switching in master/slave data storehouse during active-standby switch;
Whole handoff procedure need not manually participate in, and saves cost of labor, and response speed is fast, and error rate is low.
Accompanying drawing explanation
Fig. 1 is the Organization Chart of the active-standby switch described in embodiments of the invention;
Fig. 2 is the flow chart of the active-standby switch described in embodiments of the invention;
Fig. 3 is the flow chart of the main/standby switching method of the application management server described in the embodiment of the present invention;
Fig. 4 is the signal that being applied to described in the embodiment of the present invention manages the device of the active-standby switch of server
Figure;
Fig. 5 is the master being applied to current the first data base as MDL described in the embodiment of the present invention
The flow chart of standby changing method;
Fig. 6 is the master being applied to current the first data base as MDL described in the embodiment of the present invention
The schematic diagram of the device of standby switching;
Fig. 7 is the master being applied to current the second data base as standby data base described in the embodiment of the present invention
The flow chart of standby changing method;
Fig. 8 is the master being applied to current the second data base as standby data base described in the embodiment of the present invention
The schematic diagram of the device of standby switching.
Detailed description of the invention
For making the technical problem to be solved in the present invention, technical scheme and advantage clearer, below in conjunction with attached
Figure and specific embodiment are described in detail.
See Fig. 1, the invention provides the method and device of a kind of data base's active-standby switch, its objective is for
Solution data base's active-standby switch process is loaded down with trivial details, and cost of labor is higher, response speed is slow, error rate is high
Problem, wherein, management server is flowed by control to be handed between the first data base and the second data base
Mutually, the first data base and the second data base report heartbeat message, and management clothes to described management server
Business device sends active-standby switch request to the first data base and the second data base;First data base and the second number
Interacted by data stream according between storehouse, the heartbeat message of second database synchronization the first data base.
See Fig. 3, a kind of method that The embodiment provides data base's active-standby switch, it is applied to pipe
Reason server, including:
Step 11, monitors the operation of the first data base as current MDL, when detecting described the
During one data base's operation exception, send for cutting main request to the second data base as current standby data base;
Further, the operation of the first data base as current MDL is monitored described in step 11
Step includes:
Obtain the heartbeat message that described first data base periodically reports, do not receive described when the interval scheduled time
During heartbeat message, it is determined that described first data base's operation exception;
After step when described first data base's operation exception being detected, according to the most described first
The heartbeat message that data base reports, obtains in described first data base for recording the current of data execution action
Binary log position primary importance;
Wherein, while sending for cutting main request to described second data base, by described first data base's
Current binary log position primary importance sends to described second data base.
In a particular embodiment of the present invention, the heartbeat message reported according to the most described first data base,
Obtain in described first data base for recording first, the current binary log position of data execution action
The step put specifically includes:
Obtain the binary log position the 3rd recording data execution action in last described heartbeat message
Position;
Whether the link between detection and described first data base exists:
If existing, then send the request obtaining current binary log position to described first data base, from institute
State and the feedback message of the first data base obtains current binary log position primary importance;If not existing, then
Last described heartbeat message will record position, binary log position the 3rd mark of data execution action
It is designated as current binary log position primary importance.
Step 12, obtains when described second data base detects described second data base and described first data base
In data consistent, described second data base's successful switch is the feedback data reported during current MDL,
Obtain described second data base according to described feedback data finally to cut from the data of described first database synchronization
Change information;
In a particular embodiment of the present invention, step 12 obtains described second number according to described feedback data
According to storehouse finally from the step of the data exchange information of described first database synchronization:
Obtain described second data base according to described feedback data finally to enter from the two of described first data syn-chronization
The iog location second position processed;
Wherein, to described first data base send main cut standby request while, by described second data base
After send to described first data base from the binary log position second position of described first database synchronization.
Step 13, sends, to described first data base, the master comprising described data exchange information and cuts standby request,
Described first database root is made to judge to be synchronized to the data of described second data base according to described data exchange information
When there is not loss of data, switch to current standby data base.
See Fig. 2, in a particular embodiment of the present invention, described currently as the first data of MDL
Storehouse periodically reports heartbeat message, described management server to obtain from described heartbeat message to described management server
Take the binary log position primary importance of described first data base, when the pre-timing in described management server interval
Between when not receiving described heartbeat message, it is determined that described first data base's operation exception;
Described management server obtains the binary log position of described first data base: obtain last institute
State the position, binary log position the 3rd recording data execution action in heartbeat message;
Whether the link between detection and described first data base exists: if existing, from described first data base
Feedback message in obtain current binary log position primary importance;If not existing, then by last institute
State binary log position the 3rd position mark recording data execution action in heartbeat message for entering when the first two
Iog location primary importance processed.
Described management server sends for cutting main request to the second data base as current standby data base, described
Second data base receive described standby cut main request after, from described standby cutting, main request obtains described first number
Current binary log position primary importance according to storehouse;Obtain described second data base from described first data base
Replicate the position, current binary log position the 5th of data;Described primary importance is entered with described 5th position
Row compares, if described primary importance is equal to described 5th position, it is determined that the current number of described first data base
It is believed that the data consistent of breath and the current data information of described second data base, switch to current MDL,
And switching result is reported to described management server, simultaneously by last from the two of described first database synchronization
The system iog location second position is reported to described management server;
If described primary importance is less than described 5th position, it is determined that the current number of described first data base it is believed that
Ceasing inconsistent with the current data information of described second data base, prompting switches to the failure of current MDL.
When described management server receives the normal heartbeat of described first data base again, described second number
The position, binary log position the 4th after described first database recovery normal heartbeat is obtained according to storehouse, and by institute
State the 4th position to compare with the described second position, if described 4th position is less than or equal to the described second position,
Then determine that the data being synchronized to described second data base do not exist loss, switch to current standby data base;
If described 4th position is more than the described second position, it is determined that be synchronized to the data of described second data base
Exist and lose, there are differences with the data of described first data base, point out handoff failure;Tool in the present invention
Among body embodiment, after the step of prompting handoff failure, detect described first data base and described second number
According to the beginning file of differentiation SQL script between storehouse;
In the data of described first data base, from binary log position, the second position begins stepping through, until institute
There is journal file, generate the SQL statement of each affairs, and be redirected to target text file, described second
Data base performs the SQL statement of described target text file, then switches over as current standby data base;If
Target text file cannot be directed to, then show to exist between described first data base and described second data base
Data difference, it is impossible to recover data consistency, handoff failure;The present invention passes through host data base constantly to standby
Machine database synchronization binary log, can effectively ensure the data one in master/slave data storehouse during active-standby switch
Cause property and the accuracy of switching;Whole handoff procedure need not manually participate in, and saves cost of labor, and
Response speed is fast, and error rate is low.
Seeing Fig. 4, embodiments of the invention additionally provide the device of a kind of data base's active-standby switch, are applied to
Management server 1, described device includes:
Monitoring modular 11, for monitoring the operation of the first data base as current MDL, works as detection
During to described first data base's operation exception, send for cutting master to the second data base as current standby data base
Request;
First acquisition module 12, for obtaining when described second data base detects described second data base and institute
Stating the data consistent in the first data base, described second data base's successful switch is to report during current MDL
Feedback data, according to described feedback data obtain described second data base finally from described first data base with
The data exchange information of step;
First data transmission blocks 13, comprises described data exchange letter for sending to described first data base
The master of breath cuts standby request, makes described first database root judge to be synchronized to described the according to described data exchange information
When the data of two data bases do not exist loss of data, switch to current standby data base.
Further, described monitoring modular 11 includes:
First monitoring submodule 111, for obtaining the heartbeat message that described first data base periodically reports, when
When the interval scheduled time does not receives described heartbeat message, it is determined that described first data base's operation exception.
Further, described device also includes:
First log acquisition module 14, for the heart beating letter reported according to the most described first data base
Breath, obtains in described first data base for recording the current binary log position first of data execution action
Position;
Wherein, described monitoring modular 11, will while sending for cutting main request to described second data base
The current binary log position primary importance of described first data base sends to described second data base.
Further, described first acquisition module 12 includes:
First log acquisition unit 121, last for obtaining described second data base according to described feedback data
From the binary log position second position of described first data syn-chronization;
Wherein, described first data transmission blocks to described first data base send main cut standby request while,
Described second data base is finally sent out from the binary log position second position of described first database synchronization
Deliver to described first data base.
Further, described first log acquisition module 14 also includes:
Second daily record acquiring unit 141, is used for obtaining in last described heartbeat message record data and performs
The position, binary log position the 3rd of action;
Whether the first detector unit, exist for the link between detection and described first data base:
If existing, then send the request obtaining current binary log position to described first data base, from institute
State and the feedback message of the first data base obtains current binary log position primary importance;If not existing, then
Last described heartbeat message will record position, binary log position the 3rd mark of data execution action
It is designated as current binary log position primary importance.
It should be noted that the data base's active-standby switch being applied to manage server that the embodiment of the present invention provides
Device be the above-mentioned device of method being applied to manage data base's active-standby switch of server of application, the most above-mentioned
All embodiments of method are all applicable to this device, and all can reach same or analogous beneficial effect.
Seeing Fig. 5, embodiments of the invention additionally provide a kind of method of data base's active-standby switch, are applied to
As the first data base of current MDL, including:
Step 21, receives the master sent when a management server detects described first data base's operation exception and cuts
Standby request;Further, before step 21, described method also includes:
Periodically report heartbeat message to described management server, make described management server believe according to described heart beating
Breath detects described first data base whether operation exception.
Step 22, cuts from described master and obtains second data base's switching as current standby data base standby request
During for MDL, finally from the data exchange information of described first database synchronization;Further, step
22 include:
Cut standby request from described master and obtain described second data base finally from described first database synchronization
The binary log position second position.
Further, the described data being synchronized to described second data base according to the judgement of described data exchange information
The step whether existence is lost, including: obtain the binary system day after described first database recovery normal heartbeat
Position, will position the 4th;
Described 4th position is compared with the described second position, if described 4th position is less than or equal to described
The second position, it is determined that the data being synchronized to described second data base do not exist loss, switches to current standby number
According to storehouse;If described 4th position is more than the described second position, it is determined that be synchronized to the number of described second data base
Lose according to existing, there are differences with the data of described first data base, point out handoff failure.
Step 23, judges whether be synchronized to the data of described second data base according to described data exchange information
Exist and lose, when judging that data do not exist loss, then switch to current standby data base;When judging that data are deposited
When losing, point out handoff failure.
Further, in step 23, when judge data exist lose time, prompting handoff failure step it
After, described method also includes:
Detect the beginning file of differentiation SQL script between described first data base and described second data base;
In the data of described first data base, from binary log position, the second position begins stepping through, until institute
There is journal file, generate the SQL statement of each affairs, and be redirected to target text file.
Seeing Fig. 6, embodiments of the invention additionally provide the device of a kind of data base's active-standby switch, are applied to
As the first data base of current MDL, described device includes:
First receiver module 21, detects described first data base's operation exception for receiving a management server
Time the master that sends cut standby request;Further, described first receiver module 21 includes:
First reports submodule 211, for periodically reporting heartbeat message to described management server, makes described
Management server detects described first data base whether operation exception according to described heartbeat message.
Second acquisition module 22, obtains standby request as currently for the of data base for cutting from described master
When two data bases switch to MDL, finally from the data exchange information of described first database synchronization;Enter
One step ground, described second acquisition module 22 includes: first obtains submodule 221, for cutting from described master
Standby request obtains described second data base finally from the binary log position of described first database synchronization
The second position.
First discrimination module 23, for judging to be synchronized to described second data according to described data exchange information
Whether the data in storehouse exist loss, when judging that data do not exist loss, then switch to current standby data base;
When judging that data exist loss, point out handoff failure;Further, described first discrimination module 23 wraps
Include:
Second obtains submodule 231, the binary system after obtaining described first database recovery normal heartbeat
Iog location the 4th position;
First differentiates submodule 232, for the 4th position is compared with the second position, if the 4th position
Less than or equal to the second position, it is determined that the data being synchronized to described second data base do not exist loss, switch to
Current standby data base;If the 4th position is more than the second position, it is determined that be synchronized to the number of described second data base
Lose according to existing, there are differences with the data of described first data base, point out handoff failure.
Further, described device also includes:
First detection module 24, is used for detecting difference between described first data base and described second data base
Change the beginning file of SQL script;
First generation module 25, for from the data of described first data base, from binary log position
The second position begins stepping through, until all journal files, generates the SQL statement of each affairs, and redirects
To target text file.
It should be noted that the embodiment of the present invention provide be applied to currently the first data as MDL
The device of data base's active-standby switch in storehouse is that application is above-mentioned is applied to current the first data as MDL
All embodiments of the device of the method for data base's active-standby switch in storehouse, i.e. said method are all applicable to this device,
And all can reach same or analogous beneficial effect.
Seeing Fig. 7, embodiments of the invention additionally provide a kind of method of data base's active-standby switch, are applied to
As second data base of current standby data base, including:
Step 31, obtains management server abnormal when monitoring the first data base as current MDL
Time send standby cut main request;
Step 32, from described for cutting the current data information obtaining described first data base main request, with
The current data information of described second data base compares, it is judged that data are the most consistent;When data consistent,
Then switching to current MDL, when data are inconsistent, prompting switches to the failure of current MDL.
Further, in step 32, from described standby cutting, main request obtains the current of described first data base
Data message, the step compared with the current data information of described second data base includes:
From described for cutting first, the current binary log position obtaining described first data base main request
Put;
Obtain described second data base and replicate the current binary log position of data from described first data base
5th position;
Described primary importance is compared with described 5th position, if described primary importance is equal to the described 5th
Position, it is determined that the current data information of described first data base it is believed that with the current number of described second data base
The data consistent of breath, switches to current MDL;If described primary importance is less than described 5th position, then
Determine that the current data information of described first data base differs with the current data information of described second data base
Causing, prompting switches to the failure of current MDL.
See Fig. 6, The embodiment provides the device of a kind of data base's active-standby switch, be applied to make
For second data base 3 of current standby data base, described device includes:
3rd acquisition module 31, for obtaining management server when monitor as current MDL the
During one data base's exception, the standby of transmission cuts main request;
Second discrimination module 32, for obtaining the current of described first data base from described standby cutting main request
Data message, compares with the current data information of described second data base, it is judged that data are the most consistent;
When data consistent, then switching to current MDL, when data are inconsistent, prompting switches to current main
Failed database.
Further, described second discrimination module includes:
3rd obtains submodule 321, for obtaining working as of described first data base main request from described standby cutting
Front binary system iog location primary importance;
4th obtains submodule 322, is used for obtaining described second data base and replicates number from described first data base
According to position, current binary log position the 5th;
Second differentiates submodule 323, described primary importance is compared with described 5th position, if described
Primary importance is equal to described 5th position, it is determined that the current data information of described first data base and described the
The data consistent of the current data information of two data bases, switches to current MDL;If described primary importance
Less than described 5th position, it is determined that the current data information of described first data base and described second data base
Current data information inconsistent, prompting switch to current MDL failure.
It should be noted that being applied to of embodiment of the present invention offer is current as the second data for data base
The device of data base's active-standby switch in storehouse is that application is above-mentioned to be applied to currently as the second data for data base
All embodiments of the device of the method for data base's active-standby switch in storehouse, i.e. said method are all applicable to this device,
And all can reach same or analogous beneficial effect.
The above is the preferred embodiment of the present invention, it is noted that for the common skill of the art
For art personnel, on the premise of without departing from principle of the present invention, it is also possible to make some improvements and modifications,
These improvements and modifications also should be regarded as protection scope of the present invention.
Claims (24)
1. a method for data base's active-standby switch, is applied to manage server, it is characterised in that including:
Monitor the operation of the first data base as current MDL, when described first data base's fortune being detected
When row is abnormal, send for cutting main request to the second data base as current standby data base;
Obtain when described second data base detects the data in described second data base and described first data base
Unanimously, described second data base's successful switch is the feedback data reported during current MDL, according to described
Feedback data obtains described second data base finally from the data exchange information of described first database synchronization;
Send, to described first data base, the master comprising described data exchange information and cut standby request, make described first
According to described data exchange information, database root judges that the data being synchronized to described second data base do not exist data
During loss, switch to current standby data base.
2. the method for data base's active-standby switch as claimed in claim 1, it is characterised in that described monitoring
Step as the operation of the first data base of current MDL includes:
Obtain the heartbeat message that described first data base periodically reports, do not receive described when the interval scheduled time
During heartbeat message, it is determined that described first data base's operation exception.
3. the method for data base's active-standby switch as claimed in claim 2, it is characterised in that when detecting
After step during described first data base's operation exception, described method also includes:
The heartbeat message reported according to the most described first data base, obtains in described first data base and uses
Current binary log position primary importance in record data execution action;
Wherein, while sending for cutting main request to described second data base, by described first data base's
Current binary log position primary importance sends to described second data base.
4. the method for data base's active-standby switch as claimed in claim 3, it is characterised in that according to described
Feedback data obtains described second data base finally from the data exchange information of described first database synchronization
In step:
Obtain described second data base according to described feedback data finally to enter from the two of described first data syn-chronization
The iog location second position processed;
Wherein, to described first data base send main cut standby request while, by described second data base
After send to described first data base from the binary log position second position of described first database synchronization.
5. the method for data base's active-standby switch as claimed in claim 3, it is characterised in that according to finally
The heartbeat message that the most described first data base reports, obtains in described first data base and holds for recording data
The step of the current binary log position primary importance that action is made specifically includes:
Obtain the binary log position the 3rd recording data execution action in last described heartbeat message
Position;
Whether the link between detection and described first data base exists:
If existing, then send the request obtaining current binary log position to described first data base, from institute
State and the feedback message of the first data base obtains current binary log position primary importance;If not existing, then
Last described heartbeat message will record position, binary log position the 3rd mark of data execution action
It is designated as current binary log position primary importance.
6. a method for data base's active-standby switch, is applied to the first data base as current MDL,
It is characterized in that, including:
Receive the master sent when a management server detects described first data base's operation exception and cut standby request;
Cut standby request obtains from described master and switch to master data as current the second data base for data base
During storehouse, finally from the data exchange information of described first database synchronization;
Judge whether the data being synchronized to described second data base exist loss according to described data exchange information,
When judging that data do not exist loss, then switch to current standby data base;When judging that data exist loss,
Prompting handoff failure.
7. the method for data base's active-standby switch as claimed in claim 6, it is characterised in that described reception
Before the master that one management server sends when detecting described first data base's operation exception cuts the step of standby request,
Described method also includes:
Periodically report heartbeat message to described management server, make described management server believe according to described heart beating
Breath detects described first data base whether operation exception.
8. the method for data base's active-standby switch as claimed in claim 6, it is characterised in that described from institute
State main cutting and standby request obtains when switching to MDL as currently the second data base for data base, finally
From the step of the data exchange information of described first database synchronization:
Cut standby request from described master and obtain described second data base finally from described first database synchronization
The binary log position second position.
9. the method for data base's active-standby switch as claimed in claim 8, it is characterised in that described basis
Described data exchange information judges to be synchronized to whether the data of described second data base exist the step of loss, bag
Include: obtain the position, binary log position the 4th after described first database recovery normal heartbeat;
Described 4th position is compared with the described second position, if described 4th position is less than or equal to described
The second position, it is determined that the data being synchronized to described second data base do not exist loss, switches to current standby number
According to storehouse;If described 4th position is more than the described second position, it is determined that be synchronized to the number of described second data base
Lose according to existing, there are differences with the data of described first data base, point out handoff failure.
10. the method for data base's active-standby switch as claimed in claim 9, it is characterised in that described when sentencing
When disconnected data exist loss, after the step of prompting handoff failure, described method also includes:
Detect the beginning file of differentiation SQL script between described first data base and described second data base;
In the data of described first data base, from binary log position, the second position begins stepping through, until institute
There is journal file, generate the SQL statement of each affairs, and be redirected to target text file.
The method of 11. 1 kinds of data base's active-standby switch, is applied to the second data base as current standby data base,
It is characterized in that, including:
Obtain what management server sent when monitoring first data base's exception as current MDL
For cutting main request;
From described for cutting the current data information obtaining described first data base main request, with described second number
Compare according to the current data information in storehouse, it is judged that data are the most consistent;When data consistent, then switch to
Current MDL, when data are inconsistent, prompting switches to the failure of current MDL.
The method of 12. data base's active-standby switch as claimed in claim 11, it is characterised in that from described
Standby cut the current data information obtaining described first data base in main request, current with described second data base
The step that data message compares includes:
From described for cutting first, the current binary log position obtaining described first data base main request
Put;
Obtain described second data base and replicate the current binary log position of data from described first data base
5th position;
Described primary importance is compared with described 5th position, if described primary importance is equal to the described 5th
Position, it is determined that the current data information of described first data base it is believed that with the current number of described second data base
The data consistent of breath, switches to current MDL;If described primary importance is less than described 5th position, then
Determine that the current data information of described first data base differs with the current data information of described second data base
Causing, prompting switches to the failure of current MDL.
The device of 13. 1 kinds of data base's active-standby switch, is applied to manage server, it is characterised in that described
Device includes:
Monitoring modular, for monitoring the operation of the first data base as current MDL, when detecting
When stating first data base's operation exception, send for cutting main request to the second data base as current standby data base;
First acquisition module, for obtaining when described second data base detects described second data base and described the
Data consistent in one data base, described second data base's successful switch is report during current MDL anti-
Feedback data, obtain described second data base finally from described first database synchronization according to described feedback data
Data exchange information;
First data transmission blocks, comprises described data exchange information for sending to described first data base
Master cuts standby request, makes described first database root judge to be synchronized to described second number according to described data exchange information
When there is not loss of data according to the data in storehouse, switch to current standby data base.
The device of 14. data base's active-standby switch as claimed in claim 13, it is characterised in that described prison
Survey module includes:
First monitoring submodule, for obtaining the heartbeat message that described first data base periodically reports, works as interval
When the scheduled time does not receives described heartbeat message, it is determined that described first data base's operation exception.
The device of 15. data base's active-standby switch as claimed in claim 14, it is characterised in that described dress
Put and also include:
First log acquisition module, for the heartbeat message reported according to the most described first data base,
Obtain in described first data base for recording first, the current binary log position of data execution action
Put;
Wherein, described monitoring modular is while sending for cutting main request to described second data base, by described
The current binary log position primary importance of the first data base sends to described second data base.
The device of 16. data base's active-standby switch as claimed in claim 15, it is characterised in that described
One acquisition module includes:
First log acquisition unit, for obtaining described second data base finally from institute according to described feedback data
State the binary log position second position of the first data syn-chronization;
Wherein, described first data transmission blocks to described first data base send main cut standby request while,
Described second data base is finally sent out from the binary log position second position of described first database synchronization
Deliver to described first data base.
The device of 17. data base's active-standby switch as claimed in claim 15, it is characterised in that described
One log acquisition module also includes:
Second daily record acquiring unit, is used for obtaining in last described heartbeat message record data execution action
Position, binary log position the 3rd;
Whether the first detector unit, exist for the link between detection and described first data base:
If existing, then send the request obtaining current binary log position to described first data base, from institute
State and the feedback message of the first data base obtains current binary log position primary importance;If not existing, then
Last described heartbeat message will record position, binary log position the 3rd mark of data execution action
It is designated as current binary log position primary importance.
The device of 18. 1 kinds of data base's active-standby switch, is applied to the first data base as current MDL,
It is characterized in that, described device includes:
First receiver module, sends out for receiving when a management server detects described first data base's operation exception
The master sent cuts standby request;
Second acquisition module, for cutting, from described master, the second number obtained standby request as current standby data base
When switching to MDL according to storehouse, finally from the data exchange information of described first database synchronization;
First discrimination module, for judging to be synchronized to described second data base's according to described data exchange information
Whether data exist loss, when judging that data do not exist loss, then switch to current standby data base;When sentencing
When disconnected data exist loss, point out handoff failure.
The device of 19. data base's active-standby switch as claimed in claim 18, it is characterised in that described
One receiver module includes:
First reports submodule, for periodically reporting heartbeat message to described management server, makes described management
Server detects described first data base whether operation exception according to described heartbeat message.
The device of 20. data base's active-standby switch as claimed in claim 18, it is characterised in that described
Two acquisition modules include:
First obtains submodule, obtains described second data base finally from institute for cutting standby request from described master
State the binary log position second position of the first database synchronization.
The device of 21. data base's active-standby switch as claimed in claim 20, it is characterised in that described
One discrimination module includes:
Second obtains submodule, the binary log after obtaining described first database recovery normal heartbeat
Position, position the 4th;
First differentiates submodule, for described 4th position is compared with the described second position, if described
4th position is less than or equal to the described second position, it is determined that the data being synchronized to described second data base do not exist
Lose, switch to current standby data base;If described 4th position is more than the described second position, it is determined that synchronize
Data to described second data base exist loses, and there are differences with the data of described first data base, prompting
Handoff failure.
The device of 22. data base's active-standby switch as claimed in claim 21, it is characterised in that described dress
Put and also include:
First detection module, is used for detecting differentiation between described first data base and described second data base
The beginning file of SQL script;
First generation module, for from the data of described first data base, from binary log position second
Position begins stepping through, until all journal files, generates the SQL statement of each affairs, and is redirected to mesh
Mark text.
The device of 23. 1 kinds of data base's active-standby switch, is applied to the second data base as current standby data base,
It is characterized in that, described device includes:
3rd acquisition module, for obtaining management server when monitoring the first number as current MDL
Main request is cut according to the standby of transmission during the exception of storehouse;
Second discrimination module, is used for from described for cutting the current data obtaining described first data base main request
Information, compares with the current data information of described second data base, it is judged that data are the most consistent;Work as number
According to time consistent, then switching to current MDL, when data are inconsistent, prompting switches to current master data
Storehouse failure.
The device of 24. data base's active-standby switch as claimed in claim 23, it is characterised in that described
Two discrimination modules include:
3rd obtains submodule, for from described standby cut main request obtains described first data base when the first two
System iog location primary importance;
4th obtains submodule, replicates data for obtaining described second data base from described first data base
Current position, binary log position the 5th;
Second differentiates submodule, for described primary importance is compared with described 5th position, if described
Primary importance is equal to described 5th position, it is determined that the current data information of described first data base and described the
The data consistent of the current data information of two data bases, switches to current MDL;If described primary importance
Less than described 5th position, it is determined that the current data information of described first data base and described second data base
Current data information inconsistent, prompting switch to current MDL failure.
Priority Applications (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201510213694.1A CN106202075B (en) | 2015-04-29 | 2015-04-29 | Method and device for switching between main database and standby database |
PCT/CN2015/089553 WO2016173179A1 (en) | 2015-04-29 | 2015-09-14 | Method and device for switching primary database and secondary database |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201510213694.1A CN106202075B (en) | 2015-04-29 | 2015-04-29 | Method and device for switching between main database and standby database |
Publications (2)
Publication Number | Publication Date |
---|---|
CN106202075A true CN106202075A (en) | 2016-12-07 |
CN106202075B CN106202075B (en) | 2021-02-19 |
Family
ID=57198042
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201510213694.1A Active CN106202075B (en) | 2015-04-29 | 2015-04-29 | Method and device for switching between main database and standby database |
Country Status (2)
Country | Link |
---|---|
CN (1) | CN106202075B (en) |
WO (1) | WO2016173179A1 (en) |
Cited By (14)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN106815097A (en) * | 2017-01-18 | 2017-06-09 | 北京许继电气有限公司 | Database disaster tolerance system and method |
CN107506263A (en) * | 2017-08-24 | 2017-12-22 | 深圳互联先锋科技有限公司 | A kind of fault testing method and device |
CN107632906A (en) * | 2017-09-30 | 2018-01-26 | 北京九桥同步软件有限公司 | Database data backup method and device |
WO2018113543A1 (en) * | 2016-12-20 | 2018-06-28 | 阿里巴巴集团控股有限公司 | Management method, system, and device for master and standby databases |
CN108897658A (en) * | 2018-05-31 | 2018-11-27 | 康键信息技术(深圳)有限公司 | Primary database monitoring method, device, computer equipment and storage medium |
CN109388630A (en) * | 2018-09-29 | 2019-02-26 | 北京京东金融科技控股有限公司 | Database switching method, system, electronic equipment and computer-readable medium |
CN109947772A (en) * | 2018-09-07 | 2019-06-28 | 网联清算有限公司 | Database automatic switching method, device, storage medium and computer equipment |
CN110109934A (en) * | 2019-05-08 | 2019-08-09 | 上海达梦数据库有限公司 | A kind of data base management method, device, server and storage medium |
CN110166524A (en) * | 2019-04-12 | 2019-08-23 | 陆金所(上海)科技服务有限公司 | Switching method, device, equipment and the storage medium of data center |
CN110209554A (en) * | 2019-06-14 | 2019-09-06 | 上海中通吉网络技术有限公司 | Database journal distribution method, device and equipment |
CN110377570A (en) * | 2017-10-12 | 2019-10-25 | 腾讯科技(深圳)有限公司 | Node switching method, device, computer equipment and storage medium |
WO2019237543A1 (en) * | 2018-06-11 | 2019-12-19 | 平安科技(深圳)有限公司 | Database switching method and system |
CN110909171A (en) * | 2019-10-16 | 2020-03-24 | 珠海格力电器股份有限公司 | Data scheduling method, device, terminal and storage medium |
CN111460029A (en) * | 2020-03-11 | 2020-07-28 | 中移动信息技术有限公司 | Data synchronization method and device |
Families Citing this family (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN108984569A (en) * | 2017-06-05 | 2018-12-11 | 中兴通讯股份有限公司 | Database switching method, system and computer readable storage medium |
CN108834179B (en) * | 2018-05-31 | 2021-07-09 | 深圳市酷达通讯有限公司 | Method, server and client for adjusting heartbeat cycle |
CN111258823A (en) * | 2020-01-17 | 2020-06-09 | 青梧桐有限责任公司 | Method and system for switching master server and slave server |
CN113297002B (en) * | 2020-02-21 | 2023-12-05 | 北京京东振世信息技术有限公司 | Database working mode switching method and device |
CN112363865A (en) * | 2020-10-19 | 2021-02-12 | 深圳云天励飞技术股份有限公司 | Database fault recovery method and device and face image search system |
CN114679399A (en) * | 2022-03-17 | 2022-06-28 | 浙江大华技术股份有限公司 | Host switching method and device, storage medium and electronic device |
CN115361269B (en) * | 2022-07-08 | 2023-05-30 | 福建新大陆通信科技股份有限公司 | Hot backup method for emergency broadcasting equipment |
Citations (11)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JPH08115323A (en) * | 1994-10-18 | 1996-05-07 | Toppan Printing Co Ltd | Automatic page-up rule generation device |
US7043504B1 (en) * | 2000-04-10 | 2006-05-09 | International Business Machines Corporation | System and method for parallel primary and secondary backup reading in recovery of multiple shared database data sets |
CN101212458A (en) * | 2006-12-25 | 2008-07-02 | 中兴通讯股份有限公司 | Database system backup method |
CN101751394A (en) * | 2008-12-16 | 2010-06-23 | 青岛海信传媒网络技术有限公司 | Method and system for synchronizing data |
CN102810111A (en) * | 2012-05-07 | 2012-12-05 | 互动在线(北京)科技有限公司 | Implementation method and system for keeping high availability of Oracle database service |
CN102945195A (en) * | 2012-11-26 | 2013-02-27 | 国电南瑞科技股份有限公司 | Master-standby redundancy replication method based on SQLite databases |
CN102968457A (en) * | 2012-10-30 | 2013-03-13 | 北京奇虎科技有限公司 | Switching method and system between databases |
CN103019875A (en) * | 2012-12-19 | 2013-04-03 | 北京世纪家天下科技发展有限公司 | Method and device for realizing double main reconstruction of database |
CN103220183A (en) * | 2013-05-02 | 2013-07-24 | 杭州电子科技大学 | Implement method of Hadoop high-availability system based on double-main-engine warm backup |
CN103226502A (en) * | 2013-05-21 | 2013-07-31 | 中国工商银行股份有限公司 | Data disaster backup control system and data recovery method |
US20130304714A1 (en) * | 2010-12-28 | 2013-11-14 | Juchang Lee | Distributed Transaction Management Using Two-Phase Commit Optimization |
Family Cites Families (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101729290A (en) * | 2009-11-04 | 2010-06-09 | 中兴通讯股份有限公司 | Method and device for realizing business system protection |
CN103064860A (en) * | 2011-10-21 | 2013-04-24 | 阿里巴巴集团控股有限公司 | Database high availability implementation method and device |
CN103780638B (en) * | 2012-10-18 | 2019-02-19 | 腾讯科技(深圳)有限公司 | Method of data synchronization and system |
-
2015
- 2015-04-29 CN CN201510213694.1A patent/CN106202075B/en active Active
- 2015-09-14 WO PCT/CN2015/089553 patent/WO2016173179A1/en active Application Filing
Patent Citations (11)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JPH08115323A (en) * | 1994-10-18 | 1996-05-07 | Toppan Printing Co Ltd | Automatic page-up rule generation device |
US7043504B1 (en) * | 2000-04-10 | 2006-05-09 | International Business Machines Corporation | System and method for parallel primary and secondary backup reading in recovery of multiple shared database data sets |
CN101212458A (en) * | 2006-12-25 | 2008-07-02 | 中兴通讯股份有限公司 | Database system backup method |
CN101751394A (en) * | 2008-12-16 | 2010-06-23 | 青岛海信传媒网络技术有限公司 | Method and system for synchronizing data |
US20130304714A1 (en) * | 2010-12-28 | 2013-11-14 | Juchang Lee | Distributed Transaction Management Using Two-Phase Commit Optimization |
CN102810111A (en) * | 2012-05-07 | 2012-12-05 | 互动在线(北京)科技有限公司 | Implementation method and system for keeping high availability of Oracle database service |
CN102968457A (en) * | 2012-10-30 | 2013-03-13 | 北京奇虎科技有限公司 | Switching method and system between databases |
CN102945195A (en) * | 2012-11-26 | 2013-02-27 | 国电南瑞科技股份有限公司 | Master-standby redundancy replication method based on SQLite databases |
CN103019875A (en) * | 2012-12-19 | 2013-04-03 | 北京世纪家天下科技发展有限公司 | Method and device for realizing double main reconstruction of database |
CN103220183A (en) * | 2013-05-02 | 2013-07-24 | 杭州电子科技大学 | Implement method of Hadoop high-availability system based on double-main-engine warm backup |
CN103226502A (en) * | 2013-05-21 | 2013-07-31 | 中国工商银行股份有限公司 | Data disaster backup control system and data recovery method |
Non-Patent Citations (1)
Title |
---|
金紫蘅: "从双机到四机中MySQL数据库高可用性实现方法", 《中国科技信息》 * |
Cited By (22)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2018113543A1 (en) * | 2016-12-20 | 2018-06-28 | 阿里巴巴集团控股有限公司 | Management method, system, and device for master and standby databases |
US10592361B2 (en) | 2016-12-20 | 2020-03-17 | Alibaba Group Holding Limited | Method, system and apparatus for managing primary and secondary databases |
CN106815097A (en) * | 2017-01-18 | 2017-06-09 | 北京许继电气有限公司 | Database disaster tolerance system and method |
CN107506263A (en) * | 2017-08-24 | 2017-12-22 | 深圳互联先锋科技有限公司 | A kind of fault testing method and device |
CN107632906A (en) * | 2017-09-30 | 2018-01-26 | 北京九桥同步软件有限公司 | Database data backup method and device |
CN110377570A (en) * | 2017-10-12 | 2019-10-25 | 腾讯科技(深圳)有限公司 | Node switching method, device, computer equipment and storage medium |
CN108897658A (en) * | 2018-05-31 | 2018-11-27 | 康键信息技术(深圳)有限公司 | Primary database monitoring method, device, computer equipment and storage medium |
CN108897658B (en) * | 2018-05-31 | 2023-03-21 | 康键信息技术(深圳)有限公司 | Method and device for monitoring master database, computer equipment and storage medium |
WO2019237543A1 (en) * | 2018-06-11 | 2019-12-19 | 平安科技(深圳)有限公司 | Database switching method and system |
CN109947772A (en) * | 2018-09-07 | 2019-06-28 | 网联清算有限公司 | Database automatic switching method, device, storage medium and computer equipment |
CN109388630A (en) * | 2018-09-29 | 2019-02-26 | 北京京东金融科技控股有限公司 | Database switching method, system, electronic equipment and computer-readable medium |
WO2020063197A1 (en) * | 2018-09-29 | 2020-04-02 | 京东数字科技控股有限公司 | Database switching method and system, and electronic device and computer-readable medium |
CN109388630B (en) * | 2018-09-29 | 2020-09-29 | 京东数字科技控股有限公司 | Database switching method, system, electronic device and computer readable medium |
CN110166524A (en) * | 2019-04-12 | 2019-08-23 | 陆金所(上海)科技服务有限公司 | Switching method, device, equipment and the storage medium of data center |
CN110109934B (en) * | 2019-05-08 | 2021-07-30 | 上海达梦数据库有限公司 | Database management method, device, server and storage medium |
CN110109934A (en) * | 2019-05-08 | 2019-08-09 | 上海达梦数据库有限公司 | A kind of data base management method, device, server and storage medium |
CN110209554A (en) * | 2019-06-14 | 2019-09-06 | 上海中通吉网络技术有限公司 | Database journal distribution method, device and equipment |
CN110209554B (en) * | 2019-06-14 | 2023-08-11 | 上海中通吉网络技术有限公司 | Database log distribution method, device and equipment |
CN110909171A (en) * | 2019-10-16 | 2020-03-24 | 珠海格力电器股份有限公司 | Data scheduling method, device, terminal and storage medium |
CN110909171B (en) * | 2019-10-16 | 2022-07-12 | 珠海格力电器股份有限公司 | Data scheduling method, device, terminal and storage medium |
CN111460029A (en) * | 2020-03-11 | 2020-07-28 | 中移动信息技术有限公司 | Data synchronization method and device |
CN111460029B (en) * | 2020-03-11 | 2024-04-19 | 中移动信息技术有限公司 | Data synchronization method and device |
Also Published As
Publication number | Publication date |
---|---|
WO2016173179A1 (en) | 2016-11-03 |
CN106202075B (en) | 2021-02-19 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN106202075A (en) | A kind of method and device of data base's active-standby switch | |
CN107291787B (en) | Main and standby database switching method and device | |
US7523352B2 (en) | System and method for examining remote systems and gathering debug data in real time | |
CN112506702B (en) | Disaster recovery method, device, equipment and storage medium for data center | |
CN103810076B (en) | The monitoring method and device of data duplication | |
US20130205017A1 (en) | Computer failure monitoring method and device | |
CN101883028A (en) | Method and device for detecting network file system server | |
US20030069959A1 (en) | Alarm lists synchronization in an alarm management system | |
CN103067209B (en) | A kind of heartbeat module self-sensing method | |
CN107294767B (en) | Live broadcast network transmission fault monitoring method and system | |
CN101777951B (en) | Method and system for data monitoring | |
CN105095008A (en) | Distributed task fault redundancy method suitable for cluster system | |
CN106294795A (en) | A kind of data base's changing method and system | |
CN102957545B (en) | The maintaining method and device of synchronous network clock | |
CN105302670B (en) | A kind of method and device that station is monitored using multi-computer Redundancy mode | |
CN112346925A (en) | Process-level dual-computer hot standby redundancy system and method | |
CN111475386B (en) | Fault early warning method and related device | |
CN108009045B (en) | Method and device for processing faults of main and standby databases | |
CN104158843B (en) | The storage-unit-failure detection method and device of distributed file storage system | |
CN109347684A (en) | A kind of network server monitoring system | |
CN110569303B (en) | MySQL application layer high-availability system and method suitable for various cloud environments | |
CN108965022A (en) | A kind of Network Abnormal data monitoring system and monitoring method | |
CN113779038B (en) | Multi-data source data synchronization method | |
CN104796294A (en) | Cloud acceleration network monitoring system and method | |
CN110830281B (en) | Hot standby method and system based on mesh network structure |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | 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 | ||
TR01 | Transfer of patent right |
Effective date of registration: 20220107 Address after: 100176 602, floor 6, building 6, courtyard 10, KEGU 1st Street, Beijing Economic and Technological Development Zone, Daxing District, Beijing (Yizhuang group, high-end industrial area of Beijing Pilot Free Trade Zone) Patentee after: Jinzhuan Xinke Co.,Ltd. Address before: 518057 Ministry of justice, Zhongxing building, South Science and technology road, Nanshan District hi tech Industrial Park, Shenzhen, Guangdong Patentee before: ZTE Corp. |
|
TR01 | Transfer of patent right |