CN106021030A - Database system and database fault processing method and device - Google Patents
Database system and database fault processing method and device Download PDFInfo
- Publication number
- CN106021030A CN106021030A CN201610370627.5A CN201610370627A CN106021030A CN 106021030 A CN106021030 A CN 106021030A CN 201610370627 A CN201610370627 A CN 201610370627A CN 106021030 A CN106021030 A CN 106021030A
- Authority
- CN
- China
- Prior art keywords
- mdl
- data base
- data
- account
- real time
- 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
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
- G06F11/1446—Point-in-time backing up or restoration of persistent data
- G06F11/1448—Management of the data involved in backup or backup restore
-
- 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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
Abstract
The invention provides a database system and a database fault processing method and device. The method comprises the steps that 1, at least one slave database is set for a master database in advance; 2, original data in the master database is copied into each slave database in advance; 3, each operation of the master database is obtained in real time; 4, the operation which is the same as the operation of the master database is carried out on each slave database; 5, whether the master database breaks down or not is detected in real time, and if yes, any slave database is used for being substituted for the master database. By means of the database system and the database fault processing method and device, database reliability can be improved.
Description
Technical field
The present invention relates to field of computer technology, particularly to system, a kind of process number of a kind of data base
Method and device according to storehouse fault.
Background technology
Complication system is more and more higher to the requirement of data storage capacity calamity, most system only one of which data base,
Once it is in operation and the problem of data base's maloperation or collapse occurs, the operation of whole system can be affected,
Possibly even cause the machine of delaying, the most so-called Single Point of Faliure.
In prior art when the data base in system is broken down, the service relevant to data base will stop
Only running, safeguard data base, after database recovery is normal, relevant service could be properly functioning.
Visible by foregoing description, the reliability of existing data base is relatively low.
Summary of the invention
Embodiments provide the system of a kind of data base, a kind of method processing database failure and
Device, it is possible to increase the reliability of data base.
First aspect, embodiments provides a kind of method processing database failure, including:
S1: for MDL, at least one is set from data base in advance；
S2: in advance initial data in described MDL is copied to each described from data base；
S3: obtain each operation of described MDL in real time；
S4: in each described operation that execution is identical with the operation of described MDL from data base；
S5: in real time detect whether described MDL breaks down, if it is, utilize arbitrary described from
Data base replaces described MDL.
Further, before described S2, also include:
Described MDL creates and replicates account, authorize described duplication account REPLICATION
SLAVE authority；
Described duplication account is utilized to connect described MDL；
Described S2, including:
Utilize the REPLICATION SLAVE authority of described duplication account, by described MDL Central Plains
Beginning data copy to each described from data base.
Further, before described S3, also include: open the binary log of described MDL；
Also include: in described binary log, record each operation of described MDL in real time；
Described S3, including:
Each operation of described MDL is obtained in real time from described binary log.
Further, described utilization arbitrary described replaces described MDL from data base, including:
The operation of described MDL is converted to by outside to be used for replacing described MDL from data
The operation in storehouse.
Second aspect, embodiments provides a kind of device processing database failure, including:
Unit is set, for arranging at least one from data base for MDL；
Copied cells, each described from data base for initial data in described MDL is copied to；
Acquiring unit, for each operation of the described MDL of acquisition in real time；
Performance element, in each described operation that execution is identical with described MDL from data base；
For in real time, detector unit, detects whether described MDL breaks down, when described master being detected
Data base breaks down, and utilizes and arbitrary described replaces described MDL from data base.
Further, also include: creating unit, replicate account for creating in described MDL,
Authorize described duplication account REPLICATION SLAVE authority；
Connect unit, be used for utilizing described duplication account to connect described MDL；
Described copied cells, for utilizing the REPLICATION SLAVE authority of described duplication account,
Initial data in described MDL is copied to each described from data base.
Further, also include: open unit, for opening the binary log of described MDL；
Also include: record unit, for recording described MDL in described binary log in real time
Each operation；
Described acquiring unit, for obtaining each of described MDL in real time from described binary log
Operation.
Further, described detector unit arbitrary described replaces described master from data base performing described utilization
During data base, for the operation of described MDL is converted to being used for replacing described master data by outside
The operation from data base in storehouse.
The third aspect, embodiments provides the system of a kind of data base, including:
MDL, at least one from data base, process data base as described in arbitrary second aspect therefore
The device of barrier.
Further, described MDL from described at least one be deployed in different servers from data base
On.
In embodiments of the present invention, for MDL arrange at least one from data base, by MDL
Initial data copy to each from data base so that each from data base, preserve MDL
Initial data, performs the operation identical with the operation of MDL each so that each from data base
Tong Bu with MDL from data base, it is achieved from data base's backup to MDL, when detection master data
When storehouse sends fault, utilize and arbitrary replace MDL from data base, outside need operation MDL
During data, can also be realized from the data of data base by operation, therefore, MDL breaks down also
Do not interfere with as outside the operation of data in MDL, improve the reliability of data base.
Accompanying drawing explanation
In order to be illustrated more clearly that the embodiment of the present invention or technical scheme of the prior art, below will be to reality
Execute the required accompanying drawing used in example or description of the prior art to be briefly described, it should be apparent that below,
Accompanying drawing in description is some embodiments of the present invention, for those of ordinary skill in the art, not
On the premise of paying creative work, it is also possible to obtain other accompanying drawing according to these accompanying drawings.
Fig. 1 is the flow chart of a kind of method processing database failure that one embodiment of the invention provides；
Fig. 2 is the flow chart of the another kind of method processing database failure that one embodiment of the invention provides；
Fig. 3 is the schematic diagram of a kind of device processing database failure that one embodiment of the invention provides；
Fig. 4 is the schematic diagram of the another kind of device processing database failure that one embodiment of the invention provides；
Fig. 5 is the schematic diagram of the system of a kind of data base that one embodiment of the invention provides.
Detailed description of the invention
For making the purpose of the embodiment of the present invention, technical scheme and advantage clearer, below in conjunction with this
Accompanying drawing in bright embodiment, is clearly and completely described the technical scheme in the embodiment of the present invention,
Obviously, described embodiment is a part of embodiment of the present invention rather than whole embodiments, based on
Embodiment in the present invention, those of ordinary skill in the art are institute on the premise of not making creative work
The every other embodiment obtained, broadly falls into the scope of protection of the invention.
As it is shown in figure 1, embodiments provide a kind of method processing database failure, the method
May comprise steps of:
S1: for MDL, at least one is set from data base in advance；
S2: in advance initial data in described MDL is copied to each described from data base；
S3: obtain each operation of described MDL in real time；
S4: in each described operation that execution is identical with the operation of described MDL from data base；
S5: in real time detect whether described MDL breaks down, if it is, utilize arbitrary described from
Data base replaces described MDL.
In embodiments of the present invention, for MDL arrange at least one from data base, by MDL
Initial data copy to each from data base so that each from data base, preserve MDL
Initial data, performs the operation identical with the operation of MDL each so that each from data base
Tong Bu with MDL from data base, it is achieved from data base's backup to MDL, when detection master data
When storehouse sends fault, utilize and arbitrary replace MDL from data base, outside need operation MDL
During data, can also be realized from the data of data base by operation, therefore, MDL breaks down also
Do not interfere with as outside the operation of data in MDL, improve the reliability of data base.
In an embodiment of the present invention, before described S2, also include:
Described MDL creates and replicates account, authorize described duplication account REPLICATION
SLAVE authority；
Described duplication account is utilized to connect described MDL；
Described S2, including:
Utilize the REPLICATION SLAVE authority of described duplication account, by described MDL Central Plains
Beginning data copy to each described from data base.
In the present embodiment, owing to the operation of MDL is needed corresponding authority, in order to replicate master
Initial data in data base, provides corresponding REPLICATION by creating duplication account
SLAVE authority.When by replicating account and connecting MDL, that i.e. can replicate in MDL is former
Beginning data.Concrete, arbitrary password chain that can utilize this duplication account and this duplication account from data base
Receive MDL.
It addition, in order to avoid making the initial data in MDL can all copy to each from data
In storehouse, before step S2, also include: forbid MDL and each write behaviour from data base
Make.So can ensure that MDL and each will not write new data from data base, it is ensured that main number
Can all copy to each from data base according to the initial data in storehouse so that MDL and each from
Data in data base are identical.
In an embodiment of the present invention, before described S3, also include:
Open the binary log of described MDL；
Also include: in described binary log, record each operation of described MDL in real time；
Described S3, including:
Each operation of described MDL is obtained in real time from described binary log.
In the present embodiment, the binary log opening described MDL can be by entering MDL
Row configuration realizes, in order to make configuration take-effective, it is generally required to restart MDL.At MDL two
System daily record records each operation of MDL, the record of operation can be come by the form of event
Record.Concrete, binary log records all of DDL (the Data Definition of MDL
Language, DDL) and DML (Data Manipulation Language, data manipulation
Language).
It addition, so that MDL is connected from data base with arbitrary, it is also possible to MDL is carried out
Configuration, concrete, configure the mark from data base, such as: from the address of data base.For from data
Storehouse is also carried out similar configuration, concrete, the mark of configuration MDL, such as: the ground of MDL
Location.
When realizing each operation obtaining described MDL in real time from described binary log, permissible
Automatically obtain by arranging acquisition thread, concrete, by obtaining thread poll binary log, obtain
Each operation in binary log.
When performing S4, execution thread can be set, each behaviour got by performing thread to perform
Make.This ensure that MDL is consistent with data from data base.
In an embodiment of the present invention, described utilization arbitrary described replaces described MDL from data base,
Including:
The operation of described MDL is converted to by outside to be used for replacing described MDL from data
The operation in storehouse.
In the present embodiment, MDL is switched to from data base, by from database realizing MDL
All functions.Concrete, the address of the data base that outside accesses can be repaiied by the address of MDL
Change the address from data base for replacing described MDL into.For example, outside software A needs
Will operate the data of MDL, software A needs the address according to the MDL being configured
Access MDL, owing to MDL breaks down, it is impossible to realize accessing MDL, by main number
Switch over from data base according to storehouse, the address of data base in the configuration of software A is revised as from data base
Address, for software A, its operation does not change, according further to configuration data base
Address conduct interviews.
As a example by MYSQL, as in figure 2 it is shown, embodiments provide a kind of process data base's event
The method of barrier, in embodiments of the present invention, MDL and be all MYSQL from data base, the method
May comprise steps of:
Step 201: arrange from data base for MDL in advance.
MDL and be deployed in different servers from data base, such MDL services due to place
Device fault and when cannot normally work, the backup to MDL can also be realized from data base.Avoid working as
MDL with from data base the most on the same server time, cause due to the server failure at place
MDL all cannot normally work with from data base.Such that make the server at MDL place send out
Raw delay the faults such as machine time, can successfully switch from data base, make to replace MDL from data base.
It addition, in order to ensure that MDL and the data between data base replicate successfully, and in order to ensure
Master server can be substituted completely, therefore, to assure that MDL and the edition compatibility from data base from data base,
Concrete, it is ensured that identical with MDL version from the version of data base or from data base version ratio is main
Database version is higher.
Step 202: create in MDL and replicate account, authorizes duplication account REPLICATION
SLAVE authority.
Concrete, after duplication account has REPLICATION SLAVE authority, the most reproducible master data
Initial data in storehouse.
Step 203: utilize and replicate account connection MDL.
Concrete, it is possible to use replicating account will be connected with MDL from data base.
Step 204: utilize the REPLICATION SLAVE authority replicating account, by MDL
Initial data copies to from data base.
This process can be completed by from data base.
Step 205: open the binary log of MDL.
Binary log records corresponding information by binary system.
Step 206: record each operation of MDL in real time in binary log.
Step 207: obtain each operation of MDL in real time from binary log.
This step can be realized by from data base.Specifically, real time polling binary log, obtain two
Record in system daily record.
Step 208: performing the operation identical with the operation of MDL on data base.
By this step so that MDL keeps Tong Bu with the data from data base so that from data
Storehouse is referred to as the backup of MDL.
Step 209: whether detection MDL breaks down in real time, if it is, utilize from data base
Replace MDL.
For example, application A needs to read data A in MDL, after MDL breaks down,
Application A is directly from reading data A from data base.For application A, can be by application A's
The address of data base is revised as the address from data base by the address of MDL and is realized replacing from data base
MDL.
Concrete, the application of outside need operation MDL all switches to and operates from data base.
This step can be realized by middleware, and the operation of MDL will be converted to from number by this middleware
Operation according to storehouse.
In embodiments of the present invention, it is possible to use the asynchronous replication function of MYSQL,
The data of MDL are copied to from data base.In the embodiment of the present invention, the operation to data base is permissible
Including: read, write, delete, revise, inquiry etc..
The problem that the embodiment of the present invention can effectively solve Single Point of Faliure.When MDL goes wrong,
Can be rapidly switched to from data base, it is ensured that system is properly functioning, simple and reliable.
As shown in Figure 3, Figure 4, a kind of device processing database failure is embodiments provided.
Device embodiment can be realized by software, it is also possible to realizes by the way of hardware or software and hardware combining.
For hardware view, as it is shown on figure 3, a kind of process database failure provided for the embodiment of the present invention
A kind of hardware structure diagram of device place equipment, except the processor shown in Fig. 3, internal memory, network connect
Outside mouth and nonvolatile memory, in embodiment, the equipment at device place generally can also include it
His hardware, such as the forwarding chip etc. of responsible process message.As a example by implemented in software, as shown in Figure 4,
As the device on a logical meaning, it is that the CPU by its place equipment is by nonvolatile memory
Corresponding computer program instructions reads and runs formation in internal memory.A kind of process that the present embodiment provides
The device of database failure, including:
Unit 401 is set, for arranging at least one from data base for MDL；
Copied cells 402, each described from data for initial data in described MDL is copied to
In storehouse；
Acquiring unit 403, for each operation of the described MDL of acquisition in real time；
Performance element 404, for each described perform from data base identical with described MDL
Operation；
For in real time, detector unit 405, detects whether described MDL breaks down, when detecting
State MDL to break down, utilize and arbitrary described replace described MDL from data base.
In an embodiment of the present invention, also include: creating unit, for creating in described MDL
Replicate account, authorize described duplication account REPLICATION SLAVE authority；
Connect unit, be used for utilizing described duplication account to connect described MDL；
Described copied cells, for utilizing the REPLICATION SLAVE authority of described duplication account,
Initial data in described MDL is copied to each described from data base.
In an embodiment of the present invention, also include: open unit, for opening the two of described MDL
System daily record；
Also include: record unit, for recording described MDL in described binary log in real time
Each operation；
Described acquiring unit, for obtaining each of described MDL in real time from described binary log
Operation.
In an embodiment of the present invention, described detector unit perform described utilize arbitrary described from data base
When replacing described MDL, for the operation of described MDL is converted to being used for replacing by outside
The operation from data base of described MDL.
Embodiments provide the system of a kind of data base, including:
MDL, the process database failure that at least one is arbitrary from data base, the embodiment of the present invention
Device.
As it is shown in figure 5, the system of a kind of data base of embodiment of the present invention offer, including:
MDL 501, from data base 502, the embodiment of the present invention arbitrary database failure that processes
Device 503.
In an embodiment of the present invention, described MDL with described at least one be deployed in not from data base
On same server.
The contents such as the information between each unit in said apparatus is mutual, execution process, due to the present invention
Embodiment of the method is based on same design, and particular content can be found in the narration in the inventive method embodiment, this
Place repeats no more.
Each embodiment of the present invention at least has the advantages that
1, in embodiments of the present invention, for MDL arrange at least one from data base, by MDL
In initial data copy to each from data base so that each from data base, preserve MDL
Initial data, from data base, perform the operation identical with the operation of MDL each so that often
Individual Tong Bu with MDL from data base, it is achieved from data base's backup to MDL, when detecting main number
When sending fault according to storehouse, utilize and arbitrary replace MDL from data base, outside need operation MDL
Data time, can also be realized from the data of data base by operation, therefore, MDL breaks down
Do not interfere with as outside the operation of data in MDL, improve the reliability of data base yet.
2, the embodiment of the present invention can effectively solve the problem of Single Point of Faliure, when MDL goes wrong
Time, can be rapidly switched to from data base, it is ensured that system is just run, simple and reliable.
It should be noted that in this article, the relational terms of such as first and second etc be used merely to by
One entity or operation separate with another entity or operating space, and not necessarily require or imply this
Relation or the order of any this reality is there is between a little entities or operation.And, term " includes ",
" comprise " or its any other variant is intended to comprising of nonexcludability, so that include that one is
The process of row key element, method, article or equipment not only include those key elements, but also include the brightest
Other key elements really listed, or also include intrinsic for this process, method, article or equipment
Key element.In the case of there is no more restriction, statement " include a 〃 " and limit
Key element, it is not excluded that there is also another in including the process of described key element, method, article or equipment
Outer same factor.
One of ordinary skill in the art will appreciate that: realize all or part of step of said method embodiment
Can be completed by the hardware that programmed instruction is relevant, aforesaid program can be stored in embodied on computer readable
Storage medium in, this program upon execution, performs to include the step of said method embodiment；And it is aforementioned
Storage medium include: various Jie that can store program code such as ROM, RAM, magnetic disc or CD
In matter.
Last it should be understood that the foregoing is only presently preferred embodiments of the present invention, it is merely to illustrate this
The technical scheme of invention, is not intended to limit protection scope of the present invention.All spirit in the present invention and former
Any modification, equivalent substitution and improvement etc. done within then, are all contained in protection scope of the present invention.
Claims (10)
1. the method processing database failure, it is characterised in that including:
S1: for MDL, at least one is set from data base in advance；
S2: in advance initial data in described MDL is copied to each described from data base；
S3: obtain each operation of described MDL in real time；
S4: in each described operation that execution is identical with the operation of described MDL from data base；
S5: in real time detect whether described MDL breaks down, if it is, utilize arbitrary described from
Data base replaces described MDL.
Method the most according to claim 1, it is characterised in that
Before described S2, also include:
Described MDL creates and replicates account, authorize described duplication account REPLICATION
SLAVE authority；
Described duplication account is utilized to connect described MDL；
Described S2, including:
Utilize the REPLICATION SLAVE authority of described duplication account, by described MDL Central Plains
Beginning data copy to each described from data base.
Method the most according to claim 1, it is characterised in that
Before described S3, also include: open the binary log of described MDL；
Also include: in described binary log, record each operation of described MDL in real time；
Described S3, including:
Each operation of described MDL is obtained in real time from described binary log.
4. according to described method arbitrary in claim 1-3, it is characterised in that
Described utilization arbitrary described replaces described MDL from data base, including:
The operation of described MDL is converted to by outside to be used for replacing described MDL from data
The operation in storehouse.
5. the device processing database failure, it is characterised in that including:
Unit is set, for arranging at least one from data base for MDL；
Copied cells, each described from data base for initial data in described MDL is copied to；
Acquiring unit, for each operation of the described MDL of acquisition in real time；
Performance element, in each described operation that execution is identical with described MDL from data base；
For in real time, detector unit, detects whether described MDL breaks down, when described master being detected
Data base breaks down, and utilizes and arbitrary described replaces described MDL from data base.
Device the most according to claim 5, it is characterised in that
Also include: creating unit, replicate account for creating in described MDL, authorize described multiple
Account REPLICATION SLAVE authority processed；
Connect unit, be used for utilizing described duplication account to connect described MDL；
Described copied cells, for utilizing the REPLICATION SLAVE authority of described duplication account,
Initial data in described MDL is copied to each described from data base.
Device the most according to claim 5, it is characterised in that
Also include: open unit, for opening the binary log of described MDL；
Also include: record unit, for recording described MDL in described binary log in real time
Each operation；
Described acquiring unit, for obtaining each of described MDL in real time from described binary log
Operation.
8. according to described device arbitrary in claim 5-7, it is characterised in that
Described detector unit perform described utilize arbitrary described replace described MDL from data base time,
For the operation of described MDL is converted to by outside to be used for replacing described MDL from data
The operation in storehouse.
9. the system of a data base, it is characterised in that including:
MDL, at least one is from data base, process data as described in arbitrary claim 5-8
The device of storehouse fault.
System the most according to claim 9, it is characterised in that including:
Described MDL with described at least one from data base dispose on a different server.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610370627.5A CN106021030A (en) | 2016-05-30 | 2016-05-30 | Database system and database fault processing method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610370627.5A CN106021030A (en) | 2016-05-30 | 2016-05-30 | Database system and database fault processing method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106021030A true CN106021030A (en) | 2016-10-12 |
Family
ID=57092621
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610370627.5A Pending CN106021030A (en) | 2016-05-30 | 2016-05-30 | Database system and database fault processing method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106021030A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108243209A (en) * | 2016-12-23 | 2018-07-03 | 深圳市优朋普乐传媒发展有限公司 | A kind of method of data synchronization and device |
| CN108932338A (en) * | 2018-07-11 | 2018-12-04 | 北京百度网讯科技有限公司 | Data-updating method, device, equipment and medium |
| WO2019047072A1 (en) * | 2017-09-06 | 2019-03-14 | 富璟科技（深圳）有限公司 | Database detection method and terminal |
| CN110019500A (en) * | 2017-08-21 | 2019-07-16 | 东软集团股份有限公司 | A kind of copy group method for monitoring state, device, equipment and storage medium |
| CN112306794A (en) * | 2020-09-28 | 2021-02-02 | 国网吉林省电力有限公司信息通信公司 | Automatic processing method and device for typical fault scene of database |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101414946A (en) * | 2008-11-21 | 2009-04-22 | 上海爱数软件有限公司 | Method and medium server for remote data backup |
| US20120109906A1 (en) * | 2006-12-07 | 2012-05-03 | Robert Edward Wagner | Method for identifying logical data discrepancies between database replicas in a database cluster using enhanced transaction logging |
| US20130117237A1 (en) * | 2011-11-07 | 2013-05-09 | Sap Ag | Distributed Database Log Recovery |
| US20140164831A1 (en) * | 2010-12-23 | 2014-06-12 | Mongodb, Inc. | Method and apparatus for maintaining replica sets |
| CN105095486A (en) * | 2015-08-17 | 2015-11-25 | 浪潮(北京)电子信息产业有限公司 | Cluster database disaster recovery method and device |
| CN105468475A (en) * | 2015-11-16 | 2016-04-06 | 北京奇虎科技有限公司 | Backup method and backup device of database |
-
2016
- 2016-05-30 CN CN201610370627.5A patent/CN106021030A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20120109906A1 (en) * | 2006-12-07 | 2012-05-03 | Robert Edward Wagner | Method for identifying logical data discrepancies between database replicas in a database cluster using enhanced transaction logging |
| CN101414946A (en) * | 2008-11-21 | 2009-04-22 | 上海爱数软件有限公司 | Method and medium server for remote data backup |
| US20140164831A1 (en) * | 2010-12-23 | 2014-06-12 | Mongodb, Inc. | Method and apparatus for maintaining replica sets |
| US20130117237A1 (en) * | 2011-11-07 | 2013-05-09 | Sap Ag | Distributed Database Log Recovery |
| CN105095486A (en) * | 2015-08-17 | 2015-11-25 | 浪潮(北京)电子信息产业有限公司 | Cluster database disaster recovery method and device |
| CN105468475A (en) * | 2015-11-16 | 2016-04-06 | 北京奇虎科技有限公司 | Backup method and backup device of database |
Non-Patent Citations (1)
| Title |
|---|
| 简简单单: "mysql数据库主从复制部署笔记", 《HTTP://WWW.111CN.NET/DATABASE/MYSQL/59749.HTM》 * |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108243209A (en) * | 2016-12-23 | 2018-07-03 | 深圳市优朋普乐传媒发展有限公司 | A kind of method of data synchronization and device |
| CN110019500A (en) * | 2017-08-21 | 2019-07-16 | 东软集团股份有限公司 | A kind of copy group method for monitoring state, device, equipment and storage medium |
| WO2019047072A1 (en) * | 2017-09-06 | 2019-03-14 | 富璟科技（深圳）有限公司 | Database detection method and terminal |
| CN108932338A (en) * | 2018-07-11 | 2018-12-04 | 北京百度网讯科技有限公司 | Data-updating method, device, equipment and medium |
| CN108932338B (en) * | 2018-07-11 | 2021-08-10 | 北京百度网讯科技有限公司 | Data updating method, device, equipment and medium |
| CN112306794A (en) * | 2020-09-28 | 2021-02-02 | 国网吉林省电力有限公司信息通信公司 | Automatic processing method and device for typical fault scene of database |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106021030A (en) | Database system and database fault processing method and device | |
| US8489558B2 (en) | Distributed file system logging | |
| US9129058B2 (en) | Application monitoring through continuous record and replay | |
| CN104932965B (en) | Object method for real-time monitoring and device | |
| CN100395717C (en) | Method and system for monitoring hard-disk damage | |
| CN106933843B (en) | Database heartbeat detection method and device | |
| US9753792B2 (en) | Method and system for byzantine fault tolerant data replication | |
| CN102810111A (en) | Implementation method and system for keeping high availability of Oracle database service | |
| CN104036043A (en) | High availability method of MYSQL and managing node | |
| CN104462612A (en) | Method and device for monitoring database information | |
| US8762662B1 (en) | Method and apparatus for application migration validation | |
| CN102567478A (en) | Online fault verification in a file system | |
| US8290992B2 (en) | File management method, file management device, and program | |
| US20150242599A1 (en) | Cluster license server | |
| CN105183799B (en) | Authority management method and client | |
| US20160110122A1 (en) | Data archiving system and method | |
| CN109933351A (en) | A kind of method and apparatus of reparation and upgrading linux system | |
| CN110798347B (en) | Service state detection method, device, equipment and storage medium | |
| CN114996955A (en) | Target range environment construction method and device for cloud-originated chaotic engineering experiment | |
| CN114238324A (en) | Checking method and device for host station, electronic equipment and storage medium | |
| CN112486718A (en) | Database fault automatic switching method and device and computer storage medium | |
| CN105095030B (en) | Hard disk corruptions processing method and processing device based on Hadoop | |
| CN111198783B (en) | Data access method, device, system, equipment and storage medium | |
| CN107707402B (en) | Management system and management method for service arbitration in distributed system | |
| CN108563578A (en) | SDK compatibility detection method, device, equipment and readable storage medium storing program for executing |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20161012 |