Hi, sharing a data directory between different servers (probably using nfs) is not a good idea and it would create a new bottleneck.
A quote from the very fine manual: "Make it easy for yourself: Forget about sharing a data directory among servers over NFS. A better solution is to have one computer that contains several CPUs and use an operating system that handles threads efficiently." Alternatively you can spend on storage and replicate all data to 40 slave servers. Regards, Thomas Spahni On Thu, 27 May 2004, tachu wrote: > WOuld the following scenario be possible > I currently have about 1.2 Tb of data that i need to transform into > mysql and be able to server a very high amount of pages from a > discussion board. would i be able to place the mysql/data directory in a > main server with huge storage and then have several mysql server > instances running on different machines accessing the same /mysql/data > directory? would there be any limitations. i need to be able to server > about 200/sec on each server and have about 40 servers. basically my > ideas is to have several mysql servers running but one main data > repository. any help is appreciated > > Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
