Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Database backup system and backup method and slave database server of database backup system

A backup system and database technology, applied in the database field, can solve problems such as unbalanced storage volume and traffic flow, small data volume growth, wasted storage space, etc., and achieve the effects of avoiding storage space shortage, saving storage space, and improving reliability

Active Publication Date: 2013-01-16
SINA COM TECH (CHINA) CO LTD
View PDF5 Cites 42 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0009] However, the inventors of the present invention have found that as time goes by, the data volumes of databases based on different businesses, or different databases of the same business, increase unevenly; the data volume of some databases increases very rapidly, and the data volume of some databases Slow growth; or, in a certain period of time, the data volume of a certain database increases greatly, while the data volume of other databases increases very little; in another period, the data volume growth of the database changes again; thus, resulting in The storage capacity and traffic in each storage server are unbalanced: it may appear that the storage capacity of some storage servers has exceeded 90%,

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
  • Database backup system and backup method and slave database server of database backup system
  • Database backup system and backup method and slave database server of database backup system
  • Database backup system and backup method and slave database server of database backup system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0053] In order to make the object, technical solution and advantages of the present invention clearer, the present invention will be described in further detail below with reference to the accompanying drawings and preferred embodiments. However, it should be noted that many of the details listed in the specification are only for readers to have a thorough understanding of one or more aspects of the present invention, and these aspects of the present invention can be implemented even without these specific details.

[0054] As used herein, terms such as "module" and "system" are intended to include computer-related entities such as, but not limited to, hardware, firmware, a combination of hardware and software, software, or software in execution. For example, a module may be, but is not limited to being limited to being, a process running on a processor, a processor, an object, an executable, a thread of execution, a program, and / or a computer. For example, both an application ...

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 discloses a database backup system and a backup method and a slave database server of the database backup system. The system comprises a master database server, the slave database server and a storage node cluster. The master database server is used for maintaining a database, the slave database server is used for backup of the database and transmitting a backup result after the backup result is obtained, the storage node cluster is based on the HDFS (Hadoop distributed file system) technology and comprises a storage control node and at least one storage node, and the storage control node is used for receiving the backup result transmitted from the slave database server and is responsible for managing backup file distributed storage of the various storage nodes. As the backup result is transmitted to the storage node cluster based on the HDFS technology to store backup files, the storage control node can comprehensively manage and adjust storage of the backup files according to storage space of the various storage nodes, the backup result is uniformly stored in the various storage nodes in a distributed storage mode, and utilization rate of the storage space can be increased in a database backup process.

Description

technical field [0001] The invention relates to database technology, in particular to a database backup system, a backup method and a slave database server. Background technique [0002] With the rapid development of office automation and e-commerce, enterprises rely more and more on information systems, and databases play an important role as the core of information systems. Especially in some industries that require high data reliability such as banking, securities, telecommunications, etc., if unexpected downtime or data loss occurs, the loss will be very heavy. Therefore, it is necessary to back up the database. In this way, after the database fails and is damaged, it can be restored through the backed up database. [0003] At present, the industry usually adopts the xtrabackup hot backup method to back up the MySQL database with a large amount of data; the database backup system architecture that uses this method for backup, such as figure 1 As shown, including: mast...

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
IPC IPC(8): G06F11/14G06F17/30
Inventor 成江东童剑邱春武杨海朝陶会祥
Owner SINA COM TECH (CHINA) CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com