How AWS allocate subnet/IP to RDS Oracle Server

0

Hi,

When I create an RDS, if I did not select a subnet group and use default AWS seems to associate the RDS with all the subnets in the VPC.

Does this mean that AWS can select any of the subnets to place the RDS oracle server and assign it an IP from the subnet IP assigned range?

Does AWS keep the RDS into the same subnet forever or it can change the subnet and IP to another subnet in the VPC after reboot?

I am trying to open up firewall rules to access the RDs listener port and see if it has to be for all subnets IP ranges or just one subnet.

2 回答
1
已接受的回答

According to https://repost.aws/knowledge-center/rds-ip-address-issues you can't guarantee that the IP address will never change.

Because the IP address of your instance is dynamic, you can't assign a static IP address or an Elastic IP address to your instance.

If you want a static IP for your firewall rules you can put a load balancer in front of the RDS instance, as described in https://aws.amazon.com/blogs/database/how-to-use-amazon-rds-and-amazon-aurora-with-a-static-ip-address/

profile picture
专家
Steve_M
已回答 1 年前
profile picture
专家
已审核 1 年前
profile picture
专家
已审核 1 年前
  • Exellent Information! However, still not clear on this When you create the RDS, does AWS select randomly any of the default subnets created in the VPC and place the RDS in that subnet? Also, if you reboot or restart the RDS does it keep the RDS always in that same SUBNET that was associated with it when it created it or it can change the subnet?

1

selection of RDS DB subnet group will remain as long as you change the subnet through back and restore. AWS doesnt change your subnet in any circumstances.

As mentioned above, your IP address may change, hence is recommended to use the Endpoint name in your configuration while connecting to RDS instances.

已回答 1 年前
  • The firewall group cannot use Endpoints and need an IP range for destination. When they created the RDS there was no subnet group selection, they used the default VPC subnets and that is why there are 12 subnets associated with RDS. However, I think AWS selects one of those and plaec the RDS in it. This is what I am trying to find out. Does it stay in that subnet forever so I can use that specific subnet IP range or not? If I look at the RDS configuration now, I see a lot of subnets listed. I am trying to find out which specific subnet so i can capture the IP range and send it to firewall group.

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则