Very interesting. I hadn't really thought about it, but I suppose you could setup a cluster. Really before you needed to cluster you could easily manage 10k plus users with a dedicated MySQL server, and dedicated apache servers round robin DNS. I've hosted forums with 25k users and we pulled it off with only 4 servers.

I would love to hear if anyone has pulled off any clustering / fail over.