Unbreakable Architecture - PowerPoint PPT Presentation

Loading...

PPT – Unbreakable Architecture PowerPoint presentation | free to download - id: 80545a-MWVmM



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

Unbreakable Architecture

Description:

Agenda Achieving High Availability Maximum Availability Architecture (MAA) Overview MAA Components Performance Considerations MAA Test Lab Q & A High Availability is ... – PowerPoint PPT presentation

Number of Views:18
Avg rating:3.0/5.0
Slides: 32
Provided by: Lawr100
Learn more at: http://www.sqlquery.com
Category:

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: Unbreakable Architecture


1
(No Transcript)
2
Ashish Prabhu Douglas UtzigHigh Availability
Systems Group Server Technologies Oracle
Corporation
3
Maximum Availability Architecture Oracle's Recipe
For Building An Unbreakable System
4
Agenda
  • Achieving High Availability
  • Maximum Availability Architecture (MAA) Overview
  • MAA Components
  • Performance Considerations
  • MAA Test Lab
  • Q A

5
High Availability is
Best Practices
RAC
?
?
Oracle9iAS
6
Causes of Downtime
7
High Availability Goal
  • Design and validate the best, integrated High
    Availability solution
  • Unbreakable Architecture
  • Handle all outages at all tiers
  • Best Practices
  • Cookbook for prevention, avoidance, mitigation,
    and recovery
  • Configuration, operational, outage solutions,
    restore fault tolerance
  • Complete out-of-the-box high availability
  • Tested and validated solution

Unbreakable Architecture Best Practices
Maximum Availability
8
Maximum Availability Architecture
  • Best Oracle High Availability Architecture
  • Blueprint for Database and Oracle9iAS
  • Guidelines for hardware and non-Oracle
    softwarebut platform, OS, storage, network,
    independent
  • Evolves with new Oracle versions and features
  • Best Practices
  • Configuration and operational
  • Outages and detailed solutions
  • Restoring fault tolerance after an outage

9
Maximum Availability Architecture
10
Secondary Site
  • Secondary Site is a Mirror of the Primary Site
  • Resolve unscheduled outages quickly and easily
  • Allow site-wide scheduled outages
  • Same Service Levels
  • Predictable performance and response time
  • Site transparency
  • Consistent Procedures and Processes
  • Reduces administrative complexity

11
Highly Available DatabaseReal Application
Clusters
  • Fast Failover
  • Protection from local site system failures
  • Faster than cold cluster failover solution
  • Fast-start fault recovery (instance failure MTTR)
  • Availability and Accessibility
  • Allows for scheduled outages
  • Add and remove nodes transparently
  • Transparent Application Failover (TAF) provides
    uninterrupted service

12
Highly Available DatabaseReal Application
Clusters
  • Higher Scalability
  • All system resources from all nodes are leveraged
  • Cache fusion eliminates need to partition data or
    modify the application fully application
    transparent
  • Connection load balancing distributes connection
    requests from application tier
  • Manageability
  • Provides a single image of the database to manage

13
Highly Available DatabaseOracle Data Guard
  • Data Protection
  • Protection from site failures, data failures,
    human errors, and corruptions
  • Protection modes balance availability with
    performance
  • Apply delay prevents user error propagation
  • Greater protection, performance, and
    manageability compared to remote mirroring
    solution
  • Offload processing from primary database system
  • Role Management
  • Switchover operation for scheduled outages
  • Failover operation for unscheduled outages

14
Highly Available ApplicationOracle9iAS
  • Availability
  • Oracle9iAS J2EE (OC4J) and Web Cache clustering
    for protection against system outages
  • Automatic monitor and restart of failed processes
  • Application state preserved through failures
  • Add and remove nodes transparently
  • Scalability
  • Hardware network load balancer distributes client
    requests to Web Cache
  • Web Cache clustering for distributed caching and
    load balancing across multiple OC4J instances

15
Highly Available ApplicationOracle9iAS
16
Network Infrastructure
  • Wide Area Traffic Manager to direct client
    traffic to proper site
  • Network load balancer to distribute incoming
    requests
  • Dedicated, fast link between sites
  • Influences production database performance
  • Redundant components and paths
  • Network paths to the site and within the site

17
Best Practices
  • Configuration
  • Detailed recommendations for Oracle software
  • Features to use, parameters to set
  • Guidelines for hardware and other software
  • Operational
  • Technical e.g. Switchover and failover
    procedures
  • Logistical e.g. Change management
    considerations
  • Emphasis on outages
  • Outages to monitor
  • Detailed steps to resolve outages
  • How to restore fault tolerance

18
Best Practices
Operational
Configuration
Monitor for Outage
DatabaseOracle9iASOSStorageNetwork
Detect Outage
Restore Fault Tolerance
Resolve Outage
19
HA and Performance
  • Combining high availability and performance
  • Secondary site with identical configuration as
    primary site
  • Network bandwidth and latency between sites
  • Data Guard protection mode
  • Instance recovery time

20
Network Bandwidth / Latency
  • Network bandwidth and latency between sites
    influences commit response time
  • Longer network latency will increase response
    time
  • Remote write network round trip time local
    write I/O time at secondary site
  • Network bandwidth should be greater than maximum
    redo generation rate

21
Database Protection Modes
  • Balance performance with level of protection from
    human error, data failures, and disasters
  • Maximum Protection and Maximum Availability modes
  • No-data-loss protection, but can have a
    performance impact on production service levels
  • Maximum Performance mode
  • Data loss possible, but less impact on production
    service levels

22
Instance Recovery Time
  • Balance performance with level of protection from
    system faults and crashes
  • Short instance recovery times can be achieved
    with negligible impact on performance
  • Provided sufficient I/O capacity exists to handle
    additional data block writes generated
  • Fast-start checkpointing makes instance recovery
    time-bounded and predictable

23
Instance Recovery Time
24
MAA Test LabOracle, Sun, HP, EMC, F5
25
Maximum Availability Architecture
  • Best Oracle High Availability Architecture
  • What to use
  • Best Practices
  • How to build it
  • How to manage it
  • How to fix it

26
MAA Information Sources
  • Oracle Technology Network
  • High Availability Collateral section
  • Maximum Availability Architecture - Overview
  • Maximum Availability Architecture The Details
  • http//otn.oracle.com/deploy/availability/techlist
    ing.html
  • Oracle Consulting Advanced Technologies
    Solutions (ATS) Group
  • http//otn.oracle.com/consulting/9iServices/conten
    t.html

27
Next StepsSessions by Oracle Database
Development
Tuesday
Monday
  • RAC The Present, The Future, but not Science
    Fiction
  • Mon, 1pm -- Moscone Room 103
  • Running Your Applications on Oracle Real
    Application Clusters
  • Mon, 11am -- Moscone Room 134
  • Real Customers, Real Application Clusters, Real
    Results
  • Mon, 4pm -- Moscone Room 134
  • Deploying A Highly Manageable Oracle Real
    Application Clusters Database
  • Mon, 530pm -- Moscone Room 134
  • Breaking All the Rules with The Unbreakable
    Database
  • Tue, 11am -- Moscone Room 103
  • Oracles Recipe For Building An Unbreakable
    System
  • Tue, 1pm -- Moscone Room 134
  • Bullet-Proof Data Protection with Oracle Data
    Guard
  • Tue, 4pm -- Moscone Room 134

For More Info On Oracle HA Go To
http//otn.oracle.com/deploy/availability/
28
Next StepsSessions by Oracle Database Development
Wednesday
  • Getting Under The Hood With Data Guard SQL Apply
  • Wed, 830am -- Moscone Room 134
  • LogMiner, Flashback Query and Online
    Redefinition Power Tools For DBAs
  • Wed, 11am -- Moscone Room 134
  • Are You Using The Best To Protect Your Enterprise
    Data?
  • Wed, 4pm -- Moscone Room 252
  • Oracle LogMiner - Not Just An Error Recovery Tool
  • Wed, 530pm -- Moscone Room 102

For More Info On Oracle HA Go To
http//otn.oracle.com/deploy/availability/
29
Next StepsSessions by Oracle Database Development
For More Info On Oracle HA Go To
http//otn.oracle.com/deploy/availability/
30
A
31
(No Transcript)
About PowerShow.com