This product was mentioned recently in the MySQL newsletter and in a MySQL press release. From the company's description of it:
"EAC uses clustering technology with a unique group communication replication technology, which provides the consistency of synchronous replication at the speed of asynchronous replication, with no decrease of overall performance. EAC combines multiple physical SQL databases, working as one logical, highly available database. It takes full advantage of available resources and balances the workload between clustered databases." It's not free, but they've got a free evaluation version, and it looks like it might do what you're looking for. If anyone has used this product, I for one would be really interested in hearing any feedback on it. 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
