add mysql 5.7 LTS release

[hooby404]

By submitting this pull request, I confirm that my contribution is made under the terms of the Apache 2.0 license.

Added EngineVersion "5.7.mysql_aurora.2.04.9" which is the current LTS release.

[michaelwittig]

@hooby404 are you sure that this works? My understanding of the below output is that the version 5.7.mysql_aurora.2.04.9 is not supported by Aurora Serverless. SupportedEngineModes misses the serverless entry. I can also not select the version in the UI.

{
            "Engine": "aurora-mysql",
            "EngineVersion": "5.7.mysql_aurora.2.04.9",
            "DBParameterGroupFamily": "aurora-mysql5.7",
            "DBEngineDescription": "Aurora MySQL",
            "DBEngineVersionDescription": "Aurora (MySQL 5.7) 2.04.9",
            "ValidUpgradeTarget": [
                {
                    "Engine": "aurora-mysql",
                    "EngineVersion": "5.7.mysql_aurora.2.05.0",
                    "Description": "Aurora (MySQL 5.7) 2.05.0",
                    "AutoUpgrade": false,
                    "IsMajorVersionUpgrade": false
                },
                {
                    "Engine": "aurora-mysql",
                    "EngineVersion": "5.7.mysql_aurora.2.07.1",
                    "Description": "Aurora (MySQL 5.7) 2.07.1",
                    "AutoUpgrade": false,
                    "IsMajorVersionUpgrade": false
                },
                {
                    "Engine": "aurora-mysql",
                    "EngineVersion": "5.7.mysql_aurora.2.07.2",
                    "Description": "Aurora (MySQL 5.7) 2.07.2",
                    "AutoUpgrade": false,
                    "IsMajorVersionUpgrade": false
                },
                {
                    "Engine": "aurora-mysql",
                    "EngineVersion": "5.7.mysql_aurora.2.08.2",
                    "Description": "Aurora (MySQL 5.7) 2.08.2",
                    "AutoUpgrade": false,
                    "IsMajorVersionUpgrade": false
                },
                {
                    "Engine": "aurora-mysql",
                    "EngineVersion": "5.7.mysql_aurora.2.09.0",
                    "Description": "Aurora (MySQL 5.7) 2.09.0",
                    "AutoUpgrade": false,
                    "IsMajorVersionUpgrade": false
                }
            ],
            "ExportableLogTypes": [
                "audit",
                "error",
                "general",
                "slowquery"
            ],
            "SupportsLogExportsToCloudwatchLogs": true,
            "SupportsReadReplica": false,
            "SupportedEngineModes": [
                "provisioned"
            ],
            "SupportedFeatureNames": [],
            "Status": "available",
            "SupportsParallelQuery": false,
            "SupportsGlobalDatabases": false
        },

[hooby404]

Yeah, I just figured that out... I put too much trust into the AWS documentation... again! (I should know not to trust them by now...)

I'll be retracting/closing that pull request.

[michaelwittig]

@hooby404 A agree, the serverless offering needs to catch up with all the features we are used to...

[hooby404]

It would be really nice to have access to at least one of these two: .) viable upgrade path to a new version .) LTS versions that you don't have to upgrade often

Being unable to upgrade and not having an LTS version at the same time really makes me feel uneasy.