Bruce Feist wrote:
Gelu Gogancea wrote:
To anyone that *didn't see the forest because of the trees*.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,
You already find it.
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
--------------------------------------------------------------------- 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