MySQL and Grafana

Grafana MySQL
1

  • 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

2

What would you like to accomplish in grafana with mysql?

3

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)
4

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?

5

should be in another server, or in a NAS

6

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

7

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?

8

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?

9

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?

10

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

11

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

12

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

13

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

1 Like