IP Library › Granted Patent US 11,003,639
Granted Patent B2
US 11,003,639 · App. 16/367,513 · Granted May 11, 2021

Database data migration method, apparatus, terminal, system, and storage medium

Inventors: Jue Wang (Shenzhen, CN); Guwu Yi (Shenzhen, CN); Liang Ni (Shenzhen, CN); Fan Yang (Shenzhen, CN); Biao Xu (Shenzhen, CN); Rui Yang (Shenzhen, CN)
Assignee: TENCENT TECHNOLOGY (SHENZHEN) COMPANY LIMITED
G06F16/214H04L61/2514H04L63/0263H04L63/20H04L67/02H04L67/1097H04L67/2814H04L67/34
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 11,003,639
App. No.
16/367,513
Granted
May 11, 2021
Kind
B2
Abstract

A method of database data migration is described. A migration task of migrating data from a source database to a target database can be obtained. The migration task can include a network type of a source network with which the source database is connected. The target database can be located in a cloud environment. A network connectivity policy is determined according to the network type of the source network of the source database. The network policy can indicate a configuration of a communication link between the source database and the target database. The communication link between the source database and the target database can be configured according to the network connectivity policy, such that the data can be migrated from the source database to the target database via the communication link.

Claims (75)

1. A database data migration method, comprising:

obtaining a migration task of migrating data from a source database to a target database, the migration task indicating a network type of a source network with which the source database is connected, the target database located in a cloud environment;

determining a network connectivity policy according to the network type of the source network of the source database, the network connectivity policy indicating a configuration of a communication link between the source database and the target database;

configuring the communication link between the source database and the target database according to the network connectivity policy, such that the data is migrated from the source database to the target database via the communication link, wherein

based on the network connectivity policy being determined to be a second network connectivity policy when the network type is a public network outside the cloud environment,

the configuring the communication link includes configuring a route management-based access proxy server, and

the method further includes:

obtaining a data packet, the data packet being from the source database or the target database;

querying for a route record in a route management table according to the data packet;

changing a source address and a destination address of the data packet according to the route record when the route record exists; and

forwarding the changed data packet.

2. The method according to claim 1 , wherein the migration task comprises a type of the source database and an attribute parameter corresponding to the type of the source database.

3. The method according to claim 1 , wherein the network type of the source network is one of:

an infrastructure network in the cloud environment,

a first private network in the cloud environment,

an IDC network interconnected to a second private network in the cloud environment and located in an Internet data center and outside of the cloud environment, and

the public network outside the cloud environment.

4. The method according to claim 1 , wherein

the determining the network connectivity policy comprises:

determining the network connectivity policy is a first network connectivity policy when the network type is an infrastructure network in the cloud environment, and

the configuring the communication link comprises:

configuring a firewall between the source database and the target database when the first network connectivity policy is determined.

5. The method according to claim 1 , wherein the configuring the route management-based access proxy server further comprises:

generating, according to the migration task, a route addition request for adding a route record to the route management table stored in the route management-based access proxy server; and

transmitting the route addition request to the route management-based access proxy server.

6. The method according to claim 1 , wherein the route management-based access proxy server is configured to access the source database and the target database.

7. The method according to claim 1 , wherein the configuring the route management-based access proxy server further comprises:

based on a HyperText Transfer Protocol, transmitting a route addition request, a route deletion request, and/or a route query request to the route management-based access proxy server.

8. The method according to claim 1 , wherein the route management-based access proxy server comprises an active proxy server and a standby proxy server.

9. The method according to claim 1 , wherein

the determining the network connectivity policy comprises:

determining the network connectivity policy is a third network connectivity policy when the network type is a private network in the cloud environment or an IDC network interconnected to a private network in the cloud environment, and

the configuring the communication link comprises:

configuring a bi-directional network address translation-based access proxy.

10. The method according to claim 9 , further comprising:

obtaining a data packet;

parsing the data packet to obtain a first source address and a first destination address;

obtaining a second destination address from a configuration file, and changing the first destination address in the data packet to the second destination address by means of destination address translation;

obtaining a second source address, and changing the first source address in the data packet to the second source address by means of source address translation; and

forwarding the changed data packet.

11. The method according to claim 9 , further comprising:

obtaining a data packet;

parsing the data packet to obtain a first source address and a first destination address;

obtaining a second destination address from a configuration file, and changing the first destination address in the data packet to the second destination address by means of destination address translation;

obtaining a second source address, and changing the first source address in the data packet to the second source address by source address translation;

forwarding the changed data packet;

obtaining a third destination address from the configuration file; and

performing secondary forwarding on the changed data packet according to the third destination address.

12. The method according to claim 11 , wherein the third destination address is obtained by using a virtual dedicated network-based gateway when the network type of the source database is an IDC network interconnected to a private network in a cloud environment through a public network, and secondary forwarding is performed on the changed data packet according to the third destination address.

13. The method according to claim 11 , wherein the third destination address is obtained by using a private line gateway when the network type of the source database is an IDC network interconnected to a private network in a cloud environment through a private line, and secondary forwarding is performed on the changed data packet according to the third destination address.

14. The method according to claim 10 , wherein a bi-directional network address translation-based gateway changes the obtained data packet, and forwards the changed data packet to the second destination address.

15. An apparatus for database data migration, comprising circuitry configured to:

obtain a migration task of migrating data from a source database to a target database, the migration task indicating a network type of a source network with which the source database is connected, the target database located in a cloud environment;

determine a network connectivity policy according to the network type of the source network of the source database, the network connectivity policy indicating a configuration of a communication link between the source database and the target database; and

configure the communication link between the source database and the target database according to the network connectivity policy, such that the data is migrated from the source database to the target database via the communication link, wherein

based on the network connectivity policy being determined to be a second network connectivity policy when the network type is a public network outside the cloud environment, the circuitry is further configured to:

configure a route management-based access proxy server in the configuration of the communication link,

obtain a data packet, the data packet being from the source database or the target database,

query for a route record in a route management table according to the data packet,

change a source address and a destination address of the data packet according to the route record when the route record exists, and

forward the changed data packet.

16. The apparatus according to claim 15 , wherein the circuitry is further configured to:

determine the network connectivity policy is a first network connectivity policy when the network type is an infrastructure network in the cloud environment, and

configure a firewall between the source database and the target database when the first network connectivity policy is determined.

17. A non-transitory computer-readable medium storing a program executable by a processor to perform a method, the method comprising:

obtaining a migration task of migrating data from a source database to a target database, the migration task indicating a network type of a source network with which the source database is connected, the target database located in a cloud environment;

determining a network connectivity policy according to the network type of the source network of the source database, the network connectivity policy indicating a configuration of a communication link between the source database and the target database; and

configuring the communication link between the source database and the target database according to the network connectivity policy, such that the data is migrated from the source database to the target database via the communication link, wherein

based on the network connectivity policy being determined to be a second network connectivity policy when the network type is a public network outside the cloud environment,

the configuring the communication link includes configuring a route management-based access proxy server, and

the method further includes:

obtaining a data packet, the data packet being from the source database or the target database,

querying for a route record in a route management table according to the data packet,

changing a source address and a destination address of the data packet according to the route record when the route record exists, and

forwarding the changed data packet.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Apr 9, 2020
From: WANG, JUE; YI, GUWU; NI, LIANG; YANG, FAN; XU, BIAO; YANG, RUI
To: TENCENT TECHNOLOGY (SHENZHEN) COMPANY LIMITED
Reel/Frame 052353/0571 →
Priority Claims (1)
CN 201611149740.7 · Dec 13, 2016 · national
Continuity (2)
Continuation PCTCN2017115237 · Dec 8, 2017
Related Publication 20190227998A1 · Jul 25, 2019