API Gateway -PAPIM Replication parameters not showing on APM agent
Article ID: 192611
Updated On: 10-26-2023
Products
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 |
+-----------------------+-------+
Feedback
