MySQL and Grafana

  • What Grafana version and what operating system are you using?

  • What are you trying to achieve?
    I am planning to use another SQL instance

  • How are you trying to achieve it?
    creating another grafana server by using a disk mirroring or clustering

  • What happened?
    Nothing

  • What did you expect to happen?
    Have another dashboard with the DB history.

  • Can you copy/paste the configuration(s) that you are having problems with?
    Not configured yet.

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    No

  • Did you follow any online instructions? If so, what is the URL?

No

What would you like to accomplish in grafana with mysql?

MySQL instance will only have data for 30 days, and I need to create a job that will the old data to an archive. On the other hand, I will need that old data as a backup should be ready to show on the Dashboard. So, I planning if it is possible to have 2 Grafana-server instances or two 2 dashboards.

  1. One will show the data for only 30 days.
  2. The other one will have the history for the last 6 months. (olddata)

you don’t need two grafana servers or 2 dashboards unless you want to.
But you can show them both on 1 dashboard if you want also.

Where will the archive data be? on the same mysql server or another one?

should be in another server, or in a NAS

NAS? And you want grafana to use archive data? seems like something is missing here

It is necessary that the archive data stay on the same Server?. For example, if the Archive stays on the same server, Can I point that Data to another HDD on the same server?

i am not sure you can visualize archive data? what do you mean by archive? since you say it is archived to NAS, I am assuming it is not a mysql server?

Should I have the old data backup in the .sql file? If I have on the extension Grafana would have the capacity to read the BD?

i dont think grafana can work with some sort of back up data or file that I know of.

Should I have the 2 BDs in the Same server but using different dashboards?

that would be a good approach, one db live one db archives.
you can then use 1 dashboard for both or 2 dashboards for each up to you

Thank You!, I will take this info into consideration.

1 Like