I was wondering if it is possible to deploy the CADC-TAP service that comes with the RSP deployment, connected to a MySQL database rather than QServ?
We’ve been deploying & customizing the RSP to enable use as a prototype with our Science Databases at the University of Edinburgh. We deploy on Kubernetes with the lsp deployment scripts here: https://github.com/lsst-sqre/lsp-deploy/tree/master/develop-gke
As a first attempt I tried editing the qserv_host parameter here: https://github.com/lsst-uk/lsp-uk/blob/master/helm/charts/cadc-tap/values.yaml#L12 and the JDBC user/pass combination here https://github.com/lsst-uk/lsp-uk/blob/master/helm/charts/cadc-tap/templates/tap-deployment.yaml#L33
However that wasn’t successful, with connection errors appearing in the logs. (I was also a bit confused about why the error shows a failed connection for the JDBC username I was providing, but using the IP of the TAP Server pod rather than the host IP I provided )
As this was just a shot in the dark, and I imagine that Qserv & MySQL cannot be used interchangeably, can anyone comment on if this is a possibility with the existing codebase, or if it would require significant extensions to enable MySQL database support?