Oracle Real Application Clusters One Node

1 <Insert Picture Here> Oracle real Application Clusters One NodeBetter Virtualization for DatabasesBob Thome, Oracle Grid DevelopmentAgenda Overview Comparison with VMs and other failover solutions Pricing Positioning vs. other Oracle products Installation Management DemoVirtualization Value Propositions Ubiquitous interest in virtualization : Directly reduce costs by consolidating servers Reduce server costs, maintenance, floor space, power, cooling Increase flexibility by enabling reshuffling of work on servers (live migration) Claims to provide universal HA Claims to reduce maintenance outagesRAC One NodeBetter Virtualization for Databases A virtualized single instance database Delivers value of server virtualization to databases on physical servers Live migration of instances across servers Rolling patches for single instance databases Built-in cluster failover for high availability Online upgrade to RAC Standardized deployment across all Oracle databasesRAC One Node DeploymentDB1DB2 Server ACommon Shared StorageSingle ClusterDB3DB4DB5 Server BServer CIsolation via Instance Caging Instance caging enables administrators to limit cpu cores by instance Protects service levels by preventing runaway

2 Cpu consumption Can be adjusted dynamically, while databases are online. Controlled by cpu_count parameter Supports partitioning and overprovisioning cpu Works with Resource ManagerRAC One Node Dcpu_count=1 RAC One Node Ccpu_count=1 RAC One Node Bcpu_count=2 RAC One Node Acpu_count=48 core serverOmotionDB1DB2 Common Shared StorageSingle ClusterDB4DB5DB3 Client ConnectionsServer AServer BServer COmotionDB1DB2 Common Shared StorageSingle ClusterDB2DB4DB5DB3 Client ConnectionsServer AServer BServer COmotionDB1DB2 Common Shared StorageSingle ClusterDB2DB4DB5DB3 Client ConnectionsServer AServer BServer COmotionDB1DB2 Common Shared StorageSingle ClusterDB2DB4DB5DB3 Client ConnectionsServer AServer BServer COmotionDB1 Common Shared StorageSingle

3 ClusterDB2DB4DB5DB3 Client ConnectionsServer AServer BServer COmotion Omotion moves a RAC One Node instance from one server to another without any downtime Use Cases Load balancing Database + OS patching and maintenance Oracle supplied tools control migration Services are not accepting connections on both nodes at the same time Migrated instance shutdown transactional once services moved A maximum of 30 minutes allowed for connections to migrate (then shutdown abort)Rolling Online Patching Rolling upgradeable RAC patches are also rolling upgradeable with RAC One Node Omotion migration followed by patching When patching complete, the primary instance is brought back online and the secondary instance is shutdown (reverse Omotion) cluster FailoverDB1DB2 Server ACommon Shared StorageSingle ClusterDB3DB4 Server BServer CCluster FailoverDB1DB2 Server ACommon Shared StorageSingle ClusterDB3DB4 Server BServer CCluster FailoverDB1DB2 Server ACommon Shared StorageSingle ClusterDB4 Server BServer CDB3 RAC One Node Provides VM-like Benefits on Physical ServerBenefitFeatureVMWareRAC One NodeConsolidationServer consolidationYes.

4 Each Guest OS consumes cpu+memoryYes. No additional cpu or memory required OS management economies-of-scaleNo. Must also manage VM hypervisorsYesStorage virtualization and consolidationNoYesHigh AvailabilityFailover protectionServer Failure onlyDatabase and Server FailureOnline OS rolling upgrade/patchNoYesOnline DB rolling patchesNoYesPerformanceVM overheadYes. 10% -20%NoServer scalability8 core limit per VMNo limitOnline scale-upNoYesOnline upgrade to RACNoYesOperational FlexibilityOnline load balancingYesYesSupport for all platformsNoYesStandard (single+multi-node) DB deployment modelNoYesProvides benefit to Virtual Servers RAC-One Node also complements virtual servers Fully supported on Oracle VM Protects against database failuresin addition to OS/node failures.

5 Rolling database and OS patching via on-demand VM deployment Enables consolidation of both databases and applications on the same physical serverOVMOVMA pplicationRAC One NodeInstanceRAC One NodeInstanceON-DEMAND RAC One NodeInstanceRAC One Node Plus OVM A Powerful CombinationBenefitFeatureVMWareRAC One NodeConsolidationServer consolidationYesYesOS management economies-of-scaleNoNoStorage virtualization and consolidationNoYesHigh AvailabilityFailover protectionServer Failure onlyDatabase and Server FailureOS rolling upgrade/patchNoYesDB rolling patchesNoYesPerformanceVM overheadYesYesServer scalability8 core limit per VM64 core limit per VMOnline scale-upNoYesOnline upgrade to RACNoYesOperational FlexibilityOnline load balancingYesYesPlatform supportLinux, WindowLinux, Windows, SolarisStandard (single+multi-node) DB deployment modelNoYesRAC One Node compares favorably vs.

6 3rdparty clustering solutionsBenefitFeature3rdParty ClusteringRAC One NodeConsolidationServer consolidationYesYes OS management economies-of-scaleYesYesStorage virtualization and consolidationNoYesHigh AvailabilityFailover protectionYesYes. Faster failover than some 3rdparty clustersOnline OS rolling upgrade/patchNoYesOnline DB rolling patchesNoYesPerformanceVM overheadNoNoServer scalabilityYesYesOnline scale-upYesYesOnline upgrade to RACNoYesOperational FlexibilityOnline load balancingNoYesSupport for all platformsVendor dependentYesStandard (single+multi-node) DB deployment modelNoYesRAC One NodePricing Oracle RAC One Node is a separately priced option to Oracle Database 11g Release 2 Enterprise Edition $10,000 per processor Eligible for list-to-list upgrade credit when upgrading to full RAC All nodes (except ONE spare node)

7 On which RAC One is installed must be licensed for RAC One Node One node may be specified to be a spare node for cold failover/Omotion and need not be licensed under the 10-day use rule Pricing policy mirrors 3rd-party cold failover policyWhen To Use What? Oracle RAC Business critical applications almost zero downtime Performance intensive applications requiring horizontal scalability Database consolidation Oracle RAC One Node Better-than-3rd-party-clustering HA (Symantec/Veritas, IBM, HP) Failover + Omotion Fits within a single server Online scale-out to multi-node RAC OS and cluster consolidation Oracle Enterprise Edition Minimal HA requirements tolerate unplanned and planned outages Fits within a single server Minimal growth expected Dedicated hardwareWhen to Use Data Guard RAC and RAC One Node Designed to protect from local failures Server or instance failure Connect to same database Run on metro cluster for DR Single logical copy of DB provides less protection EE + RAC One Node can be licensed on ONEserver Eligible for 10-day rule Data Guard Designed to protect from datacenter failures Disaster, power failure.

8 Fire Connect to standby database Can be used to provide HA Failover is potentially more disruptive All Oracle software needs to be licensed on both nodesFor best protection, use RAC or RAC One Node with Data GuardInstalling RAC One NodeInstall Grid Infrastructure on all nodesInstalling RAC One NodeInstall RACI nstall on all nodes where RAC One Node will runCreate a RAC One Node with DBCAC hoose RAC DatabaseCreate a RAC One Node with DBCAC hoose Admin-ManagedSelect only one nodeManagement Tools Command Line tools raconeinit Identifies to the cluster that this is a RAC One Node database and specifies servers for failover raconestatus displays status of RAC One Node databases running in the cluster raconefix fixes metadata after a failure or failover Omotion orchestrates live migration from one node to another Operate with flags (for customer)

9 Scripting), or in an interactive mode Install RAC One Node via patch on top of RAC installation. Patch includes One Node rac1 Common Shared ASM StorageSingle ClusterServer rac2 FreeSummary RAC One Node Benefits: Better virtualization for databases Consolidation, workload management, Better HA Plus, online maintenance, and DB failover Better cluster failover Additional value (online migration, online maintenance) Single-vendor solution Ready to scale Online upgrade to multi-node RAC Standardized Environment Common toolset for both single-node and multi-node Oracle database deploymentsQ U E S T I O N SA N S W E R