Amazon Relational Database Service

2026/11/04 - Amazon Relational Database Service - 6 updated api methods

Changes  Adding support for copying and tagging option groups with cross-Region DB snapshot copies, in the same account or across accounts.

CopyDBSnapshot (updated) Link ¶
Changes (request)
{'TagSpecifications': [{'ResourceType': 'string',
                        'Tags': [{'Key': 'string', 'Value': 'string'}]}]}

Copies the specified DB snapshot. The source DB snapshot must be in the available state.

You can copy a snapshot from one Amazon Web Services Region to another. In that case, the Amazon Web Services Region where you call the CopyDBSnapshot operation is the destination Amazon Web Services Region for the DB snapshot copy.

This command doesn't apply to RDS Custom.

For more information about copying snapshots, see Copying a DB Snapshot in the Amazon RDS User Guide.

See also: AWS API Documentation

Request Syntax

client.copy_db_snapshot(
    SourceDBSnapshotIdentifier='string',
    TargetDBSnapshotIdentifier='string',
    KmsKeyId='string',
    Tags=[
        {
            'Key': 'string',
            'Value': 'string'
        },
    ],
    CopyTags=True|False,
    PreSignedUrl='string',
    OptionGroupName='string',
    TargetCustomAvailabilityZone='string',
    SnapshotTarget='string',
    CopyOptionGroup=True|False,
    SnapshotAvailabilityZone='string',
    TagSpecifications=[
        {
            'ResourceType': 'string',
            'Tags': [
                {
                    'Key': 'string',
                    'Value': 'string'
                },
            ]
        },
    ]
)
type SourceDBSnapshotIdentifier:

string

param SourceDBSnapshotIdentifier:

[REQUIRED]

The identifier for the source DB snapshot.

If the source snapshot is in the same Amazon Web Services Region as the copy, specify a valid DB snapshot identifier. For example, you might specify rds:mysql-instance1-snapshot-20130805.

If you are copying from a shared manual DB snapshot, this parameter must be the Amazon Resource Name (ARN) of the shared DB snapshot.

If the source snapshot is in a different Amazon Web Services Region than the copy, specify a valid DB snapshot ARN. You can also specify an ARN of a snapshot that is in a different account and a different Amazon Web Services Region. For example, you might specify arn:aws:rds:us-west-2:123456789012:snapshot:mysql-instance1-snapshot-20130805.

Constraints:

  • Must specify a valid source snapshot in the "available" state.

Example: rds:mydb-2012-04-02-00-01

Example: arn:aws:rds:us-west-2:123456789012:snapshot:mysql-instance1-snapshot-20130805

type TargetDBSnapshotIdentifier:

string

param TargetDBSnapshotIdentifier:

[REQUIRED]

The identifier for the copy of the snapshot.

Constraints:

  • Can't be null, empty, or blank

  • Must contain from 1 to 255 letters, numbers, or hyphens

  • First character must be a letter

  • Can't end with a hyphen or contain two consecutive hyphens

Example: my-db-snapshot

type KmsKeyId:

string

param KmsKeyId:

The Amazon Web Services KMS key identifier for an encrypted DB snapshot. The Amazon Web Services KMS key identifier is the key ARN, key ID, alias ARN, or alias name for the KMS key.

If you copy an encrypted DB snapshot from your Amazon Web Services account, you can specify a value for this parameter to encrypt the copy with a new KMS key. If you don't specify a value for this parameter, then the copy of the DB snapshot is encrypted with the same Amazon Web Services KMS key as the source DB snapshot.

If you copy an encrypted DB snapshot that is shared from another Amazon Web Services account, then you must specify a value for this parameter.

If you specify this parameter when you copy an unencrypted snapshot, the copy is encrypted.

If you copy an encrypted snapshot to a different Amazon Web Services Region, then you must specify an Amazon Web Services KMS key identifier for the destination Amazon Web Services Region. KMS keys are specific to the Amazon Web Services Region that they are created in, and you can't use KMS keys from one Amazon Web Services Region in another Amazon Web Services Region.

type Tags:

list

param Tags:

A list of tags.

For more information, see Tagging Amazon RDS resources in the Amazon RDS User Guide or Tagging Amazon Aurora and Amazon RDS resources in the Amazon Aurora 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 or Tagging Amazon Aurora and Amazon RDS resources in the Amazon Aurora 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}_.:/=+\-@]*)$").

type CopyTags:

boolean

param CopyTags:

Specifies whether to copy all tags from the source DB snapshot to the target DB snapshot. By default, tags aren't copied.

type PreSignedUrl:

string

param PreSignedUrl:

When you are copying a snapshot from one Amazon Web Services GovCloud (US) Region to another, the URL that contains a Signature Version 4 signed request for the CopyDBSnapshot API operation in the source Amazon Web Services Region that contains the source DB snapshot to copy.

This setting applies only to Amazon Web Services GovCloud (US) Regions. It's ignored in other Amazon Web Services Regions.

You must specify this parameter when you copy an encrypted DB snapshot from another Amazon Web Services Region by using the Amazon RDS API. Don't specify PreSignedUrl when you are copying an encrypted DB snapshot in the same Amazon Web Services Region.

The presigned URL must be a valid request for the CopyDBClusterSnapshot API operation that can run in the source Amazon Web Services Region that contains the encrypted DB cluster snapshot to copy. The presigned URL request must contain the following parameter values:

  • DestinationRegion - The Amazon Web Services Region that the encrypted DB snapshot is copied to. This Amazon Web Services Region is the same one where the CopyDBSnapshot operation is called that contains this presigned URL. For example, if you copy an encrypted DB snapshot from the us-west-2 Amazon Web Services Region to the us-east-1 Amazon Web Services Region, then you call the CopyDBSnapshot operation in the us-east-1 Amazon Web Services Region and provide a presigned URL that contains a call to the CopyDBSnapshot operation in the us-west-2 Amazon Web Services Region. For this example, the DestinationRegion in the presigned URL must be set to the us-east-1 Amazon Web Services Region.

  • KmsKeyId - The KMS key identifier for the KMS key to use to encrypt the copy of the DB snapshot in the destination Amazon Web Services Region. This is the same identifier for both the CopyDBSnapshot operation that is called in the destination Amazon Web Services Region, and the operation contained in the presigned URL.

  • SourceDBSnapshotIdentifier - The DB snapshot identifier for the encrypted snapshot to be copied. This identifier must be in the Amazon Resource Name (ARN) format for the source Amazon Web Services Region. For example, if you are copying an encrypted DB snapshot from the us-west-2 Amazon Web Services Region, then your SourceDBSnapshotIdentifier looks like the following example: arn:aws:rds:us-west-2:123456789012:snapshot:mysql-instance1-snapshot-20161115.

To learn how to generate a Signature Version 4 signed request, see Authenticating Requests: Using Query Parameters (Amazon Web Services Signature Version 4) and Signature Version 4 Signing Process.

type OptionGroupName:

string

param OptionGroupName:

The name of an option group to associate with the copy of the snapshot.

Specify this option if you are copying a snapshot from one Amazon Web Services Region to another, and your DB instance uses a nondefault option group. If your source DB instance uses Transparent Data Encryption for Oracle or Microsoft SQL Server, you must specify this option when copying across Amazon Web Services Regions. For more information, see Option group considerations in the Amazon RDS User Guide.

type TargetCustomAvailabilityZone:

string

param TargetCustomAvailabilityZone:

The external custom Availability Zone (CAZ) identifier for the target CAZ.

Example: rds-caz-aiqhTgQv.

type SnapshotTarget:

string

param SnapshotTarget:

Configures the location where RDS will store copied snapshots.

Valid Values:

  • local (Dedicated Local Zone)

  • outposts (Amazon Web Services Outposts)

  • region (Amazon Web Services Region)

type CopyOptionGroup:

boolean

param CopyOptionGroup:

Specifies whether to copy the DB option group associated with the source DB snapshot to the target Amazon Web Services account or Amazon Web Services Region and associate it with the target DB snapshot.

type SnapshotAvailabilityZone:

string

param SnapshotAvailabilityZone:

Specifies the name of the Availability Zone where RDS stores the DB snapshot. This value is valid only for snapshots that RDS stores on a Dedicated Local Zone.

type TagSpecifications:

list

param TagSpecifications:

Tags to assign to the copied option group. By default, the copied option group isn't tagged.

Valid Values:

  • og - The copied option group.

Constraints:

  • Can only be specified when CopyOptionGroup is true

  • (dict) --

    The tags to apply to resources when creating or modifying a DB instance or DB cluster, or when copying a DB instance snapshot. When you specify a tag, you must specify the resource type to tag, otherwise the request will fail.

    • ResourceType (string) --

      The type of resource to tag on creation.

      Valid Values:

      • auto-backup - The DB instance's automated backup.

      • cluster-auto-backup - The DB cluster's automated backup.

      • og - The copied option group. Valid only for CopyDBSnapshot.

    • Tags (list) --

      A list of tags.

      For more information, see Tagging Amazon RDS resources in the Amazon RDS User Guide or Tagging Amazon Aurora and Amazon RDS resources in the Amazon Aurora 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 or Tagging Amazon Aurora and Amazon RDS resources in the Amazon Aurora 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}_.:/=+\-@]*)$").

rtype:

dict

returns:

Response Syntax

{
    'DBSnapshot': {
        'DBSnapshotIdentifier': 'string',
        'DBInstanceIdentifier': 'string',
        'SnapshotCreateTime': datetime(2015, 1, 1),
        'Engine': 'string',
        'AllocatedStorage': 123,
        'Status': 'string',
        'Port': 123,
        'AvailabilityZone': 'string',
        'VpcId': 'string',
        'InstanceCreateTime': datetime(2015, 1, 1),
        'MasterUsername': 'string',
        'EngineVersion': 'string',
        'LicenseModel': 'string',
        'SnapshotType': 'string',
        'Iops': 123,
        'StorageThroughput': 123,
        'OptionGroupName': 'string',
        'PercentProgress': 123,
        'SourceRegion': 'string',
        'SourceDBSnapshotIdentifier': 'string',
        'StorageType': 'string',
        'TdeCredentialArn': 'string',
        'Encrypted': True|False,
        'StorageEncryptionType': 'none'|'sse-kms'|'sse-rds',
        'BackupRetentionPeriod': 123,
        'PreferredBackupWindow': 'string',
        'KmsKeyId': 'string',
        'DBSnapshotArn': 'string',
        'Timezone': 'string',
        'IAMDatabaseAuthenticationEnabled': True|False,
        'ProcessorFeatures': [
            {
                'Name': 'string',
                'Value': 'string'
            },
        ],
        'DbiResourceId': 'string',
        'TagList': [
            {
                'Key': 'string',
                'Value': 'string'
            },
        ],
        'SnapshotTarget': 'string',
        'OriginalSnapshotCreateTime': datetime(2015, 1, 1),
        'SnapshotDatabaseTime': datetime(2015, 1, 1),
        'DBSystemId': 'string',
        'MultiTenant': True|False,
        'DedicatedLogVolume': True|False,
        'AdditionalStorageVolumes': [
            {
                'VolumeName': 'string',
                'AllocatedStorage': 123,
                'IOPS': 123,
                'MaxAllocatedStorage': 123,
                'StorageThroughput': 123,
                'StorageType': 'string'
            },
        ],
        'SnapshotAvailabilityZone': 'string',
        'FullSnapshotSizeInBytes': 123
    }
}

Response Structure

  • (dict) --

    • DBSnapshot (dict) --

      Contains the details of an Amazon RDS DB snapshot.

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

      • DBSnapshotIdentifier (string) --

        Specifies the identifier for the DB snapshot.

      • DBInstanceIdentifier (string) --

        Specifies the DB instance identifier of the DB instance this DB snapshot was created from.

      • SnapshotCreateTime (datetime) --

        Specifies when the snapshot was taken in Coordinated Universal Time (UTC). Changes for the copy when the snapshot is copied.

      • Engine (string) --

        Specifies the name of the database engine.

      • AllocatedStorage (integer) --

        Specifies the allocated storage size in gibibytes (GiB).

      • Status (string) --

        Specifies the status of this DB snapshot.

      • Port (integer) --

        Specifies the port that the database engine was listening on at the time of the snapshot.

      • AvailabilityZone (string) --

        Specifies the name of the Availability Zone the DB instance was located in at the time of the DB snapshot.

      • VpcId (string) --

        Provides the VPC ID associated with the DB snapshot.

      • InstanceCreateTime (datetime) --

        Specifies the time in Coordinated Universal Time (UTC) when the DB instance, from which the snapshot was taken, was created.

      • MasterUsername (string) --

        Provides the master username for the DB snapshot.

      • EngineVersion (string) --

        Specifies the version of the database engine.

      • LicenseModel (string) --

        License model information for the restored DB instance.

      • SnapshotType (string) --

        Provides the type of the DB snapshot.

      • Iops (integer) --

        Specifies the Provisioned IOPS (I/O operations per second) value of the DB instance at the time of the snapshot.

      • StorageThroughput (integer) --

        Specifies the storage throughput for the DB snapshot.

      • OptionGroupName (string) --

        Provides the option group name for the DB snapshot.

      • PercentProgress (integer) --

        The percentage of the estimated data that has been transferred.

      • SourceRegion (string) --

        The Amazon Web Services Region that the DB snapshot was created in or copied from.

      • SourceDBSnapshotIdentifier (string) --

        The DB snapshot Amazon Resource Name (ARN) that the DB snapshot was copied from. It only has a value in the case of a cross-account or cross-Region copy.

      • StorageType (string) --

        Specifies the storage type associated with DB snapshot.

      • TdeCredentialArn (string) --

        The ARN from the key store with which to associate the instance for TDE encryption.

      • Encrypted (boolean) --

        Indicates whether the DB snapshot is encrypted.

      • StorageEncryptionType (string) --

        The type of encryption used to protect data at rest in the DB snapshot. Possible values:

        • none - The DB snapshot is not encrypted.

        • sse-rds - The DB snapshot is encrypted using an Amazon Web Services owned KMS key.

        • sse-kms - The DB snapshot is encrypted using a customer managed KMS key or Amazon Web Services managed KMS key.

      • BackupRetentionPeriod (integer) --

        The number of days for which automatic DB snapshots are retained.

      • PreferredBackupWindow (string) --

        The daily time range during which automated backups are created if automated backups are enabled, as determined by the BackupRetentionPeriod.

      • KmsKeyId (string) --

        If Encrypted is true, the Amazon Web Services KMS key identifier for the encrypted DB snapshot.

        The Amazon Web Services KMS key identifier is the key ARN, key ID, alias ARN, or alias name for the KMS key.

      • DBSnapshotArn (string) --

        The Amazon Resource Name (ARN) for the DB snapshot.

      • Timezone (string) --

        The time zone of the DB snapshot. In most cases, the Timezone element is empty. Timezone content appears only for snapshots taken from Microsoft SQL Server DB instances that were created with a time zone specified.

      • IAMDatabaseAuthenticationEnabled (boolean) --

        Indicates whether mapping of Amazon Web Services Identity and Access Management (IAM) accounts to database accounts is enabled.

      • ProcessorFeatures (list) --

        The number of CPU cores and the number of threads per core for the DB instance class of the DB instance when the DB snapshot was created.

        • (dict) --

          Contains the processor features of a DB instance class.

          To specify the number of CPU cores, use the coreCount feature name for the Name parameter. To specify the number of threads per core, use the threadsPerCore feature name for the Name parameter.

          You can set the processor features of the DB instance class for a DB instance when you call one of the following actions:

          • CreateDBInstance

          • ModifyDBInstance

          • RestoreDBInstanceFromDBSnapshot

          • RestoreDBInstanceFromS3

          • RestoreDBInstanceToPointInTime

          You can view the valid processor values for a particular instance class by calling the DescribeOrderableDBInstanceOptions action and specifying the instance class for the DBInstanceClass parameter.

          In addition, you can use the following actions for DB instance class processor information:

          • DescribeDBInstances

          • DescribeDBSnapshots

          • DescribeValidDBInstanceModifications

          If you call DescribeDBInstances, ProcessorFeature returns non-null values only if the following conditions are met:

          • You are accessing an Oracle or SQL Server DB instance.

          • Your Oracle or SQL Server DB instance class supports configuring the number of CPU cores and threads per core.

          • The current number CPU cores and threads is set to a non-default value.

          For more information, see Configuring the processor for a DB instance class in RDS for Oracle, Optimizing your RDS for SQL Server CPU, and DB instance classes in the Amazon RDS User Guide.

          • Name (string) --

            The name of the processor feature. Valid names are coreCount and threadsPerCore.

          • Value (string) --

            The value of a processor feature.

      • DbiResourceId (string) --

        The identifier for the source DB instance, which can't be changed and which is unique to an Amazon Web Services Region.

      • TagList (list) --

        A list of tags.

        For more information, see Tagging Amazon RDS resources in the Amazon RDS User Guide or Tagging Amazon Aurora and Amazon RDS resources in the Amazon Aurora 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 or Tagging Amazon Aurora and Amazon RDS resources in the Amazon Aurora 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}_.:/=+\-@]*)$").

      • SnapshotTarget (string) --

        Specifies where manual snapshots are stored: Dedicated Local Zones, Amazon Web Services Outposts or the Amazon Web Services Region.

      • OriginalSnapshotCreateTime (datetime) --

        Specifies the time of the CreateDBSnapshot operation in Coordinated Universal Time (UTC). Doesn't change when the snapshot is copied.

      • SnapshotDatabaseTime (datetime) --

        The timestamp of the most recent transaction applied to the database that you're backing up. Thus, if you restore a snapshot, SnapshotDatabaseTime is the most recent transaction in the restored DB instance. In contrast, originalSnapshotCreateTime specifies the system time that the snapshot completed.

        If you back up a read replica, you can determine the replica lag by comparing SnapshotDatabaseTime with originalSnapshotCreateTime. For example, if originalSnapshotCreateTime is two hours later than SnapshotDatabaseTime, then the replica lag is two hours.

      • DBSystemId (string) --

        The Oracle system identifier (SID), which is the name of the Oracle database instance that manages your database files. The Oracle SID is also the name of your CDB.

      • MultiTenant (boolean) --

        Indicates whether the snapshot is of a DB instance using the multi-tenant configuration (TRUE) or the single-tenant configuration (FALSE).

      • DedicatedLogVolume (boolean) --

        Indicates whether the DB instance has a dedicated log volume (DLV) enabled.

      • AdditionalStorageVolumes (list) --

        The additional storage volumes associated with the DB snapshot. RDS supports additional storage volumes for RDS for Oracle and RDS for SQL Server.

        • (dict) --

          Contains details about an additional storage volume for a DB instance. RDS support additional storage volumes for RDS for Oracle and RDS for SQL Server.

          • VolumeName (string) --

            The name of the additional storage volume.

            Valid Values: RDSDBDATA2 | RDSDBDATA3 | RDSDBDATA4

          • AllocatedStorage (integer) --

            The amount of storage allocated for the additional storage volume, in gibibytes (GiB). The minimum is 20 GiB. The maximum is 65,536 GiB (64 TiB).

          • IOPS (integer) --

            The number of I/O operations per second (IOPS) provisioned for the additional storage volume.

          • MaxAllocatedStorage (integer) --

            The upper limit in gibibytes (GiB) to which RDS can automatically scale the storage of the additional storage volume.

          • StorageThroughput (integer) --

            The storage throughput value for the additional storage volume, in mebibytes per second (MiBps). This setting applies only to the General Purpose SSD ( gp3) storage type.

          • StorageType (string) --

            The storage type for the additional storage volume.

            Valid Values: GP3 | IO2

      • SnapshotAvailabilityZone (string) --

        Specifies the name of the Availability Zone where RDS stores the DB snapshot. This value is valid only for snapshots that RDS stores on a Dedicated Local Zone.

      • FullSnapshotSizeInBytes (integer) --

        The full size of the DB snapshot, in bytes.

CopyOptionGroup (updated) Link ¶
Changes (response)
{'OptionGroup': {'SourceRegion': 'string'}}

Copies the specified option group.

See also: AWS API Documentation

Request Syntax

client.copy_option_group(
    SourceOptionGroupIdentifier='string',
    TargetOptionGroupIdentifier='string',
    TargetOptionGroupDescription='string',
    Tags=[
        {
            'Key': 'string',
            'Value': 'string'
        },
    ]
)
type SourceOptionGroupIdentifier:

string

param SourceOptionGroupIdentifier:

[REQUIRED]

The identifier for the source option group.

Constraints:

  • Must specify a valid option group.

type TargetOptionGroupIdentifier:

string

param TargetOptionGroupIdentifier:

[REQUIRED]

The identifier for the copied option group.

Constraints:

  • Can't be null, empty, or blank

  • Must contain from 1 to 255 letters, numbers, or hyphens

  • First character must be a letter

  • Can't end with a hyphen or contain two consecutive hyphens

Example: my-option-group

type TargetOptionGroupDescription:

string

param TargetOptionGroupDescription:

[REQUIRED]

The description for the copied option group.

type Tags:

list

param Tags:

A list of tags.

For more information, see Tagging Amazon RDS resources in the Amazon RDS User Guide or Tagging Amazon Aurora and Amazon RDS resources in the Amazon Aurora 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 or Tagging Amazon Aurora and Amazon RDS resources in the Amazon Aurora 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}_.:/=+\-@]*)$").

rtype:

dict

returns:

Response Syntax

{
    'OptionGroup': {
        'OptionGroupName': 'string',
        'OptionGroupDescription': 'string',
        'EngineName': 'string',
        'MajorEngineVersion': 'string',
        'Options': [
            {
                'OptionName': 'string',
                'OptionDescription': 'string',
                'Persistent': True|False,
                'Permanent': True|False,
                'Port': 123,
                'OptionVersion': 'string',
                'OptionSettings': [
                    {
                        'Name': 'string',
                        'Value': 'string',
                        'DefaultValue': 'string',
                        'Description': 'string',
                        'ApplyType': 'string',
                        'DataType': 'string',
                        'AllowedValues': 'string',
                        'IsModifiable': True|False,
                        'IsCollection': True|False
                    },
                ],
                'DBSecurityGroupMemberships': [
                    {
                        'DBSecurityGroupName': 'string',
                        'Status': 'string'
                    },
                ],
                'VpcSecurityGroupMemberships': [
                    {
                        'VpcSecurityGroupId': 'string',
                        'Status': 'string'
                    },
                ]
            },
        ],
        'AllowsVpcAndNonVpcInstanceMemberships': True|False,
        'VpcId': 'string',
        'OptionGroupArn': 'string',
        'SourceOptionGroup': 'string',
        'SourceAccountId': 'string',
        'CopyTimestamp': datetime(2015, 1, 1),
        'SourceRegion': 'string'
    }
}

Response Structure

  • (dict) --

    • OptionGroup (dict) --

      • OptionGroupName (string) --

        Specifies the name of the option group.

      • OptionGroupDescription (string) --

        Provides a description of the option group.

      • EngineName (string) --

        Indicates the name of the engine that this option group can be applied to.

      • MajorEngineVersion (string) --

        Indicates the major engine version associated with this option group.

      • Options (list) --

        Indicates what options are available in the option group.

        • (dict) --

          The details of an option.

          • OptionName (string) --

            The name of the option.

          • OptionDescription (string) --

            The description of the option.

          • Persistent (boolean) --

            Indicates whether this option is persistent.

          • Permanent (boolean) --

            Indicates whether this option is permanent.

          • Port (integer) --

            If required, the port configured for this option to use.

          • OptionVersion (string) --

            The version of the option.

          • OptionSettings (list) --

            The option settings for this option.

            • (dict) --

              Option settings are the actual settings being applied or configured for that option. It is used when you modify an option group or describe option groups. For example, the NATIVE_NETWORK_ENCRYPTION option has a setting called SQLNET.ENCRYPTION_SERVER that can have several different values.

              • Name (string) --

                The name of the option that has settings that you can set.

              • Value (string) --

                The current value of the option setting.

              • DefaultValue (string) --

                The default value of the option setting.

              • Description (string) --

                The description of the option setting.

              • ApplyType (string) --

                The DB engine specific parameter type.

              • DataType (string) --

                The data type of the option setting.

              • AllowedValues (string) --

                The allowed values of the option setting.

              • IsModifiable (boolean) --

                Indicates whether the option setting can be modified from the default.

              • IsCollection (boolean) --

                Indicates whether the option setting is part of a collection.

          • DBSecurityGroupMemberships (list) --

            If the option requires access to a port, then this DB security group allows access to the port.

            • (dict) --

              This data type is used as a response element in the following actions:

              • ModifyDBInstance

              • RebootDBInstance

              • RestoreDBInstanceFromDBSnapshot

              • RestoreDBInstanceToPointInTime

              • DBSecurityGroupName (string) --

                The name of the DB security group.

              • Status (string) --

                The status of the DB security group.

          • VpcSecurityGroupMemberships (list) --

            If the option requires access to a port, then this VPC security group allows access to the port.

            • (dict) --

              This data type is used as a response element for queries on VPC security group membership.

              • VpcSecurityGroupId (string) --

                The name of the VPC security group.

              • Status (string) --

                The membership status of the VPC security group.

                Currently, the only valid status is active.

      • AllowsVpcAndNonVpcInstanceMemberships (boolean) --

        Indicates whether this option group can be applied to both VPC and non-VPC instances. The value true indicates the option group can be applied to both VPC and non-VPC instances.

      • VpcId (string) --

        If AllowsVpcAndNonVpcInstanceMemberships is false, this field is blank. If AllowsVpcAndNonVpcInstanceMemberships is true and this field is blank, then this option group can be applied to both VPC and non-VPC instances. If this field contains a value, then this option group can only be applied to instances that are in the VPC indicated by this field.

      • OptionGroupArn (string) --

        Specifies the Amazon Resource Name (ARN) for the option group.

      • SourceOptionGroup (string) --

        Specifies the name of the option group from which this option group is copied.

      • SourceAccountId (string) --

        Specifies the Amazon Web Services account ID for the option group from which this option group is copied.

      • CopyTimestamp (datetime) --

        Indicates when the option group was copied.

      • SourceRegion (string) --

        Specifies the Amazon Web Services Region for the option group from which this option group is copied.

CreateOptionGroup (updated) Link ¶
Changes (response)
{'OptionGroup': {'SourceRegion': 'string'}}

Creates a new option group. You can create up to 20 option groups.

This command doesn't apply to RDS Custom.

See also: AWS API Documentation

Request Syntax

client.create_option_group(
    OptionGroupName='string',
    EngineName='string',
    MajorEngineVersion='string',
    OptionGroupDescription='string',
    Tags=[
        {
            'Key': 'string',
            'Value': 'string'
        },
    ]
)
type OptionGroupName:

string

param OptionGroupName:

[REQUIRED]

Specifies the name of the option group to be created.

Constraints:

  • Must be 1 to 255 letters, numbers, or hyphens

  • First character must be a letter

  • Can't end with a hyphen or contain two consecutive hyphens

Example: myoptiongroup

type EngineName:

string

param EngineName:

[REQUIRED]

The name of the engine to associate this option group with.

Valid Values:

  • db2-ae

  • db2-ce

  • db2-se

  • mariadb

  • mysql

  • oracle-ee

  • oracle-ee-cdb

  • oracle-se2

  • oracle-se2-cdb

  • postgres

  • sqlserver-ee

  • sqlserver-se

  • sqlserver-ex

  • sqlserver-web

type MajorEngineVersion:

string

param MajorEngineVersion:

[REQUIRED]

Specifies the major version of the engine that this option group should be associated with.

type OptionGroupDescription:

string

param OptionGroupDescription:

[REQUIRED]

The description of the option group.

type Tags:

list

param Tags:

Tags to assign to the option group.

  • (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 or Tagging Amazon Aurora and Amazon RDS resources in the Amazon Aurora 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}_.:/=+\-@]*)$").

rtype:

dict

returns:

Response Syntax

{
    'OptionGroup': {
        'OptionGroupName': 'string',
        'OptionGroupDescription': 'string',
        'EngineName': 'string',
        'MajorEngineVersion': 'string',
        'Options': [
            {
                'OptionName': 'string',
                'OptionDescription': 'string',
                'Persistent': True|False,
                'Permanent': True|False,
                'Port': 123,
                'OptionVersion': 'string',
                'OptionSettings': [
                    {
                        'Name': 'string',
                        'Value': 'string',
                        'DefaultValue': 'string',
                        'Description': 'string',
                        'ApplyType': 'string',
                        'DataType': 'string',
                        'AllowedValues': 'string',
                        'IsModifiable': True|False,
                        'IsCollection': True|False
                    },
                ],
                'DBSecurityGroupMemberships': [
                    {
                        'DBSecurityGroupName': 'string',
                        'Status': 'string'
                    },
                ],
                'VpcSecurityGroupMemberships': [
                    {
                        'VpcSecurityGroupId': 'string',
                        'Status': 'string'
                    },
                ]
            },
        ],
        'AllowsVpcAndNonVpcInstanceMemberships': True|False,
        'VpcId': 'string',
        'OptionGroupArn': 'string',
        'SourceOptionGroup': 'string',
        'SourceAccountId': 'string',
        'CopyTimestamp': datetime(2015, 1, 1),
        'SourceRegion': 'string'
    }
}

Response Structure

  • (dict) --

    • OptionGroup (dict) --

      • OptionGroupName (string) --

        Specifies the name of the option group.

      • OptionGroupDescription (string) --

        Provides a description of the option group.

      • EngineName (string) --

        Indicates the name of the engine that this option group can be applied to.

      • MajorEngineVersion (string) --

        Indicates the major engine version associated with this option group.

      • Options (list) --

        Indicates what options are available in the option group.

        • (dict) --

          The details of an option.

          • OptionName (string) --

            The name of the option.

          • OptionDescription (string) --

            The description of the option.

          • Persistent (boolean) --

            Indicates whether this option is persistent.

          • Permanent (boolean) --

            Indicates whether this option is permanent.

          • Port (integer) --

            If required, the port configured for this option to use.

          • OptionVersion (string) --

            The version of the option.

          • OptionSettings (list) --

            The option settings for this option.

            • (dict) --

              Option settings are the actual settings being applied or configured for that option. It is used when you modify an option group or describe option groups. For example, the NATIVE_NETWORK_ENCRYPTION option has a setting called SQLNET.ENCRYPTION_SERVER that can have several different values.

              • Name (string) --

                The name of the option that has settings that you can set.

              • Value (string) --

                The current value of the option setting.

              • DefaultValue (string) --

                The default value of the option setting.

              • Description (string) --

                The description of the option setting.

              • ApplyType (string) --

                The DB engine specific parameter type.

              • DataType (string) --

                The data type of the option setting.

              • AllowedValues (string) --

                The allowed values of the option setting.

              • IsModifiable (boolean) --

                Indicates whether the option setting can be modified from the default.

              • IsCollection (boolean) --

                Indicates whether the option setting is part of a collection.

          • DBSecurityGroupMemberships (list) --

            If the option requires access to a port, then this DB security group allows access to the port.

            • (dict) --

              This data type is used as a response element in the following actions:

              • ModifyDBInstance

              • RebootDBInstance

              • RestoreDBInstanceFromDBSnapshot

              • RestoreDBInstanceToPointInTime

              • DBSecurityGroupName (string) --

                The name of the DB security group.

              • Status (string) --

                The status of the DB security group.

          • VpcSecurityGroupMemberships (list) --

            If the option requires access to a port, then this VPC security group allows access to the port.

            • (dict) --

              This data type is used as a response element for queries on VPC security group membership.

              • VpcSecurityGroupId (string) --

                The name of the VPC security group.

              • Status (string) --

                The membership status of the VPC security group.

                Currently, the only valid status is active.

      • AllowsVpcAndNonVpcInstanceMemberships (boolean) --

        Indicates whether this option group can be applied to both VPC and non-VPC instances. The value true indicates the option group can be applied to both VPC and non-VPC instances.

      • VpcId (string) --

        If AllowsVpcAndNonVpcInstanceMemberships is false, this field is blank. If AllowsVpcAndNonVpcInstanceMemberships is true and this field is blank, then this option group can be applied to both VPC and non-VPC instances. If this field contains a value, then this option group can only be applied to instances that are in the VPC indicated by this field.

      • OptionGroupArn (string) --

        Specifies the Amazon Resource Name (ARN) for the option group.

      • SourceOptionGroup (string) --

        Specifies the name of the option group from which this option group is copied.

      • SourceAccountId (string) --

        Specifies the Amazon Web Services account ID for the option group from which this option group is copied.

      • CopyTimestamp (datetime) --

        Indicates when the option group was copied.

      • SourceRegion (string) --

        Specifies the Amazon Web Services Region for the option group from which this option group is copied.

DescribeOptionGroupOptions (updated) Link ¶
Changes (response)
{'OptionGroupOptions': {'CopyableCrossRegion': 'boolean'}}

Describes all available options for the specified engine.

See also: AWS API Documentation

Request Syntax

client.describe_option_group_options(
    EngineName='string',
    MajorEngineVersion='string',
    Filters=[
        {
            'Name': 'string',
            'Values': [
                'string',
            ]
        },
    ],
    MaxRecords=123,
    Marker='string'
)
type EngineName:

string

param EngineName:

[REQUIRED]

The name of the engine to describe options for.

Valid Values:

  • db2-ae

  • db2-ce

  • db2-se

  • mariadb

  • mysql

  • oracle-ee

  • oracle-ee-cdb

  • oracle-se2

  • oracle-se2-cdb

  • postgres

  • sqlserver-ee

  • sqlserver-se

  • sqlserver-ex

  • sqlserver-web

type MajorEngineVersion:

string

param MajorEngineVersion:

If specified, filters the results to include only options for the specified major engine version.

type Filters:

list

param Filters:

This parameter isn't currently supported.

  • (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.

    The following actions can be filtered:

    • DescribeDBCapacityReservations

    • DescribeDBClusterBacktracks

    • DescribeDBClusterEndpoints

    • DescribeDBClusters

    • DescribeDBInstances

    • DescribeDBRecommendations

    • DescribeDBShardGroups

    • 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) --

type MaxRecords:

integer

param MaxRecords:

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

Default: 100

Constraints: Minimum 20, maximum 100.

type Marker:

string

param Marker:

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.

rtype:

dict

returns:

Response Syntax

{
    'OptionGroupOptions': [
        {
            'Name': 'string',
            'Description': 'string',
            'EngineName': 'string',
            'MajorEngineVersion': 'string',
            'MinimumRequiredMinorEngineVersion': 'string',
            'PortRequired': True|False,
            'DefaultPort': 123,
            'OptionsDependedOn': [
                'string',
            ],
            'OptionsConflictsWith': [
                'string',
            ],
            'Persistent': True|False,
            'Permanent': True|False,
            'RequiresAutoMinorEngineVersionUpgrade': True|False,
            'VpcOnly': True|False,
            'SupportsOptionVersionDowngrade': True|False,
            'OptionGroupOptionSettings': [
                {
                    'SettingName': 'string',
                    'SettingDescription': 'string',
                    'DefaultValue': 'string',
                    'ApplyType': 'string',
                    'AllowedValues': 'string',
                    'IsModifiable': True|False,
                    'IsRequired': True|False,
                    'MinimumEngineVersionPerAllowedValue': [
                        {
                            'AllowedValue': 'string',
                            'MinimumEngineVersion': 'string'
                        },
                    ]
                },
            ],
            'OptionGroupOptionVersions': [
                {
                    'Version': 'string',
                    'IsDefault': True|False
                },
            ],
            'CopyableCrossAccount': True|False,
            'CopyableCrossRegion': True|False
        },
    ],
    'Marker': 'string'
}

Response Structure

  • (dict) --

    • OptionGroupOptions (list) --

      List of available option group options.

      • (dict) --

        Available option.

        • Name (string) --

          The name of the option.

        • Description (string) --

          The description of the option.

        • EngineName (string) --

          The name of the engine that this option can be applied to.

        • MajorEngineVersion (string) --

          Indicates the major engine version that the option is available for.

        • MinimumRequiredMinorEngineVersion (string) --

          The minimum required engine version for the option to be applied.

        • PortRequired (boolean) --

          Indicates whether the option requires a port.

        • DefaultPort (integer) --

          If the option requires a port, specifies the default port for the option.

        • OptionsDependedOn (list) --

          The options that are prerequisites for this option.

          • (string) --

        • OptionsConflictsWith (list) --

          The options that conflict with this option.

          • (string) --

        • Persistent (boolean) --

          Persistent options can't be removed from an option group while DB instances are associated with the option group. If you disassociate all DB instances from the option group, your can remove the persistent option from the option group.

        • Permanent (boolean) --

          Permanent options can never be removed from an option group. An option group containing a permanent option can't be removed from a DB instance.

        • RequiresAutoMinorEngineVersionUpgrade (boolean) --

          If true, you must enable the Auto Minor Version Upgrade setting for your DB instance before you can use this option. You can enable Auto Minor Version Upgrade when you first create your DB instance, or by modifying your DB instance later.

        • VpcOnly (boolean) --

          If true, you can only use this option with a DB instance that is in a VPC.

        • SupportsOptionVersionDowngrade (boolean) --

          If true, you can change the option to an earlier version of the option. This only applies to options that have different versions available.

        • OptionGroupOptionSettings (list) --

          The option settings that are available (and the default value) for each option in an option group.

          • (dict) --

            Option group option settings are used to display settings available for each option with their default values and other information. These values are used with the DescribeOptionGroupOptions action.

            • SettingName (string) --

              The name of the option group option.

            • SettingDescription (string) --

              The description of the option group option.

            • DefaultValue (string) --

              The default value for the option group option.

            • ApplyType (string) --

              The DB engine specific parameter type for the option group option.

            • AllowedValues (string) --

              Indicates the acceptable values for the option group option.

            • IsModifiable (boolean) --

              Indicates whether this option group option can be changed from the default value.

            • IsRequired (boolean) --

              Indicates whether a value must be specified for this option setting of the option group option.

            • MinimumEngineVersionPerAllowedValue (list) --

              The minimum DB engine version required for the corresponding allowed value for this option setting.

              • (dict) --

                The minimum DB engine version required for each corresponding allowed value for an option setting.

                • AllowedValue (string) --

                  The allowed value for an option setting.

                • MinimumEngineVersion (string) --

                  The minimum DB engine version required for the allowed value.

        • OptionGroupOptionVersions (list) --

          The versions that are available for the option.

          • (dict) --

            The version for an option. Option group option versions are returned by the DescribeOptionGroupOptions action.

            • Version (string) --

              The version of the option.

            • IsDefault (boolean) --

              Indicates whether the version is the default version of the option.

        • CopyableCrossAccount (boolean) --

          Indicates whether the option can be copied across Amazon Web Services accounts.

        • CopyableCrossRegion (boolean) --

          Indicates whether the option can be copied across Amazon Web Services Regions.

    • 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.

DescribeOptionGroups (updated) Link ¶
Changes (response)
{'OptionGroupsList': {'SourceRegion': 'string'}}

Describes the available option groups.

See also: AWS API Documentation

Request Syntax

client.describe_option_groups(
    OptionGroupName='string',
    Filters=[
        {
            'Name': 'string',
            'Values': [
                'string',
            ]
        },
    ],
    Marker='string',
    MaxRecords=123,
    EngineName='string',
    MajorEngineVersion='string'
)
type OptionGroupName:

string

param OptionGroupName:

The name of the option group to describe. Can't be supplied together with EngineName or MajorEngineVersion.

type Filters:

list

param Filters:

This parameter isn't currently supported.

  • (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.

    The following actions can be filtered:

    • DescribeDBCapacityReservations

    • DescribeDBClusterBacktracks

    • DescribeDBClusterEndpoints

    • DescribeDBClusters

    • DescribeDBInstances

    • DescribeDBRecommendations

    • DescribeDBShardGroups

    • 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) --

type Marker:

string

param Marker:

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

type MaxRecords:

integer

param MaxRecords:

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

Default: 100

Constraints: Minimum 20, maximum 100.

type EngineName:

string

param EngineName:

A filter to only include option groups associated with this database engine.

Valid Values:

  • db2-ae

  • db2-ce

  • db2-se

  • mariadb

  • mysql

  • oracle-ee

  • oracle-ee-cdb

  • oracle-se2

  • oracle-se2-cdb

  • postgres

  • sqlserver-ee

  • sqlserver-se

  • sqlserver-ex

  • sqlserver-web

type MajorEngineVersion:

string

param MajorEngineVersion:

Filters the list of option groups to only include groups associated with a specific database engine version. If specified, then EngineName must also be specified.

rtype:

dict

returns:

Response Syntax

{
    'OptionGroupsList': [
        {
            'OptionGroupName': 'string',
            'OptionGroupDescription': 'string',
            'EngineName': 'string',
            'MajorEngineVersion': 'string',
            'Options': [
                {
                    'OptionName': 'string',
                    'OptionDescription': 'string',
                    'Persistent': True|False,
                    'Permanent': True|False,
                    'Port': 123,
                    'OptionVersion': 'string',
                    'OptionSettings': [
                        {
                            'Name': 'string',
                            'Value': 'string',
                            'DefaultValue': 'string',
                            'Description': 'string',
                            'ApplyType': 'string',
                            'DataType': 'string',
                            'AllowedValues': 'string',
                            'IsModifiable': True|False,
                            'IsCollection': True|False
                        },
                    ],
                    'DBSecurityGroupMemberships': [
                        {
                            'DBSecurityGroupName': 'string',
                            'Status': 'string'
                        },
                    ],
                    'VpcSecurityGroupMemberships': [
                        {
                            'VpcSecurityGroupId': 'string',
                            'Status': 'string'
                        },
                    ]
                },
            ],
            'AllowsVpcAndNonVpcInstanceMemberships': True|False,
            'VpcId': 'string',
            'OptionGroupArn': 'string',
            'SourceOptionGroup': 'string',
            'SourceAccountId': 'string',
            'CopyTimestamp': datetime(2015, 1, 1),
            'SourceRegion': 'string'
        },
    ],
    'Marker': 'string'
}

Response Structure

  • (dict) --

    List of option groups.

    • OptionGroupsList (list) --

      List of option groups.

      • (dict) --

        • OptionGroupName (string) --

          Specifies the name of the option group.

        • OptionGroupDescription (string) --

          Provides a description of the option group.

        • EngineName (string) --

          Indicates the name of the engine that this option group can be applied to.

        • MajorEngineVersion (string) --

          Indicates the major engine version associated with this option group.

        • Options (list) --

          Indicates what options are available in the option group.

          • (dict) --

            The details of an option.

            • OptionName (string) --

              The name of the option.

            • OptionDescription (string) --

              The description of the option.

            • Persistent (boolean) --

              Indicates whether this option is persistent.

            • Permanent (boolean) --

              Indicates whether this option is permanent.

            • Port (integer) --

              If required, the port configured for this option to use.

            • OptionVersion (string) --

              The version of the option.

            • OptionSettings (list) --

              The option settings for this option.

              • (dict) --

                Option settings are the actual settings being applied or configured for that option. It is used when you modify an option group or describe option groups. For example, the NATIVE_NETWORK_ENCRYPTION option has a setting called SQLNET.ENCRYPTION_SERVER that can have several different values.

                • Name (string) --

                  The name of the option that has settings that you can set.

                • Value (string) --

                  The current value of the option setting.

                • DefaultValue (string) --

                  The default value of the option setting.

                • Description (string) --

                  The description of the option setting.

                • ApplyType (string) --

                  The DB engine specific parameter type.

                • DataType (string) --

                  The data type of the option setting.

                • AllowedValues (string) --

                  The allowed values of the option setting.

                • IsModifiable (boolean) --

                  Indicates whether the option setting can be modified from the default.

                • IsCollection (boolean) --

                  Indicates whether the option setting is part of a collection.

            • DBSecurityGroupMemberships (list) --

              If the option requires access to a port, then this DB security group allows access to the port.

              • (dict) --

                This data type is used as a response element in the following actions:

                • ModifyDBInstance

                • RebootDBInstance

                • RestoreDBInstanceFromDBSnapshot

                • RestoreDBInstanceToPointInTime

                • DBSecurityGroupName (string) --

                  The name of the DB security group.

                • Status (string) --

                  The status of the DB security group.

            • VpcSecurityGroupMemberships (list) --

              If the option requires access to a port, then this VPC security group allows access to the port.

              • (dict) --

                This data type is used as a response element for queries on VPC security group membership.

                • VpcSecurityGroupId (string) --

                  The name of the VPC security group.

                • Status (string) --

                  The membership status of the VPC security group.

                  Currently, the only valid status is active.

        • AllowsVpcAndNonVpcInstanceMemberships (boolean) --

          Indicates whether this option group can be applied to both VPC and non-VPC instances. The value true indicates the option group can be applied to both VPC and non-VPC instances.

        • VpcId (string) --

          If AllowsVpcAndNonVpcInstanceMemberships is false, this field is blank. If AllowsVpcAndNonVpcInstanceMemberships is true and this field is blank, then this option group can be applied to both VPC and non-VPC instances. If this field contains a value, then this option group can only be applied to instances that are in the VPC indicated by this field.

        • OptionGroupArn (string) --

          Specifies the Amazon Resource Name (ARN) for the option group.

        • SourceOptionGroup (string) --

          Specifies the name of the option group from which this option group is copied.

        • SourceAccountId (string) --

          Specifies the Amazon Web Services account ID for the option group from which this option group is copied.

        • CopyTimestamp (datetime) --

          Indicates when the option group was copied.

        • SourceRegion (string) --

          Specifies the Amazon Web Services Region for the option group from which this option group is copied.

    • 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.

ModifyOptionGroup (updated) Link ¶
Changes (response)
{'OptionGroup': {'SourceRegion': 'string'}}

Modifies an existing option group.

See also: AWS API Documentation

Request Syntax

client.modify_option_group(
    OptionGroupName='string',
    OptionsToInclude=[
        {
            'OptionName': 'string',
            'Port': 123,
            'OptionVersion': 'string',
            'DBSecurityGroupMemberships': [
                'string',
            ],
            'VpcSecurityGroupMemberships': [
                'string',
            ],
            'OptionSettings': [
                {
                    'Name': 'string',
                    'Value': 'string',
                    'DefaultValue': 'string',
                    'Description': 'string',
                    'ApplyType': 'string',
                    'DataType': 'string',
                    'AllowedValues': 'string',
                    'IsModifiable': True|False,
                    'IsCollection': True|False
                },
            ]
        },
    ],
    OptionsToRemove=[
        'string',
    ],
    ApplyImmediately=True|False
)
type OptionGroupName:

string

param OptionGroupName:

[REQUIRED]

The name of the option group to be modified.

Permanent options, such as the TDE option for Oracle Advanced Security TDE, can't be removed from an option group, and that option group can't be removed from a DB instance once it is associated with a DB instance

type OptionsToInclude:

list

param OptionsToInclude:

Options in this list are added to the option group or, if already present, the specified configuration is used to update the existing configuration.

  • (dict) --

    A list of all available options for an option group.

    • OptionName (string) -- [REQUIRED]

      The configuration of options to include in a group.

    • Port (integer) --

      The optional port for the option.

    • OptionVersion (string) --

      The version for the option.

    • DBSecurityGroupMemberships (list) --

      A list of DB security groups used for this option.

      • (string) --

    • VpcSecurityGroupMemberships (list) --

      A list of VPC security group names used for this option.

      • (string) --

    • OptionSettings (list) --

      The option settings to include in an option group.

      • (dict) --

        Option settings are the actual settings being applied or configured for that option. It is used when you modify an option group or describe option groups. For example, the NATIVE_NETWORK_ENCRYPTION option has a setting called SQLNET.ENCRYPTION_SERVER that can have several different values.

        • Name (string) --

          The name of the option that has settings that you can set.

        • Value (string) --

          The current value of the option setting.

        • DefaultValue (string) --

          The default value of the option setting.

        • Description (string) --

          The description of the option setting.

        • ApplyType (string) --

          The DB engine specific parameter type.

        • DataType (string) --

          The data type of the option setting.

        • AllowedValues (string) --

          The allowed values of the option setting.

        • IsModifiable (boolean) --

          Indicates whether the option setting can be modified from the default.

        • IsCollection (boolean) --

          Indicates whether the option setting is part of a collection.

type OptionsToRemove:

list

param OptionsToRemove:

Options in this list are removed from the option group.

  • (string) --

type ApplyImmediately:

boolean

param ApplyImmediately:

Specifies whether to apply the change immediately or during the next maintenance window for each instance associated with the option group.

rtype:

dict

returns:

Response Syntax

{
    'OptionGroup': {
        'OptionGroupName': 'string',
        'OptionGroupDescription': 'string',
        'EngineName': 'string',
        'MajorEngineVersion': 'string',
        'Options': [
            {
                'OptionName': 'string',
                'OptionDescription': 'string',
                'Persistent': True|False,
                'Permanent': True|False,
                'Port': 123,
                'OptionVersion': 'string',
                'OptionSettings': [
                    {
                        'Name': 'string',
                        'Value': 'string',
                        'DefaultValue': 'string',
                        'Description': 'string',
                        'ApplyType': 'string',
                        'DataType': 'string',
                        'AllowedValues': 'string',
                        'IsModifiable': True|False,
                        'IsCollection': True|False
                    },
                ],
                'DBSecurityGroupMemberships': [
                    {
                        'DBSecurityGroupName': 'string',
                        'Status': 'string'
                    },
                ],
                'VpcSecurityGroupMemberships': [
                    {
                        'VpcSecurityGroupId': 'string',
                        'Status': 'string'
                    },
                ]
            },
        ],
        'AllowsVpcAndNonVpcInstanceMemberships': True|False,
        'VpcId': 'string',
        'OptionGroupArn': 'string',
        'SourceOptionGroup': 'string',
        'SourceAccountId': 'string',
        'CopyTimestamp': datetime(2015, 1, 1),
        'SourceRegion': 'string'
    }
}

Response Structure

  • (dict) --

    • OptionGroup (dict) --

      • OptionGroupName (string) --

        Specifies the name of the option group.

      • OptionGroupDescription (string) --

        Provides a description of the option group.

      • EngineName (string) --

        Indicates the name of the engine that this option group can be applied to.

      • MajorEngineVersion (string) --

        Indicates the major engine version associated with this option group.

      • Options (list) --

        Indicates what options are available in the option group.

        • (dict) --

          The details of an option.

          • OptionName (string) --

            The name of the option.

          • OptionDescription (string) --

            The description of the option.

          • Persistent (boolean) --

            Indicates whether this option is persistent.

          • Permanent (boolean) --

            Indicates whether this option is permanent.

          • Port (integer) --

            If required, the port configured for this option to use.

          • OptionVersion (string) --

            The version of the option.

          • OptionSettings (list) --

            The option settings for this option.

            • (dict) --

              Option settings are the actual settings being applied or configured for that option. It is used when you modify an option group or describe option groups. For example, the NATIVE_NETWORK_ENCRYPTION option has a setting called SQLNET.ENCRYPTION_SERVER that can have several different values.

              • Name (string) --

                The name of the option that has settings that you can set.

              • Value (string) --

                The current value of the option setting.

              • DefaultValue (string) --

                The default value of the option setting.

              • Description (string) --

                The description of the option setting.

              • ApplyType (string) --

                The DB engine specific parameter type.

              • DataType (string) --

                The data type of the option setting.

              • AllowedValues (string) --

                The allowed values of the option setting.

              • IsModifiable (boolean) --

                Indicates whether the option setting can be modified from the default.

              • IsCollection (boolean) --

                Indicates whether the option setting is part of a collection.

          • DBSecurityGroupMemberships (list) --

            If the option requires access to a port, then this DB security group allows access to the port.

            • (dict) --

              This data type is used as a response element in the following actions:

              • ModifyDBInstance

              • RebootDBInstance

              • RestoreDBInstanceFromDBSnapshot

              • RestoreDBInstanceToPointInTime

              • DBSecurityGroupName (string) --

                The name of the DB security group.

              • Status (string) --

                The status of the DB security group.

          • VpcSecurityGroupMemberships (list) --

            If the option requires access to a port, then this VPC security group allows access to the port.

            • (dict) --

              This data type is used as a response element for queries on VPC security group membership.

              • VpcSecurityGroupId (string) --

                The name of the VPC security group.

              • Status (string) --

                The membership status of the VPC security group.

                Currently, the only valid status is active.

      • AllowsVpcAndNonVpcInstanceMemberships (boolean) --

        Indicates whether this option group can be applied to both VPC and non-VPC instances. The value true indicates the option group can be applied to both VPC and non-VPC instances.

      • VpcId (string) --

        If AllowsVpcAndNonVpcInstanceMemberships is false, this field is blank. If AllowsVpcAndNonVpcInstanceMemberships is true and this field is blank, then this option group can be applied to both VPC and non-VPC instances. If this field contains a value, then this option group can only be applied to instances that are in the VPC indicated by this field.

      • OptionGroupArn (string) --

        Specifies the Amazon Resource Name (ARN) for the option group.

      • SourceOptionGroup (string) --

        Specifies the name of the option group from which this option group is copied.

      • SourceAccountId (string) --

        Specifies the Amazon Web Services account ID for the option group from which this option group is copied.

      • CopyTimestamp (datetime) --

        Indicates when the option group was copied.

      • SourceRegion (string) --

        Specifies the Amazon Web Services Region for the option group from which this option group is copied.