"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.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.
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:Finally,What i wish to say is that distributed databases depend on us to be achieved and not by the RDBMS.
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
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.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 so, then using it in conjunction with MySQL would indeed create a distributed database management 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.
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
