I’d like to know if there is redundancy while connecting datasources on Grafana. I have two redundancy SCADAs with separate servers and on that servers we have two SQL databases which redundancy by SCADA application. (Architecture is in below.) It means SCADA replicate two database each other. But when SCADA is turned off, database is not replicating anymore. (SCADAs are replicating by period (every day at 00:00 am)). I installed Grafana on one server (Let’s say Server 1) not both of them. I can reach one datasource on server where I installed Grafana.
(last 7 days)
So, while Server 1 is turned off, I can’t reach Grafana. Normal
While Server 1 is turned on, but if Scada 1 is turned off, I reach no data values. That’s not ok.
I want that,
while Server 1 is turned off, I can’t reach Grafana. That’s ok.
While Server 1 is turned on but if Scada 1 is turned off, I should reach values. ( By redundancy I should reach Server 2’s datasource.)
Is there anyway to make redundancy two datasource?
My architecture is in below.