site_treelogo
  -   Terms of Use and Privacy
Apps | GNU/Linux | IT Prepper | Meta
rss
site_treelogo
  -   Terms of Use and Privacy
Apps | GNU/Linux | IT Prepper | Meta
rss

<<   <   >   >>

2020-12-25 | Apps | Visualize Compute, Network and Storage

Spreadsheets of numbers are difficult to visualize. Here is a method to visualize the connections and capacity of infrastructure graphically. Run your spreadsheet through a script and set the sizes in a dot format file, and graphviz will automatically route the connections and display your infrastructure like this:

cluster_EASTDC Fanisizer EASTDC cluster_WESTDC Fanisizer WESTDC SCDB CORENET COUNTRY-NET-21 CORENET->SCDB 100Mbit tnn-web-01 CORENET->tnn-web-01 10Mbit tnn-web-02 CORENET->tnn-web-02 10Mbit Legend Legend Compute Number of outer rings = Cores X Speed Diameter is amount of memory Network Circuit/Provider Storage Diameter is capacity

Notice that if you hover, the links are valid and provide more information. Link to text specifics or other diagrams, whatever you like.

Here is the dot file that generated the above graph:

digraph{
   size ="9,9";
   graph [fontname = "monospace", fontsize="18", color="grey", fontcolor="grey"];
   node [fontname = "monospace",fontsize="18" shape="circle",style="filled"];
   edge [fontname = "monospace",color="blue", fontcolor="blue",fontsize="10"];
   splines="true";
   "SCDB" [color="grey" label=<<table ><tr><td height="20" width="33.3" bgcolor="black"></td><td height="20" width="66.6" bgcolor="firebrick"></td></tr></table>> tooltip="SCDB\nFanisizer\ntotal cpacity: 56000GB\nused capacity: 30%"]
   "CORENET" [shape="oval" color="darkorange" label="COUNTRY-NET-21"]
   "tnn-web-01" [color="aquamarine3" label=<<table ><tr><td height="20" width="20" bgcolor="black"></td><td height="20" width="80" bgcolor="firebrick"></td></tr></table>> tooltip="EASTDC\ntnn-web-01\nFanisizer\ntotal memory: 461GB\nused memory: 20%\nConnections: 40/128" href="https://itdocent.com/6/6/" peripheries=4.0]
   "tnn-web-02" [color="aquamarine3" label=<<table ><tr><td height="20" width="120" bgcolor="black"></td><td height="20" width="80" bgcolor="firebrick"></td></tr></table>> tooltip="EASTDC\ntnn-web-01\nFanisizer\ntotal memory: 700GB\nused memory: 16%\nConnections: 68/256" href="https://itdocent.com/6/6/" peripheries=8.0]
   subgraph cluster_EASTDC {
      margin="40"
      fontcolor="DarkGreen"
      fontsize="25"
      tooltip="Detail of EASTDC logical grouping"
      href="https://itdocent.com/6/6/"
      label="\nFanisizer EASTDC"
      "tnn-web-02"
      "tnn-web-01"
   }
   subgraph cluster_WESTDC {
      margin="40"
      fontcolor="DarkGreen"
      fontsize="25"
      tooltip="Detail of WESTDC logical grouping"
      href="https://itdocent.com/6/6/"
      label="\nFanisizer WESTDC"
      "SCDB"
   }
"CORENET" -> "tnn-web-02"[dir="both" label=" 10Mbit" labeltooltip="CORENET <-> tnn-web-02" fontsize=16];

"CORENET" -> "tnn-web-01"[dir="both" label=" 10Mbit" labeltooltip="CORENET <-> tnn-web-01" fontsize=16];
"CORENET" -> "SCDB"[dir="both" label=" 100Mbit" labeltooltip="CORENET <-> SCDB" fontsize=16];

{ rank = sink;
    Legend [shape=none, margin=0, label=<
    <TABLE BGCOLOR="White" BORDER="0" CELLBORDER="1" CELLSPACING="0" CELLPADDING="4">
     <TR>
      <TD COLSPAN="2"><B><FONT POINT-SIZE="20">Legend</FONT></B></TD>
     </TR>
     <TR>
      <TD BGCOLOR="aquamarine3"> <FONT POINT-SIZE="20">Compute</FONT> </TD>
      <TD> <FONT POINT-SIZE="20"> Number of outer rings = Cores X Speed </FONT> <BR/> Diameter is amount of memory </TD>
     </TR>
     <TR>
      <TD BGCOLOR="darkorange"> <FONT POINT-SIZE="20">Network</FONT> </TD>
      <TD> <FONT POINT-SIZE="20"> Circuit/Provider </FONT> </TD>
     </TR>
     <TR>
      <TD BGCOLOR="grey"> <FONT POINT-SIZE="20">Storage</FONT> </TD>
      <TD> <FONT POINT-SIZE="20">Diameter is capacity</FONT> </TD>
     </TR>
    </TABLE>
   >];
  }
}
graphviz

Articles tagged with graphviz on L1G3R Information Systems:

graphviz