I strongly recommend not subclassing DBI. You are very likely to break things and clash with other systems like Class::DBI or Apache::DBI.

I don't actually use these myself, but DBIx::Cluster and DBIx::HA look like they may do some of what you want.