David,
Yes we are using NetApp for both Oracle and MySQL. NetApp RAID 4 is much faster than RAID 5 and has the appropriate protections.
Definitely use TCP. Get the fastest network you can. And hopefully you are not hopping over more than one switch from the server to the filer. Keep the network simple between them.
We have two filer systems that are snap mirrored between two buildings. We have tested fail over many times and it works like a charm. Also, the snapmirror technology is by far my favorite for migrating databases or applications between filers. You can get away with a very short downtime (minutes) when switching out the storage. Pretty cool.
Cheers,
Joe
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.