ApsaraDB RDS:Getting Started

MySQL

MySQL is one of the most popular open source databases in the world. As an important part of the open source software bundle LAMP (Linux, Apache, MySQL, and Perl/PHP/Python), MySQL is widely used for various applications.

• Since the Web 2.0 era, MySQL has been serving as a basis for the underlying infrastructure of DISCUZ!, a popular Bulletin Board System (BBS) software system, and WordPress, a blogging platform.

• In the Web 3.0 era, leading Internet companies, such as Alibaba Group, Facebook, and Google, have built large-sized, mature database clusters by taking advantage of the advanced flexibility of MySQL.

ApsaraDB RDS for MySQL

ApsaraDB RDS for MySQL is developed based on the MySQL source code branch of Alibaba Cloud. It has withstood traffic bursts from highly concurrent requests and proven its excellent performance and high throughput over years of Double 11, a shopping festival in China. ApsaraDB RDS for MySQL provides enhanced advanced features, such as read/write splitting, database proxy, and intelligent optimization. For more information, see Enable the proxy terminal feature for an ApsaraDB RDS for MySQL instance, What are database proxies?, and Overview of DAS.

Supported versions

MySQL 5.5, MySQL 5.6, MySQL 5.7, and MySQL 8.0.

SQL Server

SQL Server is one of the first commercial database management systems. As an important part of the Windows platform (IIS + .NET + SQL Server), SQL Server provides support for a variety of enterprise applications. SQL Server Management Studio provided with SQL Server offers a complete suite of built-in graphical tools and script editors. You can quickly get started with a variety of database operations by using visual user interfaces (UIs).

ApsaraDB RDS for SQL Server

ApsaraDB RDS for SQL Server provides the high availability (HA) architecture and the capability to restore data to a point in time to provide support for various enterprise applications. For more information, see Restore the data of an ApsaraDB RDS for SQL Server instance. In addition, ApsaraDB RDS for SQL Server instances are provided with Microsoft SQL Server licenses included. The fee for the license is included in the fees of your RDS instance, and you do not need to pay Microsoft license fees.

Supported versions

• SQL Server 2017 EE on RDS Cluster Edition, SQL Server 2019 EE on RDS Cluster Edition, and SQL Server 2022 EE on RDS Cluster Edition

• SQL Server 2012 EE and SQL Server 2016 EE

• SQL Server 2012 EE Basic

• SQL Server 2012 SE, SQL Server 2016 SE, SQL Server 2017 SE, SQL Server 2019 SE, and SQL Server 2022 SE

• SQL Server 2012 Web, SQL Server 2016 Web, SQL Server 2017 Web, SQL Server 2019 Web, and SQL Server 2022 Web

PostgreSQL

PostgreSQL is an open source database management system. As the ancestor of academic relational database management systems, PostgreSQL provides full compliance with SQL specifications and robust support for diverse data formats, such as JSON, IP, and geometric data. These data formats are not supported in most of the commercial database management systems that are available on the market today.

ApsaraDB RDS for PostgreSQL

ApsaraDB RDS for PostgreSQL supports basic features such as transactions, subqueries, Multi-Version Concurrency Control (MVCC), and data integrity check. It also supports advanced features, such as HA, backup, and restoration. These features make database O&M easier.

Supported versions

PostgreSQL 11 or later

MariaDB

MariaDB is a branch of MySQL. It is maintained mainly by the open source community and follows GNU General Public License (GPL) specifications. MariaDB is designed to be fully compatible with MySQL, including the API and command line interface (CLI), with an intention to substitute MySQL. MariaDB 10.0.9 and later use the XtraDB storage engine, code-named Aria, to replace the InnoDB storage engine that is used with MySQL.

ApsaraDB RDS for MariaDB

ApsaraDB RDS for MariaDB is an enterprise-level database solution. It is fully compatible with open source MariaDB. It supports the PL/SQL language and is highly compatible with Oracle. Alibaba Cloud provides technical support and expert services for this database solution.

Supported versions

MariaDB 10.3 and MariaDB 10.6