Transcript Manage Your Cluster Without Its Managing You

Session id: 40132
Oracle RAC 10g: Manage Your
Cluster Without It Managing You
Michael Salinas
Senior Product Manager
Oracle Corporation
Agenda




Today’s Realities
What’s new
Flexible Computing
Benefits
Today
Today: Business and IT
 The Good
–
IT is seen as on the critical
path to business success
 The Bad
–
DBA’s and System
administrators face
increasingly complex
environments
Today: Business and IT
 The Ugly
–
–
Administrators are
extremely over
utilized
Systems are under
utilized
 “My storage is
30% utilized and
growing by 50% a
year”
 15% utilization of
CPU is normal
Business Challenges
 Managing the environment
 Meeting the workload
 Doing it efficiently with existing resources
Oracle9i
Real Application Clusters
 Changed the game for the database
–
–
–
Scale Up and Scale Out
Highly Available
Off the shelf applications
 Only clustered database that runs real
applications and scales both DSS and OLTP
 Proven
–
–
Hundreds of production customers
Certified by leading applications vendors
 SAP, Oracle, PeopleSoft
Oracle
Database
g
10
Real Application Clusters 10g
 Raises the bar
 Extends Availability and Flexibility to your
applications
 Manage your environment, not each piece
 Automate Management
Simplify
Current Cluster Stack
Applications
Cluster Control & Failover APIs
Resource Manager & Agents
Volume Manager / File
system
Messaging / Locking / etc.
Membership
Connectivity
Hardware/OS Kernel
System Management
Event Services
Life today is complicated and costly
 Many vendors are slapped
together for Clustering
 Management is complicated
 Uneven quality & functionality
 Mostly fail over
 Costly
 Complicated support picture
Real Application Clusters 10g
Complete, Integrated Clusterware

–
–


High quality and functionality
across all platforms
Common event and management
support
–

No need to purchase additional
software
Easy to install & manage
Multi-tier HA & minimal MTTR
Support for third-party clusterware
Applications
RAC, Other Apps
Services Framework
Cluster Control/Recovery APIs
Automatic Storage Management
Messaging and Locking
Membership
Connectivity
Hardware/OS Kernel
Management APIs


Complete Oracle cluster software
solution
Single-vendor support
Extends clusterware from Oracle
and HP
Low Cost
Event Services

Manage
Where do DBA’s spend their time?
Others
15%
Software
Maintenance 6%
Ongoing System
Management 55%
Source: IOUG 2001 DBA Survey
Installation
6%
Creation &
Configuration 12 %
Data
Loading 6%
RAC 10g – Scalable Installation
and Upgrade
 Fast, Lightweight Install
–
–
One install
Smaller size
 Automatic Pre & Post Install
Validations
 Configures all administration
tools & components
 Silent mode for Embedded
ISV’s
 Pre upgrade checks
 Post upgrade status checks
RAC 10g – Scalable Creation
and Configuration
 90% fewer initialization
parameters to set
 Out-of-box database
management with Enterprise
Manager DB Control
 Automatic setup of common
tasks, e.g. backups, optimizer
statistics
 Best practice configuration
recommendations
–
–
–
Parameter Usage
Space
New features
RAC 10g Management
 Single software stack allows simplified management
 Designed to address largest time hits for DBAs
 Choice of management model
–
–
Centralized Management – Enterprise Manager Grid
Control
Database Management – Enterprise Manager DB
Control
 Improved tools are integrated to simplify management
–
–
Performance & Availability
Ongoing management (55% of DBA time)
Enterprise Manager
Cluster Home Page
Enterprise Manager
Cluster HW Performance
Cluster view
 Shows hardware
utilization
–
–
–
CPU
Memory
Disk
Enterprise Manager
Database Home Page
Enterprise Manager
Database Performance Page
 Database view
–
Drill down for
instance info
 Shows
–
–
–
–
Service wait times
Throughput
Alerts
Host run
queue/paging
Automate
RAC 10g – Management
 Self-Managing, SelfTuning, Self-Learning
Database
 EM provides
Environment-wide
operations
 Scale to 100’s of
databases or nodes
Built-In Intelligent Infrastructure
 Automatic Workload
Repository
–
–
Automatically collects
statistics, SQL
workload, Feature
usage
Base-lining capability
 Automatic Maintenance
Tasks
–
Pre-packaged, resource
controlled
RAC 10g – Services
 Policy based behavior
–
–
Performance
Availablility
 Uses Automatic
Workload Repository
Statistics
 Created and managed
with existing tools
Automatic SGA Management
Instance N
Instance 1
Online
Users
Buffer Cache
Large Batch
Jobs
Buffer Cache
Large Pool
Large Pool
Large Pool
SQL Cache
SQL Cache
Java Pool
Java Pool
sort
sort
 Only 2 memory
parameters
 Advisor helps
set parameters
 Automatically
resizes with
changes in
SGA Pool workload
 Each instance
PGA Pool
according to
usage
Automatic Storage Management 10g
New capability from Oracle
 Provides integration of the file system and volume
manager for simplified management of database files
 Spreads database files across all available storage for
optimal performance
 Enables simple and non-intrusive resource allocation
with automatic rebalancing
 Virtualizes the storage resources
ASM Benefits
 Enables non-disruptive storage
deployment
 Eliminates manual performance tuning
tasks
 Increases DBA productivity
RAC 10g and ASM Synergy





Simplified Cluster Environment
Easier Management
Higher Availability
Smoother Growth
Adaptable Resources
Flexible
Automatic Service Provisioning
 Hands-free allocation and re-allocation of
servers to workloads (services) based on
rules
–
–
Automated routing of service requests to
appropriate server with lowest load
On server failure, automated re-allocation of
surviving servers to services
 Works across all platforms
Enterprise Grid - Automatic
Service Provisioning
Order Entry Supply Chain
HR
Financials
Normal Server Allocation
Enterprise Grid - Automatic
Service Provisioning
Order Entry
Supply Chain
HR
End of Quarter
Financials
Enterprise Grid - Automatic
Service Provisioning
Order Entry Supply Chain
HR
Financials
Normal Server Allocation
Enterprise Grid - Automatic
Service Provisioning
Order Entry Supply Chain
HR
Server Fails
Financials
Enterprise Grid - Automatic
Service Provisioning
Order Entry Supply Chain
HR
Financials
Reallocate HR server to Order Entry
Enterprise Grid - Automatic
Service Provisioning
Order Entry Supply Chain
HR
Financials
Order Entry on Two Servers
Summary
Real Application Clusters 10g
 Preserves your investment
 Is simpler to manage
 Is easier to support
 Brings reliability to your applications
 Scales for the most demanding business
environments
RAC makes it easier to succeed!
Next Steps….
 Recommended sessions
–
–
–
–
Tues, 9/9 16:00 Oracle RAC 10g: Running Mixed Workloads - G.
Smith (Rm 104)
Wed, 9/10 11:00 Oracle RAC 10g: Application Continuous Services
for a Grid - B. Kehoe (Rm 104)
Wed, 9/10 13:00 Oracle RAC 10g: Best Practices on Linux - K.
McGowan (Rm 104)
Wed, 9/10 16:30 Oracle RAC 10g: Customer Round Table - G.
LeMay (Rm 104)
 Visit the DEMOgrounds to see RAC in action
 Visit the RAC web sites for more information
–
http://otn.oracle.com/products/database/clustering/content.
html
Reminder –
please complete the
OracleWorld online session
survey
Thank you.