David, we've been doing the same with all of our MySQL servers (linux) to NetApp for years now and have loved every minute. It's not as fast as a high performance local raid, but you get all the netapp-love. If you get creative, you can use snapshoting for backups to to avoid hvaing to use hotcopy or mysql dump.
On Mon, Jan 12, 2004 at 04:04:50PM +0000, David Lee wrote:
Our MySQL person, who is not on this list, has drafted the question below. (He had earlier asked on a "mysql" list but received very little feedback.)
# Currently we are using mysql-standard-4.0.12-sun-solaris2.8-sparc on a # Solaris 8 machine where the MySQL databases, MySQL binaries and MySQL # logs are stored on local discs. # # We now want to store the MySQL databases, the MySQL binaries, and the # MySQL logs on a NetApps server, and to access these filesystems from # the Solaris 8 machine using NFS. # # Are there problems with doing this? # Are people using NetApps to store the databases for MySQL?
The anxieties we wish to allay with this query concern things such as locking, simultaneous access, etc. At present, there would continue to be a single front-end machine (the Solaris 8 one mentioned above).
Further into the future, this might be replicated for failover (not simultaneous access), for loadsharing (simultaneous access) and/or be replaced by Redhat/Linux. Are there any known issues on these further points?
Thanks in advance.
--
: David Lee I.T. Service : : Systems Programmer Computer Centre : : University of Durham : : http://www.dur.ac.uk/t.d.lee/ South Road : : Durham : : Phone: +44 191 334 2752 U.K. :