检测到您已登录华为云国际站账号,为了您更好的体验,建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Prepare for the Migration Prepare an ECS that can access the source MySQL instance. Ensure that the ECS where the source MySQL instance is located, destination DDM instance, and prepared new RDS for MySQL instance are in the same VPC.
If they cannot communicate with each other, export data as a file and upload the file to the ECS through a transit server.
Export Data Connect to the on-premises MySQL instance using the IP address of the ECS and export data from the instance using mysqldump. Before you export data, make sure that: The destination DDM instance is in the same subnet and VPC as the ECS on the client side.
ECS You can access your DDM instance through an ECS. Relational Database Service (RDS) After you buy a DDM instance, you can associate it with RDS for MySQL instances in the same VPC to obtain separated storage resources.
Linux Issues More Disks Initializing EVS Data Disks Handling Insufficient Disk Space on a Windows ECS Initializing a Linux Data Disk What Should I Do If a Disk Is Offline?
So you need to export databases as files, upload the files to the ECS, and import the file data from the ECS to DDM. Migration Methods DDM supports the following migration methods: Using official MySQL clients.
*:get*", "ecs:*:list*", "ecs:cloudServerNics:update", "ecs:serverInterfaces:use"], "Effect": "Allow" }] } DDM CommonOperations { "Version": "1.1", "Statement": [{ "Action": [ "vpc:*:*list*", "vpc:*:*get*", "vpc:ports
Table name Destination DDM instance Connection address Listening port Username Name of a shard on the RDS instance associated with the DDM instance Connection address of the new RDS instance Listening port of the new RDS instance Administrator of the new RDS instance Database name ECS
*:get* ecs:*:list* vpc:vpcs:list vpc:securityGroups:get vpc:subnets:get ecs:cloudServerNics:update ecs:serverInterfaces:use Global or region-level vpc:ports:* BSS Finance and BSS Operator policies The last permission is required only when you buy a yearly/monthly DDM instance. √
For example, if an IAM user queries ECSs using an API, the user must have been granted permissions that allow the ecs:servers:list action. Supported Actions DDM provides system-defined policies that can be directly used in IAM.
Migrating Data from a Self-Built MySQL Instance to DDM You have built a MySQL instance on an ECS and want to migrate your data from the instance to DDM for distributed data storage. This practice describes how to migrate data from a self-built MySQL instance to DDM.
Preparations before Migration Prepare an ECS that can access the old RDS instance, the target DDM instance, and the RDS instance associated with the target DDM instance.
For details, see Login Using VNC in the Elastic Cloud Server User Guide. In the instance list, click the name of the target instance to go to the Basic Information page. In the Network Information area, obtain the private IP address and DDM service port.
Figure 4 DB instance successfully associated Step 2: Buy an ECS Go to the Buy ECS page. Configure basic settings and click Next: Configure Network. Keep the region and AZ of the ECS the same as those of the DDM instance to be connected.
Public services, such as Elastic Cloud Server (ECS), Elastic Volume Service (EVS), Object Storage Service (OBS), Virtual Private Cloud (VPC), Elastic IP (EIP), and Image Management Service (IMS), are shared within the same region.
Therefore, you must export databases as files to the ECS, and then import data in the files into DDM from the ECS. Preparations for Migration Prepare an ECS that can access the MyCat database, the target DDM instance, and the RDS instance associated with the target DDM instance.
Intra-VPC Access to DDM Instances Access to a DDM instance includes access to the DDM instance from the ECS where a client is located and access to its associated data nodes. The ECS, DDM instance, and data nodes must be in the same VPC.