My experience may be limited but I don't know of any database that will allow a single query to access mutiple database servers
In fact, only a few seem to be able to even access mutiple databases on the same server Frankly, I am still looking for a db that provides n way replication (this may solve some of your wishes since a local copy could be maintain on your local server) Paul DuBois ([EMAIL PROTECTED]) wrote: > >At 9:55 -0500 3/14/03, Bruce Feist wrote: >>Gelu Gogancea wrote: >> >>>To anyone that *didn't see the forest because of the trees*. >>> >>>You already find it. >>> >>Is MySQL really distributed, or just client-server? I've seen no >>indication of distributed capabilities; I'm new to MySQL, so maybe I >>just haven't read enough. But a distributed DBMS should be able to >>execute a single query which transparently accesses multiple >>database installations on multiple computers, possibly on multiple >>platforms. For instance, >> >>SELECT * from a, b ON a.id = b.id; >> >>where table 'a' is in a database on a Windows/2000 computer and >>table 'b' is on a Linux machine. The DBMS should keep track of >>which table is in which database on which computer, and its >>optimizer should be capable of figuring out an efficient way of >>resolving such queries. >> >>Can MySQL do that? >> >>Bruce Feist > >No. A given connection is a connection to a specific server. You cannot >access tables managed by different servers within a single query. > >> >>>----- Original Message ----- >>>From: "james" <[EMAIL PROTECTED]> >>>Sent: Thursday, March 13, 2003 4:44 PM >>> >>>>I am looking for a bona fide distributed database system, like Oracle or >>>>SQLServer, but open source running on Linux. > > >--------------------------------------------------------------------- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > -- Brian Johnson This is where my witty signature line would be if I bothered to edit this line :) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php