Knowledge Base

cancel
Showing results for 
Search instead for 
Did you mean: 

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

memsql-collector.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.

memsql4.pngmemsql3.pngmemsql2.pngmemsql1.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/

 

______________________________________Thumbs Up Icon Kudos Screen Shot 2017-12-11 at 12.22.35 PM.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.  

 

Version history
Revision #:
6 of 6
Last update:
‎09-07-2018 03:34 PM
Updated by:
 
Labels (1)
0 Kudos