cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Not a customer? Start a free trial

Click the Start a free trial link to start a 15-day SaaS trial of our product and join our community as a trial user. If you are an existing customer do not start a free trial.

AppDynamics customers and established members should click the sign in button to authenticate.

Knowledge Base

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/

 

______________________________________Was 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!Was 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
Last update:
‎09-07-2018 03:34 PM
Updated by:
Labels (1)
By replying you agree to the Terms and Conditions of the AppDynamics Community.
0 Kudos