doufeng1249 2012-06-14 12:18
浏览 96
已采纳

PHP无法连接到RDS上的MySQL

Recently few days I run into a weird problem of php not able to connect to mysql on RDS, while manual connections are fine.

So I have several php scripts sitting on our server which is hosted on EC2, and these scripts are called by the clients to communicate with a mysql server sitting on RDS. The scripts are setup so that if any connection error occurs, they would send email notification to me.

So for the recent few days I'm receiving thousands of error emails from my scripts, at the first few days the errors were simple saying the server host is not recognized, but I am sure the address is correct. And now the errors are almost all saying "Host XXX is blocked because of many connection errors, unblock with mysqladmin flush-hosts..." If I flush the hosts, the errors come back to me after a while.

What confuses me the most is that, I cannot reproduce the problem! I tried connecting to the RDS server from my EC2 server through command line and through test php scripts... They all work! If I manually invoke the scripts sending me error emails, they work too! Looking at the RDS monitor, all stat looks normal, CPU is bouncing around 50%, and plenty of hard drive space.

So I'm totally confused right now... Can anyone provide me some insight about how to solve this problem? I don't even know where to look at now...

  • 写回答

1条回答 默认 最新

  • duanbu4962 2012-08-03 04:16
    关注

    you need to check your connection to the mysql server and check for errors. Until then you can cron a "flush hosts" to temporary fix the issue. Be aware that this should be used only as a temporary fix.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
编辑
预览

报告相同问题?

悬赏问题

  • ¥15 PADS Logic 原理图
  • ¥15 PADS Logic 图标
  • ¥15 电脑和power bi环境都是英文如何将日期层次结构转换成英文
  • ¥20 气象站点数据求取中~
  • ¥15 如何获取APP内弹出的网址链接
  • ¥15 wifi 图标不见了 不知道怎么办 上不了网 变成小地球了
手机看
程序员都在用的中文IT技术交流社区

程序员都在用的中文IT技术交流社区

专业的中文 IT 技术社区,与千万技术人共成长

专业的中文 IT 技术社区,与千万技术人共成长

关注【CSDN】视频号,行业资讯、技术分享精彩不断,直播好礼送不停!

关注【CSDN】视频号,行业资讯、技术分享精彩不断,直播好礼送不停!

客服 返回
顶部