We help IT Professionals succeed at work.
Get Started

Installing multiple MySQL servers on the same machine using bind address

Umesh
Umesh asked
on
989 Views
Last Modified: 2012-05-06
There is one MySQL server running on standard port of 3306 on a machine. I'm trying to add another instance using a new bind-address but same port of 3306. This first instance is running via mysqld_safe (not via using mysqld_multi since there was only one instance initailly).

Now, trying to start the second instance using mysqld_multi with a newly created IP (or the network interface). So the server now has 2 IPs that resolve properly to different domains (that part is does not seem to be an issue).

Getting this error message when I start the second instance on 3306.

[ERROR] Can't start server: Bind on TCP/IP port: Address already in use
[ERROR] Do you already have another mysqld server running on port: 3306 ?
[ERROR] Aborting

However, I'm able to start the second instance using another port - 3307.  But the idea is to use the same port of 3306 for multiple instances.

Is there any issue having combination of servers running (one using mysqld_safe and other mysqld_multi)?  Is there a need to convert the first instance also using mysqld_multi to get this to work (since the first instance was being used by customers, I didn't get a chance to restart it).

Thanks.
Comment
Watch Question
Top Expert 2008
Commented:
This problem has been solved!
Unlock 1 Answer and 4 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE