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.
I didn't find performance of mysql or any database to be good over nfs (filer or other nfs mount). If you do a lot of reads/writes you should try to simulate that load on a similar setup on the filer.
--- David Lee t.d.lee@durham.ac.uk 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. :
__________________________________ Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus
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.
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. :
-
David Lee -
Jerry -
Joseph Bishop -
Kelsey Cummings