Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

Thanks

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 clusterlabs.org/doc/en-US/Pacemaker/1.1-crmsh/html/… but you'll have to have set up the rest of the software beforehand. –  NickW Mar 7 '13 at 11:49
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.