检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Local Windows Server Database client such as MySQL-Front EIP 3306 To connect to a DB instance from a Linux ECS, perform the following steps: Step 1: Buy an ECS: Purchase and log in to a Linux ECS.
Easy Management Quick Setup You can create a DB instance on the management console within minutes and access RDS from an ECS to reduce the application response time and avoid paying for the traffic that would be generated by regular public access.
To download a MySQL client to the ECS, bind an EIP to the ECS. For details about how to purchase a Linux ECS, see Purchasing a Custom ECS in Elastic Cloud Server User Guide. On the ECS Information page, view the region and VPC of the ECS.
For details about how to purchase a Linux ECS, see Purchasing a Custom ECS in Elastic Cloud Server User Guide. Check whether the ECS and RDS for PostgreSQL instance are in the same region and VPC.
Operation Process The following figure shows the process of creating a MySQL database on an ECS, buying an RDS for MySQL instance, and migrating data from the MySQL database to the RDS instance.
Prepare an ECS for accessing DB instances in the same VPC or prepare a device for accessing RDS through an EIP. To connect to a DB instance through an ECS, you need to create an ECS first. To connect to a DB instance through an EIP, you must: Bind an EIP to the DB instance.
Figure 3 Instance successfully purchased Step 2: Buy an ECS Go to the Elastic Cloud Server console. Check whether there is a Linux ECS. If yes, go to 3. If no, purchase an ECS and select Linux (for example, CentOS) as its OS.
Troubleshoot RDS connection failures caused by a client problem by checking the following items: ECS Security Policy In Windows, check whether the RDS instance port is enabled in the Windows security policy.
Viewing Storage of RDS DB Instances Scenario The storage of an RDS instance refers to the data disk storage you have purchased, not including the ECS system disks. You can use Cloud Eye to monitor the size, usage, and utilization of your storage space and set alarm rules.
VPC: Virtual Private Cloud ECS: Elastic Cloud Server If the ECS is in the same VPC as your RDS DB instance, you do not need to apply for an EIP. Figure 1 illustrates the connection over a private network or a public network.
Buying an ECS Log in to the management console. Click in the upper left corner and select a region. Choose Compute > Elastic Cloud Server. The Elastic Cloud Server page is displayed. On the ECS console, buy an ECS.
Buying an ECS Log in to the management console. Click in the upper left corner and select a region. Choose Compute > Elastic Cloud Server. The Elastic Cloud Server page is displayed. On the ECS console, buy an ECS.
For details on how to create and log in to an ECS, see Purchasing an ECS and Logging In to an ECS. To connect to a DB instance through an ECS, you must ensure that: The ECS and DB instance are in the same VPC. The ECS is allowed by the security group to access the DB instance.
If the ECS and DB instance are in different VPCs, change the VPC of the ECS to that of the DB instance. For details, see Changing a VPC. Figure 6 Checking the VPC of an ECS Figure 7 Checking the VPC of an RDS instance Check security group rules.
ECS: indicates the Elastic Cloud Server. You can log in to DB instances using the Data Admin Service (DAS) service or other database clients. If the ECS is in the same VPC as the RDS DB instance, you do not need to apply for an EIP.
VPC: Virtual Private Cloud ECS: Elastic Cloud Server EIP: Elastic IP You can log in to DB instances using the Data Admin Service (DAS) service or other database clients. If the ECS is in the same VPC as your RDS DB instance, you do not need to apply for an EIP.
Connecting to an RDS for PostgreSQL Instance Through the psql CLI Client Connecting to a DB Instance from a Linux ECS over a Private Network Connecting to a DB Instance from a Linux ECS over a Public Network Parent Topic: Instance Connection
ECS: indicates the Elastic Cloud Server. You can log in to DB instances using the DAS service or other database clients. If the ECS is in the same VPC as your RDS DB instance, you do not need to apply for an EIP.
If you connect to the RDS DB instance through a private network, the ECS and DB instance must be in the same VPC and the DB instance can be accessed only through an ECS in the same VPC.
[root@ecs]# tar -zxf mysql-5.7.27-linux-glibc2.12-x86_64.tar.gz [root@ecs]# cd mysql-5.7.27-linux-glibc2.12-x86_64/bin [root@ecs]# ll mysqlbinlog -rwxr-xr-x 1 7161 31415 11310886 Jun 10 2019 mysqlbinlog [root@ecs]# ./mysqlbinlog -V .
