CN111143124A - Database automation recovery method and device and electronic equipment - Google Patents
Database automation recovery method and device and electronic equipment Download PDFInfo
- Publication number
- CN111143124A CN111143124A CN201911322983.XA CN201911322983A CN111143124A CN 111143124 A CN111143124 A CN 111143124A CN 201911322983 A CN201911322983 A CN 201911322983A CN 111143124 A CN111143124 A CN 111143124A
- Authority
- CN
- China
- Prior art keywords
- recovery
- binlog
- database
- time
- backup
- 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
- 238000011084 recovery Methods 0.000 title claims abstract description 90
- 238000000034 method Methods 0.000 title claims abstract description 44
- 238000012216 screening Methods 0.000 claims description 7
- 238000012545 processing Methods 0.000 abstract description 6
- 238000004590 computer program Methods 0.000 description 13
- 230000006870 function Effects 0.000 description 7
- 238000010586 diagram Methods 0.000 description 6
- 238000011156 evaluation Methods 0.000 description 5
- 230000003287 optical effect Effects 0.000 description 4
- 238000004891 communication Methods 0.000 description 3
- 230000008569 process Effects 0.000 description 3
- 230000000644 propagated effect Effects 0.000 description 2
- 230000000694 effects Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 239000013307 optical fiber Substances 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
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/1458—Management of the backup or restore process
- G06F11/1469—Backup restoration techniques
-
- 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/1471—Saving, restoring, recovering or retrying involving logging of persistent data for recovery
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2201/00—Indexing scheme relating to error detection, to error correction, and to monitoring
- G06F2201/80—Database-specific techniques
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Quality & Reliability (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the disclosure provides a database automatic recovery method, a database automatic recovery device and electronic equipment, belonging to the technical field of computers, wherein the method comprises the following steps: mounting a backup file and a binlog log corresponding to the backup file; initializing a database needing to be recovered; analyzing the starting time, the ending time, the starting position point and the ending position point of the binlog log at the same time when the binlog log is backed up; when recovery is carried out, backup snapshots and binlog logs which need to be applied can be rapidly screened out according to backup time and time points for selecting recovery, and corresponding recovery starting position points and recovery ending position points in the binlog logs are found out. By the processing scheme, the database can be automatically recovered.
Description
Technical Field
The present disclosure relates to the field of computer technologies, and in particular, to a database automation recovery method and apparatus, and an electronic device.
Background
With the advent of the big data era, the importance of data is self-evident, and the security of data is more and more important for enterprises, so how to accurately and quickly restore backed-up data becomes a main problem facing enterprises. The general use of binlog log recovery has two modes of specified position point recovery and time point recovery, and the two modes of recovery have some problems, are complex to operate and cannot be recovered accurately and quickly, so that the problem of partial data loss or data repetition is caused:
(1) specified location point recovery
The use of binlog logs for recovery at a given location point has the problem that it is unclear which location point corresponds to which time, and when there are multiple binlog logs, it is unclear which binlog logs are specifically applied.
(2) Specified point in time recovery
The problem of using binlog logs to recover at a given point in time is unclear as to which binlog logs are specifically applied, resulting in lost or duplicate data being recovered.
(3) The operation is complicated
In any recovery method, a lot of preparation work is required, and the recovery cannot be performed quickly.
Disclosure of Invention
In view of the above, embodiments of the present disclosure provide a method, an apparatus, and an electronic device for database automated recovery, so as to at least partially solve the problems in the prior art.
In a first aspect, an embodiment of the present disclosure provides an automated database recovery method, including:
mounting a backup file and a binlog log corresponding to the backup file;
initializing a database needing to be recovered;
analyzing the starting time, the ending time, the starting position point and the ending position point of the binlog log at the same time when the binlog log is backed up;
when recovery is carried out, backup snapshots and binlog logs which need to be applied can be rapidly screened out according to backup time and time points for selecting recovery, and corresponding recovery starting position points and recovery ending position points in the binlog logs are found out.
According to a specific implementation manner of the embodiment of the present disclosure, the mounting of the backup file and the binlog log corresponding to the backup file includes:
searching a storage directory where the backup file is located;
and mounting the backup file in the storage directory.
According to a specific implementation manner of the embodiment of the present disclosure, the mounting of the backup file and the binlog log corresponding to the backup file includes:
searching a storage path of the binlog log;
reading the binlog log from the storage path.
According to a specific implementation manner of the embodiment of the present disclosure, the initializing the database that needs to be restored includes:
loading an initialization instruction to a database needing to be recovered;
and initializing the database needing to be recovered based on the initialization instruction.
According to a specific implementation manner of the embodiment of the present disclosure, the initializing the database that needs to be restored includes:
judging the running state of a database needing to be recovered;
and when the database needing to be recovered is in the running state, executing restart operation on the database needing to be recovered.
According to a specific implementation manner of the embodiment of the present disclosure, the analyzing the beginning time, the ending time, the beginning position point, and the ending position point of the binlog log at the same time when the binlog log is backed up includes:
acquiring an operation instruction of a backup binlog log;
and analyzing the content in the binlog log based on the operation instruction.
According to a specific implementation manner of the embodiment of the present disclosure, when performing recovery, the method can quickly screen backup snapshots and binlog logs that need to be applied according to backup time and time point of selective recovery, and find out corresponding location points of starting recovery and location points of ending recovery in the binlog logs, including:
acquiring a recovery operation instruction;
and screening backup snapshots and binlog logs which need to be applied based on the recovery operation instruction.
In a second aspect, an embodiment of the present disclosure provides an automatic database recovery apparatus, including:
the mounting module is used for mounting the backup file and the binlog log corresponding to the backup file;
the initialization module is used for initializing the database needing to be recovered;
the analysis module is used for simultaneously analyzing the start time, the end time, the start position point and the end position point of the binlog when the binlog is backed up;
and the execution module is used for rapidly screening backup snapshots and binlog logs which need to be applied according to the backup time and the time point of selective recovery during recovery, and finding out corresponding position points for starting recovery and position points for finishing recovery in the binlog logs.
In a third aspect, an embodiment of the present disclosure further provides an electronic device, where the electronic device includes:
at least one processor; and the number of the first and second groups,
a memory communicatively coupled to the at least one processor; wherein,
the memory stores instructions executable by the at least one processor to enable the at least one processor to perform the database automation recovery method of the first aspect or any implementation manner of the first aspect.
In a fourth aspect, the disclosed embodiments also provide a non-transitory computer-readable storage medium storing computer instructions for causing a computer to execute the database automation recovery method in the first aspect or any implementation manner of the first aspect.
In a fifth aspect, the present disclosure also provides a computer program product, which includes a computer program stored on a non-transitory computer-readable storage medium, the computer program including program instructions, which, when executed by a computer, cause the computer to execute the database automation recovery method in the first aspect or any implementation manner of the first aspect.
The automatic database recovery scheme in the embodiment of the disclosure comprises mounting a backup file and a binlog log corresponding to the backup file; initializing a database needing to be recovered; analyzing the starting time, the ending time, the starting position point and the ending position point of the binlog log at the same time when the binlog log is backed up; when recovery is carried out, backup snapshots and binlog logs which need to be applied can be rapidly screened out according to backup time and time points for selecting recovery, and corresponding recovery starting position points and recovery ending position points in the binlog logs are found out. According to the invention, the database backup file and the binlog log are restored, so that the restoration function of any time point in the database operation time is realized quickly and accurately, and the restoration is restored to automatic restoration, so that persons who do not know the mysql database restoration mechanism can complete restoration in one step, and a large amount of labor force of operation and maintenance personnel is liberated
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present disclosure, the drawings needed to be used in the embodiments will be briefly described below, and it is apparent that the drawings in the following description are only some embodiments of the present disclosure, and it is obvious for those skilled in the art that other drawings can be obtained according to the drawings without creative efforts.
Fig. 1 is a flowchart of a database automation recovery method according to an embodiment of the present disclosure;
FIG. 2 is a flow chart of another database automation recovery method provided by the embodiments of the present disclosure;
fig. 3 is a schematic structural diagram of an automatic database recovery apparatus according to an embodiment of the present disclosure;
fig. 4 is a schematic view of an electronic device provided in an embodiment of the present disclosure.
Detailed Description
The embodiments of the present disclosure are described in detail below with reference to the accompanying drawings.
The embodiments of the present disclosure are described below with specific examples, and other advantages and effects of the present disclosure will be readily apparent to those skilled in the art from the disclosure in the specification. It is to be understood that the described embodiments are merely illustrative of some, and not restrictive, of the embodiments of the disclosure. The disclosure may be embodied or carried out in various other specific embodiments, and various modifications and changes may be made in the details within the description without departing from the spirit of the disclosure. It is to be noted that the features in the following embodiments and examples may be combined with each other without conflict. All other embodiments, which can be derived by a person skilled in the art from the embodiments disclosed herein without making any creative effort, shall fall within the protection scope of the present disclosure.
It is noted that various aspects of the embodiments are described below within the scope of the appended claims. It should be apparent that the aspects described herein may be embodied in a wide variety of forms and that any specific structure and/or function described herein is merely illustrative. Based on the disclosure, one skilled in the art should appreciate that one aspect described herein may be implemented independently of any other aspects and that two or more of these aspects may be combined in various ways. For example, an apparatus may be implemented and/or a method practiced using any number of the aspects set forth herein. Additionally, such an apparatus may be implemented and/or such a method may be practiced using other structure and/or functionality in addition to one or more of the aspects set forth herein.
It should be noted that the drawings provided in the following embodiments are only for illustrating the basic idea of the present disclosure, and the drawings only show the components related to the present disclosure rather than the number, shape and size of the components in actual implementation, and the type, amount and ratio of the components in actual implementation may be changed arbitrarily, and the layout of the components may be more complicated.
In addition, in the following description, specific details are provided to facilitate a thorough understanding of the examples. However, it will be understood by those skilled in the art that the aspects may be practiced without these specific details.
The embodiment of the disclosure provides an automatic database recovery method. The database automation recovery method provided by the embodiment may be executed by a computing device, which may be implemented as software or implemented as a combination of software and hardware, and may be integrally provided in a server, a client, and the like.
Referring to fig. 1 and fig. 2, a database automation recovery method in an embodiment of the present disclosure may include the following steps:
s101, mounting the backup file and the binlog log corresponding to the backup file.
Specifically, mount operations may be performed on the backup file and the binlog log by searching a storage directory in which the backup file is located and a storage path of the binlog log file.
And S102, initializing the database needing to be restored.
The initialization operation may be performed on the database in various manners, for example, the initialization operation may be performed on the database that needs to be restored by means of an initialization instruction. For the database which is already in the running state, the initialization operation can be executed by means of restarting.
S103, when backing up the binlog, the start time, the end time, the start position point and the end position point of the binlog are analyzed at the same time.
S104, when the recovery is carried out, the backup snapshot and the binlog log which need to be applied can be rapidly screened out according to the backup time and the time point of selecting the recovery, and the corresponding position point for starting the recovery and the position point for finishing the recovery in the binlog log are found out.
In the process of implementing steps S101 to S104, the present invention aims to quickly and accurately restore to any time point between the earliest backup time point and the latest log time by using the way of backing up the file + binlog log. The method comprises the steps of analyzing the starting time, the ending time, the starting position point and the ending position point of the binlog log simultaneously when the binlog log is backed up, rapidly screening backup snapshots and the binlog which need to be applied according to the backup time and the time point of selective recovery when recovery is carried out, and finding out the corresponding position point of starting recovery and the position point of ending recovery in the binlog, so that recovery to the specified time point is rapidly and accurately carried out.
According to a specific implementation manner of the embodiment of the present disclosure, the mounting of the backup file and the binlog log corresponding to the backup file includes:
searching a storage directory where the backup file is located;
and mounting the backup file in the storage directory.
According to a specific implementation manner of the embodiment of the present disclosure, the mounting of the backup file and the binlog log corresponding to the backup file includes:
searching a storage path of the binlog log;
reading the binlog log from the storage path.
According to a specific implementation manner of the embodiment of the present disclosure, the initializing the database that needs to be restored includes:
loading an initialization instruction to a database needing to be recovered;
and initializing the database needing to be recovered based on the initialization instruction.
According to a specific implementation manner of the embodiment of the present disclosure, the initializing the database that needs to be restored includes:
judging the running state of a database needing to be recovered;
and when the database needing to be recovered is in the running state, executing restart operation on the database needing to be recovered.
According to a specific implementation manner of the embodiment of the present disclosure, the analyzing the beginning time, the ending time, the beginning position point, and the ending position point of the binlog log at the same time when the binlog log is backed up includes:
acquiring an operation instruction of a backup binlog log;
and analyzing the content in the binlog log based on the operation instruction.
According to a specific implementation manner of the embodiment of the present disclosure, when performing recovery, the method can quickly screen backup snapshots and binlog logs that need to be applied according to backup time and time point of selective recovery, and find out corresponding location points of starting recovery and location points of ending recovery in the binlog logs, including:
acquiring a recovery operation instruction;
and screening backup snapshots and binlog logs which need to be applied based on the recovery operation instruction.
Corresponding to the above method embodiment, referring to fig. 3, the embodiment of the present disclosure further provides a database automation recovery apparatus 30, including:
a mounting module 301, configured to mount a backup file and a binlog log corresponding to the backup file;
an initialization module 302, configured to perform initialization processing on a database that needs to be restored;
the parsing module 303 is configured to parse a start time, an end time, a start position point, and an end position point of a binlog at the same time when the binlog is backed up;
the execution module 304 is configured to quickly screen out the backup snapshot and the binlog log that need to be applied according to the backup time and the time point of selecting recovery when performing recovery, and find out a corresponding location point where recovery starts and a location point where recovery ends in the binlog log. .
For parts not described in detail in this embodiment, reference is made to the contents described in the above method embodiments, which are not described again here.
Referring to fig. 4, an embodiment of the present disclosure also provides an electronic device 60, including:
at least one processor; and the number of the first and second groups,
a memory communicatively coupled to the at least one processor; wherein,
the memory stores instructions executable by the at least one processor to enable the at least one processor to perform the database automation recovery method of the preceding method embodiment.
The disclosed embodiments also provide a non-transitory computer-readable storage medium storing computer instructions for causing the computer to perform the database automated recovery method in the aforementioned method embodiments.
The disclosed embodiments also provide a computer program product comprising a computer program stored on a non-transitory computer readable storage medium, the computer program comprising program instructions which, when executed by a computer, cause the computer to perform the database automation recovery method in the aforementioned method embodiments.
Referring now to FIG. 4, a block diagram of an electronic device 60 suitable for use in implementing embodiments of the present disclosure is shown. The electronic devices in the embodiments of the present disclosure may include, but are not limited to, mobile terminals such as mobile phones, notebook computers, digital broadcast receivers, PDAs (personal digital assistants), PADs (tablet computers), PMPs (portable multimedia players), in-vehicle terminals (e.g., car navigation terminals), and the like, and fixed terminals such as digital TVs, desktop computers, and the like. The electronic device shown in fig. 4 is only an example, and should not bring any limitation to the functions and the scope of use of the embodiments of the present disclosure.
As shown in fig. 4, the electronic device 60 may include a processing means (e.g., a central processing unit, a graphics processor, etc.) 601 that may perform various appropriate actions and processes in accordance with a program stored in a Read Only Memory (ROM)602 or a program loaded from a storage means 608 into a Random Access Memory (RAM) 603. In the RAM 603, various programs and data necessary for the operation of the electronic apparatus 60 are also stored. The processing device 601, the ROM602, and the RAM 603 are connected to each other via a bus 604. An input/output (I/O) interface 605 is also connected to bus 604.
Generally, the following devices may be connected to the I/O interface 605: input devices 606 including, for example, a touch screen, touch pad, keyboard, mouse, image sensor, microphone, accelerometer, gyroscope, etc.; output devices 607 including, for example, a Liquid Crystal Display (LCD), a speaker, a vibrator, and the like; storage 608 including, for example, tape, hard disk, etc.; and a communication device 609. The communication means 609 may allow the electronic device 60 to communicate with other devices wirelessly or by wire to exchange data. While the figures illustrate an electronic device 60 having various means, it is to be understood that not all illustrated means are required to be implemented or provided. More or fewer devices may alternatively be implemented or provided.
In particular, according to an embodiment of the present disclosure, the processes described above with reference to the flowcharts may be implemented as computer software programs. For example, embodiments of the present disclosure include a computer program product comprising a computer program embodied on a computer readable medium, the computer program comprising program code for performing the method illustrated in the flow chart. In such an embodiment, the computer program may be downloaded and installed from a network via the communication means 609, or may be installed from the storage means 608, or may be installed from the ROM 602. The computer program, when executed by the processing device 601, performs the above-described functions defined in the methods of the embodiments of the present disclosure.
It should be noted that the computer readable medium in the present disclosure can be a computer readable signal medium or a computer readable storage medium or any combination of the two. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples of the computer readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the present disclosure, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. In contrast, in the present disclosure, a computer readable signal medium may comprise a propagated data signal with computer readable program code embodied therein, either in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to: electrical wires, optical cables, RF (radio frequency), etc., or any suitable combination of the foregoing.
The computer readable medium may be embodied in the electronic device; or may exist separately without being assembled into the electronic device.
The computer readable medium carries one or more programs which, when executed by the electronic device, cause the electronic device to: acquiring at least two internet protocol addresses; sending a node evaluation request comprising the at least two internet protocol addresses to node evaluation equipment, wherein the node evaluation equipment selects the internet protocol addresses from the at least two internet protocol addresses and returns the internet protocol addresses; receiving an internet protocol address returned by the node evaluation equipment; wherein the obtained internet protocol address indicates an edge node in the content distribution network.
Alternatively, the computer readable medium carries one or more programs which, when executed by the electronic device, cause the electronic device to: receiving a node evaluation request comprising at least two internet protocol addresses; selecting an internet protocol address from the at least two internet protocol addresses; returning the selected internet protocol address; wherein the received internet protocol address indicates an edge node in the content distribution network.
Computer program code for carrying out operations for aspects of the present disclosure may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, Smalltalk, C + +, and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or the connection may be made to an external computer (for example, through the Internet using an Internet service provider).
The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
The units described in the embodiments of the present disclosure may be implemented by software or hardware. Where the name of a unit does not in some cases constitute a limitation of the unit itself, for example, the first retrieving unit may also be described as a "unit for retrieving at least two internet protocol addresses".
It should be understood that portions of the present disclosure may be implemented in hardware, software, firmware, or a combination thereof.
The above description is only for the specific embodiments of the present disclosure, but the scope of the present disclosure is not limited thereto, and any changes or substitutions that can be easily conceived by those skilled in the art within the technical scope of the present disclosure should be covered within the scope of the present disclosure. Therefore, the protection scope of the present disclosure shall be subject to the protection scope of the claims.
Claims (10)
1. An automated database recovery method, comprising:
mounting a backup file and a binlog log corresponding to the backup file;
initializing a database needing to be recovered;
analyzing the starting time, the ending time, the starting position point and the ending position point of the binlog log at the same time when the binlog log is backed up;
when recovery is carried out, backup snapshots and binlog logs which need to be applied can be rapidly screened out according to backup time and time points for selecting recovery, and corresponding recovery starting position points and recovery ending position points in the binlog logs are found out.
2. The method of claim 1, wherein the mounting the backup file and the binlog log corresponding to the backup file comprises:
searching a storage directory where the backup file is located;
and mounting the backup file in the storage directory.
3. The method of claim 1, wherein the mounting the backup file and the binlog log corresponding to the backup file comprises:
searching a storage path of the binlog log;
reading the binlog log from the storage path.
4. The method according to claim 1, wherein initializing the database to be restored comprises:
loading an initialization instruction to a database needing to be recovered;
and initializing the database needing to be recovered based on the initialization instruction.
5. The method according to claim 1, wherein initializing the database to be restored comprises:
judging the running state of a database needing to be recovered;
and when the database needing to be recovered is in the running state, executing restart operation on the database needing to be recovered.
6. The method of claim 1, wherein parsing out a start time, an end time, a start position point, and an end position point of a binlog log simultaneously when the binlog log is backed up comprises:
acquiring an operation instruction of a backup binlog log;
and analyzing the content in the binlog log based on the operation instruction.
7. The method of claim 1, wherein the rapidly screening backup snapshots and binlog logs that need to be applied according to the backup time and the time point of selective recovery when performing recovery, and finding out corresponding recovery start location points and recovery end location points in the binlog logs comprises:
acquiring a recovery operation instruction;
and screening backup snapshots and binlog logs which need to be applied based on the recovery operation instruction.
8. An automated database recovery apparatus, comprising:
the mounting module is used for mounting the backup file and the binlog log corresponding to the backup file;
the initialization module is used for initializing the database needing to be recovered;
the analysis module is used for simultaneously analyzing the start time, the end time, the start position point and the end position point of the binlog when the binlog is backed up;
and the execution module is used for rapidly screening backup snapshots and binlog logs which need to be applied according to the backup time and the time point of selective recovery during recovery, and finding out corresponding position points for starting recovery and position points for finishing recovery in the binlog logs.
9. An electronic device, characterized in that the electronic device comprises:
at least one processor; and the number of the first and second groups,
a memory communicatively coupled to the at least one processor; wherein,
the memory stores instructions executable by the at least one processor to enable the at least one processor to perform the database automation recovery method of any one of the preceding claims 1-7.
10. A non-transitory computer readable storage medium storing computer instructions for causing a computer to perform the database automated recovery method of any of the preceding claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911322983.XA CN111143124A (en) | 2019-12-19 | 2019-12-19 | Database automation recovery method and device and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911322983.XA CN111143124A (en) | 2019-12-19 | 2019-12-19 | Database automation recovery method and device and electronic equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111143124A true CN111143124A (en) | 2020-05-12 |
Family
ID=70519084
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911322983.XA Pending CN111143124A (en) | 2019-12-19 | 2019-12-19 | Database automation recovery method and device and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111143124A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20160026536A1 (en) * | 2014-07-25 | 2016-01-28 | Netapp, Inc. | Recovery path selection during database restore |
| CN105373448A (en) * | 2015-10-27 | 2016-03-02 | 北京百度网讯科技有限公司 | Method and system for recovering failure data in database |
| CN107018507A (en) * | 2017-03-22 | 2017-08-04 | 武汉虹信通信技术有限责任公司 | A kind of evolution block core restarts restoration methods |
| CN107256182A (en) * | 2017-05-03 | 2017-10-17 | 上海上讯信息技术股份有限公司 | A kind of method and apparatus of database restoration |
| CN108205482A (en) * | 2017-12-29 | 2018-06-26 | 广州鼎甲计算机科技有限公司 | File mount restoration methods |
-
2019
- 2019-12-19 CN CN201911322983.XA patent/CN111143124A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20160026536A1 (en) * | 2014-07-25 | 2016-01-28 | Netapp, Inc. | Recovery path selection during database restore |
| CN105373448A (en) * | 2015-10-27 | 2016-03-02 | 北京百度网讯科技有限公司 | Method and system for recovering failure data in database |
| CN107018507A (en) * | 2017-03-22 | 2017-08-04 | 武汉虹信通信技术有限责任公司 | A kind of evolution block core restarts restoration methods |
| CN107256182A (en) * | 2017-05-03 | 2017-10-17 | 上海上讯信息技术股份有限公司 | A kind of method and apparatus of database restoration |
| CN108205482A (en) * | 2017-12-29 | 2018-06-26 | 广州鼎甲计算机科技有限公司 | File mount restoration methods |
Non-Patent Citations (2)
| Title |
|---|
| GOETZ GRAEFE: "Definition, detection, and recovery of single-page failures, a fourth class of database failures" * |
| 周继恩;尹祥龙;魏丹;: "银行卡跨行交易系统群的故障分析方法" * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111813641B (en) | Method, device, medium and equipment for collecting crash information | |
| CN111597065B (en) | Method and device for collecting equipment information | |
| CN107644075B (en) | Method and device for collecting page information | |
| CN111290797A (en) | Page switching method, client, server, electronic equipment and system | |
| CN111198859A (en) | Data processing method and device, electronic equipment and computer readable storage medium | |
| CN112016284B (en) | Electronic form processing method and device | |
| CN111198777A (en) | Data processing method, device, terminal and storage medium | |
| CN111258803B (en) | Collapse positioning method and device and electronic equipment | |
| CN110221857A (en) | The problem of application program restorative procedure, device, electronic equipment and storage medium | |
| CN110673986A (en) | Memory operation abnormity capturing method, device, terminal and storage medium | |
| CN111897827B (en) | Data updating method and system for data warehouse and electronic equipment | |
| CN112291121B (en) | Data processing method and related equipment | |
| CN111177260A (en) | Database remote copying method and device and electronic equipment | |
| CN111198853B (en) | Data processing method, device, electronic equipment and computer readable storage medium | |
| CN111625291A (en) | Automatic iteration method and device of data processing model and electronic equipment | |
| CN111143124A (en) | Database automation recovery method and device and electronic equipment | |
| CN112422648B (en) | Data synchronization method and system | |
| CN114968644A (en) | System software dump method and device, electronic equipment and readable storage medium | |
| CN111625326B (en) | Task pipeline execution method and device and electronic equipment | |
| CN112882921B (en) | Fault simulation method and device | |
| CN112052128B (en) | Disaster recovery method and device and electronic equipment | |
| CN111382057A (en) | Test case generation method, test method and device, server and storage medium | |
| CN116955014A (en) | Data back-shifting method, device, medium and electronic equipment | |
| CN117768443A (en) | Method, system, equipment and storage medium for replacing client center address | |
| CN117294875A (en) | Method and apparatus for video editing |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |