Skip to main content
Question

MySQL failovers

H
Forum|alt.badge.img+9
  • hjcao
  • Contributor
  • 38 replies

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

    3 replies

    donmontalvo
    Forum|alt.badge.img+36
    • donmontalvo
    • Legendary Contributor
    • 4293 replies
    • August 2, 2017

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

    --https://donmontalvo.com
    J
    Forum|alt.badge.img+1

    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/

    H
    Forum|alt.badge.img+9
    • hjcao
    • Author
    • Contributor
    • 38 replies
    • August 2, 2017

    Thank so much for this!

    Reply


    Most helpful members this week

    Terms & ConditionsCookie settingsAccessibility statement

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings