Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Webserver, MySQL, shared storage, HA

  • 28-03-2007 05:30PM
    #1
    po0k
    Registered Users, Registered Users 2 Posts: 15,817 ✭✭✭✭


    I'm at a bit of a loss for terms to use when researching solutions for MySQL in a load-balanced web-server system.

    Scenario: Migrate from single LAMP server to 2 load-directors balancing requests between 2 web servers running apache and mysql, using shared storage.

    Distro: Probably going to be RedHat5, shared storage will be a GFS volume. Running a mysqld on each of the cluster nodes, db datasets sitting on shared storage.

    Need To Know: What flavour/feature of MySQL should I be looking at so that these 4 nodes can serve up webpages and the CMS while the MySQLds avoid tripping over their feet?
    When a node dies, it should not impact the service.
    How nodes will be restored/added (brought up as mysqld slaves, then added as masters, then get sent requests from ldirectords)?

    Master-master replication was mentioned before, but this is not convincing.
    MMR may well be what I'm looking for, but I'm curious as to how shared storage might affect it, wrt file-locking etc.


Advertisement