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.
RDS allows you to quickly build a stable and reliable database system. It has the following advantages compared with user-created databases:
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 offers four editions: Basic, High-availability, Cluster, and Enterprise.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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
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
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 supports multiple storage engines, including MySQL InnoDB to meet different user requirements.
More: https://www.alibabacloud.com/product/apsaradb-for-rds-mariadb
Cloud-Native and Application Management with Ease – Part 3: Architecture Principles
Cloud-Native and Application Management with Ease – Part 4: Architecture Models
2,599 posts | 762 followers
FollowAlibaba Clouder - August 2, 2019
Alibaba Clouder - May 6, 2021
Alibaba Clouder - July 26, 2019
Sabith - August 8, 2018
ApsaraDB - February 9, 2022
ApsaraDB - November 25, 2022
2,599 posts | 762 followers
Follow
ApsaraDB RDS for MySQL
An on-demand database hosting service for MySQL with automated monitoring, backup and disaster recovery capabilities
Learn More
ApsaraDB RDS for PostgreSQL
An on-demand database hosting service for PostgreSQL with automated monitoring, backup and disaster recovery capabilities
Learn More
ApsaraDB RDS for MariaDB
ApsaraDB RDS for MariaDB supports multiple storage engines, including MySQL InnoDB to meet different user requirements.
Learn More
ApsaraDB RDS for SQL Server
An on-demand database hosting service for SQL Server with automated monitoring, backup and disaster recovery capabilities
Learn MoreMore Posts by Alibaba Clouder
