Difference: CondDBCommissioning (12 vs. 13)

Revision 132006-09-28 - MarcoClemencic

Line: 1 to 1
 
META TOPICPARENT name="Main.MarcoClemencic"

Index

Line: 78 to 78
 
  • 30 Aug 2006
    • Privileges replication: Smooth, only a bit long (few hours).
  • 05 Sep 2006
Changed:
<
<
    • Fake PIT:
>
>
    • Fake PIT: Non trivial!
      • Followed instructions at PSSGroup.ThroughputTestsPreparation, but it was not enough...
      • Few extra roles/functions were needed (Eva provided the scripts for them)
      • Set the SGA memory limit to 700M (import phase was failing)
      • Set the DB in ARCHIVELOG mode (see this article)
 

Streaming from CERN to Tier-1

The first thing is the definition of the accounts on the Master copy. Currently we have (on the integration rack int4r_lb):
Changed:
<
<
lhcb_conddb
schema owner for the off-line conditions (alignments, etc.), 10GB tablespace
lhcb_online_conddb
schema owner for on-line conditions (those written in the PIT), 10GB tablespace
>
>
lhcb_conddb
schema owner for the off-line conditions (alignments, etc.), 10GB tablespace (LHCB_CONDDB_DATA01)
lhcb_online_conddb
schema owner for on-line conditions (those written in the PIT), 10GB tablespace (LHCB_ONLINE_CONDDB_DATA01)
 
lhcb_conddb_manager
account with read/write permission to the other schemas (he can store/tag data, but not add folders), no tablespace
lhcb_conddb_reader
account with read only permission on the main schemas, no tablespace
Line: 115 to 119
 

-- MarcoClemencic - 29 Aug 2006 \ No newline at end of file

Added:
>
>
META FILEATTACHMENT attachment="cern_profile_role_creation.sql" attr="" comment="" date="1159449696" name="cern_profile_role_creation.sql" path="cern_profile_role_creation.sql" size="2834" stream="cern_profile_role_creation.sql" user="Main.MarcoClemencic" version="1"
META FILEATTACHMENT attachment="cern_verify_function.sql" attr="" comment="" date="1159450931" name="cern_verify_function.sql" path="cern_verify_function.sql" size="4355" stream="cern_verify_function.sql" user="Main.MarcoClemencic" version="1"
 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2019 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback