Multiple Updates to Amazon Relational Database Service The Amazon Relational Database Service (Amazon RDS), which is available on the Amazon Web Services Inc.’s (AWS) cloud, recently received multiple updates. It now supports newer versions of MySQL and MariaDB, as well as PostgreSQL. Amazon RDS allows customers to use relational databases in cloud. It also handles administration functions such as hardware provisioning, database setup, patching, and backups. It supports six RDBMS options: Amazon Aurora (PostgreSQL), MySQL, MariaDB and Oracle as well as Microsoft SQL Server. AWS has announced several database version upgrades this week, as well as other updates.

  • Amazon RDS for MariaDB now supports MariaDB 10, the latest major version of the open-source database from the original developers. The company stated that MariaDB 10.3 has improved Oracle compatibility, supports querying historical databases, and features that increase flexibility and manageability for developers and DBAs.
  • Amazon RDS for MySQL now supports MySQL Community Edition major release 8.0. AWS stated that MySQL 8.0 is the most recent major version and includes new query functionality and enhancements to improve performance, reliability and security. It also offers international and mobile support. AWS announced earlier this month that the MySQL service now supports minor versions of the 5.x series. AWS also announced that the service now supports global transaction identifiers.
  • Amazon RDS for Oracle now supports database storage sizes up to 32TiB. AWS stated that 32TiB storage supports larger transactional databases and allows you to consolidate multiple database shards into one instance. This will simplify your application code, and reduce the administration work involved in maintaining the database.
  • PostgreSQL 11 now available in the Amazon RDS Database Preview Environment. This environment allows data developers to test the beta, release candidate, and early production versions on RDS. On October 18, PostgreSQL 11 was released. Yesterday, AWS announced that customers can now “test the early version of PostgreSQL 11 via Amazon RDS.” This includes 40+ extensions such as PostGIS and support to hash partitioning. PostgreSQL 11 is now available for performance and development testing in the Amazon RDS Database Preview Environment. This allows you to avoid the hassle of installing, provisioning and managing the database.

In a blog post on October 23, Jeff Barr, spokesperson for AWS, detailed many of these announcements as well as more in a detailed blog post. Barr also shared the following news:

  • Console Update — The RDS console has a new, fresh look. Barr stated that you can view a complete overview of your RDS resources, create a new RDS database, access documentation, etc., from the home page.
  • RDS Recommendations — Customers now have the ability to get recommendations to help set up database instances using AWS best practices.
  • Performance Insights for MySQL — Customers have the ability to look deep within MySQL to learn more about how queries are processed.
  • M5 Instances — Customers now have the option to use MySQL or MariaDB on M5 instances

Barr stated that all new features, engines, and instance types are now available.