Running Drupal in MySQL Cluster (NDBCLUSTER)

Update: I figured out the many steps to running Drupal in a MySQL Cluster and you can find them here: http://www.coderintherye.com/drupal-mysql-cluster-ndbcluster-high-availability

Hi guys. I'm trying to run Drupal on a MySQL cluster. I know the docs have been updated to show this is not supported, but looks like some of you guys have got it going. I've been documenting what I have been doing and hope to post up info when done, as info on this is a bit scarce.

I've read: http://drupal.org/node/391130 and http://groups.drupal.org/node/20005#comments and the kris buytaert presentation http://www.slideshare.net/KrisBuytaert/drupal-mysql-cluster

I got Drupal to work by changing the values on various columns in menu_router to make them smaller (e.g., text to tinytext and smaller varchar). Obviously, not the best way to go.

However, I still had a problem with logging in, I could log in, but wasn't getting authenticated so just ended up back at the same page. So I try putting SESSIONS table back to MyISAM and bam things work again. So, I put it back to NDBCLUSTER, log in, then I try a manual query "SELECT * from SESSIONS" in mysql. This gives me the error: ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction

So, it seems like SESSIONS is locking for some when replicating, no idea why though, no other errors are in the log asides that. You guys have any ideas? How else has anyone solved the Drupal on MySQL Cluster problem?

Update: The problem was auto_commits were on for root but off for the user, despite the default set to on for the database.