What you are asking to do is not built into MySQL :(
Mysql matintains its own internal database locking that would not
be shared amongs the other computers, if you have multiple machines
reading a writing to the same database file you will corrupt it
in short order.
Your best bet in such an environment (IMHO) would be to better
arrange your database(s) so that they can be logicaly split amongst
multiple computers. You can still use the common drive array as
long as you don't have multiple computers assigned to the same
database.
For example we have some systems that devide sessiontracking,
order management, catalog images, separately. We have another
system that that has databases split along a logical divider and
a single database that acts as an index server. For example if you
are managing a collaboration software type database break your
projects to different servers by the letter they start with, or
simply round robin their creation across multiple servers and maintain
a single server that has the index containing which project is on
which server. Back up all of the servers independantly and you're
ready to do.. You can get pretty big doing it like this. Maintenance
is a little higher than for a single master database, but again, mysql
doesn't do that, so if you want to use mysql think differently.
It may be possible to maintain multiple read servers and a single
master "write/update" server while attached to the same database, but
the way I see it this wont' work either given the way MySQL caches
indexes and the servers will cache the file system (databases).
Quite frankly ebay, Microsoft, apple and amazon are not using MySQL
in environments that require multiple servers to accomplish single
data management tasks.
Kenneth Kopelson wrote:
>
> I am hoping there are people who use MySQL for serious business
> applications on this list. If so, please answer my question :) If not,
> will someone please direct me to a source of expert information?
>
> HERE IS MY QUESTION:
>
> I have need for multiple servers to share the same database files. We are
> implementing a site that will have hundreds of thousands of users at the
> same time, so we need a large pool of Linux servers that are
> load-balanced. Then, all these servers, each of which will run Apache and
> MySQL (or another database if MySQL just can't handle the load), needs to
> access the single large RAID disk array through a giga-bit network connection.
>
> Certainly, this is not uncommon, as any large database driven website needs
> to have a similar setup (like eBay, Microsoft, Apple, Amazon, etc.). The
> servers need to be setup in a cluster to provide the required
> high-availability. Also, replication will NOT work, as we need changes to
> the database to be immediately available to everyone else, and managing 100
> or more replicated databases would be a nightmare.
>
> 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.
>
> Any help in this matter would be greatly appreciated.
>
> Thanks
>
> ---------------------------------------------------------------------
> 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
