rds_instance_facts – obtain facts about one or more RDS instances

New in version 2.6.

Synopsis

  • obtain facts about one or more RDS instances

Requirements

The below requirements are needed on the host that executes this module.

  • boto

  • boto3

  • python >= 2.6

  • python >= 2.7

Parameters

Parameter Choices/Defaults Comments
aws_access_key
string
AWS access key. If not set then the value of the AWS_ACCESS_KEY_ID, AWS_ACCESS_KEY or EC2_ACCESS_KEY environment variable is used.

aliases: ec2_access_key, access_key
aws_secret_key
string
AWS secret key. If not set then the value of the AWS_SECRET_ACCESS_KEY, AWS_SECRET_KEY, or EC2_SECRET_KEY environment variable is used.

aliases: ec2_secret_key, secret_key
db_instance_identifier
-
The RDS instance's unique identifier.

aliases: id
debug_botocore_endpoint_logs
boolean
added in 2.8
    Choices:
  • no ←
  • yes
Use a botocore.endpoint logger to parse the unique (rather than total) "resource:action" API calls made during a task, outputing the set to the resource_actions key in the task results. Use the aws_resource_action callback to output to total list made during a playbook. The ANSIBLE_DEBUG_BOTOCORE_LOGS environment variable may also be used.
ec2_url
string
Url to use to connect to EC2 or your Eucalyptus cloud (by default the module will use EC2 endpoints). Ignored for modules where region is required. Must be specified for all other modules if region is not used. If not set then the value of the EC2_URL environment variable, if any, is used.
filters
-
A filter that specifies one or more DB instances to describe. See https://docs.aws.amazon.com/AmazonRDS/latest/APIReference/API_DescribeDBInstances.html
profile
string
Uses a boto profile. Only works with boto >= 2.24.0.
region
string
The AWS region to use. If not specified then the value of the AWS_REGION or EC2_REGION environment variable, if any, is used. See http://docs.aws.amazon.com/general/latest/gr/rande.html#ec2_region

aliases: aws_region, ec2_region
security_token
string
AWS STS security token. If not set then the value of the AWS_SECURITY_TOKEN or EC2_SECURITY_TOKEN environment variable is used.

aliases: access_token
validate_certs
boolean
    Choices:
  • no
  • yes ←
When set to "no", SSL certificates will not be validated for boto versions >= 2.6.0.

Notes

Note

  • If parameters are not set within the module, the following environment variables can be used in decreasing order of precedence AWS_URL or EC2_URL, AWS_ACCESS_KEY_ID or AWS_ACCESS_KEY or EC2_ACCESS_KEY, AWS_SECRET_ACCESS_KEY or AWS_SECRET_KEY or EC2_SECRET_KEY, AWS_SECURITY_TOKEN or EC2_SECURITY_TOKEN, AWS_REGION or EC2_REGION

  • Ansible uses the boto configuration file (typically ~/.boto) if no credentials are provided. See https://boto.readthedocs.io/en/latest/boto_config_tut.html

  • AWS_REGION or EC2_REGION can be typically be used to specify the AWS region, when required, but this can also be configured in the boto config file

Examples

# Get facts about an instance
- rds_instance_facts:
    db_instance_identifier: new-database
  register: new_database_facts

# Get all RDS instances
- rds_instance_facts:

Return Values

Common return values are documented here, the following are the fields unique to this module:

Key Returned Description
instances
complex
always
List of RDS instances

  allocated_storage
integer
always
Gigabytes of storage allocated to the database

Sample:
10
  auto_minor_version_upgrade
boolean
always
Whether minor version upgrades happen automatically

Sample:
True
  availability_zone
string
always
Availability Zone in which the database resides

Sample:
us-west-2b
  backup_retention_period
integer
always
Days for which backups are retained

Sample:
7
  ca_certificate_identifier
string
always
ID for the CA certificate

Sample:
rds-ca-2015
  copy_tags_to_snapshot
boolean
always
Whether DB tags should be copied to the snapshot

  db_instance_arn
string
always
ARN of the database instance

Sample:
arn:aws:rds:us-west-2:111111111111:db:helloworld-rds
  db_instance_class
string
always
Instance class of the database instance

Sample:
db.t2.small
  db_instance_identifier
string
always
Database instance identifier

Sample:
helloworld-rds
  db_instance_port
integer
always
Port used by the database instance

  db_instance_status
string
always
Status of the database instance

Sample:
available
  db_name
string
always
Name of the database

Sample:
management
  db_parameter_groups
complex
always
List of database parameter groups

    db_parameter_group_name
string
always
Name of the database parameter group

Sample:
psql-pg-helloworld
    parameter_apply_status
string
always
Whether the parameter group has been applied

Sample:
in-sync
  db_security_groups
list
always
List of security groups used by the database instance

  db_subnet_group
complex
always
list of subnet groups

    db_subnet_group_description
string
always
Description of the DB subnet group

Sample:
My database subnet group
    db_subnet_group_name
string
always
Name of the database subnet group

Sample:
my-subnet-group
    subnet_group_status
string
always
Subnet group status

Sample:
Complete
    subnets
complex
always
List of subnets in the subnet group

      subnet_availability_zone
complex
always
Availability zone of the subnet

        name
string
always
Name of the availability zone

Sample:
us-west-2c
      subnet_identifier
string
always
Subnet ID

Sample:
subnet-abcd1234
      subnet_status
string
always
Subnet status

Sample:
Active
    vpc_id
string
always
VPC id of the subnet group

Sample:
vpc-abcd1234
  dbi_resource_id
string
always
AWS Region-unique, immutable identifier for the DB instance

Sample:
db-AAAAAAAAAAAAAAAAAAAAAAAAAA
  domain_memberships
list
always
List of domain memberships

  endpoint
complex
always
Database endpoint

    address
string
always
Database endpoint address

Sample:
helloworld-rds.ctrqpe3so1sf.us-west-2.rds.amazonaws.com
    hosted_zone_id
string
always
Route53 hosted zone ID

Sample:
Z1PABCD0000000
    port
integer
always
Database endpoint port

Sample:
5432
  engine
string
always
Database engine

Sample:
postgres
  engine_version
string
always
Database engine version

Sample:
9.5.10
  iam_database_authentication_enabled
boolean
always
Whether database authentication through IAM is enabled

  instance_create_time
string
always
Date and time the instance was created

Sample:
2017-10-10T04:00:07.434000+00:00
  kms_key_id
string
always
KMS Key ID

Sample:
arn:aws:kms:us-west-2:111111111111:key/abcd1234-0000-abcd-1111-0123456789ab
  latest_restorable_time
string
always
Latest time to which a database can be restored with point-in-time restore

Sample:
2018-05-17T00:03:56+00:00
  license_model
string
always
License model

Sample:
postgresql-license
  master_username
string
always
Database master username

Sample:
dbadmin
  monitoring_interval
integer
always
Interval, in seconds, between points when Enhanced Monitoring metrics are collected for the DB instance

  multi_az
boolean
always
Whether Multi-AZ is on

  option_group_memberships
complex
always
List of option groups

    option_group_name
string
always
Option group name

Sample:
default:postgres-9-5
    status
string
always
Status of option group

Sample:
in-sync
  pending_modified_values
complex
always
Modified values pending application

  performance_insights_enabled
boolean
always
Whether performance insights are enabled

  preferred_backup_window
string
always
Preferred backup window

Sample:
04:00-05:00
  preferred_maintenance_window
string
always
Preferred maintenance window

Sample:
mon:05:00-mon:05:30
  publicly_accessible
boolean
always
Whether the DB is publicly accessible

  read_replica_db_instance_identifiers
list
always
List of database instance read replicas

  storage_encrypted
boolean
always
Whether the storage is encrypted

Sample:
True
  storage_type
string
always
Storage type of the Database instance

Sample:
gp2
  tags
complex
always
Tags used by the database instance

  vpc_security_groups
complex
always
List of VPC security groups

    status
string
always
Status of the VPC security group

Sample:
active
    vpc_security_group_id
string
always
VPC Security Group ID

Sample:
sg-abcd1234


Status

Authors

  • Will Thames (@willthames)

  • Michael De La Rue (@mikedlr)

Hint

If you notice any issues in this documentation you can edit this document to improve it.