MySQL HA Solutions

There is no ultimate solution, a proper solution depends on your needs. MySQL Cluster uses memory-only storage and fully synchronous protocol based on 2-phase commit. So, if you have a ot of data you will need plenty of RAM to use the MySQL cluster. Percona XtraDB Cluster uses synchronous replication too but from my own experience its replicator is not stable enough, I have had some odd problems with it. But if you don't expect high write load (say, you write only several records per sec) on your DB I'd recommend it. Tugsten Replicator seems to be asynchronous only. So, if you need synchronous replication go with MySQL Cluster or Percona XtraDB Cluster, if you can live without it, try Tungsten.