Tungsten works. But size does matter. It is one of the heaver solutions requiring Java and many moving parts with version requirements and dependencies. As a result you can build a working system but its rock and hard to move forward to newer releases its parts.
Percona’s XtraDB Cluster gives me hope. It’s Alpha and only works on InnoDB tables (now) but it’s light, eazy to install and maintain. (I think I can see the Holly Grail.)
I’m currently taking a second look at MySQL Master HA. My first run through was rough. MHA suffered from some dependency trouble and documentation holes. It seems to be currently under rapid development. That’s both good and bad. MHA may be your best choose if you’re looking from something free, simple to install and easy to maintain that keep your DBS alive. Unlike MMM, MHA does not move IP address. You’ll still need something more like heartbeat.
How can you choose wisely? Lets talk.