We are changing the network and the IP addresses will be changing. Will there be any impact to MySQL running on the server?

I don't use the IP address to reference the server. Instead I use the server name.

For example:

Server IP MYPROD01 -> becomes ->


When you use the server name (DNS name) then a change of IP address will be used by your clients as soon as all DNS servers have this new address. Since you change your subnet you must be able to 'reach' this subnet from your clients. The only 'problem' can be that you loose the open connections.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.