Linux server, setup heartbeat for mySQL redundancy

Posted on 2006-04-13
Last Modified: 2010-03-18
I looking for someone to set up two servers using heartbeat so one will take over if the master fails. I want mySQL on them both set up in a Master-Slave. The Slave will only take over if the Master fails and if it fails it will take over when it comes back online. My question is how many hours should I expect an experienced Linux consultant to take to set this up if they are experienced with both heartbeat and mySQL?


Question by:td234
    LVL 7

    Expert Comment

    About 1 -2 days.  Do you have a shared disk array?
    LVL 2

    Author Comment

    Each machine would have its own RAID 5.
    LVL 7

    Accepted Solution

    Then you have a cutover problem since if machine A goes doen, then machine B will not have all
    transactions performed after the last sync.

    You can use something like drbd to force file synchronization however

    Also if you are in planning stages, investigate STONITH and a watchdog card.

    The STONITH (shoot the other node in the head) card kills the other server if a failure mode exists, the watchdog
    card reboots the machine if the processor does not receive a signal from the CPU within a certain threshold.

    The STONITH card is probably more important sinceit prevents "split brain" problems.


    PS: You don't need these to get up and running for non-critical work, but a serious cluster absolutely does.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    I have seen several blogs and forum entries elsewhere state that because NTFS volumes do not support linux ownership or permissions, they cannot be used for anonymous ftp upload through the vsftpd program.   IT can be done and here's how to get i…
    Note: for this to work properly you need to use a Cross-Over network cable. 1. Connect both servers S1 and S2 on the second network slots respectively. Note that you can use the 1st slots but usually these would be occupied by the Service Provide…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    how to add IIS SMTP to handle application/Scanner relays into office 365.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now