Shareplex for oracle l.jpg
This presentation is the property of its rightful owner.
Sponsored Links
1 / 27

SharePlex ® for Oracle PowerPoint PPT Presentation


  • 702 Views
  • Uploaded on
  • Presentation posted in: General

SharePlex ® for Oracle. A detailed technical presentation. January 2001. Presentation Overview. Introduction to Quest Software What is SharePlex for Oracle? Configuration options SharePlex architecture Customer uses and results with SharePlex Complementary solutions. DEVELOP/DEPLOY.

Download Presentation

SharePlex ® for Oracle

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Shareplex for oracle l.jpg

SharePlex® for Oracle

A detailed technical presentation

January 2001


Presentation overview l.jpg

Presentation Overview

  • Introduction to Quest Software

  • What is SharePlex for Oracle?

  • Configuration options

  • SharePlex architecture

  • Customer uses and results with SharePlex

  • Complementary solutions


Slide3 l.jpg

DEVELOP/DEPLOY

MANAGE

DB Server Development

DB Change Management

Database Performance Management

High Availability

DB & Application Monitoring

Application Offloading

The Complete Quest Solution


Slide4 l.jpg

SharePlex

Continuous, real-time

(LAN or WAN)

  • 24x7 Alternate Server

  • Relocate activities that reduce or

  • cause spikes in OLTP performance

  • - Reports & Queries

  • - Backups & Extracts

  • Reduces risks of unplanned downtime

    • Protection from ORA-600s

    • Protection from table drops

    • Reduced stress on OLTP system

OLTP Server

  • Provides up to 80% OLTP

  • performance improvement at

  • month-end by relocating

  • reports & queries

  • Enables higher daily SLA

  • Reduces planned downtime for

  • end users by enabling rolling

  • OS and ORACLE upgrades

  • Reduces planned downtime for

  • routine maintenance because

  • business can continue on the

  • other database

SharePlex®High-Speed, Log-Based ReplicationProvides Continuous Access to Continuously Updated Target Instances


Slide5 l.jpg

Configuration Options

Reporting Instance

Fail-over

Active/Active

Data Distribution

Consolidation

Discrete 2-Way

Tables A, B, C

Tables X, Y, Z


Shareplex and clustering l.jpg

SharePlex and Clustering

LAN or WAN

Remote

Database

Local

Cluster


How to set up shareplex with automated failover l.jpg

How to Set up SharePlex with Automated Failover

WWW users

SharePlex

We have customers who’ve used tools from Resonate, F5 Labs, Tuxedo, and Internap


Design goals l.jpg

Design Goals

High speed replication

  • Continuous: Uninterrupted access to target database

  • Lightweight: Minimal impact on the source

  • Complete: supports all Oracle data types

  • Accurate: respects Oracle’s read consistency

  • Fault tolerant: can withstand failures

  • Flexible, configurable, and manageable

    • Differing platforms, O/S, Oracle versions, & schemas

    • Many different replication topologies, easy to change


Architecture l.jpg

Archive

Logs

Capture

Process

Reader

Q

On-line

Redo Logs

Reader

Process

Export

Process

ExportQ

Source

System

Quest

Transport

Layer

Network

Target

System

Import

Process

Post

Q

Architecture

Post

Process

SQL


Shareplex control options l.jpg

SharePlex Control Options


How to setup shareplex l.jpg

How to Setup SharePlex

5.SharePlex Post and Query Access Resume

3. DBCopy performs

a hot backup from the source

to the target system.

1.SharePlex Post is Stopped

4. SharePlex reconciles its queues

SharePlex

2. Config listing tables to replicate is activated.


Shareplex overdrive emc 2 corp offerings l.jpg

The target instance on the 3rd mirror is accessible for queries

SharePlex replicates the transactions as they occur

SRDF from EMCsynchronously replicates to the target for DR

SharePlex Overdrive + EMC2 Corp. Offerings

3rd Mirror

SharePlex

EMC’sTimeFinder™ periodically refreshes the environment with updates to files outside the database, and/or with DDL changes

SRDF™


Shareplex improves a mirrored environment l.jpg

Protection from ORA600 Datafile Corruption Errors

Continuous updates increase value of reports

Target database is always accessible

Offloading queries improves OLTP performance

SharePlex Improves a Mirrored Environment

3rd Mirror

SharePlex

Overdrive

  • Benefits:

  • Reduces setup time

  • Simplifies DDL changes

  • Enables hot resync option

  • Facilitates live activation

  • Allows hot DBCopy


Overdrive and physical refresh l.jpg

Overdrive and Physical Refresh

4.SharePlex Post and Query Access Resume

1.SharePlex Post is Stopped

3rd Mirror

2. Refresh

SharePlex

3.SharePlex Reconciles its Queues


Audit shareplex with dataequator l.jpg

Audit SharePlex with DataEquator

  • Problem: Discover out of sync conditions too late

  • Solution: SharePlex 3.0 offers DataEquator

    • Compares the content of source and target tables without locking the source table

    • Background job to periodically audit key tables


High availability benefits l.jpg

High Availability Benefits

  • Reduces Risks of Unplanned Downtime

    • Protects against software bugs like block corruptions

    • Insulates from hardware failure

    • Shields from human error

    • Reduces stress on production instance by enabling processing to be offloaded to target instance`

  • Minimizes Planned Downtime

    • Enables hardware migration

    • Facilitates rolling upgrades

    • Supports major preventive maintenance


Minimize downtime to migrate l.jpg

Minimize Downtime to Migrate

  • Without SharePlex, extensive downtime is required to:

  • Export/import data

  • Rebuild the database

  • Verify the migration

Ultimate target

Intermediate

SharePlex

Primary

SharePlex

  • With SharePlex, end-user downtime can be minimized

    - Failback position, rather than forcing you to “go for broke”

    - Allows you to take the time required to be careful and successful


Using shareplex for migration l.jpg

  • Stop Post during an export

  • Setup replication to the new h/w

Using SharePlex for Migration

Ultimate target

1. Use DBCopy or Overdrive with a hot backup to create the intermediate database

Intermediate

SharePlex

Primary

SharePlex

  • Import the data onto the new h/w platform

  • Start Post to update the target with the updates from the primary system


Using shareplex for major maintenance l.jpg

Using SharePlex for Major Maintenance

4.SharePlex Post and Query Access Resume

3. A new SharePlex version

is installed on the target

1.SharePlex Post is Stopped

2. OS / Oracle upgrade or database rebuild is performed on the target

SharePlex


Customer performance tests l.jpg

Customer Performance Tests

Batch Processing

  • Sun E6000 source; Sun E4500 target

  • Inserted 4,000,000 rows

  • Completed on target 10 minutes later

  • 350 MB of data over LAN (source to target)

  • Bottom Line: 3000 inserts per second during the test

    Network Use

  • Using a trigger solution, replication would saturate multiple large lines, while replicating less data

  • SharePlex replicating all data (long columns, sequences) never saturated smaller line


Customer performance tests21 l.jpg

Customer Performance Tests

Performance during a Large Import

  • Unmodified installation - 32 minutes

  • Internalized triggers - 67 minutes

  • SharePlex - 33 minutes

    Installation and Maintenance

  • SharePlex can be installed in an hour

  • Full implementation in 3-10 days (or more for multi-master)

  • One-fifth of a DBA’s time during the first year


Replication tool kit l.jpg

Replication Tool Kit

Space Manager

Enables easy analysis and correction of space issues

SQLab Vision

Identifies tuning opportunities with expert advice

Schema Manager

Propagates DDL

Facilitates instance optimization

SpotLight™ for Oracle

Real-time graphical representation of the instance


Complementary quest solutions l.jpg

Complementary Quest Solutions

SharePlex FS™

Replicates files in the file system

Foglight™

Enterprise lights-out monitor with drop-in components

  • Oracle instance

  • File system

  • Server

  • Network

    LiveReorg™

    Hot reorgs for 24x7 operations


How livereorg works l.jpg

How LiveReorg Works


For more information l.jpg

For More Information

  • To read, see, and hear how our customers have used SharePlex:

    http://www.quest.com/shareplex/press-white-case.asp

    (This contains case studies, video testimonials, white papers, and press releases.)

  • Joint presentations explaining how SharePlex solved specific issues at Lucent Technology and at LSI Logic, are also on our website: www.quest.com


Shareplex is the best l.jpg

1. High performance

Low latency

Low overhead

High volumes

2. Access to continuously updated targets

3. Complete

Long columns

Sequences

4. Accurate

Maintains Oracle’s Read

Consistency

5. Faulttolerant

Log wraps

Instance failure

Physical corruption

Accidental drops

Server failure

Network failure

6. LAN & WAN support

7. Flexible configuration options

8. Easier to implement and Manage

SharePlex is the Best


  • Login