High Availability Lamp cluster

Discussion in 'HOWTO-Related Questions' started by vincentthe, Mar 20, 2008.

  1. vincentthe

    vincentthe New Member

    Hi there,

    I'm in the situation that I need a new HA-cluster in operation, but I want to limit the needed resources to a minimum.
    After reading the series on the high availability nfs/apache/mysql clusters + loadbalancer I have a couple of questions, I wonder if anyone could give me a hand in this.

    I'm going to run a php/mysql web-application with several interactive elements (= heavy DB usage) and some data-hogs (movies on demand). At this moment I think that fail-over is more important than pure performance so the setup I have in mind at this moment consists of:
    2x loadbalancer
    2x webserver
    2x db-server + nfs server

    My questions:
    - Is this the logical combination or is it better to combine webserver & nfs server on 1 box?
    - The MySQL clustering solution has loadbalancer 1 as the management node. Shouldn't it be installed on loadbalancer 2 as well? It seems to me that the approach from the tutorial still creates a single point of failure. What happens to the Cluster if LB 1 crashes and DB1 crashes after that?

    Thanks in advance!
     
  2. vincentthe

    vincentthe New Member

    Could it be an option to purchase 3(?) faster machines and use Virtualization and Xen to obtain the same goal? It would save on co-location costs...
     
  3. falko

    falko Super Moderator

  4. vincentthe

    vincentthe New Member

    From the tutorial it seems to me that downtime from one of the master requires quite a lot of manual intervention to get the system up again? In short, how is disaster recovery managed in this case?
    Is it still possible to use mysql load balancing in this setup?
     
  5. falko

    falko Super Moderator

    Once the systems gets up again, it should catch up with the other master again, provided that the relevant logs still exist on the other master (look at the expire_log_days setting in my.cnf). You can check with the
    Code:
    SHOW SLAVE STATUS;
    command if both systems are in sync. If they aren't, you must set up replication again as shown in the tutorial.


    You can put a load balancer in front of the MySQL server, e.g. HAProxy.
     

Share This Page