Can all Informix data (i.e., database, binaries, etc.) reside on nfsleaving only system files on the cpu (i.e. system, services, vfstab)?
Yes, that is what we do.
So what does reside on the server? Just the files I mentioned or do you have more files specific to that system? I am really pushing this one because I want to make a class in cfengine for informix servers.
Can snapshots be used to get a reliable backup without quiescing thedatabase?
During testing, our DBA tried restores from snapshots of an active database, and they did work. However, when we went into production, we decided to continue to quiesce the database before running our nightly backups. Note that it only takes a few seconds to create a snapshot, so the database is in this state for a very short period of time.
Good to know. I think we'll probably do the same thing (test it just to see if it works but then play it safe in production).
In the event that logical logs are still required we would write themto mirrored internal drives. Has anyone managed to write these logs to nfs?
We haven't tried that.
Where do your logical logs go now then?
Thanks.