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

FTS worklog

Contacts

ADC-DP: Miguel Anjo GD: Gavin Mccance

Worklog

Miguel Anjo, 27/10/2005, 16:00, wiki
  • Production RAC
  • Host: lcgr1-v(pref),lcgr2-v(avail) / Service name: lcg_fts.cern.ch
  • Accounts:
owner reader writer expected_2006 max_conn
lcg_fts_prod lcg_fts_prod_r lcg_fts_prod_w 20GB 150
Note: Any changes to the values above should be notified
  • Connection url:
   (DESCRIPTION=
      (LOAD_BALANCE=no)
        (ADDRESS=(PROTOCOL=TCP)(HOST=lcgr1-v.cern.ch)(PORT=1521))
        (ADDRESS=(PROTOCOL=TCP)(HOST=lcgr2-v.cern.ch)(PORT=1521))
        (CONNECT_DATA=(SERVICE_NAME=lcg_fts.cern.ch)))
  • Monitoring: EM, sms, monpack (quota+ts monitoring/miguel, session monitoring/jacek)
  • Backups: every 10 minutes

Miguel Anjo, 15/09/2005, 10:00, wiki

  • Pilot machine moved host
  • Host: grid8.cern.ch / Service name: fts-pilot.cern.ch

Miguel Anjo, 31/05/2005, 16:00, wiki
  • Production machine
  • Host: fts.cern.ch / Service name: fts_prod.cern.ch
  • Accounts to be created: done
    • schema owners: fts_sc3prod, fts_alice, fts_atlas, fts_cms, fts_lhcb, fts_dteam, fts_glite
    • application: fts_sc3prod_w, fts_alice_w, fts_atlas_w, fts_cms_w, fts_lhcb_w, fts_dteam_w, fts_glite_reader, fts_glite_writer
  • Tablespaces to be created: homonimous to owner accounts done
  • Initial size of tablespaces: fts_sc3prod 20GB, each other 5GB, autoextensible to double done
  • Monitoring: EM, sms, monpack (quota+ts monitoring/miguel, session monitoring/jacek) done
  • Backups: every 10 minutes done
  • A dedicated connect string, fts_prod, has been added to tnsnames (marta).

Miguel Anjo, 24/05/2005, 16:00, wiki
  • Pilot machine
  • Host: grid2.cern.ch / Service name: fts.cern.ch
  • Accounts to be created: done
    • schema owners: fts_sc3prod, fts_alice, fts_atlas, fts_cms, fts_lhcb, fts_dteam, fts_glite
    • application: fts_sc3prod_w, fts_alice_w, fts_atlas_w, fts_cms_w, fts_lhcb_w, fts_dteam_w, fts_glite_reader, fts_glite_writer
  • Tablespaces to be created: homonimous to owner accounts done
  • Initial size of tablespaces: fts_sc3prod 20GB, each other 5GB, autoextensible to double done
  • Monitoring: EM, monpack (quota+ts monitoring/miguel, session monitoring/jacek) done
  • Backups: every 20 minutes done

Gavin Mccance, 19/05/2005, 16:06, email

I think we agreed 6 accounts eventually:
1 for production throughput account and 5 for the 4 VOs + dteam to play with. The names for them I'm not bothered: they should probably have sc3prod, atlas, cms, alice, lhcb, dteam, in them respectively.
As for quota, its not clear. I estimated for you the daily volume on the production throughput account at 300-500 MB per day not including indices (the space of which i don't know how to estimate), assuming we are running at 1 GB/s.
...
As for the 5 VO accounts.. the transfer rate will be much lower than 1 GB/s, so the DB volume will be lower. Say 10 of the figure for the production account%?


Marta Jakubowska-Sobczak, 06/07/2005, 15:52, wiki

*The explanation of usage host and service name to connect to the database.
It can be used in so called "easy connect identifiaction" which has the following form:
sqlplus user_name/password@host/service_name

This requires 10g version of client. On lxplus it can be set by:
/afs/cern.ch/project/oracle/script/setoraenv.csh -s 10103
or
/afs/cern.ch/project/oracle/script/setoraenv.sh -s 10103


Edit | Attach | Watch | Print version | History: r12 < r11 < r10 < r9 < r8 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r12 - 2005-11-29 - unknown
 
    • 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