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.
Subject
Written By
Posted
November 02, 2010 11:19AM
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.