No workload in PI (Performance Investigator) for MariaDB 10.2 on RDS (4226127)

No workload is displayed in the Global view databases dashboard for SQL PI on MariaDB 10.2 where the MySQL database agent uses the hostname instead of the IP address. 

The workload is displayed correctly in the SQL PI pages.

WORKAROUND 

Replace the attached script in the Foglight Management Server

• Navigate to Configuration | Definitions | Databases | SQL PI Repository | presentation
• Switch the pulldown to function and search for “Get DB MySql Instance Topology"
• Edit the script
• Replace the script content with the attached script
• Save changes

Note: The user must have the Cartridge Developer role to make these changes

STATUS

This issue has been logged as defect FOG-2356 and has been fixed in the 6.1.0.10 release of the MySQL cartridge.