Corporate PPT Template
Download
Report
Transcript Corporate PPT Template
Session id: 40131
Oracle Real Application
Clusters 10g: The Fourth
Generation
Angelo Pruscino
Oracle Corporation
Agenda
The Generations
Key IT imperatives
Roadmap to Enterprise Grids
Where We Are Now
–
–
Oracle9i RAC HA and Scalability
Low Cost Clusters
Next Steps
–
Oracle RAC 10g Manageability “RAC for
Everyone”
Be
Adaptive
Proactive
Agile
The Generations
Enterprise
Consolidate
Reach
Your
Customer
Know
Your
Customer
1
2
BI and CRM
Internet
And
e-Commerce
3
4
Big SMP
And
Clusters
Grids
Key IT Imperatives
Highest Quality of Service
–
–
Maximum availability
Maximum scalability
Most Efficient Management
–
Do much more
Lowest Cost
–
With much less
Enterprise
Grids
Adaptive
Proactive
Agile
Roadmap
RAC 10g
For Everyone
Oracle9i RAC
HA & Scalability
Now
Most
Efficient
Management
Low Cost
Clusters
Highest
Quality
Service
Lowest
Cost
Enterprise
Grids
Oracle9i RAC HA & Scalability
Full Cache Fusion
–
–
–
Cache-to-cache data
Low Latency Interconnect
shipping
VIA or Proprietary
Shared cache
eliminates
High Speed
Switch or
slow I/O
Interconnect
Enhanced IPC Clustered
Allows flexible
and transparent
deployment
–
Centralized
Management
Console
Users
Database Servers
Storage Area Network
Mirrored Disk
Subsystem
Scale-up/Scale-out
Hub or
Switch
Fabric
Oracle9i RAC HA
Failover Operation
RAC
‘Cold’
Reconfigure Group Membership
Reconfigure Distributed Locks
Failover Disk Volumes
Restart Oracle
Recover Oracle
Warm Buffer Cache
15 sec
5 sec
0 sec
0 sec
Up to 20 min
Total Failover Time
< 60 sec*
0 sec
0 sec
20 sec
0 sec
Up to 5 min
20 sec
5 + min
> 30 min
* Oracle RAC 10g failover time < 8 sec
Oracle9i RAC SAP Scalability
SD 3-Tier Parallel Benchmark Results Now Official
82%
Scalability
14,000
12,000
12,000
10,000
# Users
8,000
6,000
Certified
6,580
4,000
2,000
3,640
0
1 Node
Running on HPQ AlphaServer Computers
2 Nodes
4 Nodes
Oracle9i RAC E-Business Suite
Scalability
Oracle11i E-Business Suite Benchmark
7,000
6,496
6,000
5,433
5,000
# Users
4,368*
4,000
3,000
2,000
2,296*
1,288
1,000
0
1 Node
Running on HP Computers
2 Nodes 4 Nodes 5 Nodes 6 Nodes
*Audited
84%
Scalability
Oracle9i RAC OLAP Scalability
75x better than the nearest competitor
Analytic Queries Per Minute (AQM)
World Record Performance
100000
90000
80000
70000
60000
50000
40000
30000
20000
10000
0
85,719
1,135
Oracle
Hyperion
Can’t Say
Microsoft
Source: DSS Lab, 2003
Oracle9i RAC Momentum
2,500+ NEW customers
550+ documented production customers
175+ production customer references
16% of new DB customers are RAC
customers
20% of RAC deals are from repeat
customers
Low Cost Clusters
Component
# Servers
Large RISC
SMP Server
RISC SMP
Cluster
Intel/Linux
Cluster
1
8
8
Processors/Server 32 @1.3Ghz
4 @1.2Ghz
4 @2Ghz
Memory/Server
64Gb
8Gb
8Gb
Operating System
UNIX
UNIX
RedHat AS
$1,250,000
$431,960
$232,664
Total Cost
Source: hardware vendor price lists
Electronic Arts ROI
Discounted Cash Outlay
Comparison
$ Millions
15
10
5
0
Year 1
Year 2
Year 3
Year 4
Year 5
Total
RAC
5.03
0.65
0.58
0.59
0.51
7.36
Sun
SMP
6.8
1.17
1.07
0.92
0.79
10.76
Takes into account:
•Hardware costs
•Software costs
•H&S maintenance
•DBA costs
•SysAdmin costs
1st Year
5 Years
Big SMP is 35%+
More Expensive
Big SMP is 46%+
More Expensive
Next Steps: RAC 10g Manageability
Key part of much larger Oracle Database effort
–
–
Oracle9i -> reduced operational costs by half
The Oracle Database 10g -> reducing by another half
Advanced functionality that has been totally
automated:
–
–
–
–
Rollback Segment Management – enables highly efficient support
for mixed OLTP/DSS workloads (Oracle9i)
Backup & Recovery – provides mission critical protection from media
failures and corruptions (Oracle9i)
Memory Buffer Management – key enabler of high performance and
scalability (Oracle9i and Oracle Database10g)
Automatic Storage Management – automatically balances I/O
across disks for maximum performance (Oracle Database 10g)
Next Steps: RAC 10g For Everyone
Eliminate need for 3rd party components that
add significantly to complexity and cost
Single system image management
Automation of workload management
Full integration with other key Oracle features
New and improved verification and diagnostic
tools
Zero downtime patches
Performance improvements
RAC for Everyone – Integrated
Clusterware
Complete Oracle cluster
software solution
Single-vendor support
Low Cost
High quality and functionality
across all platforms
Large number of nodes
Common event and
management api’s
–
Multi-tier HA & minimal
MTTR
Support for third-party
clusterware
Services Framework
Cluster Control/Recovery APIs
Automatic Storage Management
Messaging and Locking
Membership
Connectivity
Hardware/OS Kernel
Management APIs
–
No need to purchase
additional software
Easy to install, manage
RAC, Other Apps
Event Services
–
Applications
RAC Enterprise Manager
Integration
Service Consumer Page
Shows alerts for SLA violations
Cluster Page
Cluster Database Page
Performance Page
RAC for Everyone –
Server Provisioning
–
–
–
Provision software to many systems at once
Clone, store and distribute “known good” configurations
Automate patch and update management
Enterprise
Manager
Software
Inventory
RAC for Everyone –
Server Provisioning
–
–
–
Provision software to many systems at once
Clone, store and distribute “known good” configurations
Automate patch and update management
Enterprise
Manager
Software
Inventory
Enterprise Grid – Workload
Management
Hands-free allocation and re-allocation of
servers to 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 – Workload
Management
Order Entry
Spare
Supply Chain
Normal Server Allocation
Enterprise Grid – Workload
Management
Order Entry
Supply Chain
End of Quarter
Enterprise Grid – Workload
Management
Order Entry
Spare
Supply Chain
Normal Server Allocation
Enterprise Grid – Cluster
Failure
Order Entry
Spare
Supply Chain
Server Fails
Enterprise Grid – Cluster
Failure
Order Entry
Supply Chain
Reallocate Spare server to Order Entry
Enterprise Grid – Cluster
Failure
Order Entry
Spare
Supply Chain
Failed Server Restored
End-to-End Integration
Load Balancing
Oracle 10g Clusterware
iAS
Dynamic load balancing
with Oracle Application
Server 10g
Multiple SLA's satisfied on
shared hardware
Self monitoring services
RAC
–
ASM
–
Automatic Workload
Repository (AWR)
measures end to end
Resource manager
End-to-End Integration
Synchronized Recovery
Oracle 10g Clusterware
End to end recovery without
human intervention
–
iAS
RAC
ASM
–
< 8 second recovery time
for database
Immediate recovery for
mid-tiers
< 4 seconds from 15
minutes Self
Correcting
Self verifying
Self diagnosing
Self correcting
End-to-End Integration
Disaster Recovery
Oracle 10g Clusterware
iAS
Production
RAC
ASM
Data Guard
Broker
Data Guard Broker
central point of control
Automatic service reprovisioning
Seamlessly integrated
Maximum availability
–
iAS
Standby
RAC
ASM
Oracle 10g
Clusterware
–
–
iAS & customer
integration
End-to-end min MTTR
Rolling Upgrade
Performance Enhancements
Dynamic file and lock affinity
Lower-overhead updates
Message aggregation
More efficient global cache
Fewer buffer copies
Less memory usage
No Cost System Changes –
Capacity on Demand
CPU
–
Add/remove CPUs on SMP online
Cluster Nodes
–
–
Add/remove cluster nodes online
No data movement needed
Memory
–
–
Grow and shrink shared memory
and buffer cache online
Auto tuning of memory online
Disk
–
–
–
Add/remove disks online
Automatically rebalance
Move datafiles
Oracle RAC 10g - Only Solution
for Enterprise Grids
Mission Critical Quality of Service on
Industry Standard, Low Cost Servers
Complete, Integrated Oracle Clusterware
Runs all Applications
Provides Capacity on Demand
RAC Made Easy for Everyone
Automatic Service Provisioning
Next Steps….
Recommended Oracle RAC sessions
–
Oracle RAC 10g Cluster: Diagnosis & Verification
Monday 4 pm, Room 104
–
Oracle RAC 10g: Managing Your Cluster
Tuesday 11 am, Room 104
–
Oracle RAC 10g: Running Mixed Workloads
Tuesday 4 pm, Room 104
–
Oracle RAC 10g: Continuous Services for the Grid
Wednesday 11 am, Room 104
–
Oracle RAC: Best Practices on Linux
Wednesday 1 pm, Room 104
–
Oracle RAC: Customer Roundtable
Wednesday 4:30 pm, Room 104
–
Real Application Cluster Guru Chat
Thursday 12 noon, Guru Lounge
Next Steps….
See RAC demos in Database DEMOgrounds
–
–
–
–
Manageability
High Availability
Scalability
Sims Online
Visit the RAC web sites for more information
http://otn.oracle.com/products/database/clustering
Also see online recordings of these presentations:
–
–
Oracle Database 10g: The Self-Managing Database
Richard Sarwal, Monday 1 pm, Moscone Rm 103
–
Enterprise Manager: Making the Grid a Reality
Jay Rossiter, Monday 2:30 pm, Moscone Rm 103
QUESTIONS
ANSWERS
Reminder –
please complete the
OracleWorld online session
survey
Thank you.