Hello questdb folks, Per the Executive Order on Cyber Security items 5.1/5.2 I'm force to split my environment into different tiers which means I will have two questdb instances. What best practice when one wants to report on consolidated data of both instances using grafana
11/22/2022, 9:48 AM
hey David, great to see you! Can you kindly take us through your setup, are you spinning a second instance in case the first one goes down?
11/22/2022, 10:24 AM
Hey David. You can do this with a mixed data source. Let me show you
Of course if you don’t need to mix data in the same panel, you could have one panel in the dashboard using a data source, and a second panel using a different data source, but the video above shows how to mix data from two source into the same panel/chart
A second video where you can see more clearly the time series in a non overlapping manner
Hey Nicolas and Javier! The second instance is not for HA or DR, EO 5.1/5.2 specifies environment isolation where you need a separate auth boundary. i.e. Need to login to a separate service on a separate network with different RBAC. So in the dev tier developers would trigger Jenkins runs and the results would be pushed to questdb-dev. And when when the testers run in te staging tier they login to a different jenkins instance and trigger runs which updates questdb-stg. Having one grafana instance where we can pull from both sources seems what I need as long as I get approval having a service access both tiers. Thanks!
11/22/2022, 3:35 PM
Thanks @David Bellizzi and @javier ramirez
Looks pretty straightforward to do as long as Grafana has access to both the Questdb instances. But will reach out incase we have any questions when actually implementing
11/22/2022, 4:43 PM
I think we would add a data source for each instance and you should be good to go
11/22/2022, 6:07 PM
Yes. That’s the idea. let us know if you hit any bump