Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

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