i run a mysql server that our company uses to process a lot of machine data and statistics. There are several processes reading from and writing to, the database and we are having trouble scaling. We are going to be ordering a couple of server machines soon, and i am considering using mysql-cluster so several machines can divide up the process jobs and system loads. I am looking to do this primarily for effeciency, not so much failover, although that is nice. I wanted some advice here. My questions are... is mysql-cluster easier to maintain and does it have the same performance or better than a master-master replication? If i were to have one of the data nodes melt down, would it be difficult or require downtime to set up another one to replace it?
Thanks for any tips.