FTS worklog

Contacts

Worklog

• Production RAC
• Host: lcgr1-v(pref),lcgr2-v(avail) / Service name: lcg_fts.cern.ch
• Accounts:

• 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

• 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).

• 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

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%?

*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