Page MenuHomePhabricator

Make Percona 8 report the basics on tendril
Closed, ResolvedPublic

Description

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.

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJan 17 2020, 3:50 PM
Marostegui closed this task as Resolved.Jan 17 2020, 3:50 PM