MySQL Error : Socket In Use
Posted on 2011-03-22
I have a Windows Server 2008R2 box running in the cloud (on Amazon EC2) with IIS enabled. Our datastore is a MySQL box (hosted on Amazon RDS) on the same region/local network as my web server.
Despite both the web server and mysql box being on the same network, I am getting occasional socket error messages during peak use (when in reality, the peak use isn't that significant at all). I'm looking to find out how to resolve this:
Server was unable to process your request. --> Can't connect to MySQL server on 'hostname' (10061): Only one usage of each socket address (protocol/network/address/port) is normally permitted 10.76.249.164:3306 --> Only one usage of each socket address (protocol/network/address/port is normally permitted)
As a web server, there will be many concurrent connections to the mysql server. Why am I getting errors about the socket address already being in use. How do I gracefully handle this situation?