WARNING: This web is not used anymore. Please use PDBService.LFCStreamReplicationTests instead!
 
TWiki> PSSGroup Web>PhysicsDatabasesSection>LCG3DWiki>LFCStreamReplicationTests (2006-07-19, EvaDafonte) EditAttachPDF

LFC Streams Replication Tests

Objective: test replication of the LFC using Oracle Streams and Materialized Views

Accounts

The following accounts were created:

  • lcg_lfc_3d_lhcb (streams replication test schema)
  • lcg_lfc_mv_lhcb and lcg_lfc_mv_lhcb_ro (materialized views test schemas)

The following accounts were added (28/04/06):

  • lcg_lfc_3d_lhcb_10m and lcg_lfc_3d_lhcb_100m (streams replication test schemas)
  • lcg_lfc_mv_lhcb_10m and lcg_lfc_mv_lhcb_100m (materialized views test schemas)

Streams Setup

@CERN

Using the 3D testbed:

  • source database: strmtest
  • replica database: strmtestr1

Streams replication at schema level:

  • lcg_lfc_3d_lhcb (18/04/06)
  • lcg_lfc_3d_lhcb_10m (28/04/06)
  • lcg_lfc_3d_lhcb_100m (28/04/06)

@CNAF

CNAF replica database is added to the initial setup: LFCDB Streams replication at schema level:

  • lcg_lfc_3d_lhcb (27/04/06)
  • lcg_lfc_3d_lhcb_10m (06/06/06)
  • lcg_lfc_3d_lhcb_100m (06/06/06)

LFC DB replication tests for LHCb

See Replication Tests

Attachments Attachments
Topic attachments
I Attachment History Action Size Date Who Comment
Unknown file formatsql StreamsLCG_LFC_addNewSchema_DESTINATION.sql r1 manage 1.0 K 2006-04-28 - 14:42 EvaDafonte Add a new schema replication to the Streams setup (to be run on each destination database)
Unknown file formatsql StreamsLCG_LFC_addNewSchema_SOURCE.sql r1 manage 2.3 K 2006-04-28 - 14:41 EvaDafonte Add a new schema replication to the Streams setup (to be run on the source database)
Unknown file formatsql StreamsSetup_LCG_LFC.sql r1 manage 3.4 K 2006-04-28 - 14:40 EvaDafonte LFC Streams Setup @ testbed - CERN
Edit | Attach | Watch | Print version | History: r5 < r4 < r3 < r2 < r1 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r5 - 2006-07-19 - EvaDafonte
 
    • 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-2023 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