MariaDB replication checks for all channels in multi-channel setup report no data

[mrmonkington]

There does not seem to be a way to collect replication statuses for all replication channels on MariaDB, though the docs/code seems to imply to me that this should be possible (and that it might be possible for MySQL).

Relevant source:

integrations-core/mysql/datadog_checks/mysql/queries.py

Line 103 in 3f21b7b

def show_replica_status_query(version, is_mariadb, channel=''):

On MariaDB, you need to use the following form to retrieve replication status for ALL channels in a multi-channel setup:

SHOW ALL REPLICAS STATUS

(as per https://mariadb.com/kb/en/show-replica-status/ )

The current behaviour reports 0 channels. It is possible to monitor a single channel (by specifying the channel name in replication_channel config key.).