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
相关内容
AWS 官方已更新 2 年前- AWS 官方已更新 2 年前
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.