AWS RDS
- RDS (Relational Database Service) is managed Relational Database offering from AWS and it natively supports
- mySQL
- Postgres
- Microsoft SQL Server
- Oracle
- AWS has a default vpc in every region with one subnet per AZ.
- DB subnet group is group (atleast 2) subnets where AWS will be creating rds database instace
- AWS RDS has a default DB subnet group
- Every DB Instance has two options
- publically accessible (internet facing)
- internally accessible (available with in vpc)
- Around Every Database instace we can protect it by Security group which will have allow rules around ip,protocol and port
- Overview of the discussion
Lets create our first free tier eligible mysql rds instance
- Navigate to RDS and follow the below screens
- Lets figure out endpoint info and security group
- Lets add a rule to allow access from any ip address
-
Now lets connect to the database (Follow instructions as discussed)
-
Clean up
