I've recently inherited a data warehouse that uses disk mirroring, and we're faced with the need to add about a terabyte (mirrored) to make it through the end of 2000. With that type of projected growth, I am wrestling with the need to continue with disk mirroring. Is it a common practice for data warehouses to use disk mirroring?
Sid Adelman’s Answer: I assume you have established service-level agreements for availability. The three situations where we see disk mirroring with data warehouses are:
Do you know how long it will take you to recover if you do not have disk mirroring? Do you know the impact of an outage? Will the cost of an outage outweigh the cost of disk mirroring?
David Marco’s Answer: Disk mirroring is common in warehouses that cannot afford downtime. Typical growth is a newer data warehouse is around 150 percent a year. In my experience, established warehouses grow around 100 percent yearly.
Douglas Hackney’s Answer: It is very common for a DW architecture to implement mirroring, especially for high performance data. You may want to look at what data types are being stored on which type of RAID. There may be opportunities where you could move some data types to RAID 5.
Register or login for access to this item and much more
All Information Management content is archived after seven days.
Community members receive:
- All recent and archived articles
- Conference offers and updates
- A full menu of enewsletter options
- Web seminars, white papers, ebooks
Already have an account? Log In
Don't have an account? Register for Free Unlimited Access