Database cluster data migration method and system
A database and data technology, applied in the database field, can solve the problems of high risk, laborious and time-consuming, and achieve the effect of less resource consumption, time saving and business impact reduction.
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
Example Embodiment
[0047] Example one
[0048] Reference figure 1 , figure 1 Shows a flowchart of a method for data migration of a database cluster provided by the present invention. Including: step S110 and step S120.
[0049] In step S110, all the data copied in parallel by the source-end database cluster using a batch call point-to-point data replication method is received.
[0050] Specifically, the source-end database cluster adopts the replication method of batch calling the underlying API interface of the database, randomly selects the destination-end servers equal to the source-end database server in the source-end database cluster in the destination-end database cluster, and receives the source through mutual trust. All data replicated in parallel by the source database server in the database cluster.
[0051] Among them, the underlying API interface of the database can be the libpg copy interface of the PostgreSQL database. The database calls the database API interface in parallel to complet...
Example Embodiment
[0093] Example two
[0094] Reference figure 2 , figure 2 It shows a flowchart of an embodiment of a method for data migration of a database cluster provided by the present invention. Including: step S210.
[0095] In step S210, the batch call point-to-point data replication method is adopted to copy all the data in parallel to the insert select method for data redistribution, and the received data can be re-distributed to the destination database cluster on the computing node.
[0096] Specifically, the source-end database cluster adopts the replication method of batch calling the underlying API interface of the database, randomly selects the destination-end servers equal to the source-end database server in the source-end database cluster in the destination-end database cluster, and receives the source through mutual trust. All data replicated in parallel by the source database server in the database cluster.
[0097] Among them, the underlying API interface of the database can b...
Example Embodiment
[0141] Example three
[0142] Reference image 3 , image 3 The structural block diagram of an embodiment of a system 300 for database cluster data migration provided by the present invention is shown, including:
[0143] The receiving module 31 is configured to receive all data copied in parallel by the source-end database cluster using a batch call point-to-point data replication method.
[0144] The data redistribution module 32 is used to perform data redistribution in an insert select mode, and redistribute the received data to the computing nodes.
[0145] Further, such as Figure 4 As shown, the receiving module 31 includes:
[0146] The receiving unit 311 is configured to randomly select a destination server in the destination database cluster that is equivalent to the source database server in the source database cluster based on the source database cluster using the batch call database bottom API interface replication mode, and pass The mutual trust method receives all data r...
PUM
Abstract
Description
Claims
Application Information
- R&D Engineer
- R&D Manager
- IP Professional
- Industry Leading Data Capabilities
- Powerful AI technology
- Patent DNA Extraction
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