We've had plenty of reports that Multi-DB doesn't work with BuddyPress. So I decided to sit down and figure out what the problem is today. Turns out I actually can't find a problem. As long as I add the bp tables (below) to db-config.php it seems to work just fine.
Can I get someone interesting in using Multi-DB with BuddyPress to confirm this?