API Gateway -PAPIM Replication parameters not showing on APM agent
search cancel

API Gateway -PAPIM Replication parameters not showing on APM agent


Article ID: 192611


Updated On:


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


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.



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.


Gateway : 9.4
MySQL 5.7
PAPIM: 3.4


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
  >> 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    |