Administering your local Controller database

[CommunityUser]

Hello All,

AppDynamic recommends we use a number of suggested SQL management tools to administer our local controller databases.

What are you guys using on a windows plaform.

Does anyone use SQL server 2008 / MySQL?

Suggestions?

regards,

Dennis

[Arun_Dasetty]

Hi ,

We understood that you are referring to controller database, let us know if any disconnect?

If the above said is right, appdynamics controller comes with inbuilt MySQL database which is used to persist data sent by agent associated on application servers.

Yes, you can monitor controller database using APPD4DB tool for more details , http://docs.appdynamics.com/display/ADDB/Install+and+Get+Started+with+AppDynamics+for+Databases

http://docs.appdynamics.com/display/ADDB/Set+Up+the+Agents

Or you can use mysql tools like mysql workbench, etc to browse controller database, steps to login controller database from shell:

shell> cd <controller_install_dir>/bin

shell> contoller.bat start-db
shell> contoller.bat login-db

Let us know if that clarifies your query , let us know if any disconnect in our understanding.

Thanks,

Arun