Resolving common errors
Some issues on RDS are seen more frequently than others. We are going to learn some of the most common errors and how to resolve them. Firstly, we will learn how to deal with connectivity issues with an RDS instance.
RDS connection issues
Typically, connection errors are caused by one of five areas, as outlined here:
- Security group rules—Review your security groups to make sure the inbound rules allow connections from the source on the port the database is running on.
- NACL rules—Review your NACLs to ensure that inbound or outbound traffic to/from the database has not been set to
DENY
. - Publicly available not set—To access the RDS instance from outside of your VPC, you need to have made it publicly available and given it a public Internet Protocol (IP) address. You can change this by modifying the instance.
- Internet gateway—To access the RDS instance, you need an internet gateway within the public subnets of...