Method, device and database system for database backup

A database and main database technology, applied in the database field, can solve the problems of inaccurate data analysis, affecting the normal use of the main database, and inability to precisely control the time point of backup completion, and achieve the effect of fast backup

Inactive Publication Date: 2018-10-16
吉林亿联银行股份有限公司
View PDF6 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, as the amount of data continues to increase, the time for backup and recovery is getting longer and longer, which will affect the normal use of the master database. In addition, due to business needs, the backup time of the slave database needs to be a specific time point. For example, at 24 o'clock on the last working day of each month, the time point of the backup is the time point when the database backup is completed, and the time point when the backup is completed cannot be precisely controlled, which will lead to inaccurate data analysis using the database sex

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method, device and database system for database backup
  • Method, device and database system for database backup
  • Method, device and database system for database backup

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0042] In this embodiment, the primary disk where the primary database is located is synchronized with another secondary disk to form a synchronous disk group, and the data on the primary disk is synchronized to the secondary disk through synchronization, thereby obtaining the backup database of the primary database on the secondary disk.

[0043] In this embodiment, the database is backed up based on a synchronous disk group. The synchronous disk group includes a master disk and a slave disk. A master database is created on the master disk, and the master database is a real-time business database.

[0044]A synchronous disk group is a disk group formed by synchronously storing two disks using synchronization technology. The primary disk in the synchronous disk group is the data source, and the secondary disk is the disk for the backup data. The primary disk and the secondary disk are made as synchronous After the disk group, as long as the two are in a synchronized state, all ...

Embodiment 2

[0061] The difference from Embodiment 1 is that in this embodiment, the slave disk is obtained by taking a snapshot of the master disk, so that the master database on the master disk is backed up to the slave disk, and the backup database of the master database is obtained on the slave disk.

[0062] In this embodiment, the backup of the database is based on the snapshot. The main database is created on the main disk. The main database is a real-time business database, that is, a database used in the production environment. The status of the database will also change accordingly.

[0063] refer to figure 2 As shown, when specifically performing a backup, in step S201, at a preset time point, a snapshot is taken of the primary disk to generate snapshot data of the primary disk, the snapshot data includes a backup database of the primary database, and the backup database for data processing.

[0064] The preset time point is a specific time point set according to business req...

Embodiment 3

[0074] The database backup method of the embodiment of the present invention has been described in detail above. In addition, the application also provides a database backup device corresponding to the above embodiment, corresponding to Embodiment 1. Refer to image 3 As shown, the database backup device includes:

[0075] Synchronization unit 300, configured to maintain the synchronization state of the master disk and the slave disk, the master disk and the slave disk are synchronous disk groups, a master database is created on the master disk, and the master database is real-time Operational business database;

[0076] The disconnection unit 310 is configured to disconnect the synchronization state of the master disk and the slave disk at a preset time point, so as to obtain a backup database of the master database on the slave disk, and the backup database is used for Perform data processing.

[0077] Further, the method further includes: a restoration unit 320, configure...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention provides a method, a device and a database system for database backup. A master database is created on a master disk, and the master database is a real-time operation business database,that is, a database used for real-time operation of the production environment. The data in the master disk is fully generated on a slave disk by means of synchronization or snapshot, thereby obtaining the backup database of the master database from the slave disk. In this method, the synchronous or snapshot storage between the master disk and the slave disk is a backup on the physical storage level of the database. When the synchronous is disconnected or snapshot is taken, the completely same data on the master disk can be obtained from the slave disk in a short time, and the backup speed ishigh. In addition, the time point of disconnection is the time point of completing the backup, the time point at which the snapshot is finished is the time point of completing backup, so that the timepoint of completing backup of the database can be precisely controlled.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a database backup method and device, and a database system. Background technique [0002] As the core of the information system, the database plays a vital role. In industries that require high data reliability, such as the banking industry, abnormal data will cause heavy losses. [0003] Generally, in the database system of the banking industry, there are two sets of databases, the master database and the slave database. Database, the data in the master database is regularly backed up to the slave database. When the master database fails, it can be switched to the slave database to continue working, and the slave database can be used for various statistics, analysis, auditing and other work. [0004] At present, all major database manufacturers have a database backup solution, mainly by fully backing up all database objects such as user tables, system tables, and indexes in t...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F11/14G06F17/30
CPCG06F11/1448G06F11/1469
Inventor 杨颖邹帮山卢秀红秦旭果
Owner 吉林亿联银行股份有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap