2022/12/12 - Amazon Relational Database Service - 6 updated api methods
Changes Update the RDS API model to support copying option groups during the CopyDBSnapshot operation
{'CopyOptionGroup': 'boolean'}
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',
CopyOptionGroup=True|False,
SourceRegion='string'
)
string
[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 the source snapshot is in a different Amazon Web Services Region than the copy, specify a valid DB snapshot ARN. For example, you might specify arn:aws:rds:us-west-2:123456789012:snapshot: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 you are copying an encrypted snapshot this parameter must be in the ARN format for the source Amazon Web Services Region.
Constraints:
Must specify a valid system 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
string
[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
string
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.
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}_.:/=+\-@]*)$").
boolean
A value that indicates whether to copy all tags from the source DB snapshot to the target DB snapshot. By default, tags aren't copied.
string
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 .
Note
If you are using an Amazon Web Services SDK tool or the CLI, you can specify SourceRegion (or --source-region for the CLI) instead of specifying PreSignedUrl manually. Specifying SourceRegion autogenerates a presigned URL that is a valid request for the operation that can run in the source Amazon Web Services Region.
Note
If you supply a value for this operation's SourceRegion parameter, a pre-signed URL will be calculated on your behalf.
string
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 .
string
The external custom Availability Zone (CAZ) identifier for the target CAZ.
Example: rds-caz-aiqhTgQv .
boolean
A value that indicates whether to copy the DB option group associated with the source DB snapshot to the target Amazon Web Services account and associate with the target DB snapshot. The associated option group can be copied only with cross-account snapshot copy calls.
string
The ID of the region that contains the snapshot to be copied.
dict
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,
'OptionGroupName': 'string',
'PercentProgress': 123,
'SourceRegion': 'string',
'SourceDBSnapshotIdentifier': 'string',
'StorageType': 'string',
'TdeCredentialArn': 'string',
'Encrypted': True|False,
'KmsKeyId': 'string',
'DBSnapshotArn': 'string',
'Timezone': 'string',
'IAMDatabaseAuthenticationEnabled': True|False,
'ProcessorFeatures': [
{
'Name': 'string',
'Value': 'string'
},
],
'DbiResourceId': 'string',
'TagList': [
{
'Key': 'string',
'Value': 'string'
},
],
'OriginalSnapshotCreateTime': datetime(2015, 1, 1),
'SnapshotDatabaseTime': datetime(2015, 1, 1),
'SnapshotTarget': 'string',
'StorageThroughput': 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.
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) --
Specifies whether the DB snapshot is encrypted.
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) --
True if mapping of Amazon Web Services Identity and Access Management (IAM) accounts to database accounts is enabled, and otherwise false.
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 DB instance.
Your Oracle 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 of the DB Instance Class 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 name.
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.
(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}_.:/=+\-@]*)$").
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.
SnapshotTarget (string) --
Specifies where manual snapshots are stored: Amazon Web Services Outposts or the Amazon Web Services Region.
StorageThroughput (integer) --
Specifies the storage throughput for the DB snapshot.
{'OptionGroup': {'CopyTimestamp': 'timestamp',
'SourceAccountId': 'string',
'SourceOptionGroup': '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'
},
]
)
string
[REQUIRED]
The identifier for the source option group.
Constraints:
Must specify a valid option group.
string
[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
string
[REQUIRED]
The description for the copied option group.
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}_.:/=+\-@]*)$").
dict
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)
}
}
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) --
Option details.
OptionName (string) --
The name of the option.
OptionDescription (string) --
The description of the option.
Persistent (boolean) --
Indicate if this option is persistent.
Permanent (boolean) --
Indicate if 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) --
A Boolean value that, when true, indicates the option setting can be modified from the default.
IsCollection (boolean) --
Indicates if 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.
{'OptionGroup': {'CopyTimestamp': 'timestamp',
'SourceAccountId': 'string',
'SourceOptionGroup': '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'
},
]
)
string
[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
string
[REQUIRED]
Specifies the name of the engine that this option group should be associated with.
Valid Values:
mariadb
mysql
oracle-ee
oracle-ee-cdb
oracle-se2
oracle-se2-cdb
postgres
sqlserver-ee
sqlserver-se
sqlserver-ex
sqlserver-web
string
[REQUIRED]
Specifies the major version of the engine that this option group should be associated with.
string
[REQUIRED]
The description of the option group.
list
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.
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}_.:/=+\-@]*)$").
dict
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)
}
}
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) --
Option details.
OptionName (string) --
The name of the option.
OptionDescription (string) --
The description of the option.
Persistent (boolean) --
Indicate if this option is persistent.
Permanent (boolean) --
Indicate if 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) --
A Boolean value that, when true, indicates the option setting can be modified from the default.
IsCollection (boolean) --
Indicates if 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.
{'OptionGroupOptions': {'CopyableCrossAccount': 'boolean'}}
Describes all available options.
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'
)
string
[REQUIRED]
A required parameter. Options available for the given engine name are described.
Valid Values:
mariadb
mysql
oracle-ee
oracle-ee-cdb
oracle-se2
oracle-se2-cdb
postgres
sqlserver-ee
sqlserver-se
sqlserver-ex
sqlserver-web
string
If specified, filters the results to include only options for the specified major engine version.
list
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.
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) --
integer
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.
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 .
dict
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
},
],
'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) --
Specifies 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) --
Boolean value where true indicates that this option group option can be changed from the default value.
IsRequired (boolean) --
Boolean value where true indicates that 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) --
True if the version is the default version of the option, and otherwise false.
CopyableCrossAccount (boolean) --
Specifies whether the option can be copied across Amazon Web Services accounts.
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 .
{'OptionGroupsList': {'CopyTimestamp': 'timestamp',
'SourceAccountId': 'string',
'SourceOptionGroup': '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'
)
string
The name of the option group to describe. Can't be supplied together with EngineName or MajorEngineVersion.
list
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.
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) --
string
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 .
integer
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.
string
Filters the list of option groups to only include groups associated with a specific database engine.
Valid Values:
mariadb
mysql
oracle-ee
oracle-ee-cdb
oracle-se2
oracle-se2-cdb
postgres
sqlserver-ee
sqlserver-se
sqlserver-ex
sqlserver-web
string
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.
dict
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)
},
],
'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) --
Option details.
OptionName (string) --
The name of the option.
OptionDescription (string) --
The description of the option.
Persistent (boolean) --
Indicate if this option is persistent.
Permanent (boolean) --
Indicate if 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) --
A Boolean value that, when true, indicates the option setting can be modified from the default.
IsCollection (boolean) --
Indicates if 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.
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 .
{'OptionGroup': {'CopyTimestamp': 'timestamp',
'SourceAccountId': 'string',
'SourceOptionGroup': '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
)
string
[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
list
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
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 DBSecurityGroupMembership name strings used for this option.
(string) --
VpcSecurityGroupMemberships (list) --
A list of VpcSecurityGroupMembership name strings 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) --
A Boolean value that, when true, indicates the option setting can be modified from the default.
IsCollection (boolean) --
Indicates if the option setting is part of a collection.
list
Options in this list are removed from the option group.
(string) --
boolean
A value that indicates whether to apply the change immediately or during the next maintenance window for each instance associated with the option group.
dict
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)
}
}
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) --
Option details.
OptionName (string) --
The name of the option.
OptionDescription (string) --
The description of the option.
Persistent (boolean) --
Indicate if this option is persistent.
Permanent (boolean) --
Indicate if 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) --
A Boolean value that, when true, indicates the option setting can be modified from the default.
IsCollection (boolean) --
Indicates if 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.