Question

What is the cause of Failed to create instance: Standalone DB Instances are not supported for Amazon RDS Aurora? Run the ansible script to create RDS Aurora but getting the error.

Ansible Script (Role)

- rds:     region:          "{{ ec2_region }}"     zone:             "{{ ec2_zone }}"     command: create     instance_name: new-database     db_engine: "aurora"     size: 20     instance_type: db.t2.small     username: admin     password: 1nsecure 

Error Message

fatal: [localhost]: FAILED! => {     "changed": false,     "failed": true,     "invocation": {         "module_args": {             "apply_immediately": false,             "aws_access_key": null,             "aws_secret_key": null,             "backup_retention": null,             "backup_window": null,             "character_set_name": null,             "command": "create",             "db_engine": "aurora",             "db_name": null,             "ec2_url": null,             "engine_version": null,             "force_failover": false,             "instance_name": "new-database",             "instance_type": "db.t2.small",             "iops": null,             "license_model": null,             "maint_window": null,             "multi_zone": null,             "new_instance_name": null,             "option_group": null,             "parameter_group": null,             "password": "VALUE_SPECIFIED_IN_NO_LOG_PARAMETER",             "port": 3306,             "profile": null,             "publicly_accessible": null,             "region": "ap-southeast-2",             "security_groups": null,             "security_token": null,             "size": "20",             "snapshot": null,             "source_instance": null,             "subnet": null,             "tags": null,             "upgrade": false,             "username": "mysql_admin",             "validate_certs": true,             "vpc_security_groups": null,             "wait": false,             "wait_timeout": 300,             "zone": "ap-southeast-2a"         }     },     "msg": "Failed to create instance: Standalone DB Instances are not supported for the specified engine" } 

Research

Add RDS support for dbengine Aurora #3180 tells below but not sure how to add the cluster in RDS Ansible.

fatal: [localhost]: FAILED! => {“changed”: false, “failed”: true, “msg”: “Failed to create instance: Standalone DB Instances are not supported for the specified engine”}

It’s because you need to have an Aurora cluster created before you try and create the Aurora instance and you must pass the cluster name as one of the arguments when calling the create_db_instance API action.