MySQL monitoring of named instance

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.