Grafana Manticore plugin

[sanikolaev]

Currently, Grafana can visualize Manticore using the mysql plugin.

The task is to create a fork of https://grafana.com/grafana/plugins/mysql/, enhance it to make it even more suitable for Manticore, and then suggest it to the Grafana team.

[AbstractiveNord]

Highly appreciate. Kill feature of logs storages in Grafana is ability to correlate logs with traces. That feaute is supported for ElasticSearch and Loki storage plugins, but not for MySQL plugin. Please check for better experience with Manticore plugin. Also may be related:

1. Abstract values doesn't work with strings
2. Support databases inside of ManticoreSearch instance

[reyjrar]

FYI: We're running Grafana 10.3.1 in production now. The MySQL plugin has been significantly upgraded since the blog post about Grafana integration and the Grafana Query builder no longer works with Manticore.

When I save the DataSource, it says everything works, but when I go to build a visualization, the "Datasets" and "Tables" drop downs are empty. I can switch over to the "Code" builder and write queries that work, but it can't detect table or column names, so it's very much limited to "Experts Only".

If the separate plugin isn't feasible, can you figure out what changed in the MySQL Datasource and patch the Manticore MySQL compatibility layer to work with the recent Grafana MySQL Datasource Plugin?

Thanks!!! :)

[sanikolaev]

FYI: We're running Grafana 10.3.1 in production now. The MySQL plugin has been significantly upgraded since the blog post about Grafana integration and the Grafana Query builder no longer works with Manticore.

Thanks for letting us know. I've created this task https://github.com/manticoresoftware/manticoresearch/issues/1842 to address it.

[PavelShilin89]

@reyjrar Are you running a manticore with Buddy? And does searchd listen to all interfaces? I have checked different versions of Grafana and different versions of Manticore, everything works fine.

I do it like this: Create a network in Docker

docker network create test_grafana

Run Gtafana on this network

docker run --network=test_grafana -d --name=grafana -p 3000:3000 grafana/grafana-enterprise:10.3.1

Running Manticore Searchd with Buddy on this network

docker run -e EXTRA=1 --network=test_grafana -it --platform linux/amd64 --name manticore -p 9306:9306 -d manticoresearch/manticore:6.2.12