apache / mysql Clusters (debian etch)

Discussion in 'Suggest HOWTO' started by MisterVlad, Oct 4, 2007.

  1. MisterVlad

    MisterVlad New Member

    I have been searching on how to create a session aware, high availbility, apache / mysql cluster

    Trying to figure out how many servers i will need (minimum).

    Is it ok to use apache and mysql on the same machine if doing it as a cluster?

    I am just looking to improve performance to my servers.

    I am also looking at getting a BLADE server, which will help me out on the server issues and multiple computers, but on the same token, i am looking at putting 2 of these together, one opposite sides of the continent in case of disaster at 1 of the locations.

    This may not be the place to ask this, but maybe this advanced topic could be talked about? or possible explained on how to do it?

    Thanks in advance.

    Mistervlad.
     
  2. falko

    falko Super Moderator ISPConfig Developer

    I think the minimum number of nodes is two (three if you need a MySQL cluster).
     
  3. MisterVlad

    MisterVlad New Member

    so would you put apache and mysql on the same servers? or would you run mysql on its own cluster?

    so then would it not be 6? 3 for apache and 3 for mysql?

    i would need to have it sesison aware, and the mysql servers will need to have redundancy checking, so that the ID's do not conflict.

    any ideas?
     
  4. falko

    falko Super Moderator ISPConfig Developer

    If the machines are powerful enough, then yes (saves a lot of money).

    http://www.howtoforge.com/load_balancing_apache_mod_proxy_balancer
    http://www.howtoforge.com/high_availability_loadbalanced_apache_cluster
    These are both session-aware.

    If you're using MySQL 5, I suggest you try master-master replication instead of a MySQL cluster: http://www.onlamp.com/pub/a/onlamp/2006/04/20/advanced-mysql-replication.html
     

Share This Page