AWS RDS MySQL remote connection extremely slow
- by nute
I have a site hosted on AWS EC2 (Elastic Beanstalk), with a MySQL database hosted on AWS RDS. Everything works fine on the production server, fast and all.
However when I try to connect remotely from my local machine, it sometimes gets extremely slow (like 4 minutes to load the list of tables), or simply times out.
I added my IP in the security group (which I did correctly, since it sometimes works).
When it doesn't work, I at the same time check the prod server and it still looks good.