Hi,
We're looking to update our web and database server to a 'more' redundant solution. This will involve using two webservers with one being idle unless the other is down for maintenance ... this bit we know about and can handle via Linux heartbeat software.
The plan for the database part is to hold identical implementations of the MySQL database server on each web system however actual database files "shared" on a network attach storage (NAS) subsystem ... (we have successfully implemented this on a shared SCSI subsystem and it worked OK)
I guess the question I have is if anyone has experience implementing MySQL on NAS or could offer general advice? So far web searches provide conflicting reports ... some stating that databases are not supported on NAS ... although this is possibly referring to database server support and not database files?
Why NAS? dual purpose really ... we need extra storage and plan to utilise this as a generic document server (over HTTP) for our LAN users.
I realise this question is a bit open-ended however if anyone has advice it would be greatly appreciated...
We're looking to update our web and database server to a 'more' redundant solution. This will involve using two webservers with one being idle unless the other is down for maintenance ... this bit we know about and can handle via Linux heartbeat software.
The plan for the database part is to hold identical implementations of the MySQL database server on each web system however actual database files "shared" on a network attach storage (NAS) subsystem ... (we have successfully implemented this on a shared SCSI subsystem and it worked OK)
I guess the question I have is if anyone has experience implementing MySQL on NAS or could offer general advice? So far web searches provide conflicting reports ... some stating that databases are not supported on NAS ... although this is possibly referring to database server support and not database files?
Why NAS? dual purpose really ... we need extra storage and plan to utilise this as a generic document server (over HTTP) for our LAN users.
I realise this question is a bit open-ended however if anyone has advice it would be greatly appreciated...