Sorry, here's the link: http://www.emicnetworks.com/products/products_eac_mysql.html
And the link to the MySQL newsletter issue: http://www.mysql.com/newsletter/2003-02/a0000000125.html Brian McCain ----- Original Message ----- From: "Bruce Feist" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Friday, March 14, 2003 5:26 PM Subject: Re: Looking for a bona fide distributed database that is open source > Gelu Gogancea wrote: > > >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. > > > "Can be used like" is not the same as "is". Similarly, by writing > software in C, you can achieve SQL and use OS files like a relational > database -- that doesn't mean that flat files *are* a relational database. > > >Finally,What i wish to say is that distributed databases depend on us to be > >achieved and not by the RDBMS. > > > Yes, it can be done manually... but there are many advantages to having > the distributed capabilities built into the RDBMS itself. I've used > such systems (Computer Associates' OpenIngres product), and when > distributed capabilities are needed it's far superior to use a product > designed for it. Some examples of the improvements are: > 1) Distributed optimizer automatically takes advantage of changes to > distribution structure > 2) Applications can be written which are independant of distribution > structure > 3) Complexity of applications is reduced, resulting in lower > development costs and fewer bugs > 4) Transaction management spanning databases on multiple computers > > >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. > > > It's one factor, though. If we relax the definition of a distributed > database system to be a client-server RDBMS which can be used to build > an application which can combine information from queries to multiple > databases on multiple computers, as it seems you wish to do, then yes, > MySQL qualifies, and has its usual advantages of low cost, open source, > and speed. Depending on the project's needs, these may or may not be > enough to counterbalance built-in distribution capabilities of true > distributed RDBMSs. > > >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. > > > If so, then using it in conjunction with MySQL would indeed create a > distributed database management system. > > 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
