[HELP] Guide for using Influx db with Speedtest-Tracker

[rhcp011235]

Hello.

I have this running on my Unraid Instance and it has been great, I finally got around to getting it hooked into InfluxDB2 about a week or so ago.

I saw some people with grafana library in InfluxDB getting a Nice graph working and I am not too keen on influxDB.

I know more Oracle/DB2/Mysql type stuff.

Any help on getting a nice dashboard in Influx would be helpful to everyone :)

Thank you

[alexdelprete]

You don't really expect a guide on using Grafana, right? :)

But you're a really lucky person, I already prepared the dashboard for influxdb v2: alexjustesen/speedtest-tracker-docs#4 (comment)

If you confirm the intructions to import the dash are ok, @alexjustesen will publish it in the official docs of the project.

Let us know.

[rhcp011235]

You don't really expect a guide on using Grafana, right? :)

But you're a really lucky person, I already prepared the dashboard for influxdb v2: alexjustesen/speedtest-tracker-docs#4 (comment)

If you confirm the intructions to import the dash are ok, @alexjustesen will publish it in the official docs of the project.

Let us know.

This requires you to install Grafana eh? Is there anyway to simply use Influx? without adding more to it? I am very new to all this and its kind of complex :)

[rhcp011235]

not sure why it closed it.

[alexdelprete]

You can reopen it...can't you?

This requires you to install Grafana eh? Is there anyway to simply use Influx? without adding more to it? I am very new to all this and its kind of complex :)

How do you want to display the graphs? Grafana does that. You need a tool.

Maybe in the future @alexjustesen can implement some graphs in the dashboard, but since there's influx, I wanted to see data immediately.

Grafana is simple...check some guides on youtube...once you have it installed, just follow the procedure above to import my dashboard.

[rhcp011235]

@alexdelprete I will try, I am very very new to all of this. For years ive been a DBA (But Cli based stuff that IMHO seems simple)

All of these GUI/Point and click things seem to be confusing to me, because it basically just does whatever vs having you set it up. so you really dont learn much.

If you feel like helping me :) I have Skype and such. :)

[alexjustesen]

@rhcp011235 thanks for using Speedtest Tracker! I too used to be a dba, then did a bit of analytics work but during that was always a web developer so this project feels like home.

[rhcp011235]

@alexjustesen Thank you! I bet it does for you, I never got into any web dev nor dealt with graphics. Ive always been behind the scenes doing actual DB work and Data mining and Data warehouse type stuff. so this is all like Korean to me :)

[alexdelprete]

For years ive been a DBA

After a couple of years of development, for years I've done system & network management, then project management, then presales and Sales. A little bit of everything. :)

All of these GUI/Point and click things seem to be confusing to me, because it basically just does whatever vs having you set it up

Oh that is not correct. I'm playing with Grafana since 3-4 months...you really need to understand databases, queries, etc. You would be very good with Grafana. Usually I suck with UI/GUI stuff...but Grafana is pretty good on that side once you understand data, where it is, and what you want to correlate and present. Install it and play with it (with my dashboard for example), with your kind of experience, I'm sure you'll like it. You start with something and customize it, to learn how to use it. Try it.

[rhcp011235]

Got it working :) Thank you @alexjustesen @alexdelprete

[rhcp011235]

closed

[alexdelprete]

Got it working :) Thank you @alexjustesen @alexdelprete

I told you it was easier than you thought. :)

So the steps of the procedure work? Can we publish them in the official docs?

[rhcp011235]

Got it working :) Thank you @alexjustesen @alexdelprete

I told you it was easier than you thought. :)

So the steps of the procedure work? Can we publish them in the official docs?

Semi.

I had to modify the queries because I named my bucket Speedtest-tracker. Other than that? It was very simple

[alexdelprete]

I had to modify the queries because I named my bucket Speedtest-tracker. Other than that? It was very simple

You can rename a bucket in InfluxDB v2. I will add that to the procedure in case the user has already created the bucket.

[PovilasID]

Hey,
I made a selector variable for buckets and made all panels listen for it. Now you do not need to rename buckets in InfluxDB.

Here is Gist for it https://gist.github.com/PovilasID/113c5d2ef6fc9fbddcd19864466399a6
I suggest adding Grafana dashboard's export in the repo so it can be versioned

[alexdelprete]

I made a selector variable for buckets and made all panels listen for it.

Thanks. I applied the variable to the panels and uploade v2 to grafana dashboards.
There was also a bug when multiple servers where used, I modified the queries and now should be good also in that case.

If somebody could test the import (to make sure latest revision is used) and report back it would be very helpful. Thanks in advance.

[PovilasID]

If somebody could test the import

I tested dash id 17460 looks good 👍

[alexdelprete]

Thanks a lot for the help. Do you have multiple speedtest servers configured? Because the dash wasn't working properly in those cases. I fixed it.

[PovilasID]

Thanks a lot for the help. Do you have multiple speedtest servers configured? Because the dash wasn't working properly in those cases. I fixed it.

Not entire sure... a) Not all testing servers get passed to my influxdb instance because of #301 so I have only a couple of records. b) They are from different servers and all the charts look populated... so it looks like it is fixed but I can not validate 100%

[PovilasID]

I updated the latest version with some bar charts:

https://gist.github.com/PovilasID/113c5d2ef6fc9fbddcd19864466399a6

[PovilasID]

I also added a row with 4 charts displaying per server dynamics of download upload speeds and ping and jitter dynamics. I also enabled shared crosshair to enabled shared crosshair.

[PovilasID]

Also added a server selector for per server results comparison

[alexdelprete]

Where did you put those bars exactly? A larger screenshot would help. :)

[PovilasID]

I added the bars the cells in the table at the top displaying averages
Here are a couple of screenshots: https://i.imgur.com/N9kwSpH.png https://i.imgur.com/9AxBFUn.png

[shalak]

Does the InfluxDB feature replace the default DB used by Speedtest Tracker, or is the InfluxDB just a sink, that may or may not work and won't interfere with regular Speedtest Tracker work?

[alexdelprete]

Does the InfluxDB feature replace the default DB used by Speedtest Tracker, or is the InfluxDB just a sink, that may or may not work and won't interfere with regular Speedtest Tracker work?

InfluxDB is an added as an optional additional data exporting feature. When ST executes a test, the internal db is updated and if you've configured Influxdb, data is also written there.

[crypticviper]

@alexdelprete thanks for the dash and the documentation on it. I was able to get it to work, however, some of the "latest" tiles are empty. Is there anything else to be configured for this data?