Hi,
IMHO:
The distributed database is a concept which is can not be assign to the SQL
engine standards(AFAIK).Stored procedures,triggers are described in the SQL
92 or SQL 99 standards.
It's quite right, some SQL DataBase engines(like Oracle,DB2,msSQL) have
implemented facilities for this.
Distributed database can be achieved,like example, using DISTRIBUTED
OBJECTS(let's say CORBA).In my understanding that means that MySQL already
can be used like distributed database.
Finally,What i wish to say is that distributed databases depend on us to be
achieved and not by the RDBMS.
Paul have right and i read very carefully him message:He said (very explicit
and without any doubt)that MySQL can not manage multiple tables which are
hosted on different servers with one single query.For me this is not a
reason to not use MySQL for distributed database system.
If i remember well, on the MySQL website is a link to a german company which
has develop a modules which treat multiple MySQL database(hosted on
different machine of course) to a logical one.
Best Regards,
Gelu
P.S.This is my opinion...if you consider that i'm wrong....????.
______________________________________________________
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
----- Original Message -----
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "Bruce Feist" <[EMAIL PROTECTED]>
Cc: "MySQL List" <[EMAIL PROTECTED]>
Sent: Friday, March 14, 2003 5:33 PM
Subject: Re: Looking for a bona fide distributed database that is open
source
> No, it is not distributed.
>
> 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
>
>
>
>
> ---------------------------------------------------------------------
> 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
>
>
---------------------------------------------------------------------
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
