00_Introduction_JFV14_00_Introduction_JFV14.ppt

00_Introduction_JFV14.ppt

1. I
Copyright © 2005, Oracle. All rights reserved.
Introduction

2. Copyright © 2005, Oracle. All rights reserved.I-2
Overview
•This course is designed for anyone interested in
implementing a Real Application Clusters (RAC)
database.
•The coverage is general and contains platform-
specific information only when it is necessary to
explain a concept using an example.
•Knowledge of and experience with Oracle
Database 10g architecture are assumed.
•Lecture material is supplemented with hands-on
practices.

3. Copyright © 2005, Oracle. All rights reserved.I-3
What Is a Cluster?
•Interconnected nodes
act as a single server.
•Cluster software
hides the structure.
•Disks are available
for read and
write by all nodes.
Node
Disks
Interconnect
Cluster ware
on each node

4. Copyright © 2005, Oracle. All rights reserved.I-4
What Is Oracle Real Application Clusters?
•Multiple instances
accessing the same
database
•Instances spread on
each node
•Physical or
logical access
to each
database file
•Software controlled
data access
Instances run on each node
Database
files
Interconnect

5. Copyright © 2005, Oracle. All rights reserved.I-5
Why Use RAC?
•High availability: Survive node and instance
failures
•No scalability limits: Add more nodes as you need
them tomorrow
•Pay as you grow: Pay for just what you need today
•Key grid computing feature:
–Grow and shrink on demand
–Single-button addition and removal of servers
–Automatic workload management for services

6. Copyright © 2005, Oracle. All rights reserved.I-6
Clusters and Scalability
SMP model RAC model
Cache
CPUCPU
Cache
CPUCPU
Memory
Cache coherency
SGA
CPUCPU
SGA
CPUCPU
Shared
storage
Cache fusion

7. Copyright © 2005, Oracle. All rights reserved.I-7
Levels of Scalability
•Hardware: Disk input/output (I/O)
•Inter-node communication: High bandwidth and
low latency
•Operating system: Number of CPUs
•Database management system: Synchronization
•Application: Design

8. Copyright © 2005, Oracle. All rights reserved.I-8
Scaleup and Speedup
Original system
100% of task
Cluster system scaleup
up to
200%
of
task
up to
300%
of
task
Time
Hardware
Time
Time
Cluster system speedup
Time/2
Hardware
Hardware
Hardware
Hardware
Time
Hardware
100%
of task

9. Copyright © 2005, Oracle. All rights reserved.I-9
Speedup/Scaleup and Workloads
Workload
OLTP and Internet
DSS with parallel query
Batch (mixed)
Speedup
No
Yes
Possible
Scaleup
Yes
Yes
Yes

10. Copyright © 2005, Oracle. All rights reserved.I-10
A History of Innovation
Nonblocking
queries
OPS
RAC
Automatic
Storage
Management
Automatic
Workload
management
Low-cost
commodity
clusters
Resource
Manager
Data
Guard
Enterprise
Grids

11. Copyright © 2005, Oracle. All rights reserved.I-11
Course Objectives
In this course, you:
•Learn the principal concepts of RAC
•Install the RAC components
•Administer database instances in a RAC
environment
•Migrate a RAC database to ASM
•Manage services
•Back up and recover RAC databases
•Monitor and tune performance of a RAC database

12. Copyright © 2005, Oracle. All rights reserved.I-12
Typical Schedule
Topics Lessons Day
Concepts and installation 1-2 1
3-4 2
Storage and services 5-6 3
7-8-9 4
Tuning and design 10-11 5