Thank you Steve, I appreciate your response :) I have considered modifying
MySQL to do what I have asked for, but I didn't want to do that until I
verified it wasn't already available somewhere. I'll bet this feature is
something that others would be interested in as well.
On the note of what eBay and others are using, do you have a suggestion of
a database that would do what we are wanting, and also be as efficient as
MySQL is? I really like MySQL's many features like regular expressions in
queries, the fact that you can easily retrieve the auto-increment value
that was used on an INSERT (not an easy task on others DBs I have used),
and many other features.
Perhaps an open-source project to add "shared DB" capabilities would be
something worth starting. I myself am a C++ developer with over 23 years
experience, so maybe I can join with some others who are interested, and we
can start a project. If anyone on this list would be interested in
discussing the possibilities of joining in such an effort, please let me know.
-Ken
At 11:47 AM 6/1/01 -0600, Steve Ruby wrote:
>Kenneth Kopelson wrote:
>
> > So, how do we get support in MySQL so that multiple instances of the mysqld
> > daemon running on separate machines can all access the same database files
> > located on a central server? I can see how the file system of the central
> > database server could be exported through NFS (or something similar) so
> > that all the machines in the cluster can access the database files. I also
> > imagine the daemons would need to have some sort of locking mechanism to
> > avoid stepping on each other.
> >
>
>Also... MySQL is open source, so the easiest way to get support for a
>feature
>it doesn't have is to get together a group of people to write it.
>
>I would start with InnoDB format tables since table level locking would
>probably
>kill you on a such a large distributed environment.
---------------------------------------------------------------------
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
