Title
#users-public
d

David Bellizzi

11/22/2022, 12:11 AM
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
Nicolas Hourcard

Nicolas Hourcard

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

javier ramirez

11/22/2022, 10:24 AM
Hey David. You can do this with a mixed data source. Let me show you
10:29 AM
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
10:32 AM
A second video where you can see more clearly the time series in a non overlapping manner
d

David Bellizzi

11/22/2022, 12:43 PM
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!
3:33 PM
@Jaison Peeris
j

Jaison Peeris

11/22/2022, 3:35 PM
Thanks @David Bellizzi and @javier ramirez
3:38 PM
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
d

David Bellizzi

11/22/2022, 4:43 PM
I think we would add a data source for each instance and you should be good to go
j

javier ramirez

11/22/2022, 6:07 PM
Yes. That’s the idea. let us know if you hit any bump