Remove support for MySQL
The only site we were aware of using MySQL as the DB backend for the CTA Catalogue have now confirmed that they are no longer using it:
We use PostgreSQL as the DB backend partly in that CTA team advise to use it. From our experience of using MySQL, the performance of MySQL may not meet our need (we didn't tune MySQL to improve performance). PostgreSQL works well in our production setup for BESIII and LHAASO, and we have no problem related to it so far. We shall not use MySQL as the DB backend anymore in CTA for now and in the future. So if no others run CTA with MySQL, I think you could drop related codes at will.
As there are no known use cases for MySQL and there are known performance issues with MySQL, we will drop support for it.
All MySQL-related code should be removed from CTA, including all dependencies such as linked libraries.
Tasks
-
Write a script to populate MySQL DB from JSON output of statistics tool, add it to CTA operations repo -
Remove update MySQL DB from statistics tool -
Deploy script and updated statistics tool in Rundeck job -
Remove all MySQL dependencies from CTA code