Database migration method and device and storage medium

A database and data technology, applied in the database field, can solve the problems of database unavailability, inability to perform read operations, and long-term impact of lock operations, so as to reduce the impact and ensure data consistency.

Active Publication Date: 2018-12-04
TENCENT TECH (SHENZHEN) CO LTD +1
View PDF4 Cites 19 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, for scenarios with a large number of business read and write accesses, the impact time of the lock operation may be very long. During the lock period, the database is basically unavailable and cannot perform any write operations, or even read operations.

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 device and storage medium
  • Database migration method and device and storage medium
  • Database migration method and device and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0066] In order to reduce the impact of database migration on database business operations, the embodiments of the present invention provide a database migration method, device and storage medium.

[0067] First, some terms involved in the embodiments of the present invention are described to facilitate the understanding of those skilled in the art.

[0068] CDB: Cloud DataBase, a relational database cloud service.

[0069] DTS: Data Transmission Service (Data Transmission Service), is a data service that supports data interaction between various heterogeneous data sources such as RDBMS (relational database). It provides multiple data transmission capabilities such as data migration, real-time data subscription, and real-time data synchronization.

[0070] Binlog: MySQL's binary log.

[0071] DML: Data Manipulation Language (Data Manipulation Language), is an instruction set in the SQL language set responsible for running data access work on database objects.

[0072] FTWRL...

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 migration method and device and a storage medium which are used for reducing the impact on the normal access operation of a database during a database migration process. The database migration method includes a step of acquiring first location information of database operation log data, a step of buffering log change data for a source database operation, a step of querying a database table to be migrated from the source database for the database table to be migrated and resetting the database table to be migrated in the target database, and a step of resetting the log change data in the target database according to cached log change data until second location information corresponding to the reset log change data is not smaller than the first location information.

Description

technical field [0001] The present invention relates to the technical field of databases, in particular to a database migration method, device and storage medium. Background technique [0002] This section is intended to provide a background or context for implementations of the invention that are recited in the claims. The descriptions herein are not admitted to be prior art by inclusion in this section. [0003] During the use of the database, data migration is often required. The reasons may be insufficient server resources, network isolation, data disaster recovery, and so on. For example, you need to add a read-only instance to the database, create a backup of the database in another computer room, migrate the database to the cloud, and so on. During the migration process, the impact on the online database needs to be as small as possible, so as to control the impact on the upper-level business that is reading and writing the database as little as possible. [0004] ...

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): G06F17/30
CPCY02D10/00
Inventor 吴双桥王珏杨繁
Owner TENCENT TECH (SHENZHEN) CO LTD
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