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.
- One will show the data for only 30 days.
- 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.