Method for migrating electric power data from MySQL to domestic database
The invention discloses a method for migrating electric power data from MySQL to a domestic database. The method comprises the following steps: carrying out data deduplication and simplification; migrating the data subjected to the duplicate removal and simplification processing from the MySQL to an...
Saved in:
Main Authors | , , , , , , , , |
---|---|
Format | Patent |
Language | Chinese English |
Published |
10.11.2023
|
Subjects | |
Online Access | Get full text |
Cover
Loading…
Summary: | The invention discloses a method for migrating electric power data from MySQL to a domestic database. The method comprises the following steps: carrying out data deduplication and simplification; migrating the data subjected to the duplicate removal and simplification processing from the MySQL to an OceanBase database; performing grammar compatibility check and feasibility evaluation of migration; configuring and verifying a migration scheme; data migration: after the data migration from the MySQL to the OceanBase is triggered, the DDL operation is forbidden in the source MySQL; and data consistency verification: after the data is synchronized to the OceanBase from the MySQL, verifying the consistency. According to the method, data is migrated from a traditional non-distributed database to a distributed database, management of larger-scale data is facilitated, expansion of the database is facilitated, and repeated and low-value non-structured data is removed and simplified in the data migration process.
本发明公开 |
---|---|
Bibliography: | Application Number: CN202310953310 |