1 / 26

Deployment Agility Through Tier Testing Hanan Hit, NoCOUG President 2009

Deployment Agility Through Tier Testing Hanan Hit, NoCOUG President 2009. www.dbapros.com. Agenda. Intro to testing Load testing challenges Tier load testing Snapshot standby d atabases Demonstration. DBA PROS, Inc. Confused?. So Are we. ORION. Load Runner.

Download Presentation

Deployment Agility Through Tier Testing Hanan Hit, NoCOUG President 2009

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Deployment Agility Through Tier Testing Hanan Hit, NoCOUG President 2009 www.dbapros.com

  2. Agenda • Intro to testing • Load testing challenges • Tier load testing • Snapshot standby databases • Demonstration DBA PROS, Inc.

  3. Confused? So Are we. ORION Load Runner Availability Testing Hammerora Rapid Bottleneck Identification Oracle Application Testing Suite Burn out testing Real Application Testing

  4. Test and Validate Why? 46 percent of users permanently or temporarily abandoned their relationship with a preferred site because of technical difficulties or performance problems. Source: Jupiter Media Metrix Consumer Study

  5. Performance Testing

  6. Load Testing Challenges Test Development Long development cycles for scripts and scenariosSimulated dataHuman resource intensive for test development Automated data collectionAutomatic parsing of dataAutomatic script creation100% reliable and authentic production dataReduce scripting time

  7. Load Testing Challenges Results Analysis Data analysis after collection of dataDifficult to interpret resultsLots of expertise required Integrated software for deep-dive analysisVisual correlation across platforms, tiers, and clustersEasy interpretation of results

  8. Throughput and Concurrency • Throughput • The amount of data the system can support, measured in hits per second, pages per second and megabytes of data per second . • Concurrency • Number of independent users simultaneously connected and using an application.

  9. Database Tier Infrastructure Tier Application Tier Database Servers Fire wall Fire wall Load Balancer Storage Streaming Media Server Web Servers Load Test Application Servers Gather Metrics Measure Performance … Tier Load Testing • Diagnose by logical tiers • Create specific tests for application and database tiers

  10. Ex: Back-end Database Testing Traditional Testing New Testing Method 1,000s of vUsers Back-end Concurrent Active Sessions Database Middle Tier • Less resources • UI independent • Less time Concurrent Active Sessions Database

  11. Database Replay Overview

  12. Test and Validate • 100% authentic production load reproduction • Unified back-end and front-end load testing

  13. OATS

  14. Snapshot Standby Databases • Ability to open a physical standby database for testing or QA purposes while simultaneously collecting production changes for immediate application in case disaster recovery is required. • snapshot standbydatabase still accepts redo information from its primary but it does not apply the redo to the database immediately; instead, the redo is only applied when the snapshot standby database is reconverted back into a physical standby DBA PROS, Inc.

  15. Setting Up Test Environment Using Snapshot Standby Databases Physical standby database Redo stream Open database Back out changes Redo stream Perform testing Snapshot standby database SQL> ALTER DATABASE CONVERT TO SNAPSHOT STANDBY;

  16. Steps for Snapshot Standby Load testing • Prerequisite – • Oracle Database 11g installation (software and db installed) on 1 server and Oracle Database 11g software only on 2nd server • Enable Flashback database on the Physical standby if not already enabled • Convert the Physical standby to a Snapshot standby • Verify that the redo is still being shipped to the standby • Execute Load test • Verify DML on few tables DBA PROS, Inc.

  17. Steps for Snapshot Standby Load testing • Convert the snapshot standby back to a Physical standby • Switch logs on the primary • Stop the apply process when the standby is caught up with the primary • Open the physical standby database read only • Shutdown and restart physical standby • Restart the MRP process • Verify that the Snapshot changes no longer exist DBA PROS, Inc.

  18. Creating Physical Standby with RMAN

  19. Start the MRP and Broker Creation • Standby • Primary

  20. Add your physical standby database to the broker configuration

  21. Convert the Physical Standby Database to a Snapshot Standby Database • Standby • Standby

  22. Execute Load Test

  23. Converting the Snapshot Standby Database to a Physical Standby Database

  24. Stop the MRP and Open the physical standby database in read-only mode • Standby • Standby

  25. Shut down the physical standby database and restart it in MOUNT mode • Standby • Standby • Invoke DGMGRL and restart the MRP process

  26. Tackle Load Testing Challenges Development, Results Analysis, Reusability Long development cycles Simulated data Difficult to interpret results Lots of expertise required High cost and resource intensive Dedicated / Shared Labs Only when application Change Automate test development Use production data Secure in-cloud load testing Integrated deep-dive analysis Easy interpretation of results Back-end testing Use less resources Use real production hardware CPU Patch has to be tested

More Related