Hook_schema and multiple databases
I think another angle to attack the problem would be to implement hook_schema the normal way, as if there was only one database. And then tell Drupal to use another database for some tables in settings.php. Your module will not have to be run on seperate databases and all that external database stuff is taken care of by Drupals database layer.