×
Community Blog How to Learn Alibaba Cloud RDS

How to Learn Alibaba Cloud RDS

In this article, we will describe the learning path for RDS, and help you master the ApsaraDB for RDS knowledge in the fastest way.

What is RDS

RDS is an abbreviation of Relational Database Serice. Alibaba Cloud ApsaraDB for RDS is a stable, reliable, and scalable online database service. Based on Apsara Distributed File System and the high-performance SSD storage of Alibaba Cloud, ApsaraDB for RDS supports the MySQL, SQL Server, PostgreSQL, PPAS (highly compatible with Oracle), and MariaDB database engines. It provides a portfolio of solutions for disaster recovery, backup, restoration, monitoring, and migration to facilitate database operations and maintenance.

Why Use RDS

RDS allows you to quickly build a stable and reliable database system. It has the following advantages compared with user-created databases:

  • Cost-effective and easy to use. You can choose flexible billing methods, change database configurations on-demand, and obtain an out-of-the-box database service.
  • High performance, including suggestions on parameter and SQL query optimization.
  • High-availability architecture and multiple disaster recovery solutions.
  • High security. Various preventive measures are used to protect data.

Alibaba Cloud ApsaraDB for RDS has significant advantages in cost-effectiveness, availability, reliability, ease of use, and performance. Its cost is one-third of the expense to build databases on ECS instances and one-tenth of the expense to build databases on physical servers.

ApsaraDB RDS Editions

ApsaraDB RDS offers four editions: Basic, High-availability, Cluster, and Enterprise.

RDS Basic Edition

In the Basic Edition, your database system consists of only one primary RDS instance, and computing is separated from storage. This edition is cost-effective.

RDS High-availability Edition

The High-availability Edition is a popular edition that allows for one primary instance and one secondary instance. The primary and secondary instances work in the high-availability architecture. This edition is suitable for more than 80% of the actual business scenarios. These scenarios include the Internet, the Internet of Things (IoT), online retail, logistics, and gaming.

RDS Cluster Edition

The Cluster Edition is developed based on the native SQL Server technology AlwaysOn. Only SQL Server 2017 supports the Cluster Edition. In the Cluster Edition, computing is separated from storage, and you can create read-only instances to implement read/write splitting. After you create read-only instances, you can apply for a read-only routing endpoint. By default, each read-only instance is assigned an independent internal endpoint that is used to connect only to the specified read-only instance.

Enterprise Edition

The Enterprise Edition is suitable for enterprises. It uses a three-node architecture that consists of one primary instance and two secondary instances. Data is replicated from the primary instance to the secondary instances. This ensures data consistency and finance-grade reliability.

How to Create an RDS instance

Create an ApsaraDB RDS for MySQL instance

This topic describes how to create an ApsaraDB RDS for MySQL instance by using the ApsaraDB RDS console. This topic also describes the parameters that you must configure in the ApsaraDB RDS console.

Create an ApsaraDB RDS for SQL Server instance

This topic describes how to create an ApsaraDB RDS for SQL Server instance in the ApsaraDB RDS console. You can also call an API operation to create an ApsaraDB RDS for SQL Server instance.

Create an ApsaraDB RDS for PostgreSQL instance

This topic describes how to create an ApsaraDB RDS for PostgreSQL instance in the ApsaraDB RDS console. You can also create an ApsaraDB RDS for PostgreSQL instance by calling an API operation.

Create an ApsaraDB RDS for PPAS instance

This topic describes how to create an ApsaraDB RDS for PPAS instance in the ApsaraDB for RDS console. You can also call an API operation to create an ApsaraDB RDS for PPAS instance.

Creates an ApsaraDB RDS for MariaDB instance

This topic describes how to create an ApsaraDB RDS for MariaDB instance in the ApsaraDB RDS console. You can also call an API operation to create an ApsaraDB RDS for MariaDB instance.

RDS Migration Tutorials

How to Migrate Your MySQL Database to Alibaba Cloud

This article starts by introducing Alibaba Cloud's ApsaraDB stack, which is Alibaba Cloud's comprehensive suit of database services, which includes support for SQL, MySQL, and MongoDB, among other languages. Then, this article goes on to show how you can set up a service and create an ApsaraDB for RDS MySQL instance to which you can then migrate an existing database.

How to Back Up Your MySQL Database on Alibaba Cloud

The ApsaraDB Stack is part of Alibaba Cloud's wider suite of database services products. Each of the database services products will free you from the administrative tasks often associated with managing your corporate data.

Creating regular backups is a vital part of managing a database server, whether it's cloud-based or running in your own on-premises data center. It may be that your application already handles this by automatically retrieving its key data from the database server and creating backup files at regular intervals. If this is not the case, you will need to create and manage your backups as part of the process of running an ApsaraDB for RDS instance.

ApsaraDB for RDS includes an automatic backup system as standard, and it's important that you configure this to ensure that your data is being backed up at suitable times.

Backing up databases is not always as straightforward as backing up document files, as one or more applications might be updating the database at the time it's being backed up. If an update involves amending more than one table in the database, and if the backup takes place before all updates are complete, the backup will not be reliable.

This tutorial will cover how to get started with the ApsaraDB Stack and how to ensure your data is backed up, including both automatic and manual backups and covering how to access your data from the backup, if case problems do occur.

How to Set Up ApsaraDB for Memcache SDK with NodeJS

ApsaraDB is a suite of database products on Alibaba Cloud that includes support for RDS, MongoDB, Redis, and Memcache. In this tutorial, we will set up Alibaba Cloud's ApsaraDB for Memcache with the Alibaba Cloud SDK and NodeJS.

Alibaba Cloud ApsaraDB for Memcache is an in-memory caching service that supports high-speed access to queries and data, which is often web application session data. It improves the response of dynamic websites or applications by relieving the load on the backend database as cached data is stored in memory.

Related Product

ApsaraDB RDS for SQL Server

An on-demand database hosting service for SQL Server with automated monitoring, backup and disaster recovery capabilities
More: https://www.alibabacloud.com/product/apsaradb-for-rds-sql-server

ApsaraDB RDS for MySQL

A fully hosted online database service that supports MySQL 5.5, 5.6, 5.7, and 8.0.
More: https://www.alibabacloud.com/product/apsaradb-for-rds-mysql

ApsaraDB RDS for PostgreSQL

An on-demand database hosting service for PostgreSQL with automated monitoring, backup and disaster recovery capabilities
More: https://www.alibabacloud.com/product/apsaradb-for-rds-postgresql

ApsaraDB for MariaDB TX

ApsaraDB for MariaDB TX supports multiple storage engines, including MySQL InnoDB to meet different user requirements.
More: https://www.alibabacloud.com/product/apsaradb-for-rds-mariadb

0 0 0
Share on

Alibaba Clouder

2,599 posts | 764 followers

You may also like

Alibaba Clouder

2,599 posts | 764 followers

Related Products