WARNING: This web is not used anymore. Please use PDBService.PVSSStreamsTests instead!

PVSS ONLINE to OFFLINE Streams replication tests for ATLAS

People involved

  • James Cook - ATLAS online
  • Florbela Tique Aires Viegas - ATLAS offline
  • Gancho Dimitrov - ATLAS offline
  • Luca Canali - IT/PSS
  • Dawid Wojcik - IT/PSS

Installation parameters and postinstallation steps

  • preinstall - modified storage parameters in RDB_config.sql:
    define initial_size        = 1024
    define next_size           = 1024
    define storage_clause      = '(INITIAL 100M MINEXTENTS 1 MAXEXTENTS UNLIMITED)'
    define storage_clause_idx  = '(INITIAL 100M MINEXTENTS 1 MAXEXTENTS UNLIMITED)'
  • postinstall - sqlplus:
    update <ACCOUNT_NAME>.ARC_GROUP set MAX_SIZE_MB=102400;
    update <ACCOUNT_NAME>.ARC_CONFIG set value=102400 where name='def_max_size_mb';
    update <ACCOUNT_NAME>.ARC_CONFIG set value=2 where name='def_max_online';

Tests description

  • All tests have been conducted using PVSS 3.6 SP1 Oracle schemas
  • Tests involved creating PVSS (3.6 SP1) account on ATONR cluster databse and setting up streams replication to INTR database
  • Test data generated by James Cook is inserted into ATLAS_PVSS_ONL @ ATONR and replicated to ATLAS_PVSS_ONL @ INTR

Test plan

  • test maximal sustainable throughput and evaluate whether we can achieve 3-5 GB of PVSS data per day - COMPLETED
    • achieved sustained rate was around 1600LCRs/s that resulted in around 3-4Gb of PVSS data per day

  • test reading from a replicated set of data using PVSS client - COMPLETED
    • all data accessible through PVSS client

  • write large amount of data thus forcing tablespace switch to occur - COMPLETED
    • Florbela prepared a ddl_handler for streams to handle tablespace creation
    • tests successful - tablespace created on the apply side

  • test PVSS client against the replicated data again (after the switch has occured) - COMPLETED
    • data accessible through PVSS client

  • conduct streams ramp-up tests of sustained 3GB/day rate with a ramp-up of 6GB/day for a short period of time - PENDING
    • ...

  • create additional indexes on the offline replica and repeat performance and ramp-up tests

Edit | Attach | Watch | Print version | History: r7 < r6 < r5 < r4 < r3 | Backlinks | Raw View | Raw edit | More topic actions...
Topic revision: r5 - 2007-07-03 - DawidWojcik
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    PSSGroup All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2020 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback