If you are new to Alibaba Cloud Relational Database Service (RDS), refer to the Quick Start documents to get started.
Introduction to database engines
ApsaraDB RDS for MySQL
MySQL | MySQL is one of the world's most popular open source databases. As a key part of the LAMP (Linux, Apache, MySQL, and Perl/PHP/Python) stack, it is widely used in various applications.
|
RDS for MySQL | ApsaraDB RDS for MySQL is based on Alibaba's MySQL source code branch. It has been tested by the high concurrency and large data volumes of the Double 11 shopping festival, and delivers excellent performance and throughput. In addition, ApsaraDB RDS for MySQL provides advanced features such as optimized read/write splitting, database proxy, and intelligent tuning. |
Supported versions | Supports MySQL 5.5, 5.6, 5.7, and 8.0. |
ApsaraDB RDS for SQL Server
SQL Server | SQL Server is one of the earliest commercial database products. As a key part of the Windows platform (IIS, .NET, and SQL Server), it supports many enterprise applications. The built-in Management Studio software for SQL Server includes many graphical tools and a rich script editor. You can quickly perform various database operations using the visualization interface. |
RDS SQL Server | ApsaraDB RDS for SQL Server provides a high availability (HA) architecture and point-in-time data restoration to support various enterprise applications. It also includes a genuine Microsoft license. The instance fee includes the Microsoft license fee, so you do not need to pay extra. |
Supported versions |
|
ApsaraDB RDS for PostgreSQL
PostgreSQL | PostgreSQL is an open source database. As the forerunner of academic relational database management systems, its main advantages are its full implementation of the SQL standard and its support for a wide variety of data types. These include JSON, IP, and geometric data, which most commercial databases do not support. |
RDS PostgreSQL | ApsaraDB RDS for PostgreSQL fully supports features such as transactions, subqueries, Multi-Version Concurrency Control (MVCC), and data integrity checks. It also integrates important features like high availability and backup and recovery to reduce your O&M workload. |
Supported versions | ApsaraDB RDS for PostgreSQL supports version 11 and later. |
ApsaraDB RDS for MariaDB
MariaDB | MariaDB is a branch of MySQL. It is mainly maintained by the open source community and is licensed under the GNU General Public License (GPL). The goal of MariaDB is to be fully compatible with MySQL, including its APIs and command line, making it an easy replacement for MySQL. For storage engines, MariaDB version 10.0.9 and later use XtraDB (codenamed Aria) instead of MySQL's InnoDB. |
RDS for MariaDB | Alibaba Cloud ApsaraDB RDS for MariaDB is fully compatible with the community edition of MariaDB. It is also highly compatible with Oracle, provides excellent compatibility with PL/SQL, and offers technical support and expert services to provide you with an enterprise-level database solution. |
Supported versions | ApsaraDB RDS for MariaDB supports versions 10.3 and 10.6. |
FAQ
Q: What are the system databases in ApsaraDB RDS?
A: The default system databases in ApsaraDB RDS vary by engine. You can connect to an ApsaraDB RDS database to view them. The system databases for each engine are as follows:
ApsaraDB RDS for MySQL:
information_schema,mysql,performance_schema,sys, and__recycle_bin__ApsaraDB RDS for SQL Server:
master,msdb,tempdb, andmodelApsaraDB RDS for PostgreSQL:
postgres,template1, andrdsadminApsaraDB RDS for MariaDB:
information_schema,mysql,performance_schema, andsys