Peter, one trick you may want to try using is to set
ipv4.ip_nonlocal_bind=1
in sysctl.conf, this will let you start mySQL and bind it to the VIP, even if
the VIP isn't live on the box yet.
so when you want to do a failover, you can have pacemaker stop MySQL on the old
box, start it on the new box, and start the VIP migration. Until the VIP
migration completes, you won't be able to reach MySQL on the new box, but as
soon as the migration does complete, you will be live.
David Lang
On Mon, 30 Sep 2013, Peter Romfeld wrote:
i am able to use IPaddr2 when running a external script explained here:
http://aws.amazon.com/articles/2127188135977316
I can adjust it to check port 3306 but i still want to use pacemaker to
handle it, since thats pacemakers job :)
I want to bind mysql to the VIP and in this case i cant use the external
script anymore, and i think its more clean to let pacemaker manage
everything related to the cluster!
I am not that experienced with scripting so,
Thanks very much!
On Mon, Sep 30, 2013 at 9:22 PM, Michael Schwartzkopff <mi...@clusterbau.com
wrote:
**
Am Montag, 30. September 2013, 21:12:56 schrieb Peter Romfeld:
I am working in AWS i cant just use a VIP i need to use a floating
secondary IP which i reassign through script, i want to let pacemaker
handle the reassignment...
Please explain the difference of a VIP and a "secondary IP" in your
opinion.
--
Dr. Michael Schwartzkopff
Guardinistr. 63
81375 München
Tel: (0163) 172 50 98
_______________________________________________
Pacemaker mailing list: Pacemaker@oss.clusterlabs.org
http://oss.clusterlabs.org/mailman/listinfo/pacemaker
Project Home: http://www.clusterlabs.org
Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
Bugs: http://bugs.clusterlabs.org
_______________________________________________
Pacemaker mailing list: Pacemaker@oss.clusterlabs.org
http://oss.clusterlabs.org/mailman/listinfo/pacemaker
Project Home: http://www.clusterlabs.org
Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
Bugs: http://bugs.clusterlabs.org
_______________________________________________
Pacemaker mailing list: Pacemaker@oss.clusterlabs.org
http://oss.clusterlabs.org/mailman/listinfo/pacemaker
Project Home: http://www.clusterlabs.org
Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
Bugs: http://bugs.clusterlabs.org
