Amazon Web Services (AWS) offers MySQL Server via the Relational Database Service (RDS) offering. Unfortunately, AWS doesn’t allow ICMP Ping to reach the nodes, so as configured by default, Nagios will fail on the host check. The solution is to submit a Passive Check for that host. Login to the Nagios web console Click on […]
Recently, I had a client site outage. AWS had a major EBS failure on Zone B, and one of the instances never recovered. One of the major issues was the inability to connect to the RDS service:
1
2
3
# mysql -h yourDB.yourRDS.us-east-1.rds.amazonaws.com -u meyadmin -p
Enter password:
ERROR1129(00000):Host'ip-X-X-X-X.ec2.internal'isblocked because of many connection errors;unblock with'mysqladmin flush-hosts'
It turns out two steps were required for resolution: 1. Reboot the instance to get network access […]