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