Amazon Web Services (AWS) is the world’s most comprehensive and widely used cloud platform, with over 200 fully featured services available from data centres around the world. Millions of clients, including the fastest-growing startups, largest corporations, and top government agencies, rely on AWS to reduce costs, improve agility, and accelerate innovation.
The Amazon Relational Database Service (Amazon RDS) is a suite of managed services that makes it easy to set up, run, and scale databases in the cloud. Select from seven popular engines — Amazon Aurora with MySQL support, Amazon Aurora with PostgreSQL support, MySQL, MariaDB, PostgreSQL, Oracle, and SQL Server — and install on-premises with Amazon RDS on AWS Outposts.
In this article, we will talk about the database engines it offers, its editions and the versions.
As previously said, common engines that are available include Amazon Aurora with MySQL support, Amazon Aurora with PostgreSQL support, MySQL, MariaDB, PostgreSQL, Oracle, and SQL Server.
When you click CREATE DATABASE from your RDS dashboard, you’ll be sent to the page seen above. You must decide which engine is required for your databases.
Amazon Aurora engine:
When you choose this engine, you’ll be presented with two Editions: Amazon Aurora MySQL Compatible Edition and Amazon Aurora PostgreSQL Compatible Edition.
There is a dropdown menu below it with the available or supported versions.
There are now 22 versions starting from – Aurora (MySQL 5.6) 1.17.9 to Aurora (MySQL 5.7) 2.10.2 and Aurora MySQL 3.01.1 to 3.02.1 (compatible with MySQL 8.0.23).
MySQL engine:
If you choose MySQL as the engine for your databases, the default edition that appears is MySQL Community. And the versions in the dropdown are from MySQL 5.7.33 to MySQL 8.0.30.
MariaDB engine:
If you choose MariaDB as the engine for your databases, you’ll see the supported versions in the dropdown are from MariaDB 10.3.28 to 10.6.8
PostgreSQL engine:
If you choose PostgreSQL as the engine for your databases, you’ll see the supported versions in the dropdown are from PostgreSQL 10.17-R1 to PostgreSQL 14.4-R1.
Oracle engine:
If you choose Oracle as the engine for your databases, you’ll see two types of database management offered by Amazon.
- Amazon RDS: Fully manages your database, including automatic patching. Choose this option if you don’t need to customize your environment.
- Amazon RDS Custom: RDS manages your database and gives you privileged access to the OS. Use this option if you want to customize the database, OS, and infrastructure.
When it comes to editions, it offers two: Enterprise edition and Standard edition 2.
- Oracle Enterprise edition is an efficient, reliable, and secure database management system that delivers comprehensive high-end capabilities for mission-critical applications and demanding database workloads.
- Standard edition 2 is an affordable and full-featured database management system supporting up to 16 vCPUs. Oracle Database Standard Edition Two is a replacement for Standard Edition and Standard Edition One. If you have already purchased a license, you can enter it here. Otherwise, you can request that the license be included.
The supported versions for the enterprise edition is – Oracle 19.0.0.0.ru-2019.07.rur-2019-07.r1 to 19.0.0.0.ru-2022.04.rur-2022-04.r1.
Microsoft SQL Server engine:
If you choose SQL Server as the engine for your databases, you’ll see two types of database management offered by Amazon, similar to Oracle.
- Amazon RDS: Fully manages your database, including automatic patching. Choose this option if you don’t need to customize your environment.
- Amazon RDS Custom: RDS manages your database and gives you privileged access to the OS. Use this option if you want to customize the database, OS, and infrastructure.
When it comes to editions, it offers Expression Edition, Web Edition, Standard Edition and Enterprise Editions.
For the Enterprise edition, the license is included and the versions are available from SQL Server 2014 12.00.6293.0.v1 to SQL Server 2019 15.00.4198.2.v1.
Hope you find this article helpful.
Please write to us.
Big Data and SQL 