I have a situation where I have several data centers spread across large distances. I have a main site and a backup site.
There are several routes between main and backup site. Based on conditions (connectivity issues) I need to decide which route to activate for data transfer.
I have all of the data on datacenters, routes and server characteristics stored as nodes and relationships in Memgraph.
How would a Cypher query look for a decision making scenario to chose to optimal route?