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

Data migration method and device in database management platform

A management platform and database technology, applied in the database field, can solve problems such as long downtime, affecting application operation, and long application interruption time, so as to ensure normal operation and realize the effect of seamless migration

Active Publication Date: 2017-12-01
BEIJING FEINNO COMM TECH
View PDF2 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The present invention provides a data migration method and device in a database management platform to solve the problem that the downtime of the existing migration scheme is particularly long, resulting in too long application interruption and affecting the operation of the application

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
  • Data migration method and device in database management platform
  • Data migration method and device in database management platform
  • Data migration method and device in database management platform

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0027] In order to make the objectives, technical solutions, and advantages of the present invention clearer, the embodiments of the present invention will be described in further detail below in conjunction with the accompanying drawings.

[0028] An embodiment of the present invention provides a data migration method in a database management platform, see figure 1 , The method includes the following steps:

[0029] S100: Select the source database instance that needs to export data and the target database instance used to import data.

[0030] S101: Configure the export parameters of the source database instance and the import parameters of the target database instance.

[0031] S102: Obtain relevant information about the source database instance and the target database instance from the database management platform.

[0032] S103: Use the export parameters to export data from the source database instance to generate backup data.

[0033] S104: Import the backup data to the target data...

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 method and a device for carrying out data migration on a database management platform. The method for carrying out the data migration on the database management platform, provided by the embodiment of the invention, comprises the steps of selecting a source database instance which needs to export data and a target database instance which is used for importing the data; collocating the export parameters of the source database instance and the import parameters of the target database instance; obtaining relevant information of the source database instance and the target database instance from the database management platform; exporting the data from the source database instance by utilizing the export parameters, and generating backup data; importing the backup data to the target database instance by utilizing the import parameters; establishing a master-slave relation between the source database instance and the target database instance by utilizing the relevant information and the backup data, and executing the synchronous operation of the source database instance and the target database instance; setting domain names of the source database instance and the target database instance, and realizing the online running of the target database instance.

Description

Technical field [0001] The present invention relates to the technical field of databases, in particular to a data migration method and device in a database management platform. Background technique [0002] MySQL database server has very good scalability, from only 1MB deep embedded applications to up to gigabit large data warehouse, it can cope with ease. MySQL also supports various Linux, UNIX and Windows platforms. At the same time, the open source feature of MySQL allows it to be customized according to the needs of users, adding users' special requirements to the database server. [0003] In the database development process, due to various reasons such as changes in requirements, the MySQL database system is no longer suitable for business development after running for a period of time, cannot meet business growth needs, database server performance cannot meet business needs, etc., data migration becomes An inevitable problem. [0004] When performing the data migration of th...

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 Patents(China)
IPC IPC(8): G06F17/30
CPCG06F11/1448G06F16/214
Inventor 乔婧王春涛
Owner BEIJING FEINNO COMM TECH
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