/
RAC Load Test Plan

RAC Load Test Plan

Jan 24, 2008

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.