Bundled MySQL Database Version

The Controller uses MySQL as its default database, where it stores configuration data, metrics data, transaction snapshot data and events, and the history of incidents that occurred (both resolved and unresolved incidents are stored). The MySQL database files are installed in <controller_home>/db by default.

The latest Splunk AppDynamics On-Premises release bundles MySQL version 8.4.

Check MySQL Version

To check what your MySQL version is in your Controller, you can run the following command:

<controller_home>/bin/controller.sh login-db
select version();

Upgrade MySQL Version

Optionally, after you install or upgrade the Controller, you can upgrade the MySQL version with the Enterprise Console. Note that you cannot reverse this process.

Note:
  • If the Controller MYSQL version is less than 5.7 version, you must upgrade Controller's MYSQL to 5.7 version.
  • Any fresh installations or upgrades from older Controller versions to 23.7 continue to use MYSQL 5.7 version by default.
  • You can upgrade the Controller MYSQL to version 8.0 after you upgrade the Enterprise Console and the Controller.
You can upgrade the MySQL to the version 8.0 on the Controller page in the GUI or with the following command:
Linux
CODE 
bin/platform-admin.sh submit-job --job mysql-upgrade --service controller --args mysqlRootPassword=<database root password>
Windows
CODE 
bin/platform-admin.exe cli submit-job --job mysql-upgrade --service controller --args mysqlRootPassword=<database root password>