Hm. I think this is more of a mount question. If you have two
machines, each with a /mysql/data directory then you cannot mount
/mysql/data from one machine to the other machine and have the
directories 'merge' into one big tree including 'all' contents. If you
mount overtop of a directory that has contents then the old contents
will seem to disappear and you will only see the contents of the mounted
drive.
If you know the specific databases then it is possible though. Just
mount each individual database in the /mysql/data directory of the other
machine (as long as the database names arent' the same).
I've used NFS for database sharing before... in a production
environment. I've since switched to builtin mysql replication... and
prefer it 100x's more. It's easy to setup will do exactly what you
want.
Matt
On Wed, 2003-10-01 at 10:05, Eric Dickner wrote:
Hello All,
I want MySQL to see several drives scattered on several machines, all with
MySQL installed on them. If I mount all of the /mysql/data/ directories to
each of the machines will all the separate machines be able to see each
others' databases in a transparant way? Or, alternatively, will I have to
mount each database directory to each
machines' /mysql/data/ directory?
Failing both of those will symbolic links
or hard links to each of the other machines' data directories allow me to
see all of the separate directories on the separate machines at once?
Thanks...I don't have a Lin/Unix network to find this out by myself
Eric D
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
