MySQL monitoring of named instance

book

Article ID: 140093

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES

Issue/Introduction

I need to know the process of monitoring named instances in mysql .

For ex : while creating connection i only see one field HOSTNAME to create connection.

Now where do i specify which instance this connection is going to connect.

I am assuming using the hostname only , it will connect to default instance only.

example scenario:

server: serverA

db instance1: serverA(default)

db instance2: ABC (named instance)

Environment

Release : 9.2.0

Component : UIM MYSQL

Resolution

  • Each MYSQL instance will need to have a unique port
  • to configure the mysql probe to monitor instances you would create a connection for each using the specific port of the instance.