We have an Oracle database on a pair of HP-UX servers running MC/ServiceGuard to create a high-availability (HA)...
system. We are short on HA skills and also short on an Oracle license, which would make it relatively easy.
We don't have the budget for the extra Oracle stuff. So, we are looking to maximize the power of MC/ServiceGuard without using the Oracle OPS. To meet the requirements, we need someone to give us guidelines/expert advice/help on how to configure Oracle in HA environment.
There is some question on whether OPS is always the best answer for availability since in some cases it can introduce some performance degradation. That being said, the best way to configure a two-node cluster, whether on MC/Serviceguard, VERITAS cluster server, or any other failover management software, is as follows:
- Two systems, configured as similarly as possible
- With mirrored disks connected directly to each host for the operating system
- With a set of mirrored dual-hosted disks (connected to both hosts). It is best if each set of mirrors is in a separate enclosure
- With two dedicated private networks for heartbeats
- With a third network (at least one) connected to the LAN where the client systems will be located
- The Oracle data and executable should be on the shared disks
- Make sure you use HP's JFS (Journaled File System) to improve performance on failover and start up, and Volume Manager for mirroring
I'm not certain what Oracle's licensing policy is on clustered hosts, but I don't believe they require you to purchase complete licenses for both hosts.
Unfortunately, achieving high availability on your critical systems can be a fairly expensive proposition. You need to balance the cost of implementation (which may include hiring skilled personnel or training for your current ones) with the benefits that increased availability will create for your business. There's no such thing as a free lunch, but if you can persuade your management to consider these costs to be an investment rather than just the throwing of good money after bad, you may be able to get the funds you require.
Editor's note: Do you agree with this expert's response? If you have more to share, post it in one of our .bphAaR2qhqA^0@/searchstorage>discussion forums.
Dig Deeper on Data storage strategy
Related Q&A from Evan Marcus
Storage expert Evan Marcus compares software and hardware RAID and outlines the benefits and drawbacks of each.continue reading
This expert answer explains the purpose of creating LUNs and details reasons for creating multiple LUNs.continue reading
This advice details the hardware and software requirements for setting up two data servers in fail-safe cluster mode for high availability.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.