Replacement for MySQL proxy

There is a module for PHP available from http://pecl.php.net/mysqlnd_ms which does master-slave splitting and load-balancing from inside PHP. I don't now if anybody has tested it with Drupal, though. But as it allows a custom decision logic where to send queries it might help.

See also the documentation and Ulf Wendel's blog.