If you are new to ApsaraDB RDS, see the following topics to know about ApsaraDB RDS:
- Create an ApsaraDB RDS for MySQL instance
- Create an ApsaraDB RDS for SQL Server instance
- Create an ApsaraDB RDS for PostgreSQL instance
- Create an ApsaraDB RDS for MariaDB TX instance
ApsaraDB RDS supports the following database engines:
MySQL is the world's most popular open source database management system. 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. In addition, ApsaraDB RDS for MySQL provides enhanced advanced features, such as read/write splitting, dedicated proxy, and intelligent optimization. For more information, see Read/write splitting, DAS overview, and What are database proxies?.
Supported MySQL versions are 5.5, 5.6, 5.7, and 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 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 2008 R2
- SQL Server 2012 Web, 2012 SE, and 2012 EE
- SQL Server 2016 Web, 2016 SE, and 2016 EE
- SQL Server 2017 SE and 2017 EE (cluster edition)
- SQL Server 2019 SE and 2019 EE (cluster edition)
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.
Supported PostgreSQL versions are 9.4, 10, 11, 12, and 13.
- MariaDB TX
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.
MariaDB TX is compatible with the Procedural Language/SQL (PL/SQL) language offered by Oracle Corporation. MariaDB TX is a transactional database platform based on MariaDB Server, MariaDB MaxScale, and MariaDB Cluster. This enterprise-oriented platform integrates database connectors and management tools and provides technical support and expert services.
Only MariaDB TX 10.3 is supported.