Debugging DNS lookup of MariaDB instance.
Hi. My serverless instance in AWS can reach my MariaDB database (RDS) and things work fine but things don't work if I try to connect from my local computer. The problem appears and disappears randomly, It works some days and it doesn't work on other days.
Here is the result of ping to MYDB.eu-west-1.rds.amazonaws.com
PING MYDB.eu-west-1.compute.amazonaws.com (52.209.116.0) 56(84) bytes of data.
---MYDB.eu-west-1.compute.amazonaws.com ping statistics ---
13 packets transmitted, 0 received, 100% packet loss, time 12448ms
Here is what it looks like if I connect with PMA in a docker container:
I tried to reboot the DB.
Is there something else I should try?
- 新しい順
- 投票が多い順
- コメントが多い順
How many connections per second are being made from the EC2 instance to the RDS instance? You may be running into a DNS quota issue where the single EC2 instance is sending too many packets too quickly to resolve the RDS DNS entry.
Info about this: https://docs.aws.amazon.com/vpc/latest/userguide/vpc-dns.html#vpc-dns-limits
Thank you for your answer. The number of connections is very close to zero at the moment.
Things are working again today but I assume I will run into the DNS issue again some day.