{"id":4366,"date":"2025-02-05T13:09:28","date_gmt":"2025-02-05T13:09:28","guid":{"rendered":"https:\/\/geekmungus.co.uk\/?p=4366"},"modified":"2025-02-05T13:09:29","modified_gmt":"2025-02-05T13:09:29","slug":"show-available-aws-aurora-mysql-database-engines","status":"publish","type":"post","link":"https:\/\/geekmungus.co.uk\/?p=4366","title":{"rendered":"Show Available AWS Aurora MySQL Database Engines"},"content":{"rendered":"\n<p>To get a list of current AWS Aurora MySQL (compatible) <strong>Database Engines<\/strong> you can use the following command from the AWS CLI:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>aws rds describe-db-engine-versions \\\n  --engine aurora-mysql \\\n  --query \"DBEngineVersions&#91;].{Engine:Engine,Version:EngineVersion}\" \\\n  --output table<\/code><\/pre>\n\n\n\n<p>So you&#8217;ll get an output like:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>---------------------------------------------\n|         DescribeDBEngineVersions          |\n+---------------+---------------------------+\n|    Engine     |          Version          |\n+---------------+---------------------------+\n|  aurora-mysql |  5.7.mysql_aurora.2.11.1  |\n|  aurora-mysql |  5.7.mysql_aurora.2.11.2  |\n|  aurora-mysql |  5.7.mysql_aurora.2.11.3  |\n|  aurora-mysql |  5.7.mysql_aurora.2.11.4  |\n|  aurora-mysql |  5.7.mysql_aurora.2.11.5  |\n|  aurora-mysql |  5.7.mysql_aurora.2.11.6  |\n|  aurora-mysql |  5.7.mysql_aurora.2.12.0  |\n|  aurora-mysql |  5.7.mysql_aurora.2.12.1  |\n|  aurora-mysql |  5.7.mysql_aurora.2.12.2  |\n|  aurora-mysql |  5.7.mysql_aurora.2.12.3  |\n|  aurora-mysql |  5.7.mysql_aurora.2.12.4  |\n|  aurora-mysql |  8.0.mysql_aurora.3.04.0  |\n|  aurora-mysql |  8.0.mysql_aurora.3.04.1  |\n|  aurora-mysql |  8.0.mysql_aurora.3.04.2  |\n|  aurora-mysql |  8.0.mysql_aurora.3.04.3  |\n|  aurora-mysql |  8.0.mysql_aurora.3.05.2  |\n|  aurora-mysql |  8.0.mysql_aurora.3.06.0  |\n|  aurora-mysql |  8.0.mysql_aurora.3.06.1  |\n|  aurora-mysql |  8.0.mysql_aurora.3.07.0  |\n|  aurora-mysql |  8.0.mysql_aurora.3.07.1  |\n|  aurora-mysql |  8.0.mysql_aurora.3.08.0  |\n+---------------+---------------------------+<\/code><\/pre>\n\n\n\n<p>At the time of writing (05\/02\/25) the recommended\/default version is: <strong>8.0.mysql_aurora.3.05.2<\/strong>, but remember that the list of Database Engines that are provided will include ones that are on &#8220;extended support&#8221;, which you may not want to use depending on your requirement.<\/p>\n\n\n\n<p>You can also specify different database engine types (with the same command above) to get the available versions for things like postgreSQL etc.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To get a list of current AWS Aurora MySQL (compatible) Database Engines you can use the following command from the AWS CLI: So you&#8217;ll get an output like: At the time of writing (05\/02\/25) the recommended\/default version is: 8.0.mysql_aurora.3.05.2, but remember that the list of Database Engines that are provided will include ones that are &#8230; <a title=\"Show Available AWS Aurora MySQL Database Engines\" class=\"read-more\" href=\"https:\/\/geekmungus.co.uk\/?p=4366\" aria-label=\"Read more about Show Available AWS Aurora MySQL Database Engines\">Read more<\/a><\/p>\n","protected":false},"author":4,"featured_media":4367,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28,4],"tags":[],"class_list":["post-4366","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-aws","category-databases"],"_links":{"self":[{"href":"https:\/\/geekmungus.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/4366","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/geekmungus.co.uk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/geekmungus.co.uk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/geekmungus.co.uk\/index.php?rest_route=\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/geekmungus.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4366"}],"version-history":[{"count":1,"href":"https:\/\/geekmungus.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/4366\/revisions"}],"predecessor-version":[{"id":4368,"href":"https:\/\/geekmungus.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/4366\/revisions\/4368"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/geekmungus.co.uk\/index.php?rest_route=\/wp\/v2\/media\/4367"}],"wp:attachment":[{"href":"https:\/\/geekmungus.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4366"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/geekmungus.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4366"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/geekmungus.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4366"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}