Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

MySQL, Fail Over and Server Cluster. Can they work ?

Discussion in 'Bind/DNS/Nameserver' started by jorj1, Jul 7, 2005.

  1. jorj1

    jorj1 Member

    Nov 21, 2004
    Likes Received:
    Trophy Points:
    "LOAD BALANCED SERVER CLUSTER" sounds great. It assures fail over and a 100% up time of the sites. So I decided to go for it and get them. Now I'm stacked thinking how the h*ll can I use MySQL in this configuration. I look forward for sugestions.

    Here are the options I found:
    1. MySQL 4.1's clustering implementation which would solve the problem if I can make it work on two computers and not on threeas in their example. Is this possible ?

    2. write the data into the master server's DB and keep a replica on the slave. Still, I don't know how can I switch the slave to use the replica if the master goes down.

    I'd really need some help here. Now I will try to see if I can configure a native MySQL clustering on two servers only and still function correctly. Should I even bother ?

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice