AWS RDS Instances
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,
- modify the instance
- 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.
page revision: 9, last edited: 21 Nov 2020 23:02