Q

Best HA and OS options for data warehouse

We are researching HA options and due to budgeting, the project is looking at migrating to a Dell Linux Oracle RAC environment. One of the databases on the Sun Solaris system is our data warehouse (OWB). My question: What are the best OS and HA options for a data warehouse?

We are currently running six Oracle 9.2.0.7 databases on Sun Solaris. We are researching HA options and due to budgeting, the project is looking at migrating to a Dell Linux Oracle RAC environment. One of the databases on the Sun Solaris system is our data warehouse (OWB). My question: What are the best OS and HA options for a data warehouse?

I'm not sure that any one OS can be classified as the "best." Each has its pros and cons. Sun Solaris is a stable OS that has been around a very long time. But many that are looking at Real Appication Clusters (RAC) are looking towards Linux. It is much cheaper to procure multiple Linux boxes for your RAC than Sun Solaris boxes. Especially when considering that for Solaris, you'll also need to procure some clustering software. For Linux,...

you can use Oracle's Cluster-ready Services (OCS), which you can get for free from Technet.

Oracle provides two really good High Availability options, Real Application Clusters and Data Guard (DG). Each has its own pros and cons as well. With RAC, you achieve high availability by clustering multiple nodes together. Should one node go down, the others are there to get the work done. RAC also lets you scale your workload by adding more nodes should your current cluster not be able to handle the load. So RAC gives you higher availability and higher performance. But RAC typically costs more than Data Guard. With DG, you have two (nearly) identical databases. Should the primary go down, you failover to the standby. DG does nothing to address performance, but it costs less to implement too.

This was first published in April 2006

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close