Is it possible to connect to multiple DBI servers in a single connection string?

valavanp has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: Is it possible to connect to multiple DBI servers in a single connection string? by davidrw (Prior) on Jun 17, 2006 at 14:40 UTC
why? what database(s)? no, you can't do that (how would it work??).. but you can just open two connections and work with each of them: `my $dbhA = DBI->connect($data_sourceA, $usernameA, $authA, \%attrA) +or die ...; my $dbhB = DBI->connect($data_sourceB, $usernameB, $authB, \%attrB) +or die ...;` [download] If you're trying to do cross-db joins or something, you'll have to do it in perl (or move all the data into one or the other, or a 3rd temp database). If you're just copying code from one to the other, try DBIx::Copy as well as Super Search for lots of related threads.	[reply] [d/l]
Re: Is it possible to connect to multiple DBI servers in a single connection string? by tantarbobus (Hermit) on Jun 17, 2006 at 15:52 UTC
Take a look at DBD::Multiplex	[reply]
Re: Is it possible to connect to multiple DBI servers in a single connection string? by dragonchild (Archbishop) on Jun 17, 2006 at 20:40 UTC
DBD::Multiplex is definitely what you're looking for. My criteria for good software: Does it work? Can someone else come in, make a change, and be reasonably certain no bugs were introduced?	[reply]
Re: Is it possible to connect to multiple DBI servers in a single connection string? by gellyfish (Monsignor) on Jun 17, 2006 at 14:41 UTC
Quite simply, no. I think you had better explain why you might want to do this, as I for one can't actually think of any sensible use for such a facility. If you want to mirror data updates across more than one database then you probably want to be doing this at the database server level rather than your application code. /J\	[reply]