Yes, that's possible. The solution JavaFan mentions is a very nice way to handle the situation, but is not stricly necessary.

There are also the DBD::Multi, DBIx::HA, and DBD::Multiplex modules, each of which takes a slightly different application-level approach to easing the use of multiple database servers.