Oracle 9i Real Application Clusters. Concepts by Rawles J. W.

By Rawles J. W.

This guide prepares you to effectively enforce clustered databases via offering genuine program Clusters strategies. details during this guide applies to actual program Clusters because it runs on all working structures. actual program Clusters is a brand new leap forward structure with scalability and excessive availability beneficial properties that exceed the functions of earlier Oracle cluster-enabled software program releases.

Show description

Read Online or Download Oracle 9i Real Application Clusters. Concepts PDF

Similar databases books

Teradata RDBMS SQL/Data Dictionary Quick Reference

This publication is a short reference for the SQL dialect supported via the Teradata Relational Database administration approach. The e-book is usually a short connection with the supported facts description words for the Teradata RDBMS and the information Dictionary. The viewers for this fast reference is all clients of Teradata SQL who desire quickly, non-detailed information regarding the best way to constitution a SQL assertion.

Access Forms & Reports For Dummies

Create queries that make varieties and studies necessary improve types to entry the knowledge you wish and make reviews that make feel! in the event you suggestion you needed to use a spreadsheet application to supply stories and types, wager what! entry can prove great-looking kinds and experiences that truly exhibit what is going on together with your facts -- when you understand how to invite it properly.

Extra resources for Oracle 9i Real Application Clusters. Concepts

Sample text

For such non-uniform disk access systems, Real Application Clusters requires that the virtual disk layer be provided at the system level. In some cases it is much more efficient to move work to the node where the disk or other I/O device is locally attached rather than to use remote requests. This ability to collocate processing with storage is known as resource affinity. It is used by Oracle in a variety of areas including parallel execution and backup. Figure 3–3 illustrates a shared nothing system: Figure 3–3 Non-Uniform Disk Access CPU CPU CPU CPU CPU Memory Memory Memory Memory Memory Disk Disk Disk Disk Disk Cluster Hardware Architecture 3-7 Clusters: Nodes and the Interconnect Advantages of Non-Uniform Disk Access The advantages of using cluster database processing on MPP or non-uniform disk access systems are: ■ The number of nodes is not limited by the disk connection hardware ■ The total disk storage can be large due to the ability to add nodes Clusters: Nodes and the Interconnect As described previously, to operate Real Application Clusters you must use either a uniprocessor, SMP (UMA), or NUMA memory configuration.

With an optimized Real Application Clusters Architecture 2-7 Disk Subsystems communication layer, various services can be implemented above it. This is how the Global Cache Service and the Cluster Manager perform their communication duties. Disk Subsystems In addition to the OSD layers, Real Application Clusters also requires that all nodes must have simultaneous access to the disks. This gives multiple instances concurrent access to the same database. 2-8 Oracle9i Real Application Clusters Concepts 3 Cluster Hardware Architecture This chapter describes the hardware components and various high-level architectural models that typify cluster environments.

The type of storage access Real Application Clusters uses is independent of the type of memory access it uses. For example, a cluster of SMP nodes can be configured with either uniform or non-uniform disk subsystems. Real Application Clusters uses two storage access models discussed in these sections: ■ Uniform Disk Access ■ Non-Uniform Disk Access Uniform Disk Access In uniform disk access systems, or shared disk systems, as shown in Figure 3–2, the cost of disk access is the same for all nodes.

Download PDF sample

Rated 4.46 of 5 – based on 50 votes