IBM Support

How to Configure more than one MySQL Instance

How To


Summary

The Instana agent supports different users and passwords for multiple MySQL instances.

Steps

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

ibm16998005