Splitting up a Drupal database Is it possible to split the Drupal database into multiple databases. For example I have one database having the watchdog table and another database having all the other tables?

I know if I created my own tables I could store them in a separate database and use the following:

How to connect to multiple Databases in Drupal 7?

db_set_active('your_second_db_alias');
$query = db_query("SELECT * FROM your_table");
db_set_active();
I think you'd be better served using Syslog for logging without cluttering your database.