Updated on 2024-09-12 GMT+08:00

Example: Buy and Connect to an RDS for MySQL DB Instance

This example illustrates how to purchase an RDS for MySQL instance and connect to it from a Linux ECS over a private network.

Figure 1 Example diagram

Step 1: Create an RDS for MySQL DB Instance

  1. Go to the Buy DB Instance page.
  2. Configure the instance information and click Next. Keep the region, AZ, VPC, and security group of the DB instance the same as those of the ECS.
    Figure 2 Selecting an engine version
    Figure 3 Selecting an instance class
    Figure 4 Configuring network information
    Figure 5 Setting a password
  3. View the purchased RDS instance.
    Figure 6 Instance successfully purchased

Step 2: Create an ECS

  1. Go to the Buy ECS page.
  2. Configure basic settings and click Next: Configure Network. Keep the region and AZ of the ECS the same as those of the RDS for MySQL instance to be connected.
    Figure 7 Basic settings
    Figure 8 Selecting an image
  3. Configure the ECS network information and click Next: Configure Advanced Settings. Keep the VPC and security group of the ECS the same as those of the RDS for MySQL instance to be connected.
    Figure 9 Network settings
    Figure 10 Selecting an EIP
  4. Configure the ECS password and click Next: Confirm.
    Figure 11 Advanced settings
  5. Confirm the configurations and click Submit.
    Figure 12 Confirming the configurations
  6. View the purchased ECS.

Step 3: Connect to the RDS for MySQL DB Instance

  1. Use a Linux remote connection tool (for example, MobaXterm) to log in to the ECS. Enter the EIP bound to the ECS for Remote host.
    Figure 13 Creating a session
  2. Enter the password of the ECS.
    Figure 14 Entering the password
    Figure 15 Successful login
  3. Download the mysql-community-client-8.0.26-1.el6.x86_64.rpm client installation package by selecting the required product version and operating system.
    Figure 16 Selecting a version
    Figure 17 Downloading the client package
  4. Upload the client installation package to the ECS.
    Figure 18 Uploading the client package
    Figure 19 Package uploaded
  5. Install the client.
    rpm -ivh --nodeps mysql-community-client-8.0.26-1.el6.x86_64.rpm
    Figure 20 Installing the client
  6. Connect to the RDS for MySQL instance.
    mysql -h 192.168.6.198 -P 3306 -u root -p
    Figure 21 Connection successful
  7. Create a database, for example, db_test.
    create database db_test;
    Figure 22 Creating a database
  8. Create a table, for example, t_test.
    create table t_test(id int(4), name char(20), age int(4));
    Figure 23 Creating a table
  9. Insert one data record to the table.
    insert into t_test(id, name, age) values(1, 'zhangsan', 30);
    Figure 24 Inserting data
  10. Query table data.
    select * from t_test;
    Figure 25 Querying data
  11. Update the value of age for the data record whose id is 1 in the table.
    update t_test set age=31 where id=1;
    Figure 26 Updating data
  12. Query the updated table data.
    select * from t_test where id=1;
    Figure 27 Querying updated data
  13. Delete the data record whose id is 1 from the table.
    delete from t_test where id=1;
    Figure 28 Deleting table data
  14. Delete the table structure.
    drop table t_test;
    Figure 29 Deleting table structure
  15. Delete the database.
    drop database db_test;
    Figure 30 Deleting a database