After installing PMM clients on 5 servers in a cluster running Percona XtraDB MySQL Cluster (MySQL 5.7), none of the servers allow any queries against performance schema table. I get the error message “Native table ‘performance_schema’.‘global_variables’ has the wrong structure after PMM”
I have tried a process restart, and running “sudo mysql_upgrade -u root -p”.
This has broken our phpMyAdmin installs, so we can not view any variables on it, as well as made it impossible for anything to get any performance metrics from MySQL other then PMM.
Anyone have any advice? Is this an issue with PMM 1.8.1? It is very concerning if it really did adjust the database structure without informing me of a change.