ApsaraDB RDS (Relational Database Service) is a stable, reliable, and scalable online database service. Based on Alibaba Cloud's distributed file system and high-performance SSDs, RDS supports MySQL, SQL Server, PostgreSQL, PPAS (Postgre Plus Advanced Server, highly compatible with Oracle) and MariaDB engines. It provides a complete solution that includes backup, recovery, monitoring, migration, and more, allowing you to focus on services rather than database O&M.
Use RDS Learning Path to learn about concepts and operations of RDS.
Learn about the following concepts to help you get familiar with RDS:
- Instance: An RDS instance is a virtualized database server. You can create one or more databases in the instance.
- Region: A region is a physical data center. Generally, your RDS and ECS instances need to be in the same region so that ECS can access RDS at the fastest speed.
- Zone: A region consists of one or more zones. A zone is a physical area that has independent power supply and networks. There are no essential differences between different zones of the same region.
- Database engine: Database engines supported by RDS are MySQL, SQL Server, PostgreSQL, PPAS (Postgre Plus Advanced Server, highly compatible with Oracle) and MariaDB. For more information, see Database engines.
- Network type: You can deploy your instance in a classic network or virtual private cloud (VPC). A VPC is an isolated network and therefore is more secure than the classic network. We recommend that you use VPCs.
- Product series: Basic Edition, High-Availability Edition, and Cluster (AlwaysOn) Edition. For more information, see Product series overview.
- Instance type family: Common instance, dedicated instance, or dedicated-host instance. For more information, see Instance type overview.
- Storage type: Local SSDs or cloud SSDs. For more information, see Storage types.
- ECS: ECS is a cloud-based server. An ECS instance can access an RDS instance at the fastest speed if the ECS instance accesses the RDS instance through the intranet. Using both ECS and RDS is a typical service model.
- Redis: Redis is a persistent in-memory database service. If the service volume is large, using ECS, RDS, and Redis can handle more read requests and reduce the response time.
- MongoDB: MongoDB is a stable, reliable, and scalable database service that is compatible with the MongoDB protocol. If your business involves different types of data structure, you use store structured data in RDS and unstructured data in MongoDB.
- MaxCompute: MaxCompute (previously known as ODPS) is a general-purpose, fully managed, multi-tenant data processing platform for large-scale data warehousing. MaxCompute supports various data importing solutions and distributed computing models, allowing you to effectively query massive datasets, reduce production costs, and ensure data security. You can use the Data Integration service to import RDS data to MaxCompute for large-scale data processing.
- DTS: You can use Data Transmission Service (DTS) to migrate on-premises database to RDS or implement remote disaster recovery of RDS.
- OSS: Object Storage Service (OSS) is an encrypted, secure, cost-effective, and easy-to-use object storage service that enables you to store, back up, and archive large amounts of data in the cloud.
How to use ApsaraDB RDS
- Web console: RDS provides a graphical web console where you can perform operations easily.
- CLI: All operations available on the web console can be performed through the CLI.
- SDK: All operations available on the web console can be performed through the SDK.
- API: All operations available on the web console can be performed through APIs.
After creating an RDS instance, you can access it through any common client, such as MySQL-Front, SSMS (SQL Server Management Studio), or pgAdmin.