AWS RDS Instances
DB%20Instances.png

Setting up AWS RDS Instance

This describes a PostGres Instance, but a MySQL instance is similar.

Private Instance

EC2 instances running within AWS and sitting on the same VPC only need to align the private IP and port.

Public instance

There are a few ways to make the instance available outside of AWS. For an instance without live data, I'm trying to expose port 5432 directly on a public IP. An alternative is to use a Bastion host as described here: https://aws.amazon.com/premiumsupport/knowledge-center/rds-connect-ec2-bastion-host/

To make the instance visible with a public IP,

  1. modify the instance
  2. under the Connectivity section, expand the "Advanced" button

Security Group

- There will be a default security group. I've added a new `PostGres` group that has a single inbound rule allowing traffic on port 5432 from my IP address alone.

Notes

- To modify an instance, it must be active.

Connecting to AWS RDS Instance

  • PostGres instance is being tested using PGAdmin and then verified using the WildFly console.
  • MySQL instance is setup and tested using `mysql` client and then verified using the WildFly console.
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License