Oh feeb, I'm posting.
Has anyone tried MySQL's transaction-safe tables using Berkley DB?
http://www.mysql.com/downloads/mysql-3.23.html
This should give MySQL the power of transactions (yes, commit and rollback!)
i have RPMs of 3.23.28-gamma that will work.
all you have to do is unpack the berkeley db and configure it with --prefix=/usr/local/BerkeleyDB
and then recompile the src.rpm 🙂