RDS / Client / describe_db_engine_versions

describe_db_engine_versions#

RDS.Client.describe_db_engine_versions(**kwargs)#

Returns a list of the available DB engines.

See also: AWS API Documentation

Request Syntax

response = client.describe_db_engine_versions(
    Engine='string',
    EngineVersion='string',
    DBParameterGroupFamily='string',
    Filters=[
        {
            'Name': 'string',
            'Values': [
                'string',
            ]
        },
    ],
    MaxRecords=123,
    Marker='string',
    DefaultOnly=True|False,
    ListSupportedCharacterSets=True|False,
    ListSupportedTimezones=True|False,
    IncludeAll=True|False
)
Parameters:
  • Engine (string) –

    The database engine to return.

    Valid Values:

    • aurora (for MySQL 5.6-compatible Aurora)

    • aurora-mysql (for MySQL 5.7-compatible and MySQL 8.0-compatible Aurora)

    • aurora-postgresql

    • mariadb

    • mysql

    • oracle-ee

    • oracle-ee-cdb

    • oracle-se2

    • oracle-se2-cdb

    • postgres

    • sqlserver-ee

    • sqlserver-se

    • sqlserver-ex

    • sqlserver-web

  • EngineVersion (string) –

    The database engine version to return.

    Example: 5.1.49

  • DBParameterGroupFamily (string) –

    The name of a specific DB parameter group family to return details for.

    Constraints:

    • If supplied, must match an existing DBParameterGroupFamily.

  • Filters (list) –

    A filter that specifies one or more DB engine versions to describe.

    Supported filters:

    • db-parameter-group-family - Accepts parameter groups family names. The results list only includes information about the DB engine versions for these parameter group families.

    • engine - Accepts engine names. The results list only includes information about the DB engine versions for these engines.

    • engine-mode - Accepts DB engine modes. The results list only includes information about the DB engine versions for these engine modes. Valid DB engine modes are the following:

      • global

      • multimaster

      • parallelquery

      • provisioned

      • serverless

    • engine-version - Accepts engine versions. The results list only includes information about the DB engine versions for these engine versions.

    • status - Accepts engine version statuses. The results list only includes information about the DB engine versions for these statuses. Valid statuses are the following:

      • available

      • deprecated

    • (dict) –

      A filter name and value pair that is used to return a more specific list of results from a describe operation. Filters can be used to match a set of resources by specific criteria, such as IDs. The filters supported by a describe operation are documented with the describe operation.

      Note

      Currently, wildcards are not supported in filters.

      The following actions can be filtered:

      • DescribeDBClusterBacktracks

      • DescribeDBClusterEndpoints

      • DescribeDBClusters

      • DescribeDBInstances

      • DescribePendingMaintenanceActions

      • Name (string) – [REQUIRED]

        The name of the filter. Filter names are case-sensitive.

      • Values (list) – [REQUIRED]

        One or more filter values. Filter values are case-sensitive.

        • (string) –

  • MaxRecords (integer) –

    The maximum number of records to include in the response. If more than the MaxRecords value is available, a pagination token called a marker is included in the response so you can retrieve the remaining results.

    Default: 100

    Constraints: Minimum 20, maximum 100.

  • Marker (string) – An optional pagination token provided by a previous request. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords .

  • DefaultOnly (boolean) – A value that indicates whether only the default version of the specified engine or engine and major version combination is returned.

  • ListSupportedCharacterSets (boolean) –

    A value that indicates whether to list the supported character sets for each engine version.

    If this parameter is enabled and the requested engine supports the CharacterSetName parameter for CreateDBInstance , the response includes a list of supported character sets for each engine version.

    For RDS Custom, the default is not to list supported character sets. If you set ListSupportedCharacterSets to true , RDS Custom returns no results.

  • ListSupportedTimezones (boolean) –

    A value that indicates whether to list the supported time zones for each engine version.

    If this parameter is enabled and the requested engine supports the TimeZone parameter for CreateDBInstance , the response includes a list of supported time zones for each engine version.

    For RDS Custom, the default is not to list supported time zones. If you set ListSupportedTimezones to true , RDS Custom returns no results.

  • IncludeAll (boolean) – A value that indicates whether to include engine versions that aren’t available in the list. The default is to list only available engine versions.

Return type:

dict

Returns:

Response Syntax

{
    'Marker': 'string',
    'DBEngineVersions': [
        {
            'Engine': 'string',
            'EngineVersion': 'string',
            'DBParameterGroupFamily': 'string',
            'DBEngineDescription': 'string',
            'DBEngineVersionDescription': 'string',
            'DefaultCharacterSet': {
                'CharacterSetName': 'string',
                'CharacterSetDescription': 'string'
            },
            'Image': {
                'ImageId': 'string',
                'Status': 'string'
            },
            'DBEngineMediaType': 'string',
            'SupportedCharacterSets': [
                {
                    'CharacterSetName': 'string',
                    'CharacterSetDescription': 'string'
                },
            ],
            'SupportedNcharCharacterSets': [
                {
                    'CharacterSetName': 'string',
                    'CharacterSetDescription': 'string'
                },
            ],
            'ValidUpgradeTarget': [
                {
                    'Engine': 'string',
                    'EngineVersion': 'string',
                    'Description': 'string',
                    'AutoUpgrade': True|False,
                    'IsMajorVersionUpgrade': True|False,
                    'SupportedEngineModes': [
                        'string',
                    ],
                    'SupportsParallelQuery': True|False,
                    'SupportsGlobalDatabases': True|False,
                    'SupportsBabelfish': True|False
                },
            ],
            'SupportedTimezones': [
                {
                    'TimezoneName': 'string'
                },
            ],
            'ExportableLogTypes': [
                'string',
            ],
            'SupportsLogExportsToCloudwatchLogs': True|False,
            'SupportsReadReplica': True|False,
            'SupportedEngineModes': [
                'string',
            ],
            'SupportedFeatureNames': [
                'string',
            ],
            'Status': 'string',
            'SupportsParallelQuery': True|False,
            'SupportsGlobalDatabases': True|False,
            'MajorEngineVersion': 'string',
            'DatabaseInstallationFilesS3BucketName': 'string',
            'DatabaseInstallationFilesS3Prefix': 'string',
            'DBEngineVersionArn': 'string',
            'KMSKeyId': 'string',
            'CreateTime': datetime(2015, 1, 1),
            'TagList': [
                {
                    'Key': 'string',
                    'Value': 'string'
                },
            ],
            'SupportsBabelfish': True|False,
            'CustomDBEngineVersionManifest': 'string',
            'SupportsCertificateRotationWithoutRestart': True|False,
            'SupportedCACertificateIdentifiers': [
                'string',
            ]
        },
    ]
}

Response Structure

  • (dict) –

    Contains the result of a successful invocation of the DescribeDBEngineVersions action.

    • Marker (string) –

      An optional pagination token provided by a previous request. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords .

    • DBEngineVersions (list) –

      A list of DBEngineVersion elements.

      • (dict) –

        This data type is used as a response element in the action DescribeDBEngineVersions .

        • Engine (string) –

          The name of the database engine.

        • EngineVersion (string) –

          The version number of the database engine.

        • DBParameterGroupFamily (string) –

          The name of the DB parameter group family for the database engine.

        • DBEngineDescription (string) –

          The description of the database engine.

        • DBEngineVersionDescription (string) –

          The description of the database engine version.

        • DefaultCharacterSet (dict) –

          The default character set for new instances of this engine version, if the CharacterSetName parameter of the CreateDBInstance API isn’t specified.

          • CharacterSetName (string) –

            The name of the character set.

          • CharacterSetDescription (string) –

            The description of the character set.

        • Image (dict) –

          The EC2 image

          • ImageId (string) –

            A value that indicates the ID of the AMI.

          • Status (string) –

            A value that indicates the status of a custom engine version (CEV).

        • DBEngineMediaType (string) –

          A value that indicates the source media provider of the AMI based on the usage operation. Applicable for RDS Custom for SQL Server.

        • SupportedCharacterSets (list) –

          A list of the character sets supported by this engine for the CharacterSetName parameter of the CreateDBInstance operation.

          • (dict) –

            This data type is used as a response element in the action DescribeDBEngineVersions .

            • CharacterSetName (string) –

              The name of the character set.

            • CharacterSetDescription (string) –

              The description of the character set.

        • SupportedNcharCharacterSets (list) –

          A list of the character sets supported by the Oracle DB engine for the NcharCharacterSetName parameter of the CreateDBInstance operation.

          • (dict) –

            This data type is used as a response element in the action DescribeDBEngineVersions .

            • CharacterSetName (string) –

              The name of the character set.

            • CharacterSetDescription (string) –

              The description of the character set.

        • ValidUpgradeTarget (list) –

          A list of engine versions that this database engine version can be upgraded to.

          • (dict) –

            The version of the database engine that a DB instance can be upgraded to.

            • Engine (string) –

              The name of the upgrade target database engine.

            • EngineVersion (string) –

              The version number of the upgrade target database engine.

            • Description (string) –

              The version of the database engine that a DB instance can be upgraded to.

            • AutoUpgrade (boolean) –

              A value that indicates whether the target version is applied to any source DB instances that have AutoMinorVersionUpgrade set to true.

            • IsMajorVersionUpgrade (boolean) –

              A value that indicates whether upgrading to the target version requires upgrading the major version of the database engine.

            • SupportedEngineModes (list) –

              A list of the supported DB engine modes for the target engine version.

              • (string) –

            • SupportsParallelQuery (boolean) –

              A value that indicates whether you can use Aurora parallel query with the target engine version.

            • SupportsGlobalDatabases (boolean) –

              A value that indicates whether you can use Aurora global databases with the target engine version.

            • SupportsBabelfish (boolean) –

              A value that indicates whether you can use Babelfish for Aurora PostgreSQL with the target engine version.

        • SupportedTimezones (list) –

          A list of the time zones supported by this engine for the Timezone parameter of the CreateDBInstance action.

          • (dict) –

            A time zone associated with a DBInstance or a DBSnapshot . This data type is an element in the response to the DescribeDBInstances , the DescribeDBSnapshots , and the DescribeDBEngineVersions actions.

            • TimezoneName (string) –

              The name of the time zone.

        • ExportableLogTypes (list) –

          The types of logs that the database engine has available for export to CloudWatch Logs.

          • (string) –

        • SupportsLogExportsToCloudwatchLogs (boolean) –

          A value that indicates whether the engine version supports exporting the log types specified by ExportableLogTypes to CloudWatch Logs.

        • SupportsReadReplica (boolean) –

          Indicates whether the database engine version supports read replicas.

        • SupportedEngineModes (list) –

          A list of the supported DB engine modes.

          • (string) –

        • SupportedFeatureNames (list) –

          A list of features supported by the DB engine.

          The supported features vary by DB engine and DB engine version.

          To determine the supported features for a specific DB engine and DB engine version using the CLI, use the following command:

          aws rds describe-db-engine-versions --engine <engine_name> --engine-version <engine_version>

          For example, to determine the supported features for RDS for PostgreSQL version 13.3 using the CLI, use the following command:

          aws rds describe-db-engine-versions --engine postgres --engine-version 13.3

          The supported features are listed under SupportedFeatureNames in the output.

          • (string) –

        • Status (string) –

          The status of the DB engine version, either available or deprecated .

        • SupportsParallelQuery (boolean) –

          A value that indicates whether you can use Aurora parallel query with a specific DB engine version.

        • SupportsGlobalDatabases (boolean) –

          A value that indicates whether you can use Aurora global databases with a specific DB engine version.

        • MajorEngineVersion (string) –

          The major engine version of the CEV.

        • DatabaseInstallationFilesS3BucketName (string) –

          The name of the Amazon S3 bucket that contains your database installation files.

        • DatabaseInstallationFilesS3Prefix (string) –

          The Amazon S3 directory that contains the database installation files. If not specified, then no prefix is assumed.

        • DBEngineVersionArn (string) –

          The ARN of the custom engine version.

        • KMSKeyId (string) –

          The Amazon Web Services KMS key identifier for an encrypted CEV. This parameter is required for RDS Custom, but optional for Amazon RDS.

        • CreateTime (datetime) –

          The creation time of the DB engine version.

        • TagList (list) –

          A list of tags. For more information, see Tagging Amazon RDS Resources in the Amazon RDS User Guide.

          • (dict) –

            Metadata assigned to an Amazon RDS resource consisting of a key-value pair.

            For more information, see Tagging Amazon RDS Resources in the Amazon RDS User Guide.

            • Key (string) –

              A key is the required name of the tag. The string value can be from 1 to 128 Unicode characters in length and can’t be prefixed with aws: or rds: . The string can only contain only the set of Unicode letters, digits, white-space, ‘_’, ‘.’, ‘:’, ‘/’, ‘=’, ‘+’, ‘-’, ‘@’ (Java regex: “^([\p{L}\p{Z}\p{N}_.:/=+\-@]*)$”).

            • Value (string) –

              A value is the optional value of the tag. The string value can be from 1 to 256 Unicode characters in length and can’t be prefixed with aws: or rds: . The string can only contain only the set of Unicode letters, digits, white-space, ‘_’, ‘.’, ‘:’, ‘/’, ‘=’, ‘+’, ‘-’, ‘@’ (Java regex: “^([\p{L}\p{Z}\p{N}_.:/=+\-@]*)$”).

        • SupportsBabelfish (boolean) –

          A value that indicates whether the engine version supports Babelfish for Aurora PostgreSQL.

        • CustomDBEngineVersionManifest (string) –

          JSON string that lists the installation files and parameters that RDS Custom uses to create a custom engine version (CEV). RDS Custom applies the patches in the order in which they’re listed in the manifest. You can set the Oracle home, Oracle base, and UNIX/Linux user and group using the installation parameters. For more information, see JSON fields in the CEV manifest in the Amazon RDS User Guide .

        • SupportsCertificateRotationWithoutRestart (boolean) –

          A value that indicates whether the engine version supports rotating the server certificate without rebooting the DB instance.

        • SupportedCACertificateIdentifiers (list) –

          A list of the supported CA certificate identifiers.

          For more information, see Using SSL/TLS to encrypt a connection to a DB instance in the Amazon RDS User Guide and Using SSL/TLS to encrypt a connection to a DB cluster in the Amazon Aurora User Guide .

          • (string) –

Examples

This example lists settings for the specified DB engine version.

response = client.describe_db_engine_versions(
    DBParameterGroupFamily='mysql5.6',
    DefaultOnly=True,
    Engine='mysql',
    EngineVersion='5.6',
    ListSupportedCharacterSets=True,
)

print(response)

Expected Output:

{
    'ResponseMetadata': {
        '...': '...',
    },
}