BiLD-DevOps

→ Europe/Zurich
2-R-014 (CERN)

2-R-014

CERN

Christophe Haen (CERN)
Description
Bi-Weekly LHCbDirac DevOps meeting

Present: Vladimir, Federico, Zoltan, Philippe, Stefan, Joel, Ignacio, Chris

Remote: Milosz, Marcelo, Raja

 

This meeting was dedicated to the post mortem of the migrations from MySQL 5.6 to MySQL 5.7

Notes can be found here: https://hackmd.web.cern.ch/EYYwDATAHApgLARgLQFYQokuATA7AQyX310wnQDMBmATmBVxGxiA

 

Discussions lead to a todo list, as well as some lessons for next time.

Next time:

  • Run performance tests before an a setup which is the target one
  • Clean our databases from useless tables before
  • DBOD: prepare plans for quick rollback

TODO list:

  • (Ignacio + Chris): DFC situation still not understood and to be investigated
  • (Ignacio) Migration of lbtrans and dfc to CentOS7 machines
  • (Ignacio) Examine whether sql statement can be extracted from binary logs
  • (DIRAC team): write performance tests. Zoltan for the accounting, Federico for the TransformationDB, Chris for the dFC
  • (Zoltan) Add multimechanize to the DIRAC externals
  • (DIRAC team): regularly check the logs of MySQL server in the next weeks to make sure there are no errors
There are minutes attached to this event. Show them.
    • 10:00 → 10:05
      Minutes/matters from last meeting

      Any comments?

      Convener: Christophe Haen (CERN)
    • 10:05 → 10:15
      LHCbDIRAC installation: Status of servers, DBs, build machines 10m

      Post mortem of MySQL migration

      Speakers: Christophe Haen (CERN), Ignacio Coterillo Coz (CERN), Raja Nandakumar (STFC-Rutherford Appleton Laboratory (GB))
    • 10:15 → 10:35
      DIRAC/LHCbDIRAC Releases planning and installation 20m
      • Reminder: documentation
      • Reminder: CS cleaning
      • Echo: https://its.cern.ch/jira/browse/LHCBDIRAC-784
    • 10:35 → 10:40
      Conferences planning and reports (if any) 5m

      CHEP abstract https://indico.cern.ch/event/680068/

    • 10:40 → 10:45
      Reports from other meetings/decisions (if any) 5m
    • 10:45 → 11:05
      AOB
      Convener: Christophe Haen (CERN)
      • 10:45
        Atomic number of the week 20m