# Deploying the CADC-TAP service with a MySQL Science Database

**URL:** <https://www.rubin.community/t/deploying-the-cadc-tap-service-with-a-mysql-science-database/4442>\
**Category:** Rubin Science Platform\
**Tags:** cadc-tap\
**Created:** [October 3, 2020, 12:34pm UTC](https://www.rubin.community/t/deploying-the-cadc-tap-service-with-a-mysql-science-database/4442 "2020-10-03T12:34:25Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![stvoutsin](https://sea2.discourse-cdn.com/flex002/user_avatar/www.rubin.community/stvoutsin/32/1218_2.png) [@stvoutsin](https://www.rubin.community/u/stvoutsin)\
**Post date:** [October 3, 2020, 12:34pm UTC](https://www.rubin.community/t/deploying-the-cadc-tap-service-with-a-mysql-science-database/4442/1 "2020-10-03T12:34:25Z")

</div>

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](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](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](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

---

<div class="post-metadata">

**Author:** ![severingaudet](https://avatars.discourse-cdn.com/v4/letter/s/5daacb/32.png) [@severingaudet](https://www.rubin.community/u/severingaudet)\
**Post date:** [October 23, 2020, 10:23pm UTC](https://www.rubin.community/t/deploying-the-cadc-tap-service-with-a-mysql-science-database/4442/2 "2020-10-23T22:23:36Z")

</div>

Hi Stelios  
There is no MySQL backend implementation for [https://github.com/opencadc/tap](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