14 May 2012

RAC which Database is best for you!!

Oracle Maximum Availability (All about RAC)
Which database services you best?

When thinking about RAC implementation you might consider a enterprise Database that will have all the requirements that you need in order to have the most optimal solution for your needs for maximum or high availability implementation of your solution.

In order to figure out which Database has the most appropriate features for your implementation consider the costs of loss of connectivity and possible Data losses and Data Breaches, like stolen credit card information. Below you find a table taken from  Functionality and Security Analysis of ORACLE, IBM-DB2 & SQL Server by A. Jangra, D. Bishla, Komal Bhatia, Priyanka.

By the way RACF stand for Resource Access Control Facility in the above table.

What about the Concurrency control in multi-user environments ensures that data updates made by one user do not affect those made by other users. Oracle, DB2 and SQL Server differ greatly in their implementation of concurrency control. The main differences show in the below table.

In the Table below a comparison of Databases functionality comparison summary is given and you can clearly see that with Oracle Database 11g R2 you are clearly on the winning Database Platform when it comes down to RAC implementations.

Question for you remains why should you choose RAC at all?

Well look at the chart below where you can find some questions you may ask your self when considering RAC as a solution for your software implementation and Database platform choice.

According to a survey held by Oracle 51 percent of Network outages are due to unplanned downtime and 47 percent due to disaster recovery time.

You can safeguard against these disaster with Oracle RAC implementation. It will help you in the long run to sustain your customer base.

A traditional High Availability look like the slide below, which gives you limited protection, no real-time data validation, and no rolling upgrades.

With Oracle’s new Maximum Availability Architecture you do have full protection, real-time data validation, and rolling upgrades.

As you can see below the Oracle Software stack for this MAA is depicted below with a planned downtime and a unplanned downtime scenario.

With RAC you have the ability to Scale Out workloads and built-in high availability features.

Oracle Maximum Availability helps you protect against unplanned downtime, human error, data corruption, storage and site failures, enabling active-active datacenters with GoldenGate technology.

GoldenGate can be used to perform cross-system migrations. For example, if you want to move your database from one platform operating system to another, GoldenGate can allow you to do that online without taking a maintenance window, since it works in a heterogeneous operating system environment.  Additionally, GoldenGate can be used to perform some complex application upgrades in an online fashion, as well. If your application upgrade involves complex changes to the physical structures, major changes to your table, for example, GoldenGate can help facilitate that. Since it can process transformations, GoldenGate can be used to transform your data from Version 1 of your application to Version 2 in an online fashion.  So, when you put this all together you have a complete high-availability solution, from RAC in a single data center to Data Guard and/or GoldenGate in a distributed environment, an environment where the servers can actually be hundreds of miles apart from each other, not just single-digit kilometers.

In short when you want RAC and MAA your still best off with Oracle Database 11g R2.

All these features are available on Oracle Hardware, like the new Database Appliance and Exadata.

For more information please contact me at: info@dbaconsulting.nl


0 reacties:

Post a Comment