AppDynamics Knowledge Base

Is AppDynamics able to monitor MemSQL DB?

Is AppDynamics able to monitor MemSQL DB?

Question

Is AppDynamics able to monitor MemSQL DB? 

Answer

Yes.

MemSQL is wire-compatible with MySQL.

MemSQL uses the MySQL jdbc libraries for connectivity.

AppDynamics database agent can monitor the MemSQL DB if configured like this:

1. Install database agent

    https://docs.appdynamics.com/display/PRO43/Install+the+Database+Agent

2. Configure a collector using the following details: (refer memsql-collector.png)  https://docs.appdynamics.com/display/PRO43/Configure+MySQL+Collectors

         Database Type - MySQL

         Host - MemSQL db host

         Port - MemSQL db listener port

         user name & password - should be entered

image.png

3. User permissions should be as mentioned in the document: https://docs.appdynamics.com/display/PRO43/Configure+MySQL+Collectors#ConfigureMySQLCollectors-permi...

4. Upon successful installation and configuration, the data will be reported as shown in the following screenshots.

image.pngimage.pngimage.pngimage.png 

Note the above is tested with following artifacts:

1. MemSQL Enterprise Trial version

2. Database agent 4.3.1.x

3. Controller version 4.3.3.x

References:

https://en.wikipedia.org/wiki/MemSQL

https://www.memsql.com/content/architecture

https://docs.memsql.com/

______________________________________image.pngWas this helpful? Give it kudos [click on the thumbs up icon at the end of the article, bottom left corner] to let others know too!

Do you have a question or need clarification? [Post Your Comment] Below.  

Labels (1)
Version history
Last update:
‎12-13-2017 05:53 PM
Updated by: