Given a valid region name, return a boto.rds2.layer1.RDSConnection. Any additional parameters after the region_name are passed on to the connect method of the region object.
Type: | str |
---|---|
Parameters: | region_name – The name of the region to connect to. |
Return type: | boto.rds2.layer1.RDSConnection or None |
Returns: | A connection to the given region, or None if an invalid region name is given |
Get all available regions for the RDS service.
Return type: | list |
---|---|
Returns: | A list of boto.regioninfo.RegionInfo |
Amazon Relational Database Service Amazon Relational Database Service (Amazon RDS) is a web service that makes it easier to set up, operate, and scale a relational database in the cloud. It provides cost-efficient, resizable capacity for an industry-standard relational database and manages common database administration tasks, freeing up developers to focus on what makes their applications and businesses unique.
Amazon RDS gives you access to the capabilities of a familiar MySQL or Oracle database server. This means the code, applications, and tools you already use today with your existing MySQL or Oracle databases work with Amazon RDS without modification. Amazon RDS automatically backs up your database and maintains the database software that powers your DB instance. Amazon RDS is flexible: you can scale your database instance’s compute resources and storage capacity to meet your application’s demand. As with all Amazon Web Services, there are no up-front investments, and you pay only for the resources you use.
This is the Amazon RDS API Reference . It contains a comprehensive description of all Amazon RDS Query APIs and data types. Note that this API is asynchronous and some actions may require polling to determine when an action has been applied. See the parameter description to determine if a change is applied immediately or on the next instance reboot or during the maintenance window. For more information on Amazon RDS concepts and usage scenarios, go to the `Amazon RDS User Guide`_.
alias of JSONResponseError
Adds a source identifier to an existing RDS event notification subscription.
Parameters: |
---|
Constraints:
must be supplied.
must be supplied.
must be supplied.
supplied.
Adds metadata tags to an Amazon RDS resource. These tags can also be used with cost allocation reporting to track cost associated with Amazon RDS resources, or used in Condition statement in IAM policy for Amazon RDS.
For an overview on tagging Amazon RDS resources, see `Tagging Amazon RDS Resources`_.
Parameters: |
---|
Enables ingress to a DBSecurityGroup using one of two forms of authorization. First, EC2 or VPC security groups can be added to the DBSecurityGroup if the application using the database is running on EC2 or VPC instances. Second, IP ranges are available if the application accessing your database is running on the Internet. Required parameters for this API are one of CIDR range, EC2SecurityGroupId for VPC, or (EC2SecurityGroupOwnerId and either EC2SecurityGroupName or EC2SecurityGroupId for non-VPC). You cannot authorize ingress from an EC2 security group in one Region to an Amazon RDS DB instance in another. You cannot authorize ingress from a VPC security group in one VPC to an Amazon RDS DB instance in another. For an overview of CIDR ranges, go to the `Wikipedia Tutorial`_.
Parameters: |
|
---|
Copies the specified DBSnapshot. The source DBSnapshot must be in the “available” state.
Parameters: | source_db_snapshot_identifier (string) – The identifier for the source DB snapshot. |
---|
Constraints:
state.
Example: rds:mydb-2012-04-02-00-01
Parameters: | target_db_snapshot_identifier (string) – The identifier for the copied snapshot. |
---|
Constraints:
Example: my-db-snapshot
Parameters: | tags (list) – A list of tags. |
---|
Creates a new DB instance.
Parameters: | db_name (string) – The meaning of this parameter differs according to the database engine you use. |
---|
MySQL
Constraints:
Type: String
Oracle
The Oracle System ID (SID) of the created DB instance.
Default: ORCL
Constraints:
SQL Server
Not applicable. Must be null.
Parameters: | db_instance_identifier (string) – The DB instance identifier. This parameter is stored as a lowercase string. |
---|
Constraints:
for SQL Server).
First character must be a letter.
Cannot end with a hyphen or contain two consecutive hyphens.
Example: mydbinstance
Parameters: | allocated_storage (integer) – The amount of storage (in gigabytes) to be initially allocated for the database instance. |
---|
MySQL
Constraints: Must be an integer from 5 to 1024.
Type: Integer
Oracle
Constraints: Must be an integer from 10 to 1024.
SQL Server
Parameters: | db_instance_class (string) – The compute and memory capacity of the DB instance. |
---|
Parameters: | engine (string) – The name of the database engine to be used for this instance. |
---|
Parameters: | master_username (string) – |
---|
The name of master user for the client DB instance.
MySQL
Constraints:
Type: String
Oracle
Constraints:
SQL Server
Constraints:
Parameters: | master_user_password (string) – The password for the master database user. Can be any printable ASCII character except “/”, ‘”’, or “@”. |
---|
Type: String
MySQL
Constraints: Must contain from 8 to 41 characters.
Oracle
Constraints: Must contain from 8 to 30 characters.
SQL Server
Constraints: Must contain from 8 to 128 characters.
Parameters: | db_security_groups (list) – A list of DB security groups to associate with this DB instance. |
---|
Default: The default DB security group for the database engine.
Parameters: | vpc_security_group_ids (list) – A list of EC2 VPC security groups to associate with this DB instance. |
---|
Parameters: | availability_zone (string) – The EC2 Availability Zone that the database instance will be created in. |
---|
Example: us-east-1d
Parameters: | db_subnet_group_name (string) – A DB subnet group to associate with this DB instance. |
---|
If there is no DB subnet group, then it is a non-VPC DB instance.
Parameters: | preferred_maintenance_window (string) – The weekly time range (in UTC) during which system maintenance can occur. |
---|
Format: ddd:hh24:mi-ddd:hh24:mi
Valid Days: Mon, Tue, Wed, Thu, Fri, Sat, Sun
Constraints: Minimum 30-minute window.
Parameters: | db_parameter_group_name (string) – |
---|
Constraints:
Parameters: | backup_retention_period (integer) – |
---|
Default: 1
Constraints:
Must be a value from 0 to 8
replicas
Parameters: | preferred_backup_window (string) – The daily time range during which automated backups are created if automated backups are enabled, using the BackupRetentionPeriod parameter. |
---|
Parameters: | port (integer) – The port number on which the database accepts connections. |
---|
MySQL
Default: 3306
Valid Values: 1150-65535
Type: Integer
Oracle
Default: 1521
Valid Values: 1150-65535
SQL Server
Default: 1433
Valid Values: 1150-65535 except for 1434 and 3389.
Parameters: |
|
---|
MySQL
Example: 5.1.42
Type: String
Oracle
Example: 11.2.0.2.v2
Type: String
SQL Server
Example: 10.50.2789.0.v1
Parameters: | auto_minor_version_upgrade (boolean) – Indicates that minor engine upgrades will be applied automatically to the DB instance during the maintenance window. |
---|
Default: True
Parameters: | license_model (string) – License model information for this DB instance. |
---|
Parameters: | iops (integer) – The amount of Provisioned IOPS (input/output operations per second) to be initially allocated for the DB instance. |
---|
Constraints: Must be an integer greater than 1000.
Parameters: | option_group_name (string) – Indicates that the DB instance should be associated with the specified option group. |
---|
Parameters: |
|
---|
Parameters: | tags (list) – A list of tags. |
---|
Creates a DB instance that acts as a read replica of a source DB instance.
All read replica DB instances are created as Single-AZ deployments with backups disabled. All other DB instance attributes (including DB security groups and DB parameter groups) are inherited from the source DB instance, except as specified below.
The source DB instance must have backup retention enabled.
Parameters: |
|
---|
Parameters: | db_instance_class (string) – The compute and memory capacity of the read replica. |
---|
Default: Inherits from the source DB instance.
Parameters: | availability_zone (string) – The Amazon EC2 Availability Zone that the read replica will be created in. |
---|
Example: us-east-1d
Parameters: | port (integer) – The port number that the DB instance uses for connections. |
---|
Default: Inherits from the source DB instance
Valid Values: 1150-65535
Parameters: | auto_minor_version_upgrade (boolean) – Indicates that minor engine upgrades will be applied automatically to the read replica during the maintenance window. |
---|
Default: Inherits from the source DB instance
Parameters: |
|
---|
Parameters: | tags (list) – A list of tags. |
---|
Creates a new DB parameter group.
A DB parameter group is initially created with the default parameters for the database engine used by the DB instance. To provide custom values for any of the parameters, you must modify the group after creating it using ModifyDBParameterGroup . Once you’ve created a DB parameter group, you need to associate it with your DB instance using ModifyDBInstance . When you associate a new DB parameter group with a running DB instance, you need to reboot the DB Instance for the new DB parameter group and associated settings to take effect.
Parameters: | db_parameter_group_name (string) – |
---|
The name of the DB parameter group.
Constraints:
This value is stored as a lower-case string.
Parameters: |
|
---|
Creates a new DB security group. DB security groups control access to a DB instance.
Parameters: | db_security_group_name (string) – The name for the DB security group. This value is stored as a lowercase string. |
---|
Constraints:
Example: mysecuritygroup
Parameters: |
---|
Creates a DBSnapshot. The source DBInstance must be in “available” state.
Parameters: | db_snapshot_identifier (string) – The identifier for the DB snapshot. |
---|
Constraints:
Example: my-snapshot-id
Parameters: | db_instance_identifier (string) – |
---|
Constraints:
Parameters: | tags (list) – A list of tags. |
---|
Creates a new DB subnet group. DB subnet groups must contain at least one subnet in at least two AZs in the region.
Parameters: | db_subnet_group_name (string) – The name for the DB subnet group. This value is stored as a lowercase string. |
---|
Example: mySubnetgroup
Parameters: |
---|
Creates an RDS event notification subscription. This action requires a topic ARN (Amazon Resource Name) created by either the RDS console, the SNS console, or the SNS API. To obtain an ARN with SNS, you must create a topic in Amazon SNS and subscribe to the topic. The ARN is displayed in the SNS console.
You can specify the type of source (SourceType) you want to be notified of, provide a list of RDS sources (SourceIds) that triggers the events, and provide a list of event categories (EventCategories) for events you want to be notified of. For example, you can specify SourceType = db-instance, SourceIds = mydbinstance1, mydbinstance2 and EventCategories = Availability, Backup.
If you specify both the SourceType and SourceIds, such as SourceType = db-instance and SourceIdentifier = myDBInstance1, you will be notified of all the db-instance events for the specified source. If you specify a SourceType but do not specify a SourceIdentifier, you will receive notice of the events for that source type for all your RDS sources. If you do not specify either the SourceType nor the SourceIdentifier, you will be notified of events generated from all RDS sources belonging to your customer account.
Parameters: | subscription_name (string) – The name of the subscription. |
---|
Constraints: The name must be less than 255 characters.
Parameters: |
|
---|
Parameters: |
---|
Constraints:
If SourceIds are supplied, SourceType must also be provided.
must be supplied.
must be supplied.
must be supplied.
supplied.
Parameters: |
|
---|
Creates a new option group. You can create up to 20 option groups.
Parameters: | option_group_name (string) – Specifies the name of the option group to be created. |
---|
Constraints:
Example: myoptiongroup
Parameters: |
|
---|
The DeleteDBInstance action deletes a previously provisioned DB instance. A successful response from the web service indicates the request was received correctly. When you delete a DB instance, all automated backups for that instance are deleted and cannot be recovered. Manual DB snapshots of the DB instance to be deleted are not deleted.
If a final DB snapshot is requested the status of the RDS instance will be “deleting” until the DB snapshot is created. The API action DescribeDBInstance is used to monitor the status of this operation. The action cannot be canceled or reverted once submitted.
Parameters: | db_instance_identifier (string) – |
---|
Constraints:
Parameters: | skip_final_snapshot (boolean) – Determines whether a final DB snapshot is created before the DB instance is deleted. If True is specified, no DBSnapshot is created. If false is specified, a DB snapshot is created before the DB instance is deleted. |
---|
Default: False
Parameters: | final_db_snapshot_identifier (string) – |
---|
Constraints:
Deletes a specified DBParameterGroup. The DBParameterGroup cannot be associated with any RDS instances to be deleted. The specified DB parameter group cannot be associated with any DB instances.
Parameters: | db_parameter_group_name (string) – |
---|
The name of the DB parameter group.
Constraints:
Deletes a DB security group. The specified DB security group must not be associated with any DB instances.
Parameters: | db_security_group_name (string) – |
---|
The name of the DB security group to delete.
You cannot delete the default DB security group.
Constraints:
Deletes a DBSnapshot. The DBSnapshot must be in the available state to be deleted.
Parameters: | db_snapshot_identifier (string) – The DBSnapshot identifier. |
---|
Deletes a DB subnet group. The specified database subnet group must not be associated with any DB instances.
Parameters: | db_subnet_group_name (string) – |
---|
The name of the database subnet group to delete.
You cannot delete the default subnet group.
Constraints:
Deletes an RDS event notification subscription.
Parameters: | subscription_name (string) – The name of the RDS event notification subscription you want to delete. |
---|
Deletes an existing option group.
Parameters: | option_group_name (string) – |
---|
The name of the option group to be deleted.
You cannot delete default option groups.
Returns a list of the available DB engines.
Parameters: |
---|
Example: 5.1.49
Parameters: | db_parameter_group_family (string) – |
---|
The name of a specific DB parameter group family to return details for.
Constraints:
Parameters: | max_records (integer) – The maximum number of records to include in the response. If more than the MaxRecords value is available, a pagination token called a marker is included in the response so that the following results can be retrieved. |
---|
Default: 100
Constraints: minimum 20, maximum 100
Parameters: |
|
---|
Returns information about provisioned RDS instances. This API supports pagination.
Parameters: | db_instance_identifier (string) – |
---|
Constraints:
Parameters: |
|
---|
Default: 100
Constraints: minimum 20, maximum 100
Parameters: | marker (string) – An optional pagination token provided by a previous DescribeDBInstances request. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords . |
---|
Returns a list of DB log files for the DB instance.
Parameters: | db_instance_identifier (string) – |
---|
Constraints:
Parameters: |
|
---|
Returns a list of DBParameterGroup descriptions. If a DBParameterGroupName is specified, the list will contain only the description of the specified DB parameter group.
Parameters: | db_parameter_group_name (string) – |
---|
The name of a specific DB parameter group to return details for.
Constraints:
Parameters: |
|
---|
Default: 100
Constraints: minimum 20, maximum 100
Parameters: | marker (string) – An optional pagination token provided by a previous DescribeDBParameterGroups request. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords. |
---|
Returns the detailed parameter list for a particular DB parameter group.
Parameters: | db_parameter_group_name (string) – |
---|
The name of a specific DB parameter group to return details for.
Constraints:
Parameters: | source (string) – The parameter types to return. |
---|
Default: All parameter types returned
Valid Values: user | system | engine-default
Parameters: | max_records (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 the remaining results may be retrieved. |
---|
Default: 100
Constraints: minimum 20, maximum 100
Parameters: | marker (string) – An optional pagination token provided by a previous DescribeDBParameters request. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords. |
---|
Returns a list of DBSecurityGroup descriptions. If a DBSecurityGroupName is specified, the list will contain only the descriptions of the specified DB security group.
Parameters: |
|
---|
Default: 100
Constraints: minimum 20, maximum 100
Parameters: | marker (string) – An optional pagination token provided by a previous DescribeDBSecurityGroups request. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords. |
---|
Returns information about DB snapshots. This API supports pagination.
Parameters: | db_instance_identifier (string) – |
---|
Constraints:
Parameters: | db_snapshot_identifier (string) – |
---|
Constraints:
Must be 1 to 255 alphanumeric characters
First character must be a letter
Cannot end with a hyphen or contain two consecutive hyphens
SnapshotType parameter must also be specified.
Parameters: |
|
---|
Default: 100
Constraints: minimum 20, maximum 100
Parameters: | marker (string) – An optional pagination token provided by a previous DescribeDBSnapshots request. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords. |
---|
Returns a list of DBSubnetGroup descriptions. If a DBSubnetGroupName is specified, the list will contain only the descriptions of the specified DBSubnetGroup.
For an overview of CIDR ranges, go to the `Wikipedia Tutorial`_.
Parameters: |
|
---|
Default: 100
Constraints: minimum 20, maximum 100
Parameters: | marker (string) – An optional pagination token provided by a previous DescribeDBSubnetGroups request. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords. |
---|
Returns the default engine and system parameter information for the specified database engine.
Parameters: |
|
---|
Default: 100
Constraints: minimum 20, maximum 100
Parameters: | marker (string) – An optional pagination token provided by a previous DescribeEngineDefaultParameters request. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords. |
---|
Displays a list of categories for all event source types, or, if specified, for a specified source type. You can see a list of the event categories and source types in the ` Events`_ topic in the Amazon RDS User Guide.
Parameters: | source_type (string) – The type of source that will be generating the events. |
---|
Lists all the subscription descriptions for a customer account. The description for a subscription includes SubscriptionName, SNSTopicARN, CustomerID, SourceType, SourceID, CreationTime, and Status.
If you specify a SubscriptionName, lists the description for that subscription.
Parameters: |
|
---|
Default: 100
Constraints: minimum 20, maximum 100
Parameters: | marker (string) – An optional pagination token provided by a previous DescribeOrderableDBInstanceOptions request. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords . |
---|
Returns events related to DB instances, DB security groups, DB snapshots, and DB parameter groups for the past 14 days. Events specific to a particular DB instance, DB security group, database snapshot, or DB parameter group can be obtained by providing the name as a parameter. By default, the past hour of events are returned.
Parameters: | source_identifier (string) – |
---|
Constraints:
If SourceIdentifier is supplied, SourceType must also be provided.
must be supplied.
be supplied.
must be supplied.
supplied.
Cannot end with a hyphen or contain two consecutive hyphens.
Parameters: |
|
---|
Example: 2009-07-08T18:00Z
Parameters: | end_time (timestamp) – The end of the time interval for which to retrieve events, specified in ISO 8601 format. For more information about ISO 8601, go to the `ISO8601 Wikipedia page.`_ |
---|
Example: 2009-07-08T18:00Z
Parameters: | duration (integer) – The number of minutes to retrieve events for. |
---|
Default: 60
Parameters: |
|
---|
Default: 100
Constraints: minimum 20, maximum 100
Parameters: | marker (string) – An optional pagination token provided by a previous DescribeEvents request. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords. |
---|
Describes all available options.
Parameters: |
|
---|
Default: 100
Constraints: minimum 20, maximum 100
Parameters: | 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. |
---|
Describes the available option groups.
Parameters: |
|
---|
Default: 100
Constraints: minimum 20, maximum 100
Parameters: |
|
---|
Returns a list of orderable DB instance options for the specified engine.
Parameters: |
|
---|
Default: 100
Constraints: minimum 20, maximum 100
Parameters: | marker (string) – An optional pagination token provided by a previous DescribeOrderableDBInstanceOptions request. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords . |
---|
Returns information about reserved DB instances for this account, or about a specified reserved DB instance.
Parameters: |
|
---|
Valid Values: 1 | 3 | 31536000 | 94608000
Parameters: |
|
---|
Parameters: |
|
---|
Default: 100
Constraints: minimum 20, maximum 100
Parameters: | 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. |
---|
Lists available reserved DB instance offerings.
Parameters: | reserved_db_instances_offering_id (string) – The offering identifier filter value. Specify this parameter to show only the available offering that matches the specified reservation identifier. |
---|
Example: 438012d3-4052-4cc7-b2e3-8d3372e0e706
Parameters: |
|
---|
Valid Values: 1 | 3 | 31536000 | 94608000
Parameters: |
|
---|
Parameters: |
|
---|
Default: 100
Constraints: minimum 20, maximum 100
Parameters: | 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. |
---|
Downloads the last line of the specified log file.
Parameters: | db_instance_identifier (string) – |
---|
Constraints:
Parameters: |
|
---|
Lists all tags on an Amazon RDS resource.
For an overview on tagging an Amazon RDS resource, see `Tagging Amazon RDS Resources`_.
Parameters: | resource_name (string) – The Amazon RDS resource with tags to be listed. This value is an Amazon Resource Name (ARN). For information about creating an ARN, see ` Constructing an RDS Amazon Resource Name (ARN)`_. |
---|
Modify settings for a DB instance. You can change one or more database configuration parameters by specifying these parameters and the new values in the request.
Parameters: | db_instance_identifier (string) – |
---|
The DB instance identifier. This value is stored as a lowercase string.
Constraints:
Parameters: | allocated_storage (integer) – The new storage capacity of the RDS instance. Changing this parameter does not result in an outage and the change is applied during the next maintenance window unless the ApplyImmediately parameter is set to True for this request. |
---|
MySQL
Default: Uses existing setting
Valid Values: 5-1024
Type: Integer
Oracle
Default: Uses existing setting
Valid Values: 10-1024
SQL Server
Cannot be modified.
Parameters: | db_instance_class (string) – The new compute and memory capacity of the DB instance. To determine the instance classes that are available for a particular DB engine, use the DescribeOrderableDBInstanceOptions action. |
---|
Default: Uses existing setting
Parameters: | db_security_groups (list) – |
---|
Constraints:
Parameters: | vpc_security_group_ids (list) – |
---|
Constraints:
Parameters: | apply_immediately (boolean) – Specifies whether or not the modifications in this request and any pending modifications are asynchronously applied as soon as possible, regardless of the PreferredMaintenanceWindow setting for the DB instance. |
---|
Default: False
Parameters: | master_user_password (string) – |
---|
Default: Uses existing setting
Parameters: | db_parameter_group_name (string) – The name of the DB parameter group to apply to this DB instance. Changing this parameter does not result in an outage and the change is applied during the next maintenance window unless the ApplyImmediately parameter is set to True for this request. |
---|
Default: Uses existing setting
Parameters: | backup_retention_period (integer) – |
---|
Default: Uses existing setting
Constraints:
Must be a value from 0 to 8
replicas or if the DB instance is a read replica
Parameters: | preferred_backup_window (string) – |
---|
Constraints:
Parameters: | preferred_maintenance_window (string) – The weekly time range (in UTC) during which system maintenance can occur, which may result in an outage. Changing this parameter does not result in an outage, except in the following situation, and the change is asynchronously applied as soon as possible. If there are pending actions that cause a reboot, and the maintenance window is changed to include the current time, then changing this parameter will cause a reboot of the DB instance. If moving this window to the current time, there must be at least 30 minutes between the current time and end of the window to ensure pending changes are applied. |
---|
Default: Uses existing setting
Format: ddd:hh24:mi-ddd:hh24:mi
Valid Days: Mon | Tue | Wed | Thu | Fri | Sat | Sun
Constraints: Must be at least 30 minutes
Parameters: | multi_az (boolean) – Specifies if the DB instance is a Multi-AZ deployment. Changing this parameter does not result in an outage and the change is applied during the next maintenance window unless the ApplyImmediately parameter is set to True for this request. |
---|
Constraints: Cannot be specified if the DB instance is a read replica.
Parameters: | engine_version (string) – The version number of the database engine to upgrade to. Changing this parameter results in an outage and the change is applied during the next maintenance window unless the ApplyImmediately parameter is set to True for this request. |
---|
Example: 5.1.42
Parameters: | allow_major_version_upgrade (boolean) – Indicates that major version upgrades are allowed. Changing this parameter does not result in an outage and the change is asynchronously applied as soon as possible. |
---|
Parameters: |
|
---|
Default: Uses existing setting
Type: Integer
Parameters: | option_group_name (string) – Indicates that the DB instance should be associated with the specified option group. Changing this parameter does not result in an outage except in the following case and the change is applied during the next maintenance window unless the ApplyImmediately parameter is set to True for this request. If the parameter change results in an option group that enables OEM, this change can cause a brief (sub-second) period during which new connections are rejected but existing connections are not interrupted. |
---|
Parameters: | new_db_instance_identifier (string) – |
---|
Constraints:
Modifies the parameters of a DB parameter group. To modify more than one parameter, submit a list of the following: ParameterName, ParameterValue, and ApplyMethod. A maximum of 20 parameters can be modified in a single request.
The apply-immediate method can be used only for dynamic parameters; the pending-reboot method can be used with MySQL and Oracle DB instances for either dynamic or static parameters. For Microsoft SQL Server DB instances, the pending-reboot method can be used only for static parameters.
Parameters: | db_parameter_group_name (string) – |
---|
The name of the DB parameter group.
Constraints:
Parameters: | parameters (list) – |
---|
Valid Values (for the application method): immediate | pending-reboot
Modifies an existing DB subnet group. DB subnet groups must contain at least one subnet in at least two AZs in the region.
Parameters: | db_subnet_group_name (string) – The name for the DB subnet group. This value is stored as a lowercase string. |
---|
Example: mySubnetgroup
Parameters: |
---|
Modifies an existing RDS event notification subscription. Note that you cannot modify the source identifiers using this call; to change source identifiers for a subscription, use the AddSourceIdentifierToSubscription and RemoveSourceIdentifierFromSubscription calls.
You can see a list of the event categories for a given SourceType in the `Events`_ topic in the Amazon RDS User Guide or by using the DescribeEventCategories action.
Parameters: |
|
---|
Parameters: |
|
---|
Modifies an existing option group.
Parameters: | option_group_name (string) – The name of the option group to be modified. |
---|
Parameters: |
|
---|
Promotes a read replica DB instance to a standalone DB instance.
Parameters: | db_instance_identifier (string) – The DB instance identifier. This value is stored as a lowercase string. |
---|
Constraints:
Example: mydbinstance
Parameters: | backup_retention_period (integer) – |
---|
Default: 1
Constraints:
Parameters: | preferred_backup_window (string) – The daily time range during which automated backups are created if automated backups are enabled, using the BackupRetentionPeriod parameter. |
---|
Purchases a reserved DB instance offering.
Parameters: | reserved_db_instances_offering_id (string) – The ID of the Reserved DB instance offering to purchase. |
---|
Example: 438012d3-4052-4cc7-b2e3-8d3372e0e706
Parameters: | reserved_db_instance_id (string) – Customer-specified identifier to track this reservation. |
---|
Example: myreservationID
Parameters: | db_instance_count (integer) – The number of instances to reserve. |
---|
Default: 1
Parameters: | tags (list) – A list of tags. |
---|
Rebooting a DB instance restarts the database engine service. A reboot also applies to the DB instance any modifications to the associated DB parameter group that were pending. Rebooting a DB instance results in a momentary outage of the instance, during which the DB instance status is set to rebooting. If the RDS instance is configured for MultiAZ, it is possible that the reboot will be conducted through a failover. An Amazon RDS event is created when the reboot is completed.
If your DB instance is deployed in multiple Availability Zones, you can force a failover from one AZ to the other during the reboot. You might force a failover to test the availability of your DB instance deployment or to restore operations to the original AZ after a failover occurs.
The time required to reboot is a function of the specific database engine’s crash recovery process. To improve the reboot time, we recommend that you reduce database activities as much as possible during the reboot process to reduce rollback activity for in-transit transactions.
Parameters: | db_instance_identifier (string) – |
---|
Constraints:
Parameters: | force_failover (boolean) – When True, the reboot will be conducted through a MultiAZ failover. |
---|
Removes a source identifier from an existing RDS event notification subscription.
Parameters: |
---|
Removes metadata tags from an Amazon RDS resource.
For an overview on tagging an Amazon RDS resource, see `Tagging Amazon RDS Resources`_.
Parameters: |
---|
Modifies the parameters of a DB parameter group to the engine/system default value. To reset specific parameters submit a list of the following: ParameterName and ApplyMethod. To reset the entire DB parameter group, specify the DBParameterGroup name and ResetAllParameters parameters. When resetting the entire group, dynamic parameters are updated immediately and static parameters are set to pending-reboot to take effect on the next DB instance restart or RebootDBInstance request.
Parameters: | db_parameter_group_name (string) – |
---|
The name of the DB parameter group.
Constraints:
Parameters: | reset_all_parameters (boolean) – Specifies whether ( True) or not ( False) to reset all parameters in the DB parameter group to default values. |
---|
Default: True
Parameters: | parameters (list) – An array of parameter names, values, and the apply method for the parameter update. At least one parameter name, value, and apply method must be supplied; subsequent arguments are optional. A maximum of 20 parameters may be modified in a single request. |
---|
MySQL
Valid Values (for Apply method): immediate | pending-reboot
Oracle
Valid Values (for Apply method): pending-reboot
Creates a new DB instance from a DB snapshot. The target database is created from the source database restore point with the same configuration as the original source database, except that the new RDS instance is created with the default security group.
Parameters: | db_instance_identifier (string) – |
---|
The identifier for the DB snapshot to restore from.
Constraints:
Parameters: | db_snapshot_identifier (string) – Name of the DB instance to create from the DB snapshot. This parameter isn’t case sensitive. |
---|
Constraints:
Example: my-snapshot-id
Parameters: | db_instance_class (string) – The compute and memory capacity of the Amazon RDS DB instance. |
---|
Parameters: | port (integer) – The port number on which the database accepts connections. |
---|
Default: The same port as the original DB instance
Constraints: Value must be 1150-65535
Parameters: | availability_zone (string) – The EC2 Availability Zone that the database instance will be created in. |
---|
Default: A random, system-chosen Availability Zone.
Example: us-east-1a
Parameters: |
|
---|
Parameters: | publicly_accessible (boolean) – Specifies the accessibility options for the DB instance. A value of true specifies an Internet-facing instance with a publicly resolvable DNS name, which resolves to a public IP address. A value of false specifies an internal instance with a DNS name that resolves to a private IP address. |
---|
Parameters: |
|
---|
Default: Same as source.
Parameters: | db_name (string) – |
---|
The database name for the restored DB instance.
This parameter doesn’t apply to the MySQL engine.
Parameters: | engine (string) – The database engine to use for the new instance. |
---|
Default: The same as source
Constraint: Must be compatible with the engine of the source
Example: oracle-ee
Parameters: | iops (integer) – Specifies the amount of provisioned IOPS for the DB instance, expressed in I/O operations per second. If this parameter is not specified, the IOPS value will be taken from the backup. If this parameter is set to 0, the new instance will be converted to a non-PIOPS instance, which will take additional time, though your DB instance will be available for connections before the conversion starts. |
---|
Constraints: Must be an integer greater than 1000.
Parameters: | option_group_name (string) – The name of the option group to be used for the restored DB instance. |
---|
Parameters: | tags (list) – A list of tags. |
---|
Restores a DB instance to an arbitrary point-in-time. Users can restore to any point in time before the latestRestorableTime for up to backupRetentionPeriod days. The target database is created from the source database with the same configuration as the original database except that the DB instance is created with the default DB security group.
Parameters: | source_db_instance_identifier (string) – |
---|
The identifier of the source DB instance from which to restore.
Constraints:
Parameters: | target_db_instance_identifier (string) – |
---|
The name of the new database instance to be created.
Constraints:
Parameters: | restore_time (timestamp) – The date and time to restore from. |
---|
Valid Values: Value must be a UTC time
Constraints:
Example: 2009-09-07T23:45:00Z
Parameters: | use_latest_restorable_time (boolean) – Specifies whether ( True) or not ( False) the DB instance is restored from the latest backup time. |
---|
Default: False
Constraints: Cannot be specified if RestoreTime parameter is provided.
Parameters: | db_instance_class (string) – The compute and memory capacity of the Amazon RDS DB instance. |
---|
Default: The same DBInstanceClass as the original DB instance.
Parameters: | port (integer) – The port number on which the database accepts connections. |
---|
Constraints: Value must be 1150-65535
Default: The same port as the original DB instance.
Parameters: | availability_zone (string) – The EC2 Availability Zone that the database instance will be created in. |
---|
Default: A random, system-chosen Availability Zone.
Example: us-east-1a
Parameters: |
|
---|
Parameters: | publicly_accessible (boolean) – Specifies the accessibility options for the DB instance. A value of true specifies an Internet-facing instance with a publicly resolvable DNS name, which resolves to a public IP address. A value of false specifies an internal instance with a DNS name that resolves to a private IP address. |
---|
Parameters: |
|
---|
Default: Same as source.
Parameters: | db_name (string) – |
---|
The database name for the restored DB instance.
This parameter is not used for the MySQL engine.
Parameters: | engine (string) – The database engine to use for the new instance. |
---|
Default: The same as source
Constraint: Must be compatible with the engine of the source
Example: oracle-ee
Parameters: | iops (integer) – The amount of Provisioned IOPS (input/output operations per second) to be initially allocated for the DB instance. |
---|
Constraints: Must be an integer greater than 1000.
Parameters: | option_group_name (string) – The name of the option group to be used for the restored DB instance. |
---|
Parameters: | tags (list) – A list of tags. |
---|
Revokes ingress from a DBSecurityGroup for previously authorized IP ranges or EC2 or VPC Security Groups. Required parameters for this API are one of CIDRIP, EC2SecurityGroupId for VPC, or (EC2SecurityGroupOwnerId and either EC2SecurityGroupName or EC2SecurityGroupId).
Parameters: |
|
---|