All Products
Search
Document Center

ApsaraDB RDS:Getting Started

Last Updated:Mar 19, 2024

If you are new to ApsaraDB RDS, see the following topics to know about ApsaraDB RDS:

Database engines

ApsaraDB RDS supports the following database engines:

  • 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 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, Overview of DAS, and What are database proxies?

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

  • 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 provides the high availability architecture and the capability to restore data to a point in time. For more information, see Restore the data of an ApsaraDB RDS for SQL Server instance. This way, ApsaraDB RDS for SQL Server supports various enterprise applications. In addition, ApsaraDB RDS for SQL Server is offered with a valid license. You do not need to pay Microsoft licensing fees.

    The following SQL Server versions are supported:

    • 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

    • SQL Server 2008 R2 with cloud disks

  • 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 supports basic features such as transactions, subqueries, Multi-Version Concurrency Control (MVCC), and data integrity check. It also supports advanced features such as high availability, backup, and restoration. These features make database O&M easier.

    PostgreSQL 10 and later versions are supported.

  • 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 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.

    Only MariaDB 10.3 is supported.