A database migration method and apparatus

By using an online migration method, the target slave database of the MySQL database cluster was shut down and the data files were copied to the storage node of the distributed database. This solved the problem of business interruption during the migration process, achieved a seamless migration from the MySQL database cluster to the distributed database, and ensured the continuous operation of the application.

CN122152786APending Publication Date: 2026-06-05NETSUNION CLEARING CORP
View PDF 0 Cites 0 Cited by

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
NETSUNION CLEARING CORP
Filing Date
2024-11-29
Publication Date
2026-06-05

AI Technical Summary

Technical Problem

Existing technologies require service interruptions when migrating MySQL database clusters to distributed databases, leading to business disruptions. This is especially time-consuming when dealing with large amounts of data, impacting the normal operation of applications.

Method used

An online migration method is adopted, which involves shutting down the target slave database in the MySQL database cluster, copying its data files to the storage node of the distributed database, and synchronizing the data to achieve data synchronization between the slave and master databases, thus avoiding business interruption.

Benefits of technology

The system enabled online migration from a MySQL database cluster to a distributed database, avoiding business interruption and ensuring the continuous operation of the application.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN122152786A_ABST
    Figure CN122152786A_ABST
Patent Text Reader

Abstract

A database migration method and device, comprising: obtaining structure information and authorization information of a distributed database, and writing into a master library of a MySQL database; wherein a storage layer of the distributed database is constructed by using a MySQL architecture; selecting a target slave library from the MySQL database cluster, closing the target slave library and a storage node in the distributed database, copying the structure information and authorization information of the distributed database saved by the target slave library, and data files to the storage node of the distributed database; starting the storage node and the target slave library, performing data synchronization of the target slave library from the master library of the MySQL database and data synchronization of the storage node of the distributed database from the target slave library. The embodiment of the present disclosure can realize online migration of the MySQL database cluster to the distributed database with the storage layer being MySQL, and avoid affecting the business provided by the application program of the MySQL database cluster service.
Need to check novelty before this filing date? Find Prior Art