IT-ASDF: Lessons learned from DBoD Major Upgrades

513/1-024 (CERN)



Show room on map
Zoom Meeting ID
IT Activities and Services Discussion Forum (ASDF)
Jorge Garcia Cuervo
Alternative hosts
Charles Delort, Ismael Posada Trobo, Stefan Nicolae Stancu, Enrico Bocchi, Pablo Martin Zamora, Karolina Przerwa, Nikos Papakyprianou
Useful links
Join via phone
Zoom URL
    • 4:00 PM 4:40 PM
      Lessons learned from DBoD Major Upgrades 40m
      Speakers: Abel Cabezas Alonso (CERN), Maurizio De Giorgi (CERN)

      The post-presentation discussion addressed several crucial aspects of database management, user group administration, password security, and upgrade protocols:

      **Expired Instances and Forced Upgrades**: Participants deliberated on whether expired instances should be automatically removed or if forced upgrades should be pursued. While acknowledging the complexities involved in forced upgrades, such as changes in OpenSSL and encryption requirements for passwords, the consensus leaned towards allowing instances to expire naturally rather than forcing upgrades.

      **Database Management**: Strategies for distinguishing between personal and professional databases were discussed. It was noted that personal databases are typically purged if they lose their owner. However, concerns were raised about the potential need to separate CERN clubs databases from supervisor assignments, though this aspect hadn't been thoroughly considered.

      **User Group Management**: Attention was drawn to the issue of expiring e-groups, with the default expiration date being one year. Suggestions were made to provide a dump of all e-groups for verification, and there was a request for an annual overview plan for ITUM to aid in preparation.

      **Upgrade Strategies**: Discussions revolved around the frequency of upgrades and the need for clear communication regarding upgrade plans. It was noted that sometimes upgrading multiple versions in advance could streamline the process and avoid incremental updates.

      **Automatic Transfer of Ownership**: Concerns were raised about the lack of acknowledgment from new owners during the automatic transfer of ownership process for databases. The importance of communication and resolution of such issues was emphasized to prevent databases from being left in limbo.

      **Problem Management**: The post-presentation discussion briefly touched upon the volume of problems encountered, typically numbering in the hundreds. Questions were raised about whether the number of problems fluctuates with minor upgrades, which would be assessed following the current campaign.