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.
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?
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