Deploying the CADC-TAP service with a MySQL Science Database

Hello,

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?

Thank you,
Stelios Voutsinas

1 Like

Hi Stelios
There is no MySQL backend implementation for https://github.com/opencadc/tap. You will find oracle and postgres implementations there that can serve as examples if you were looking to develop one.
Cheers
Séverin