MySQL failovers

[hjcao]

Hey all,

I was wondering if anyone here has a similar set up, and how you have failover contingencies set up.

We have two MySQL servers (Master and Slave) set up. They are set to be replicate and that is all good. I was wondering if there is a script or other process to handle failover automatically? If our master goes down, it'd be really great to have the JSS go to the slave without having to manually enter the DB information again.

If this helps:
2 JSS on WIndows Server 2012
F5 between the two JSS
2 MySQL instances on RHEL
SMB DP's on RHEL

[donmontalvo]

@jorgeislaspineda is our DBA. He and our architect @henryxyz set up MySQL HA, so if the Master MySQL goes down failover is automagical.

[jorgeislaspined]

hey, there are many solutions, but based on your comments, i think MHA is what you need, you can start looking this page
https://github.com/yoshinorim/mha4mysql-manager/wiki , this is the official site
here you will see, what are you going to download acording with the Linux version and MySQL version, how to install and configure.
also you can see this link how to configure MHA, but his is not the official site
http://www.arborisoft.com/how-to-configure-mysql-masterslave-replication-with-mha-automatic-failover/

[hjcao]

Thank so much for this!