By using AWS re:Post, you agree to the Terms of Use

Debugging DNS lookup of MariaDB instance.

0

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: Enter image description here

I tried to reboot the DB.

Is there something else I should try?

1 Answers
0

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

SUPPORT ENGINEER
answered 9 days ago
  • 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.

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions