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

Database backup method and device based on openstack

A database and backup technology, applied in the field of data processing, can solve the problems of unsupported unified management of backup tasks, high R&D costs, and high costs, and achieve the effects of fast task intelligent scheduling, low R&D costs, and high R&D efficiency

Pending Publication Date: 2020-07-31
新浪技术(中国)有限公司
View PDF6 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

These two methods either cannot meet the requirements of intelligent task scheduling and unified task management in the Internet massive MySQL cluster scenario, or the research and development costs of pure self-developed are high and the research and development efficiency is low.
[0003] Among them, the xtrabackup+mysqldump+Linux crontab method: does not support unified management of backup tasks, does not support intelligent scheduling of backup tasks, and cannot flexibly support business personalized backup strategy requirements
[0004] xtrabackup+mysqldump+pure self-developed backup management system method: high cost, low research and development efficiency, and scalability is not easy to guarantee

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 method and device based on openstack
  • Database backup method and device based on openstack
  • Database backup method and device based on openstack

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0020] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0021] Such as figure 1 Shown is a flow chart of a database backup method based on openstack in an embodiment of the present invention, the method comprising:

[0022] S101: Obtain the backup task of the MySQL database from the metadata database through the task manager taskmanager deployed on the server in the form of a daemon process.

[0023] Preferably, as figure 2 As shown, the task manager taskmanager is multiple, and the multiple task managers are de...

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 embodiment of the invention provides a database backup method and device based on openstack, and the method comprises the steps: obtaining a backup task of a MySQL database from a meta-database through a task manager deployed on a server in a daemon process mode; sending the backup task in the task manager to a guest deployed in each MySQL database in a message queue manner through a remote procedure call protocol rpc; and obtaining a backup task of the MySQL database connected with the guest through the guest, executing the backup task, and updating a backup state at the same time. According to the technical scheme, the mass MySQL cluster backup device is low in research and development cost, high in research and development efficiency and high in expandability, unified management ofbackup tasks and intelligent scheduling of the backup tasks can be supported, and personalized backup strategy requirements of services can be flexibly met.

Description

technical field [0001] The invention belongs to the field of data processing, and relates to an openstack-based database backup method and device, in particular to an openstack-based massive MySQL database backup method and device. Background technique [0002] The current MySQL database backup mainly relies on two kinds of software: the open source xtrabackup software for physical backup, and the mysqldump software for logical backup. However, both xtrabackup and mysqldump can only implement a single backup operation. The current common practice is to use Linux crontab to implement backup task management or develop a complete backup management system on the basis of these two software. These two methods either cannot meet the needs of intelligent task scheduling and unified task management in the Internet massive MySQL cluster scenario, or the research and development costs of pure self-developed research are high and the research and development efficiency is low. [0003...

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/14
CPCG06F11/1448G06F11/1464Y02D10/00
Inventor 张博森邱春武孙希鹏
Owner 新浪技术(中国)有限公司
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