How to create an Alibaba Cloud ApsaraDB RDS Instance for MySQL

My name is Ishita Mahajan and I am a Roopu Cloud Ambassador. In this blog post, I will deep dive into ApsaraDB for RDS and after that, I will show you step-by-step how you can create an ApsaraDB RDS instance for MySQL.

ApsaraDB for RDS

RDS stands for Relational Database System. A relational database is a data structure that allows you to store different types of data in form of tables. ApsaraDB for RDS is the Alibaba Cloud Online Database Service that allows you to rapidly build a stable and reliable database system. ApsaraDB for RDS is designed based on the Apsara Distributed File System and high-performance SSD storage media of Alibaba Cloud. 

Database Engines

ApsaraDB for RDS supports the following database engines:

  • MariaDB 
  • MySQL
  • SQL Server
  • PostgreSQL
  • PPAS

Instance Types

ApsaraDB for RDS supports the following instance types:

  • Shared instance
  • General-purpose instance 
  • Dedicated instance 
  • Dedicated cluster instance

Editions

ApsaraDB for RDS is available in 4 different editions:

  • Basic Edition
  • High-availability Edition
  • Cluster Edition
  • Enterprise Edition

Self-managed databases

Self-managed databases are databases that are hosted on ECS instances. To use self-managed databases, you must purchase a minimum of 2 ECS instances to set up a primary/secondary architecture. Also, you need to pay for the storage that you use. You can only use intranet traffic, to use internet traffic you need to pay for that. In a self-managed database, automated backup is not possible. You need to configure streaming backup and PITR features which will increase your cost. If your Database breaks down then Self-managed databases take about 30 minutes to complete failover. 

Features of ApsaraDB for RDS overcome self-managed databases:
  • In ApsaraDB for RDS, you need only to pay for the  RDS instances.
  •  It provides you free O&M service. 
  • It gives 99.95% service availability and 99.9999% data reliability.
  • Automatic backup is possible for ApsaraDB for RDS. 
  • If your database server breaks down it takes about 15 minutes to complete failover. 
  • In cluster editions, you can also use Alibaba Cloud Proprietary High Availability Architecture. This will complete a failover within 30 seconds. 
  • It allows you to create read-only RDS instance to balance loads of your primary instance 
  • It supports DDoS protection, Access Control, System Security, and VPC Isolation mechanism.

Demo: How to create an ApsaraDB for RDS instance for MySQL

Follow below steps to create an ApsaraDB for RDS Instance for MySQL:

  • Step 2 :  Go to Services and Click on ApsaraDB for RDS.
  • Step 3:  Now you will be redirected to the ApsaraDB RDS console. Click on Create Instance to create a new RDS Instance.
Alibaba Cloud ApsaraDB for RDS console

  • Step 4: Once you clicked on to create an instance, let’s configure the Basic Configurations. For this demo, I will select Pay-as-you-go, the Mumbai region, the MySQL database engine, Basic Instance Edition, the Standard SDD Storage type, Zone B as my primary node, and the general purpose instance type [mysql.n1.micro.1]. 
ApsaraDB for RDS instance Basic Configurations
ApsaraDB for RDS instance Basic Configurations

  • Step 5: Let’s configure now the Instance Configurations. In my case, I will select VPC as my network type, choose the VPCs and Vswitches, and select the InnoDB as the default storage engine. 
ApsaraDB for RDS instance Instance Configurations
ApsaraDB for RDS instance Instance Configurations

  • Step 6: Once you review your instance configuration click on Confirm Order.
  • Step 7: Once you order is confirmed, agree the Terms of Service and click on Pay Now.
ApsaraDB for RDS instance Confirm Order

After this purchase your instance will be ready within 1-5 minutes. To see your RDS instance go back to the RDS console.

About Roopu Cloud

If you have any questions or concerns about Alibaba Cloud, you can contact us. We are experts in building and implementing cloud solutions in the Alibaba Cloud platform as well as in other Chinese cloud platforms. Let us help you!

Other related posts:

Leave a Comment

Scroll to Top