On Fri, Aug 30, 2002 at 10:43:38AM -0700, Jeff Kennedy wrote:
Can all Informix data (i.e., database, binaries, etc.) reside on nfs leaving only system files on the cpu (i.e. system, services, vfstab)?
Yes, that is what we do.
Can snapshots every 5 minutes really replace logical logs if 5 minutes is an acceptable point-in-time recovery period?
Perhaps, but I'm not sure I would count on it.
Can snapshots be used to get a reliable backup without quiescing the database?
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.
In the event that logical logs are still required we would write them to mirrored internal drives. Has anyone managed to write these logs to nfs?
We haven't tried that.
-- Deron Johnson djohnson@amgen.com