Database migration method and system based on log synchronization

A technology for migrating systems and databases, which is applied in the field of database migration methods and systems based on log synchronization. It can solve problems such as huge projects, time-consuming and labor-intensive projects, and achieve the effects of reducing downtime, simplifying the migration process, and avoiding migration risks.

Pending Publication Date: 2021-06-29
福建星瑞格软件有限公司
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

For database migration, there may be differences between the source and target hardware, cross-domain and cross-database, need to migrate between different operating systems, especially for databases contained in the production systems of many enterprises, with massive data, must support 7 *24-hour external service, requiring the minimum possible downtime to complete the migration; during the migration, all knowledge in the database field will be involved, including management, backup recovery, disaster recovery, monitoring, etc. This process also includes some storage on the host , Configuration, everything in the whole process needs to be considered, the risk of migration is everywhere, the database migration is a huge project, time-consuming and labor-intensive preparation, there is a lot of uncertainty whether the migration can be completed smoothly; when a risk does occur, whether It is also a major test to be able to roll back smoothly

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 migration method and system based on log synchronization

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0022] Please refer to figure 1 , a database migration method based on log synchronization, characterized in that, comprising steps:

[0023] S1. Use the standby database of the production database to copy and migrate the base database to the target database;

[0024] Step S1 is specifically:

[0025] Use the standby database of the database to export the base database as an SQL file, and then re-import it to the target data.

[0026] What needs to be considered is that there may be differences in SQL between different versions of different databases, and there may even be various incompatibilities such as functions, field types, and stored procedures. Compatibility processing between databases needs to be completed, and partial support or non-support functions, you need to use alternative methods or mitigation methods to avoid affecting the use of applications during migration.

[0027] S2. Record the time point of the last synchronization of the standby database, obtain t...

Embodiment 2

[0034] A database migration system based on log synchronization, including a base import module, a transaction log acquisition module and an incremental data synchronization module;

[0035] The base amount import module utilizes the standby database of the production database to copy and migrate the base amount database to the target library;

[0036] The described base quantity import module utilizes the standby database of the production database to copy and migrate the base quantity database to the target database as follows:

[0037] The basic quantity importing module uses the backup database of the database to export the basic quantity database as an SQL file, and then re-imports it into 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

According to the database migration method and system based on log synchronization provided by the invention, the backup database of the production database is copied to the target database in a base database copy synchronization mode, so that the influence on the production system is avoided; while copying the base database, production database incremental data finally synchronized by the standby database is cached; after the base amount database is copied, the incremental redo is synchronously tracked to the target database, and the data tracking time can be determined according to the actual incremental data amount and is not limited by time; after data leveling, it is ensured that the migration database continues to be synchronized with the data of the production database; whether the new database runs normally and whether the data are correct are verified, after the new database can run for a period of time, the time point is determined, the new database is switched to, database migration is completed seamlessly, the database migration process is simplified, the risk of database migration is avoided, and the database downtime is shortened.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a database migration method and system based on log synchronization. Background technique [0002] Database migration is a relatively complex systematic project. For database migration, there may be differences between the source and target hardware, cross-domain and cross-database, need to migrate between different operating systems, especially for databases contained in the production systems of many enterprises, with massive data, must support 7 *24-hour external service, requiring the minimum possible downtime to complete the migration; during the migration, all knowledge in the database field will be involved, including management, backup recovery, disaster recovery, monitoring, etc. This process also includes some storage on the host , Configuration, everything in the whole process needs to be considered, the risk of migration is everywhere, the database migration is a h...

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): G06F16/21G06F16/27G06F16/178G06F16/18
CPCG06F16/178G06F16/1815G06F16/214G06F16/27
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