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.