MYSQL Configuration Changes
Hi
We are in the process of Production Deployment of Linode Manage Databases. After creating Linode Managed Database Cluster, we want to change some of the configurations inside my.cnf file.
Could you please let us know whether it is possible to change the configuration inside my.cnf file and if so, how we can access those file as in case with Managed Database?
Do we have shell access to the Mysql Environment?
Kindly let me know if you need any further information from my side
1 Reply
tlambert
Linode Staff
The limits and considerations of the Managed Database service are mentioned on the Product Page. There we note that Configuration files (such as my.cnf) cannot be directly edited. Changes need to be made using Server System Variables and are not persistent after a reboot. However, if you would like certain changes made to your configurations, you can reach out via Support ticket and to see if the change is something our Administrators can accommodate.
"Do we have shell access to the Mysql Environment?"
While you do not have SSH access to the nodes within the Managed Database cluster, you do have access mysql shell access. You'll need to have the MySQL client installed an ensure your client IP is added to your access control list. You will then use the following string to connect:
mysql -u linroot -p -P 3306 -h <cluster connection host> --ssl-mode=VERIFY_CA --ssl_ca=<the cert file>
Connections can also be made using the MySQL Shell advanced client.