MySQL Forums
Forum List  »  Install & Repo

MySQL Instance Bind IP vs Port
Posted by: Kevin Riley
Date: October 07, 2015 10:51AM

I have inherited a number of MySQL installations which are configured with bound IP addresses to allow multiple instances to exist on an individual Linux server. I would have expected to use different ports rather than IPs to achieve the same result.

Is there a benefit to using the bind-address method of installing multiple MySQL instances on a single server, and is this ever a best practice? Would the preferred method be to assign unique port numbers to each instance, and allow them all to respond to the default IP address for the server? Are there any configuration or use-case considerations that might favor the multiple IP address configuration?

Thank you for any information you can provide.

Options: ReplyQuote


Subject
Written By
Posted
MySQL Instance Bind IP vs Port
October 07, 2015 10:51AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.