Binding MySQL to run from the public or private LAN IP address - which one is faster
Posted
by
Lamin Barrow
on Server Fault
See other posts from Server Fault
or by Lamin Barrow
Published on 2012-10-14T07:53:39Z
Indexed on
2012/10/14
9:40 UTC
Read the original article
Hit count: 197
So we have 2 servers all running at the same web host. We have bind MySQL to listen on the public ip-address of the database server and the web server connects to it from the public ip. Both servers run on the same private network.
Currently, the DB connect method from our php script takes about 3ms to connect to the MySQL database server host.
My question is, would MySql data interaction from the web server be faster if we bind it to listen on the private lan address on the database server instead of the public IP? or is it the same regardless and it wont make a different.
© Server Fault or respective owner