VM::EC2::REST::relational_database_service(3pm) | User Contributed Perl Documentation | VM::EC2::REST::relational_database_service(3pm) |
use VM::EC2 ':rds';
These methods give access and control over the AWS Relational Database Service. RDS provides easy access to creating and managing an Oracle or MySQL database in the AWS cloud.
Implemented: AddSourceIdentifierToSubscription AddTagsToResource AuthorizeDBSecurityGroupIngress CopyDBSnapshot CreateDBInstance CreateDBInstanceReadReplica CreateDBParameterGroup CreateDBSecurityGroup CreateDBSnapshot CreateDBSubnetGroup CreateEventSubscription CreateOptionGroup DescribeDBEngineVersions DescribeDBInstances DescribeDBParameterGroups DescribeDBParameters DescribeDBSecurityGroups DescribeDBSnapshots DescribeDBSubnetGroups DescribeEngineDefaultParameters DescribeEventCategories DescribeEventSubscriptions DescribeEvents DescribeOptionGroupOptions DescribeOptionGroups DescribeOrderableDBInstanceOptions DescribeReservedDBInstances DescribeReservedDBInstancesOfferings DownloadDBLogFilePortion ListTagsForResource ModifyDBInstance ModifyDBParameterGroup ModifyDBSubnetGroup ModifyEventSubscription ModifyOptionGroup PromoteReadReplica PurchaseReservedDBInstancesOffering RebootDBInstance RemoveSourceIdentifierFromSubscription RemoveTagsFromResource ResetDBParameterGroup RestoreDBInstanceFromDBSnapshot RestoreDBInstanceToPointInTime RevokeDBSecurityGroupIngress
Unimplemented:
(none)
VM::EC2
Adds a source identifier to an existing RDS event notification subscription.
Required arguments:
-source_identifier The identifier of the event source to be added. -subscription_name The name of the RDS event notification subscription you want to add a source identifier to.
Returns a VM::EC2::DB::Event::Subscription object.
Adds metadata tags to an Amazon RDS resource. These tags can also be used with cost allocation reporting to track costs associated with Amazon RDS resources, or used in a Condition statement in an IAM policy for Amazon RDS.
Required arguments:
-resource_name The Amazon RDS resource the tags will be removed from. This value is an Amazon Resource Name (ARN). For information about creating an ARN, see Constructing an RDS Amazon Resource Name (ARN) at: http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_Tagging.html#USER_Tagging.ARN -tags hashref or arrayref of hashrefs containing tag Key/Value pairs
This method does not return a value but will raise an error if unsuccessful.
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 arguments:
-db_security_group_name The name of the DB Security Group to add authorization to.
Optional arguments:
-cidrip The IP range to authorize. -ec2_security_group_id ID of the EC2 Security Group to authorize. For VPC DB security groups, EC2SecurityGroupId must be provided. -ec2_security_group_name Name of the EC2 Security Group to authorize. -ec2_security_group_owner_id AWS Account Number of the owner of the EC2 Security Group specified in the -ec2_security_group_name parameter.
Returns a VM::EC2::DB::SecurityGroup object.
Copies the specified DBSnapshot. The source DBSnapshot must be in the "available" state.
Required arguments:
-source_db_snapshot_identifier The identifier for the source DB snapshot. Constraints: * Must specify a valid system snapshot in the "available" state * If the source snapshot is in the same region as the copy, specify a valid DB snapshot identifier * If the source snapshot is in a different region than the copy, specify a valid DB snapshot ARN For more information, see: http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_CopySnapshot.html -target_db_snapshot_identifier The identifier for the copied snapshot. Constraints: * Cannot be null, empty, or blank * Must contain from 1 to 255 alphanumeric characters or hyphens * First character must be a letter * Cannot end with a hyphen or contain two consecutive hyphens -source Alias for -source_db_snapshot_identifier -target Alias for -target_db_snapshot_identifier
Optional arguments:
-tags hashref or arrayref of hashrefs containing Key/Value pairs
Returns a VM::EC2::DB::Snapshot object.
Creates a new DB instance.
Required arguments:
-allocated_storage MySQL: * Must be an integer from 5 to 1024. Oracle: * Must be an integer from 10 to 1024. SQL Server: * Must be an integer from 200 to 1024 (Standard Edition and Enterprise Edition) or from 30 to 1024 (Express Edition and Web Edition) -db_instance_class The compute and memory capacity of the DB Instance. db.t1.micro | db.m1.small | db.m1.medium | db.m1.large | db.m1.xlarge | db.m2.xlarge |db.m2.2xlarge | db.m2.4xlarge -db_instance_identifier The DB Instance identifier. This parameter is stored as a lowercase string. Constraints: * Must contain from 1 to 63 alphanumeric characters or hyphens (1 to 15 for SQL Server). * First character must be a letter. * Cannot end with a hyphen or contain two consecutive hyphens. -engine The name of the database engine to be used for this instance. Valid values: MySQL | oracle-se1 | oracle-se | oracle-ee | sqlserver-ee | sqlserver-se | sqlserver-ex | sqlserver-web -master_user_password The password for the master database user. Can be any printable ASCII character except "/", "\", or "@". Constraints: * MySQL: Must contain from 8 to 41 alphanumeric characters. * Oracle: Must contain from 8 to 30 alphanumeric characters. * SQL Server: Must contain from 8 to 128 alphanumeric characters. -master_username The name of master user for the client DB Instance. Constraints: * First character must be a letter. * Cannot be a reserved word for the chosen database engine. MySQL: * Must be 1 to 16 alphanumeric characters. Oracle: * Must be 1 to 30 alphanumeric characters. SQL Server: * Must be 1 to 128 alphanumeric characters.
Optional arguments:
-auto_minor_version_upgrade Indicates that minor engine upgrades will be applied automatically to the DB Instance during the maintenance window. (Boolean). Default: true -availability_zone The EC2 Availability Zone that the database instance will be created in. Default: A random, system-chosen Availability Zone in the endpoint's region. -backup_retention_period The number of days for which automated backups are retained. Setting this parameter to a positive number enables backups. Setting this parameter to 0 disables automated backups. Default: 1 Constraints: * Must be a value from 0 to 8 * Cannot be set to 0 if the DB Instance is a master instance with read replicas -character_set_name For supported engines, indicates that the DB Instance should be associated with the specified CharacterSet. -db_name The meaning of this parameter differs according to the database engine you use. MySQL: The name of the database to create when the DB Instance is created. If this parameter is not specified, no database is created in the DB Instance. Constraints: * Must contain 1 to 64 alphanumeric characters * Cannot be a reserved word Oracle: The Oracle System ID (SID) of the created DB Instance. Constraints: * Cannot be longer than 8 characters SQL Server: Not applicable. Must be null. -db_parameter_group_name The name of the DB Parameter Group to associate with this DB instance. If this argument is omitted, the default DBParameterGroup for the specified engine will be used. Constraints: * Must be 1 to 255 alphanumeric characters * First character must be a letter. * Cannot end with a hyphen or contain two consecutive hyphens -db_security_groups An arrayref of DB Security Groups to associate with the instance -db_subnet_group_name A DB Subnet Group to associate with this DB Instance. If not specified, then it is a non-VPC DB instance. -engine_version The version number of the database engine to use. -iops The amount of Provisioned IOPS initially allocated. Integer between 100-1000 -license_model License model information for this DB Instance. Valid values: license-included | bring-your-own-license | general-public-license -multi_az Specifies if the DB Instance is a Multi-AZ deployment. You cannot set the -availability_zone argument if the -multi_az argument is set to true. -option_group_name Indicates that the DB Instance should be associated with the specified option group. -port The port number on which the database accepts connections. MySQL: * Default: 3306, Valid values: 1150-65535 Oracle: * Default: 1521, Valid values: 1150-65535 Oracle: * Default: 1433, Valid values: 1150-65535 except 1434 and 3389. -preferred_backup_window The daily time range during which automated backups are created if automated backups are enabled using the -backup_retention_period argument. Default: Default: A 30-minute window selected at random from an 8-hour block of time per region. The following list shows the time blocks for each region from which the default backup windows are assigned. * US-East (Northern Virginia) Region: 03:00-11:00 UTC * US-West (N. California, Oregon) Region: 06:00-14:00 UTC * EU (Ireland) Region: 22:00-06:00 UTC * Asia Pacific (Singapore) Region: 14:00-22:00 UTC * Asia Pacific (Tokyo) Region: 17:00-03:00 UTC Constraints: * Must be in the format hh24:mi-hh24:mi * Times in Universal Time Coordinated (UTC). * Must not conflict with the preferred maintenance window. * Must be at least 30 minutes. -preferred_maintenance_window The weekly time range (in UTC) during which system maintenance can occur. Format: ddd:hh24:mi-ddd:hh24:mi Default: A 30-minute window selected at random from an 8-hour block of time per region, occurring on a random day of the week. The following list shows the time blocks for each region from which the default maintenance windows are assigned. * US-East (Northern Virginia) Region: 03:00-11:00 UTC * US-West (N. California, Oregon) Region: 06:00-14:00 UTC * EU (Ireland) Region: 22:00-06:00 UTC * Asia Pacific (Singapore) Region: 14:00-22:00 UTC * Asia Pacific (Tokyo) Region: 17:00-03:00 UTC Valid Days: Mon, Tue, Wed, Thu, Fri, Sat, Sun Constraints: Minimum 30-minute window. -publicly_accessible 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. Default: The default behavior varies depending on whether a VPC has been requested or not. The following list shows the default behavior in each case. * DefaultVPC:true * VPC:false If no DB subnet group has been specified as part of the request and the -publicly_accessible value has not been set, the DB instance will be publicly accessible. If a specific DB subnet group has been specified as part of the request and the PubliclyAccessible value has not been set, the DB instance will be private. -tags hashref or arrayref of hashrefs containing Key/Value pairs -vpc_security_group_ids A list of EC2 VPC Security Groups to associate with this DB Instance.
This method returns a VM::EC2::DB:Instance object.
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. IMPORTANT: The source DB Instance must have backup retention enabled.
Required arguments:
-db_instance_identifier The DB Instance identifier of the Read Replica. This is the unique key that identifies a DB Instance. This parameter is stored as a lowercase string. -source_db_instance_identifier The identifier of the DB Instance that will act as the source for the Read Replica. Each DB Instance can have up to five Read Replicas. Constraints: Must be the identifier of an existing DB Instance that is not already a Read Replica DB Instance.
Optional arguments:
-auto_minor_version_upgrade Indicates that minor engine upgrades will be applied automatically to the Read Replica during the maintenance window. (Boolean) -availability_zone The Amazon EC2 Availability Zone that the Read Replica will be created in. Default: A random, system-chosen Availability Zone in the endpoint's region. -db_instance_class The compute and memory capacity of the Read Replica. Valid Values: db.m1.small | db.m1.medium | db.m1.large | db.m1.xlarge | db.m2.xlarge | db.m2.2xlarge | db.m2.4xlarge -iops The amount of Provisioned IOPS to be initially allocated for the DB Instance. -option_group_name The option group the DB instance will be associated with. If omitted, the default Option Group for the engine specified will be used. -port The port number that the DB Instance uses for connections. Default: Inherits from the source instance Valid Values: 1150-65535 -publicly_accessible 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. Default: The default behavior varies depending on whether a VPC has been requested or not. The following list shows the default behavior in each case. * DefaultVPC:true * VPC:false If no DB subnet group has been specified as part of the request and the -publicly_accessible value has not been set, the DB instance will be publicly accessible. If a specific DB subnet group has been specified as part of the request and the PubliclyAccessible value has not been set, the DB instance will be private.
Returns a VM::EC2::DB::Instance object on success.
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 modify_db_parameter_group(). Once you've created a DB Parameter Group, you need to associate it with your DB Instance using modify_db_instance(). 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.
Required arguments:
-db_parameter_group_family The DB Parameter Group Family name. A DB Parameter Group can be associated with one and only one DB Parameter Group Family, and can be applied only to a DB Instance running a database engine and engine version compatible with that DB Parameter Group Family. -db_parameter_group_name The name of the DB Parameter Group. Constraints: * Must be 1 to 255 alphanumeric characters * First character must be a letter * Cannot end with a hyphen or contain two consecutive hyphens NOTE: This value is stored as a lower-case string. -description The description for the DB Parameter Group.
Returns a VM::EC2::DB::Parameter::Group object.
Creates a new DB Security Group. DB Security Groups control access to a DB Instance if not in a VPC.
Required arguments:
-db_security_group_description The description for the DB Security Group. -db_security_group_name The name for the DB Security Group. This value is stored as a lowercase string. Constraints: Must contain no more than 255 alphanumeric characters or hyphens. Must not be "Default". -name Alias for -db_security_group_name -description Alias for -db_security_group_description
Returns a VM::EC2::DB::SecurityGroup object.
Creates a DB snapshot. The source DB instance must be in "available" state.
Required arguments:
-db_instance_identifier The DB instance identifier. This is the unique key that identifies a DB instance. This parameter is not case sensitive. Constraints: * Must contain from 1 to 63 alphanumeric characters or hyphens * First character must be a letter * Cannot end with a hyphen or contain two consecutive hyphens -db_snapshot_identifier The identifier for the DB snapshot. Constraints: * Cannot be null, empty, or blank * Must contain from 1 to 255 alphanumeric characters or hyphens * First character must be a letter * Cannot end with a hyphen or contain two consecutive hyphens -db_id Alias for -db_instance_identifier -snapshot_id Alias for -db_snapshot_identifier
Returns a VM::EC2::DB::Snapshot object on success.
Creates a new DB subnet group. DB subnet groups must contain at least one subnet in at least two availability zones in the region.
Required arguments:
-db_subnet_group_description The description for the DB subnet group. -db_subnet_group_name The name for the DB Subnet Group. This value is stored as a lowercase string. Constraints: * Must contain no more than 255 alphanumeric characters or hyphens. * Must not be "Default". -subnet_ids Arrayref of subnet IDs for the subnet group. -description Alias for -db_subnet_group_description -name Alias -db_subnet_group_name
Returns a VM::EC2::DB::Subnet::Group object on success.
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.
Required arguments:
-sns_topic_arn The Amazon Resource Name (ARN) of the SNS topic created for event notification. The ARN is created by Amazon SNS when you create a topic and subscribe to it. -subscription_name The name of the subscription.
Optional arguments:
-enabled Boolean; set to true to activate the subscription, set to false to create the subscription but not active it. -event_categories An arrayref of event categories for a -source_type that you want to subscribe to. You can see a list of the categories for a given -source_type in the Events topic in the Amazon RDS User Guide or by using the describe_event_categories() call. -source_ids An arrayref of identifiers of the event sources for which events will be returned. If not specified, then all sources are included in the response. An identifier must begin with a letter and must contain only ASCII letters, digits, and hyphens; it cannot end with a hyphen or contain two consecutive hyphens. -source_type The type of source that will be generating the events. For example, if you want to be notified of events generated by a DB instance, you would set this parameter to db-instance. if this value is not specified, all events are returned. Valid values: db-instance | db-parameter-group | db-security-group | db-snapshot -name Alias for -subscription_name
Returns a VM::EC2::DB::Event::Subscription object on success.
Creates a new Option Group. You can create up to 20 option groups.
Required arguments:
-engine_name Specifies the name of the engine that this option group should be associated with. -major_engine_version Specifies the major version of the engine that this option group should be associated with. -option_group_description The description of the option group. -option_group_name Specifies the name of the option group to be created. Constraints: * Must be 1 to 255 alphanumeric characters or hyphens * First character must be a letter * Cannot end with a hyphen or contain two consecutive hyphens -name Alias for -option_group_name -description Alias for -option_group_description
Returns a VM::EC2::DB::Option::Group object on success.
All arguments are optional.
-db_parameter_group_family The specific DB Parameter Group family to return details for. -family Alias for -db_parameter_group_family -default_only Return only the default version of the specified engine or engine and major version combination (boolean). -engine Database engine to return. -engine_version Database engine version to return. -list_supported_character_sets List supported charsets (boolean) -marker An optional pagination token provided by a previous request. If specified, the response includes only records after the marker, up to the value specified by -max_records. -max_records The maximum number of records to include in the response. If more records than the max exist, a marker token is included in the response.
Returns an array of VM::EC2::DB::Engine::Version objects.
All arguments are optional.
-db_instance_identifier The user-supplied instance identifier. If this parameter is specified, only information for the specific DB Instance is returned. -marker An optional pagination token provided by a previous request. If specified, the response includes only records after the marker, up to the value specified by -max_records. -max_records The maximum number of records to include in the response. If more records than the max exist, a marker token is included in the response. -db_instance_id alias for -db_instance_identifier
Returns an array of VM::EC2::DB::Instance objects if any exist.
All arguments are optional.
-db_parameter_group_name The name of the DB parameter group to describe. -marker An optional pagination token provided by a previous request. If specified, the response includes only records after the marker, up to the value specified by -max_records. -max_records The maximum number of records to include in the response. If more records than the max exist, a marker token is included in the response. -group_name alias for -db_subnet_group_name
Returns an array of VM::EC2::DB::Parameter::Group objects if any exist.
Required arguments:
-db_parameter_group_name The name of the DB parameter group.
Optional arguments:
-source The parameter types to return. Valid values: user | system | engine-default Default is all parameter types. -marker An optional pagination token provided by a previous request. If specified, the response includes only records after the marker, up to the value specified by -max_records. -max_records The maximum number of records to include in the response. If more records than the max exist, a marker token is included in the response.
Returns an array of VM::EC2::DB::Parameter objects.
All arguments are optional.
-db_security_group_name The name of the DB security group. -marker An optional pagination token provided by a previous request. If specified, the response includes only records after the marker, up to the value specified by -max_records. -max_records The maximum number of records to include in the response. If more records than the max exist, a marker token is included in the response. -group_name alias for -db_security_group_name
Returns an array of VM::EC2::DB::SecurityGroup objects if any exist.
All arguments are optional.
-db_instance_identifier A DB Instance Identifier to retrieve the list of DB snapshots for. Cannot be used in conjunction with -db_snapshot_identifier. This parameter is not case sensitive. -db_snapshot_identifier A specific DB Snapshot Identifier to describe. Cannot be used in conjunction with . This value is stored as a lowercase string. -marker An optional pagination token provided by a previous request. If specified, the response includes only records after the marker, up to the value specified by -max_records. -max_records The maximum number of records to include in the response. If more records than the max exist, a marker token is included in the response. -snapshot_type An optional snapshot type for which snapshots will be returned. If not specified, the returned results will include snapshots of all types. -db_instance_id Alias for -db_instance_identifier -db_snapshot_id Alias for -db_snapshot_identifier
Returns an array of VM::EC2:DB::Snapshot objects if any exist.
All arguments are optional.
-db_subnet_group_name The name of the DB Subnet Group to describe. -marker An optional pagination token provided by a previous request. If specified, the response includes only records after the marker, up to the value specified by -max_records. -max_records The maximum number of records to include in the response. If more records than the max exist, a marker token is included in the response. -group_name alias for -db_subnet_group_name
Returns an array of VM::EC2::DB::Subnet::Group objects if any exist.
Required arguments:
-db_parameter_group_family The name of the DB Parameter Group Family. -family Alias for -db_parameter_group_family
Returns an array of VM::EC2::DB::Parameter objects.
Optional argument:
-source_type The type of source that will be generating the events. Valid values: db-instance | db-parameter-group | db-security-group | db-snapshot
Returns an array of VM::EC2::DB::Event::Category objects
Optional argument:
-subscription_name The name of the RDS event notification subscription.
Returns an array of VM::EC2::DB::Event::Subscription object.
All arguments are optional but some conditions apply.
-duration The number of minutes to retrieve events for. -end_time The end of the time interval for which to retrieve events, specified in ISO 8601 format. For more information on ISO 8601, visit: http://en.wikipedia.org/wiki/ISO_8601 -event_categories A string or arrayref of event categories that trigger notifications for a event notification subscription. -source_identifier The identifier of the event source for which events will be returned. If not specified, then all sources are included in the response. -source_type The event source to retrieve events for. If no value is specified, all events are returned. REQUIRED if -source_identifier is provided. If 'DBInstance', then a DBInstanceIdentifier must be supplied in -source_identifier. If 'DBSecurityGroup', a DBSecurityGroupName must be supplied in -source_identifier. If 'DBParameterGroup', a DBParameterGroupName must be supplied in -source_identifier. If 'DBSnapshot', a DBSnapshotIdentifier must be supplied in -source_identifier. -start_time The beginning of the time interval to retrieve events for, specified in ISO 8601 format. For more information on ISO 8601, visit: http://en.wikipedia.org/wiki/ISO_8601
Returns an array of VM::EC2::DB::Event objects.
Describes all available options for a particular database engine.
Required arguments:
-engine_name Database engine to describe options for.
Optional arguments:
-major_engine_version If specified, filters the results to include only options for the specified major engine version.
Returns an array of VM::EC2::DB::Option::Group::Option objects.
Describes the available option groups.
All arguments are optional.
-engine_name Database engine to describe options for. -major_engine_version If specified, filters the results to include only options for the specified major engine version. -option_group_name The name of the option group to describe. Cannot be supplied together with -engine_name or -major_engine_version.
Returns an array of VM::EC2::DB::Option::Group objects.
Describe the different RDS instances that can be launched.
Required arguments:
-engine The name of the engine to retrieve DB Instance options for.
Optional arguments:
-db_instance_class The DB Instance class (size) filter value. -engine_version The engine version filter value. -license_model The license model filter value. -vpc The VPC filter value. (boolean)
Returns an array of VM::EC2::DB::Instance::OrderableOption objects.
Returns information about reserved DB Instances for the account, or about a specific reserved DB Instance.
All arguments are optional:
-db_instance_class The DB Instance class (size) filter. -duration The duration filter value, specified in years or seconds. Valid values: 1 | 3 | 31536000 | 94608000 -multi_az The Multi-AZ filter value. (boolean) -offering_type The offering type filter value. Valid Values: "Light Utilization" | "Medium Utilization" | "Heavy Utilization" -product_description The product description filter value. -reserved_db_instance_id The reserved DB Instance identifier filter value. -reserved_db_instances_offering_id The offering identifier filter value.
Returns an array of VM::EC2::DB::Reserved::Instance objects.
Lists available reserved DB Instance offerings.
All arguments are optional:
-db_instance_class The DB Instance class (size) filter. -duration The duration filter value, specified in years or seconds. Valid values: 1 | 3 | 31536000 | 94608000 -multi_az The Multi-AZ filter value. (boolean) -offering_type The offering type filter value. Valid Values: "Light Utilization" | "Medium Utilization" | "Heavy Utilization" -product_description The product description filter value. -reserved_db_instance_id The reserved DB Instance identifier filter value. -reserved_db_instances_offering_id The offering identifier filter value.
Returns an array of VM::EC2::DB::Reserved::Instance objects.
Downloads the last line of the specified log file.
All arguments are optional:
-db_instance_identifier The DB Instance class (size) filter. -log_file_name The name of the log file to be downloaded. -marker The pagination token provided in the previous request. If this parameter is specified the response includes only records beyond the marker, up to MaxRecords. -number_of_lines The number of lines remaining to be downloaded.
Returns a VM::EC2::DB::LogFilePortion object.
Lists all tags on a DB Instance or Snapshot.
Arguments:
-resource_name The name of the resource to list tags for.
Returns a hash or hashref of tags.
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.
Required arguments:
-db_instance_identifier The DB Instance identifier.
Optional arguments:
-allocated_storage 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 -apply_immediately parameter is set to true for this request. MySQL: * Must be an integer from 5 to 1024. * Value supplied must be at least 10% greater than the current value. Values that are not at least 10% greater than the existing value are rounded up so that they are 10% greater than the current value. Oracle: * Must be an integer from 10 to 1024. * Value supplied must be at least 10% greater than the current value. Values that are not at least 10% greater than the existing value are rounded up so that they are 10% greater than the current value. SQL Server: * CANNOT BE MODIFIED -allow_major_version_upgrade 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. Constraints: This parameter must be set to true when specifying a value for the -engine_version argument that is a different major version than the DB Instance's current version. -apply_immediately Specifies whether or not the modifications in this request and any pending modifications are asynchronously applied as soon as possible, regardless of the -preferred_maintenance_window setting for the DB Instance. If this parameter is passed as false, changes to the DB Instance are applied on the next reboot_db_instance() call, the next maintenance reboot, or the next failure reboot, whichever occurs first. See each parameter to determine when a change is applied. Default is false. -auto_minor_version_upgrade Indicates that minor engine upgrades will be applied automatically to the DB Instance during the maintenance window. Changing this parameter does not result in an outage except in the following case and the change is asynchronously applied as soon as possible. An outage will result if this parameter is set to true during the maintenance window, and a newer minor version is available, and RDS has enabled auto patching for that engine version. (Boolean) -backup_retention_period The number of days for which automated backups are retained. Setting this parameter to a positive number enables backups. Setting this parameter to 0 disables automated backups. Default: Existing setting Constraints: * Must be a value from 0 to 8 * Cannot be set to 0 if the DB Instance is a master instance with read replicas -db_instance_class The new compute and memory capacity of the DB Instance. To determine the available classes, use the describe_orderable_db_instance_options() call. Passing a value for this parameter causes an outage during the change and is applied during the next maintenance window, unless the -apply_immediately argument is specified as true for this request. Valid values: db.t1.micro | db.m1.small | db.m1.medium | db.m1.large | db.m1.xlarge | db.m2.xlarge |db.m2.2xlarge | db.m2.4xlarge -db_parameter_group_name 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 -apply_immediately argument is set to true for this request. Default: Existing setting. Constraints: * Must be 1 to 255 alphanumeric characters * First character must be a letter. * Cannot end with a hyphen or contain two consecutive hyphens -db_security_groups An arrayref of DB Security Groups to authorize on this DB Instance. Changing this parameter does not result in an outage and the change is asynchronously applied as soon as possible. -engine_version 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 -apply_immediately parameter is set to true for this request. For major version upgrades, if a nondefault DB Parameter Group is currently in use, a new DB Parameter Group in the DB Parameter Group Family for the new engine version must be specified. The new DB Parameter Group can be the default for that DB Parameter Group Family. -iops The new Provisioned IOPS (I/O operations per second) value for the RDS instance. Changing this parameter does not result in an outage and the change is applied during the next maintenance window unless the -apply_immediately argument is set to true for this request. Default: Existing setting. Constraints: * Value supplied must be at least 10% greater than the current value. Values that are not at least 10% greater than the existing value are rounded up so that they are 10% greater than the current value. -master_user_password The new password for the master database user. Can be any printable ASCII character except "/", "\", or "@". Changing this parameter does not result in an outage and the change is asynchronously applied as soon as possible. Between the time of the request and the completion of the request, the MasterUserPassword element exists in the PendingModifiedValues element of the operation response. Constraints: * MySQL: Must contain from 8 to 41 alphanumeric characters. * Oracle: Must contain from 8 to 30 alphanumeric characters. * SQL Server: Must contain from 8 to 128 alphanumeric characters. -multi_az 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 -apply_immediately argument is set to true for this request. (Boolean) Constraints: * Cannot be specified if the DB Instance is a read replica. -new_db_instance_identifier The new DB Instance identifier for the DB Instance when renaming a DB Instance. This value is stored as a lowercase string. Constraints: * Must contain from 1 to 63 alphanumeric characters or hyphens (1 to 15 for SQL Server). * First character must be a letter. * Cannot end with a hyphen or contain two consecutive hyphens. -option_group_name 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 -apply_immediately argument 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. Note that persistent options, such as the TDE_SQLServer option for Microsoft SQL Server, cannot be removed from an option group while DB instances are associated with the option group. Permanent options, such as the TDE option for Oracle Advanced Security TDE, cannot be removed from an option group, and that option group cannot be removed from a DB instance once it is associated with a DB instance. -preferred_backup_window The daily time range during which automated backups are created if automated backups are enabled using the -backup_retention_period argument. Default: Default: A 30-minute window selected at random from an 8-hour block of time per region. The following list shows the time blocks for each region from which the default backup windows are assigned. * US-East (Northern Virginia) Region: 03:00-11:00 UTC * US-West (N. California, Oregon) Region: 06:00-14:00 UTC * EU (Ireland) Region: 22:00-06:00 UTC * Asia Pacific (Singapore) Region: 14:00-22:00 UTC * Asia Pacific (Tokyo) Region: 17:00-03:00 UTC Constraints: * Must be in the format hh24:mi-hh24:mi * Times in Universal Time Coordinated (UTC). * Must not conflict with the preferred maintenance window. * Must be at least 30 minutes. -preferred_maintenance_window The weekly time range (in UTC) during which system maintenance can occur. Format: ddd:hh24:mi-ddd:hh24:mi Default: A 30-minute window selected at random from an 8-hour block of time per region, occurring on a random day of the week. The following list shows the time blocks for each region from which the default maintenance windows are assigned. * US-East (Northern Virginia) Region: 03:00-11:00 UTC * US-West (N. California, Oregon) Region: 06:00-14:00 UTC * EU (Ireland) Region: 22:00-06:00 UTC * Asia Pacific (Singapore) Region: 14:00-22:00 UTC * Asia Pacific (Tokyo) Region: 17:00-03:00 UTC Valid Days: Mon, Tue, Wed, Thu, Fri, Sat, Sun Constraints: Minimum 30-minute window. -vpc_security_group_ids A list of EC2 VPC Security Groups to associate with this DB Instance. This change is asynchronously applied as soon as possible.
This method returns a VM::EC2::DB:Instance object.
Modifies the parameters of a DB Parameter Group.
Note: The 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.
Required arguments:
-db_parameter_group_name The name of the DB Parameter Group. Constraints: * Must be the name of an existing DB Parameter Group * Must be 1 to 255 alphanumeric characters * First character must be a letter * Cannot end with a hyphen or contain two consecutive hyphens -parameters An arrayref of hashes containing 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. The hash keys must be: ParameterName, ParameterValue, ApplyMethod ie: [ { ParameterName => 'db_block_checking', ParameterValue => 'FULL', ApplyMethod => 'immediate' } ] -name Alias for -db_parameter_group_name
Returns the DB Parameter Group name on success.
Modifies an existing DB subnet group. DB subnet groups must contain at least one subnet in at least two AZs in the region.
Required arguments:
-db_subnet_group_name The name for the DB Subnet Group. -subnet_ids An arrayref of EC2 Subnet IDs for the DB Subnet Group.
Optional arguments:
-db_subnet_group_description The description for the DB Subnet Group.
Returns VM::EC2::DB::Subnet::Group object on success.
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 add_source_identifier_to_subscription() and remove_source_identifier_from_subscription() calls.
Required arguments:
-subscription_name The name of the RDS event notification subscription.
Optional arguments:
-enabled Boolean value; set to true to activate the subscription. -event_categories An arrayref of event categories for a -source_type to subscribe to. A list of the categories for a given -source_type can be seen in the Events topic in the Amazon RDS User Guide or by using the describe_event_categories() call. -sns_topic_arn The Amazon Resource Name (ARN) of the SNS topic created for event notification. The ARN is created by Amazon SNS when a topic is created and subscribed to. -source_type The type of source that will be generating the events. For example, to be notified of events generated by a DB instance, set this parameter to db-instance. if this value is not specified, all events are returned. Valid values: db-instance | db-parameter-group | db-security-group | db-snapshot
Returns a VM::EC2::DB::Event::Subscription object on success.
Modifies an existing Option Group.
Required arguments:
-option_group_name The name of the option group to be modified.
Optional arguments:
-apply_immediately Indicates whether the changes should be applied immediately, or during the next maintenance window for each instance associated with the Option Group. (Boolean) -options_to_include An arrayref of hashes containing OptionName and other available options. Available options are: DBSecurityGroupMemberships, OptionName, OptionSettings, Port, VpcSecurityGroupMemberships OptionName and Port must be provided as scalars. DBSecurityGroupMemberships, VpcSecurityGroupMemberships must be provided as arrayrefs. OptionSettings must be a hashref of Name => Value pairs. ie: [ { OptionName => 'OEM', DBSecurityGroupMemberships => [ 'mygroup' ], Port => 1158 }, { OptionName => 'NATIVE_NETWORK_ENCRYPTION', OptionSettings => { 'SQLNET.ENCRYPTION_SERVER' => 'REQUIRED', 'SQLNET.CRYPTO_CHECKSUM_SERVER' => 'REQUIRED' } } ] -options_to_remove A string or arrayref containing the containing the option(s) to remove. ie: [ 'OEM', 'NATIVE_NETWORK_ENCRYPTION' ] or 'OEM'
Returns a VM::EC2::DB::Option::Group object on success.
Promotes a Read Replica DB Instance to a standalone DB Instance.
Required arguments:
-db_instance_identifier The DB Instance identifier. This value is stored as a lowercase string. Constraints: * Must be the identifier for an existing Read Replica DB Instance * Must contain from 1 to 63 alphanumeric characters or hyphens * First character must be a letter * Cannot end with a hyphen or contain two consecutive hyphens
Optional arguments:
-backup_retention_period The daily time range during which automated backups are created if automated backups are enabled. -preferred_backup_window The daily time range during which automated backups are created if automated backups are enabled using the -backup_retention_period argument. Default: Default: A 30-minute window selected at random from an 8-hour block of time per region. The following list shows the time blocks for each region from which the default backup windows are assigned. * US-East (Northern Virginia) Region: 03:00-11:00 UTC * US-West (N. California, Oregon) Region: 06:00-14:00 UTC * EU (Ireland) Region: 22:00-06:00 UTC * Asia Pacific (Singapore) Region: 14:00-22:00 UTC * Asia Pacific (Tokyo) Region: 17:00-03:00 UTC Constraints: * Must be in the format hh24:mi-hh24:mi * Times in Universal Time Coordinated (UTC). * Must not conflict with the preferred maintenance window. * Must be at least 30 minutes.
Returns a VM::EC2::DB::Instance object on success.
Purchases a reserved DB Instance offering.
Required arguments:
-reserved_db_instances_offering_id The ID of the Reserved DB Instance offering to purchase. ie: 438012d3-4052-4cc7-b2e3-8d3372e0e706
Optional arguments:
-db_instance_count The number of instances to reserve. Default: 1 -reserved_db_instance_id Customer-specified identifier to track this reservation. ie: myreservationID
Returns a VM::EC2::DB::Reserved::Instance object on success.
Reboots a previously provisioned RDS instance. This API results in the application of modified DBParameterGroup parameters with ApplyStatus of pending-reboot to the RDS instance. This action is taken as soon as possible, and results in a momentary outage to the RDS instance during which the RDS 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. A DBInstance event is created when the reboot is completed.
Required arguments:
-db_instance_identifier The DB Instance identifier.
Optional arguments:
-force_failover When true, the reboot will be conducted through a MultiAZ failover. Constraints: * You cannot specify true if the instance is not configured for MultiAZ.
Returns a VM::EC2::DB::Instance object on success.
Removes a source identifier from an existing RDS event notification subscription.
Required arguments:
-source_identifier The source identifier to be removed from the subscription, such as the DB instance identifier for a DB instance or the name of a security group. -subscription_name The name of the RDS event notification subscription to remove a source identifier from.
Returns a VM::EC2::DB::Event::Subscription object on success.
Remove metadata tags from a resource.
Required arguments:
-resource_name The Amazon RDS resource the tags will be removed from. This value is an Amazon Resource Name (ARN). For information about creating an ARN, see Constructing an RDS Amazon Resource Name (ARN) at: http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_Tagging.html#USER_Tagging.ARN -tags hashref or arrayref of hashrefs containing tag Key/Value pairs
This method does not return a value but will raise an error if unsuccessful.
Modifies the parameters of a DB parameter group to the engine/system default value. To reset specific parameters, submit a hashref of the following: ParameterName and ApplyMethod. To reset the entire DB parameter group, set the -reset_all_parameters argument to true. 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 after issuing a reboot_db_instance().
Required arguments:
-db_parameter_group_name The name of the DB Parameter Group. Constraints: * Must be the name of an existing DB Parameter Group * Must be 1 to 255 alphanumeric characters * First character must be a letter * Cannot end with a hyphen or contain two consecutive hyphens
Conditional arguments:
-parameters An arrayref of hashes containing parameter names and the apply method for the parameter update. The hash keys must be: ParameterName and ApplyMethod ie: [ { ParameterName => 'max_user_connections', ApplyMethod => 'pending-reboot' }, { ParameterName => 'max_allowed_packet', ApplyMethod => 'immediate' } ] -reset_all_parameters Reset all parameters in the DB parameter group to default values. Boolean, default is true.
Returns the name of the DB parameter group.
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 in the default security group.
Required arguments:
-db_instance_identifier The DB Instance identifier. Constraints: * Must contain from 1 to 63 alphanumeric characters or hyphens (1 to 15 for SQL Server). * First character must be a letter. * Cannot end with a hyphen or contain two consecutive hyphens. -db_snapshot_identifier The identifier for the DB snapshot. Constraints: * Must contain 1 to 255 alphanumeric characters or hyphens * First character must be a letter * Cannot end with a hyphen or contain two consecutive hyphens
Optional arguments:
-auto_minor_version_upgrade Indicates that minor engine upgrades will be applied automatically to the DB Instance during the maintenance window. (Boolean). Default: true -availability_zone The EC2 Availability Zone that the database instance will be created in. Default: A random, system-chosen Availability Zone in the endpoint's region. Constraint: Cannot specify if -multi_az is true -db_instance_class The compute and memory capacity of the DB Instance. db.t1.micro | db.m1.small | db.m1.medium | db.m1.large | db.m1.xlarge | db.m2.xlarge |db.m2.2xlarge | db.m2.4xlarge -db_name The database name for the restored DB instance. NOTE: Does not apply to MySQL engine. -db_subnet_group_name A DB Subnet Group to associate with this DB Instance. If not specified, then it is a non-VPC DB instance. -engine The name of the database engine to be used for this instance. Default is that of source. Valid values: MySQL | oracle-se1 | oracle-se | oracle-ee | sqlserver-ee | sqlserver-se | sqlserver-ex | sqlserver-web -iops The amount of Provisioned IOPS initially allocated. Must be an integer greater than 1000 -license_model License model information for this DB Instance. Valid values: license-included | bring-your-own-license | general-public-license -multi_az Specifies if the DB Instance is a Multi-AZ deployment. You cannot set the -availability_zone argument if the -multi_az argument is set to true. -option_group_name Indicates that the DB Instance should be associated with the specified option group. -port The port number on which the database accepts connections. MySQL: * Default: 3306, Valid values: 1150-65535 Oracle: * Default: 1521, Valid values: 1150-65535 Oracle: * Default: 1433, Valid values: 1150-65535 except 1434 and 3389. -publicly_accessible 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. Default: The default behavior varies depending on whether a VPC has been requested or not. The following list shows the default behavior in each case. * DefaultVPC:true * VPC:false If no DB subnet group has been specified as part of the request and the -publicly_accessible value has not been set, the DB instance will be publicly accessible. If a specific DB subnet group has been specified as part of the request and the PubliclyAccessible value has not been set, the DB instance will be private. -tags hashref or arrayref of hashrefs containing Key/Value pairs
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.
Required arguments:
-source_db_instance_identifier The identifier of the source DB instance from which to restore. Constraints: Must be the identifier of an existing DB Instance -target_db_instance_identifier The name of the new database instance to be created. Constraints: * Must contain from 1 to 63 alphanumeric characters or hyphens * First character must be a letter * Cannot end with a hyphen or contain two consecutive hyphens
Optional arguments:
-auto_minor_version_upgrade Indicates that minor engine upgrades will be applied automatically to the DB Instance during the maintenance window. (Boolean). Default: true -availability_zone The EC2 Availability Zone that the database instance will be created in. Default: A random, system-chosen Availability Zone in the endpoint's region. Constraint: Cannot specify if -multi_az is true -db_instance_class The compute and memory capacity of the DB Instance. db.t1.micro | db.m1.small | db.m1.medium | db.m1.large | db.m1.xlarge | db.m2.xlarge |db.m2.2xlarge | db.m2.4xlarge -db_name The database name for the restored DB instance. NOTE: Does not apply to MySQL engine. -db_subnet_group_name A DB Subnet Group to associate with this DB Instance. If not specified, then it is a non-VPC DB instance. -engine The name of the database engine to be used for this instance. Default is that of source. Valid values: MySQL | oracle-se1 | oracle-se | oracle-ee | sqlserver-ee | sqlserver-se | sqlserver-ex | sqlserver-web -iops The amount of Provisioned IOPS initially allocated. Must be an integer greater than 1000 -license_model License model information for this DB Instance. Valid values: license-included | bring-your-own-license | general-public-license -multi_az Specifies if the DB Instance is a Multi-AZ deployment. You cannot set the -availability_zone argument if the -multi_az argument is set to true. -option_group_name Indicates that the DB Instance should be associated with the specified option group. -port The port number on which the database accepts connections. MySQL: * Default: 3306, Valid values: 1150-65535 Oracle: * Default: 1521, Valid values: 1150-65535 Oracle: * Default: 1433, Valid values: 1150-65535 except 1434 and 3389. -publicly_accessible 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. Default: The default behavior varies depending on whether a VPC has been requested or not. The following list shows the default behavior in each case. * DefaultVPC:true * VPC:false If no DB subnet group has been specified as part of the request and the -publicly_accessible value has not been set, the DB instance will be publicly accessible. If a specific DB subnet group has been specified as part of the request and the PubliclyAccessible value has not been set, the DB instance will be private. -restore_time The date and time to restore from. Valid Values: Value must be a UTC time Constraints: * Must be prior the latest restorable time for the DB instance * Cannot be specified if -use_latest_restorable_time parameter is true Example: 2009-09-07T23:45:00Z -tags hashref or arrayref of hashrefs containing Key/Value pairs -use_latest_restorable_time Specifies if the DB instance is restored from the latest backup time. Boolean, default is false. Constraints: Cannot be specified if -restore_time parameter is provided.
Revokes ingress from a DBSecurityGroup for previously authorized IP ranges or EC2 or VPC Security Groups.
Required arguments:
-db_security_group_name The name of the DB Security Group to revoke authorization from.
Optional arguments:
-cidrip The IP range to revoke. Must be a valid CIDR range. Security group parameters cannot be specified if -cidrip is specified. -ec2_security_group_id ID of the EC2 Security Group to revoke access from. For VPC DB security groups, this must be provided. -ec2_security_group_name Name of the EC2 Security Group to revoke access from. -ec2_security_group_owner_id AWS Account Number of the owner of the EC2 Security Group specified in the -ec2_security_group_name parameter.
Returns a VM::EC2::DB::SecurityGroup object.
Lance Kinley <lkinley@loyaltymethods.com<gt>.
Copyright (c) 2013 Loyalty Methods, Inc.
This package and its accompanying libraries is free software; you can redistribute it and/or modify it under the terms of the GPL (either version 1, or at your option, any later version) or the Artistic License 2.0. Refer to LICENSE for the full license text. In addition, please see DISCLAIMER.txt for disclaimers of warranty.
2016-06-04 | perl v5.22.2 |