On Mon, Feb 18, 2002 at 05:10:14PM +0000, johnd@energis2.net wrote:
A quick question for all you good people in Toaster List Land.
Has anyone had any experience of running a (busy) MySQL DB off a filer?
We used mysql on a F740 with ONTAP 5.3.2 without a problem. It served a few thousand databases of about 200 Gigabytes disk space.
Performance of course depends on the usual factors like caching and bandwidth.
Compared to local disks the filer is often a win for the first because of the additional hardware and a loss for the latter because the network is slower than your disk array.
But in the real world it all depends on what kind of queries and updates you run on the database and what kind of concurrency your application requires.