I recently installed 2 instances of mysql on the same server, using port 3307 for the second server, the normal 3306 for the first server. I found that while logged onto that box I could communicate to the 3307 instances using the socket parameter. Using the port parameter (--port=3307) by itself didn't work.
I am now trying to set up master-to-master replication on that machine, where the 2 masters are the 2 instances running on that machine (sounds a little flaky, but it's for a dev box and it ought to work). It's not working and I'm wondering if it's because I can't specify the socket the 3306 master needs to connect to on the 3307 master. In the "change master to" command I can only specify the port. I did specify it as 3307 but the "slave" can't connect. Has anyone done this? -- Jim Lyons Web developer / Database administrator http://www.weblyons.com
