How to do it...

We will be using the RDS module to create an RDS instance. We will be creating a MySQL database instance in our task:

- name: Create RDS Instance 
  rds: 
      aws_access_key: "{{ access_key }}" 
      aws_secret_key: "{{ secret_key }}" 
      region: "{{ aws_region }}" 
      command: create 
      instance_name: my-first-rds-instance 
      db_engine: MySQL 
      size: 10 
      instance_type: db1.m1.small 
      username: cookbook-admin 
      password: koobkooc 
      security_groups: "{{ my_first_sg.group_id }}" 
      multi_zone: yes 
      backup_retention: 7 
      tags: 
          Enviornment: cookbook-prod 
          Application: cookbook-test 
   tags: 
     - recipe1