Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to use mysql-master-ha.

I managed to get it connected with the master and slave mysql servers.

Now I would like to know how to connect to mysql-master-ha from my web application server so that the mysql-master-ha will automatically switch between master and slave. I can give only one IP address to my application server.


share|improve this question
What method are you using to control the virtual IP? – NickW Mar 7 '13 at 10:24
I am planning to Peacemaker over Ubuntu server. Will that help me? – Sivakumar Mar 7 '13 at 11:25
Yea, you need to set up a virtual IP in some manner, that would be the IP address your application needs to speak to. – NickW Mar 7 '13 at 11:30
Thanks. Can you recommend Virtual IP solution. – Sivakumar Mar 7 '13 at 11:43
You're going to need to read a bit on corosync and pacemaker, this talks about setting up the virtual IP… but you'll have to have set up the rest of the software beforehand. – NickW Mar 7 '13 at 11:49
up vote 2 down vote accepted

If you are planning to control the mysql resources from within pacemaker, you will also be able to configure a virtual IP controlled by pacemaker. That IP will be the one your application will need to talk to.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.