Type: Technical task
Fix Version/s: None
Team:Data Access and Database
We are preparing to release the new lsst-dev-db.ncsa.illinois.edu database server to replace the current lsst-db. This ticket is to ask recommendations of configuration and possible changes to the new server. I’m targeting either our Dec 14 or Jan 18 planned maintenance for this release.
lsst-dev-db can be accessed via SSH from any LSST server at NCSA. It is running the latest version of MariaDB 10.1 available from MariaDB's yum repositories. Currently it has no specific configuration tuning or optimizations in place.
The new server is named lsst-dev-db.ncsa.illinois.edu to better reflect it’s intended purpose. Once this server is ready to go live, we’ll redirect the hostnames lsst-db & lsst10 to point to the new server.
Can you or someone on your team help vet and optimize this new server? It currently has a copy of lsst-db data from November 15, 2017.
Could you help with recommending the following?
- Any MariaDB 10.1 tuning & optimizations that would make sense.
- If MySQLdb / MySQL-Python needs to be installed.
- If the scisql tools need to be installed/updated.
- If any other UDFs need to be installed/updated.
Also, I’d like to start addressing the following issues:
- 5.7/10.1 requires updated user password formats (currently disabling secure_auth option to allow existing passwords). We need a plan for users to upgrade their passwords.
- Can we push forward with SSL encrypted sessions?
- And/or can we switch authentication over to NCSA/LSST LDAP?