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'd quite like all the nice, scrummy data-protection features of a proper filestore but, well, you know, NFS and databases.
Are we mad, or will it work?
We have Filers aplenty so we can mess around, but the databases are all a bit company-critical so we're being cautious.
We know it will *basically* work, but performance issues are the main worry. The DB has to be reasonable quick still, and random block access isn't a NAS strong point.
So, any previous wins or horror stories?
Ta,
J
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.
-
johnd＠energis2.net -
Michael van Elst