RAC Load Test Plan

Owned by Mike Wenk
Last updated: Jan 24, 2008Version comment
2 min read

Testing RAC performance under load

  • Assumptions:
    • RAC hosts will be hammer and steele

Overall Results Grid

Test 1 (Results)

  • Purpose: To test basic RAC functionality and establish a baseline for comparision
  • DB Configuration
    • Internal Hosts: Steele (Hammer is turned off)
    • External Hosts: Steele (Hammer is turned off)
    • Connect Using: LDAP string (jdbc:oracle:thin:@ldap://oraldap1.ucdavis.edu:389/sakai_steele,cn=OracleContext,dc=ucdavis,dc=edu ldap://oraldap2.ucdavis.edu:389/sakai_steele,cn=OracleContext,dc=ucdavis,dc=edu)
    • Internal: Caje(Prod) Snapshot from 12/18 AM.
    • External: SAK-1202 running on a manually managed tablespace.
    • Special Notes: None
  • Sakai Configuration
    • Tag: sakai_2-4-x-HEAD-prod-008 with distauth.patch applied.
    • Servers: braddock.ucdavis.edu
  • Silk Configuration
    • Project: Smartsite-Test RAC
    • Script: SmartsiteViewing.bdf
    • Test Time: 1 hr 15 mins
    • Max Users: 100
    • Workload: Increasing - Starting at 25 increasing 5 users every 15 seconds.
  • Metrics Watched
    • Load on steele
    • Silk Metrics:
      • Transactions OK
      • Average Page Time
      • Requests Sent (Count)
      • Errors
  • Notes: None

Test 2 (Results Results 2)

  • Purpose: To test chatting while running on the RAC
  • DB Configuration
    • Internal Hosts: Steele (Hammer is turned off)
    • External Hosts: Steele (Hammer is turned off)
    • Connect Using: LDAP string (jdbc:oracle:thin:@ldap://oraldap1.ucdavis.edu:389/sakai_steele,cn=OracleContext,dc=ucdavis,dc=edu ldap://oraldap2.ucdavis.edu:389/sakai_steele,cn=OracleContext,dc=ucdavis,dc=edu)
    • Internal: Production (Unmodified from Test 1)
      • Library cache will not be cleared.
    • External: SAK-1202 running on a manually managed tablespace.
    • Special Notes: Chat will be fully turned on and maximized on this test
  • Sakai Configuration
    • Tag: sakai_2-4-x-HEAD-prod-008 with distauth.patch applied.
    • Servers: braddock.ucdavis.edu
  • Silk Configuration
    • Project: Smartsite-Test RAC
    • Script: SmartsiteChat.bdf
    • Test Time: 1 hr 15 mins
    • Max Users: 100
    • Workload: Increasing - Starting at 25 increasing 5 users every 15 seconds.
  • Metrics Watched
    • Load on steele
    • Silk Metrics:
      • Transactions OK
      • Average Page Time
      • Requests Sent (Count)
      • Errors
  • Notes: After this test is over, the database needs to be cleared.

Test 3 - It has been decided to not do test 3 at this time.

Test 4 (Results)

  • Purpose: To test RAC long term operation
  • DB Configuration
    • Internal Hosts: Steele (Hammer is turned off)
    • External Hosts: Steele (Hammer is turned off)
    • Connect Using: LDAP string (jdbc:oracle:thin:@ldap://oraldap1.ucdavis.edu:389/sakai_steele,cn=OracleContext,dc=ucdavis,dc=edu ldap://oraldap2.ucdavis.edu:389/sakai_steele,cn=OracleContext,dc=ucdavis,dc=edu)
    • Internal: TBD
    • External: SAK-1202 running on a manually managed tablespace.
    • Special Notes: None
  • Sakai Configuration
    • Tag: TBD
    • Servers: braddock.ucdavis.edu (pulled from smartsite-test's loadbalancer)
  • Silk Configuration
    • Project: Smartsite-Test RAC
    • Script: SmartsiteViewing.bdf
    • Test Time: TBD
    • Max Users: 100
    • Workload: Increasing - Starting at 25 increasing 5 users every 15 seconds.
    • Possible Workload: all Day - Peaks and valleys occuring 75 minutes. (Ie start with 20 users, 75 minutes later, go to 100, 75 minutes later, drop to 20, rinse/repeat)
  • Metrics Watched
    • Load on steele
    • Silk Metrics:
      • Transactions OK
      • Average Page Time
      • Requests Sent (Count)
      • Errors
  • Notes: Hopefully Silk Central can run this, otherwise we'll have to play it by ear the exact mechanics.