API Gateway -PAPIM Replication parameters not showing on APM agent

book

Article ID: 192611

calendar_today

Updated On:

Products

CA API Gateway API SECURITY CA API Gateway Precision API Monitoring Module for API Gateway (Layer 7) CA API Gateway Enterprise Service Manager (Layer 7) STARTER PACK-7 CA Microgateway

Issue/Introduction

In MySQL 5.5 & Gateway 9.2, when you ran "show status", you saw the following parameters were present unlike Gateway 9.4 with MySQL 5.7.

In MySQL 5.7, "Show status" no longer returns the following variables.

Rpl_status

Slave_heartbeat_period
Slave_received_heartbeats
Slave_retried_transactions
Slave_running

The actual problem is, not having the above information in MySQL 5.7 so that APM agent doesn't show the above variables whereas you see these variables for MySQL 5.5.
As a result, the customer can't monitor the status of replication on APM Agent via PAPIM.  

PAPIM script only checks the the output of SHOW STATUS; however, PAPIM needs to accommodate the status of replication so that it will be reflected on APM agent.



Environment

Gateway : 9.4
MySQL 5.7
PAPIM: 3.4

Resolution

MySQL deprecated the above said parameters in 5.7, please refer to this link https://dev.mysql.com/doc/refman/5.7/en/server-status-variables.html and https://www.docs4dev.com/docs/en/mysql/5.7/reference/replication-administration-status.html

Defining show_compatibility_56 in MySQL 5.7 as below suggested appears to resolve the problem:

Connect to a server with MySQL 5.7 via SSH.

Edit the MySQL configuration file my.cnf.
 Open my.cnf in a text editor. In this example, we are using the vi editor:

1. on CentOS/RHEL-based distributions:
   >> vi /etc/my.cnf

2. Add the following directive under the [mysqld] section:
  >> show_compatibility_56=ON

3. Save the changes and close the file.

4. Restart the MySQL server:
   >> service mysql restart
OR
  >> service mysqld restart

5. Verify that the variable has been enabled:
   plesk db "SHOW SESSION VARIABLES where Variable_name like '%show_compatibility%'"
+-----------------------+-------+
| Variable_name         | Value |
+-----------------------+-------+
| show_compatibility_56 | ON    |
+-----------------------+-------+