MySQL Forums
Forum List  »  Perl

Re: use different socket file to connect with one dataBase
Posted by: Rick James
Date: November 03, 2010 03:10PM

Some rules about having multiple MySQL instances on a single box...

* Each MySQL must have a different IP or a different port. (IP may be possible with Virtual Machines.) (Port=3306 is the default.)

* You must not have the different instances point to the same directories/data files.

* Connect via IP (or hostname), not socket.

* An instance of MySQL will build a socket file (normally in /tmp, but configurable in my.cnf); be sure they are not the same file.

* When configuring cache sizes, remember that each instance cannot have all of RAM.

Options: ReplyQuote


Subject
Written By
Posted
Re: use different socket file to connect with one dataBase
November 03, 2010 03:10PM


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.