How to terraform a read replica in a different region?

[Romano Aquino]

I'm able to use the following to create an RDS instance and a read replica in the same region, but how would I create a read replica in a different region? The AWS Console has this ability, but I don't see how to create this using Terraform:

resource "aws_db_instance" "default" {

  identifier = "${var.identifier}"

  allocated_storage = "${var.storage}"

  engine = "${var.engine}"

  engine_version = "${lookup(var.engine_version, var.engine)}"

  instance_class = "${var.instance_class}"

  name = "${var.db_name}"

  username = "${var.username}"

  password = "${var.password}"

  vpc_security_group_ids = ["${aws_security_group.default.id}"]

  db_subnet_group_name = "${aws_db_subnet_group.default.id}"

  backup_retention_period = "1"

}

resource "aws_db_instance" "default_replica1" {

  identifier = "replica1"

  replicate_source_db = "${aws_db_instance.default.identifier}"

  availability_zone = "ap-northeast-1a"

  allocated_storage = "${var.storage}"

  engine = "${var.engine}"

  engine_version = "${lookup(var.engine_version, var.engine)}"

  instance_class = "${var.instance_class}"

  name = "${var.db_name}"

  username = "${var.username}"

  password = "${var.password}"

  vpc_security_group_ids = ["${aws_security_group.default.id}"]

  db_subnet_group_name = "${aws_db_subnet_group.default.id}"

[Clint Shryock]

Hello Romano –

Can you clarify about the different region, via the console? I just attempted this and was only able to chose a different availability zone in the same region. If by chance you meant that, then you can specify the `availability_zone` in the replica, but I don't see a means of doing a separate region. 

Regards,

Clint

--
This mailing list is governed under the HashiCorp Community Guidelines - https://www.hashicorp.com/community-guidelines.html. Behavior in violation of those guidelines may result in your removal from this mailing list.
 
GitHub Issues: https://github.com/hashicorp/terraform/issues
IRC: #terraform-tool on Freenode
---
You received this message because you are subscribed to the Google Groups "Terraform" group.
To unsubscribe from this group and stop receiving emails from it, send an email to terraform-too...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/terraform-tool/e465d098-fef1-4a3f-a019-20ffb3ef3b05%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Clint

[Romano Aquino]

Hi Clint,

I was referring to this:

https://aws.amazon.com/blogs/aws/cross-region-read-replicas-for-amazon-rds-for-mysql/

In the AWS Management Console, you can set a read replica in a different region, I was wondering if Terraform had this ability as well.

[Clint Shryock]

Hey Romano – 

It turns out that due to a bug in Terraform you can't do this yet:

- https://github.com/hashicorp/terraform/issues/4192

I have an idea for the patch though, and I'll try to get to it shortly :)

Thanks!

Clint

To view this discussion on the web visit https://groups.google.com/d/msgid/terraform-tool/e0ac29a3-10bb-42c0-b178-b149bec935a4%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--

Clint

[Clint Shryock]

Hello –

I just merged https://github.com/hashicorp/terraform/pull/4215 , which allows you to create a read replica in another region. It will go out in the next release, or you could build Terraform from the master branch.

You must use the Primary database's ARN as the `replicate_source_db` (not just the name/id).

Thanks!

Clint

--

Clint

[Dharmendra Kumar]

Hello Romano,

Could you please share the code for creating oracle rds instance. that will be an great help for me.

Thanks,

Dharmendra

[chengkai liang]

If you read the terraform document - aws_db_instance, you will find that the attribute, availability_zone - (Optional) The AZ for the RDS instance, will allow you to set shard zone ...

--

This mailing list is governed under the HashiCorp Community Guidelines - https://www.hashicorp.com/community-guidelines.html. Behavior in violation of those guidelines may result in your removal from this mailing list.
 
GitHub Issues: https://github.com/hashicorp/terraform/issues
IRC: #terraform-tool on Freenode
---
You received this message because you are subscribed to the Google Groups "Terraform" group.
To unsubscribe from this group and stop receiving emails from it, send an email to terraform-too...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/terraform-tool/ac9f7fe3-b800-4af0-aa8b-7a0fd4fe49a3%40googlegroups.com.