Creating this retroactively just for the record and to have it documented somewhere.
I have spent sometime getting db1114 (Percona 8.0) to report on Tendril.
In order to get it correctly reporting I have had to change some of the FEDERATED connections of two tables, so they can gather the data correctly as some global tables live in information_schema on MariaDB but on performance_schema on MySQL
I have had to change the following two tables
Table: xxx_eqiad_wmnet_3306_global_vars
MariaDB
mysql:root@localhost [tendril]> show create table db1089_eqiad_wmnet_3306_global_vars; +-------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | db1089_eqiad_wmnet_3306_global_vars | CREATE TABLE `db1089_eqiad_wmnet_3306_global_vars` ( `VARIABLE_NAME` varchar(64) NOT NULL DEFAULT '', `VARIABLE_VALUE` varchar(1024) DEFAULT NULL ) ENGINE=FEDERATED DEFAULT CHARSET=utf8 CONNECTION='mysql://watchdog:PASSWORD@db1089.eqiad.wmnet:3306/information_schema/GLOBAL_VARIABLES' | +-------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
Percona
mysql:root@localhost [tendril]> show create table db1114_eqiad_wmnet_3306_global_vars; +-------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | db1114_eqiad_wmnet_3306_global_vars | CREATE TABLE `db1114_eqiad_wmnet_3306_global_vars` ( `VARIABLE_NAME` varchar(64) NOT NULL DEFAULT '', `VARIABLE_VALUE` varchar(1024) DEFAULT NULL ) ENGINE=FEDERATED DEFAULT CHARSET=utf8 CONNECTION='mysql://watchdog:PASSWORD@db1114.eqiad.wmnet:3306/performance_schema/global_variables' | +-------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
Table: xxx_eqiad_wmnet_3306_global_status
MariaDB
mysql:root@localhost [tendril]> show create table db1089_eqiad_wmnet_3306_global_status; +---------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +---------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | db1089_eqiad_wmnet_3306_global_status | CREATE TABLE `db1089_eqiad_wmnet_3306_global_status` ( `VARIABLE_NAME` varchar(64) NOT NULL DEFAULT '', `VARIABLE_VALUE` varchar(1024) DEFAULT NULL ) ENGINE=FEDERATED DEFAULT CHARSET=utf8 CONNECTION='mysql://watchdog:PASSWORD@db1089.eqiad.wmnet:3306/information_schema/GLOBAL_STATUS' | +---------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
Percona
mysql:root@localhost [tendril]> show create table db1114_eqiad_wmnet_3306_global_status; +---------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +---------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | db1114_eqiad_wmnet_3306_global_status | CREATE TABLE `db1114_eqiad_wmnet_3306_global_status` ( `VARIABLE_NAME` varchar(64) NOT NULL DEFAULT '', `VARIABLE_VALUE` varchar(1024) DEFAULT NULL ) ENGINE=FEDERATED DEFAULT CHARSET=utf8 CONNECTION='mysql://watchdog:PASSWORD@db1114.eqiad.wmnet:3306/performance_schema/global_status' | +---------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
On the other hand the event tendril.db1114_eqiad_wmnet_3306_activity needs more working as it tries to SELECT stuff from information_schema.processlist which in MariaDB it has two columns STAGE MAX_STAGE which don't exist on Percona's version, so deleting them from the federated table means that the insert will fail as it has expect a different number of columns.
After those changes it now correctly reports everything (including its master) but the last time the activity event ran.