Can I control which database Drupal uses for certain data?
If it's not possible at the Drupal level, this might be possible at the MySQL level using the FEDERATED storage engine.  This is a thoroughly untested solution, however, and it might not play nice with Drupal.