Re: Looking for a bona fide distributed database that is open source

[Bruce Feist]

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

----- 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