Does anyone know if the MDS product line will work in this way when licensed with the Enterprise option for the read-only zoning?
I am trying to come up with a solution to provide real-time access to database files for a 2nd server that facilitates reporting applications. If I have LUNs that contain my primary database data and log volumes mapped to one server and create a 2nd read-only zone containing those LUNs, can I map those LUNs to a 2nd server as a kind of virtual/snapshot type instance?
I know that this will throw some odd things at the application side as it may or may not recognize the LUNs at read-only and could store things in temp tables or memory that would be cached and not actual current data but we've dealt with that in our reporting applications in the past utilizing snapshot technology on our storage platform. The downside to using that is in updating the snapshot to more recent copies, you have to at least offline the database to create a new snapshot with the same name/location which introduces interruptions, timeouts, etc.
Any feedback on how the read-only zoning feature is supposed to perform this type of functionality and/or real-world examples of how you are using it would be appreciated.