UIM (Nimsoft) HA setup - DB failover options for MySQL when the DB becomes unavailable

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

I have already setup HA between Primary andSecondary hub with the HA probe, and it works fine.

But what if the database server becomes unavailable?

1. Will the monitoring still work if the DB is unavailable for some reason?

2. Is it possible to setup DB in failover?

Environment

Release: 20.4

Cause

• Guidance

Resolution

Q. Will the UIM monitoring still work if the DB is unavailable for some reason?

A. No, it is important for the database to remain available/accessible by the secondary/HA hub. You may choose to implement local monitoring (via robot) or remote monitoring of the database via monitoring probe(s) like sqlserver / oracle / mysql or other probes like net_connect, or logmon.

Q. Is it possible to setup the DB in failover?
We recommend consulting with a DBA/your customer's DBA on what DB failover options might be available.

A. We normally don't recommend any particular approach. It depends on the environment and what options are available for the given DB vendor, version, and edition.

For instance, for MySQL, there are failover options and some are discussed here at this link:

https://dev.mysql.com/blog-archive/replication-and-auto-failover-made-easy-with-mysql-utilities/  

General options include:

a. Deploy proactive monitoring of the database server locally or remotely via UIM probe(s).
b. Implement vendor-specific database server failover option, e.g., auto-failover

or, MySQL Cluster.

https://www.mysql.com/products/cluster/availability.html 

Failover options are usually dependent on which version and edition of the database is running, e.g., Standard versus Enterprise, etc.