The new version of MYSQL CLUSTER DB just came out and upon preliminary research i think its better than the older one and the DATA REPLICATION it supports.I like they have used shared nothing architecture and now they use heartbeat to track the status of each node in the cluster.
MYSQL CLUSTER DB by default requires three nodes
- Data Node
- Management Node
- SQL node
Also Apache has a module which enables load balancing and session support. I was just wondering will we see radical changes in performance if we use MYSQL CLUSTER and apache with load balancing enabled. To mirror the web app on different nodes i was thinking about using high availability NFS SERVER or rsync server. If i were to use rsync i would look for changes in the main repository every new few hours or so.
Though since MYSQL DB loads everything in memory it requires a huge amount of ram. But inspite of the inherit drawbacks of both the application will we see a increase in performance.
I will try to run this experiment when i have time 
Something to ponder.
After reading through the article, I just feel that I need more information on the topic. Can you share some resources please?
Hi Pirsey,
Can you please let me know what exactly you want to know?
Anjin