Database Meeting 2022-04-13

Summary notes from 3rd Data Facilities Planning Workshop - 2022-04-05/07

?

Context:

• what's the role of this setup? Migrating from NCSA? Setting up an advanced development platform? Serving LSST needs for DP02, ComCam and beyond?
• there is an ongoing discussion on the first batch of hardware for installing Qserv at USDF
• a couple of technical questions still exist

Context:

• the new version of the R-I system adds the worker registry that needs to be integrated into the operator
• the latest bugfix release of Qserv should be used by the operator: qserv/lite-qserv:2022.4.1-rc1

Support for ingesting the image metadata tables Visit  and CcdVisit into Qserv has been added. Both tables have been test-ingested into the 

Questions/problems that are still remaining:

• technical aspects of using Felis as a "source of truth" for preparing table schemas as needed by the Qserv ingest protocol (JSON is expected, while Felis  s still producing the "traditional" MySQL CREATE TABLE  statements.
• publishing/unpublishing/extending catalogs to add more tables and adding rows to existing tables. What protocol/API do we need here?