This topic provides an overview of how to configure and administer Controller data storage.
The Controller requires persistent data storage to store the following type of information:
By default, the AppDynamics Controller uses MySQL as its storage mechanism. The Controller bundles a MySQL instance with the Controller. At installation time, the installer creates the necessary tables and artifacts in the database.
By default, the database files and data are stored in: <Controller_Installation_Director>/db.
The installer creates the user account that the Controller uses to log into the database to perform database-related operations. The username of the account is "root", and the password is the one you supply to the installer during the installation process.
If you changed the password for the Controller's database user in the database management system, you need to configure the Controller to use the new password. By default, the Controller stores the password on disk at the following location:
When it access the database, it attempts to read the password from that location. For security reasons, or to facilitate automation, you may choose to keep the password in an environment variable or by supplying it at the command line instead of the file.
When attempting to access the data, the Controller reads the database user password from these sources and in the priority shown:
If you do not keep the password in the environment variable or the .rootpw file, you will need to supply it in response to a command line prompt whenever performing an operation that involves accessing the database, such as starting the Controller (since this requires starting the database), starting the database, stopping the database, or logging into the database.
After installation you can move the data directory to a new location. The following conditions can make it necessary to move the data:
Note: If you are using symlinks, you must create the symlink outside of the root Controller install directory and move the data directory to the new volume after you install the Controller.
Warning: Do not mount a file system on <Controller_Installation_Directory>/db/data. During Controller upgrade, the installer moves the data directory to data_orig. Upgrade will fail if the installer cannot complete this move.
Modify following properties in the <Controller_Installation_Directory>/db/db.cnf file to point to the new location of the data directory.
datadir tmpdir log slow_query_log_file
Copy (or move) the existing data directory <Controller_Installation_Directory>/db to the new location.
For example, to copy the data on Linux:
cd <Controller_Installation_Directory>/db/ cp data <new-location>
See the following topics for more information on administering AppDynamics data: