The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'Bind / DNS / Nameserver Issues' 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