IBM Support

Multi MySQL monitoring

How To


Summary

How to Configure more than one MySQL Instance to be monitored

Objective

The Instana agent supports different user/passwords for multiple MySQL instances. 

This is an example of how they can set up several instances of MySQL in docker:

#agent config: 
   com.instana.plugin.mysql: 
     user: 
     configuration_from: 
       type: env 
     env_name: INSTANA_USER 
       password: 
     configuration_from: 
       type: env 
     env_name: INSTANA_SIFRA 
       #start 2 mysql instances in docker: 
#  instance 1 
     docker run \ 
       --name mysql1 \ 
       -e MYSQL_ROOT_PASSWORD=instana123 \ 
       -e INSTANA_USER=user1 \ 
       -e INSTANA_SIFRA=pass1 \ 
       -d mysql:5.7.38 
#  instance 2 
     docker run \ 
       --name mysql2 \ 
       -e MYSQL_ROOT_PASSWORD=instana123 \ 
       -e INSTANA_USER=user2 \ 
       -e INSTANA_SIFRA=pass2 \ 
       -d mysql:5.7.38

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSE1JP5","label":"IBM Instana Observability"},"ARM Category":[{"code":"a8m3p000000UoUHAA0","label":"Agent-\u003EReq - Install - Config"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

Document Information

Modified date:
08 August 2023

UID

ibm17000917

Page Feedback