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.