About MySQL Cluster, is it possible to set it up on only two machines? Is it advisable?
We currently have MySQL replication setup on our two databases, and we would like to implement R/W splitting between them. So you know how non-trivial it is to setup such scheme (from what I've been reading, I hope I'm wrong) on asynchronous replication-driven setup. So my thinking is, apply MySQL Cluster, so load balancing would become easier.
What are your thoughts about this?
Thank you very much!