clickhouse-learning-cluster/Схема кластера.drawio

<mxfile host="Electron" agent="Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) draw.io/28.1.2 Chrome/138.0.7204.243 Electron/37.4.0 Safari/537.36" version="28.1.2">
  <diagram name="Страница — 1" id="FHKpafrjKkJkzZQU2sBS">
    <mxGraphModel dx="1235" dy="694" grid="1" gridSize="10" guides="1" tooltips="1" connect="1" arrows="1" fold="1" page="1" pageScale="1" pageWidth="1169" pageHeight="827" math="0" shadow="0">
      <root>
        <mxCell id="0" />
        <mxCell id="1" parent="0" />
        <mxCell id="tSqiZl5FNUn8lHeOsgIg-36" value="Внешний клиент (Client)" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#dae8fc;strokeColor=#6c8ebf;fontSize=14;" vertex="1" parent="1">
          <mxGeometry x="640" y="30" width="200" height="60" as="geometry" />
        </mxCell>
        <mxCell id="tSqiZl5FNUn8lHeOsgIg-40" value="Учебный кластер ClickHouse (Docker Compose)" style="text;html=1;align=left;verticalAlign=middle;whiteSpace=wrap;rounded=0;fontSize=16;" vertex="1" parent="1">
          <mxGeometry x="40" y="45" width="520" height="30" as="geometry" />
        </mxCell>
        <mxCell id="tSqiZl5FNUn8lHeOsgIg-41" value="" style="group" vertex="1" connectable="0" parent="1">
          <mxGeometry x="40" y="121" width="840" height="480" as="geometry" />
        </mxCell>
        <mxCell id="tSqiZl5FNUn8lHeOsgIg-34" value="Хост-машина - Docker network" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#f5f5f5;arcSize=5;strokeColor=#666666;fontColor=#333333;align=left;verticalAlign=top;spacingLeft=12;spacingTop=6;fontSize=13;container=0;dashed=1;dashPattern=8 8;" vertex="1" parent="tSqiZl5FNUn8lHeOsgIg-41">
          <mxGeometry width="840" height="480" as="geometry" />
        </mxCell>
        <mxCell id="tSqiZl5FNUn8lHeOsgIg-22" value="" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;entryX=0.5;entryY=0;entryDx=0;entryDy=0;fillColor=#0050ef;strokeColor=#001DBC;strokeWidth=1.5;" edge="1" parent="tSqiZl5FNUn8lHeOsgIg-41" source="tSqiZl5FNUn8lHeOsgIg-15" target="tSqiZl5FNUn8lHeOsgIg-5">
          <mxGeometry relative="1" as="geometry">
            <mxPoint x="320" y="188" as="targetPoint" />
          </mxGeometry>
        </mxCell>
        <mxCell id="tSqiZl5FNUn8lHeOsgIg-23" value="" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;entryX=0.5;entryY=0;entryDx=0;entryDy=0;exitX=0.5;exitY=1;exitDx=0;exitDy=0;fillColor=#0050ef;strokeColor=#001DBC;strokeWidth=1.5;" edge="1" parent="tSqiZl5FNUn8lHeOsgIg-41" source="tSqiZl5FNUn8lHeOsgIg-15" target="tSqiZl5FNUn8lHeOsgIg-1">
          <mxGeometry relative="1" as="geometry">
            <mxPoint x="450" y="168" as="sourcePoint" />
            <mxPoint x="370" y="246" as="targetPoint" />
          </mxGeometry>
        </mxCell>
        <mxCell id="tSqiZl5FNUn8lHeOsgIg-24" value="" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;entryX=0.5;entryY=0;entryDx=0;entryDy=0;exitX=0.5;exitY=1;exitDx=0;exitDy=0;fillColor=#0050ef;strokeColor=#001DBC;strokeWidth=1.5;" edge="1" parent="tSqiZl5FNUn8lHeOsgIg-41" source="tSqiZl5FNUn8lHeOsgIg-15" target="tSqiZl5FNUn8lHeOsgIg-8">
          <mxGeometry relative="1" as="geometry">
            <mxPoint x="400" y="168" as="sourcePoint" />
            <mxPoint x="320" y="246" as="targetPoint" />
          </mxGeometry>
        </mxCell>
        <mxCell id="tSqiZl5FNUn8lHeOsgIg-25" value="Балансировка подключений пользователей" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;entryX=0.5;entryY=0;entryDx=0;entryDy=0;exitX=0.5;exitY=1;exitDx=0;exitDy=0;fillColor=#0050ef;strokeColor=#001DBC;strokeWidth=1.5;" edge="1" parent="tSqiZl5FNUn8lHeOsgIg-41" source="tSqiZl5FNUn8lHeOsgIg-15" target="tSqiZl5FNUn8lHeOsgIg-11">
          <mxGeometry x="-0.201" y="9" relative="1" as="geometry">
            <mxPoint x="430" y="148" as="sourcePoint" />
            <mxPoint x="550" y="226" as="targetPoint" />
            <mxPoint as="offset" />
          </mxGeometry>
        </mxCell>
        <mxCell id="tSqiZl5FNUn8lHeOsgIg-27" value="" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;exitX=0.5;exitY=0;exitDx=0;exitDy=0;endArrow=classic;endFill=1;dashed=1;startArrow=classic;startFill=1;" edge="1" parent="tSqiZl5FNUn8lHeOsgIg-41" source="tSqiZl5FNUn8lHeOsgIg-19">
          <mxGeometry relative="1" as="geometry">
            <mxPoint x="410" y="208" as="sourcePoint" />
            <mxPoint x="120" y="278" as="targetPoint" />
          </mxGeometry>
        </mxCell>
        <mxCell id="tSqiZl5FNUn8lHeOsgIg-28" value="" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;exitX=0.5;exitY=0;exitDx=0;exitDy=0;endArrow=classic;endFill=1;dashed=1;startArrow=classic;startFill=1;" edge="1" parent="tSqiZl5FNUn8lHeOsgIg-41" source="tSqiZl5FNUn8lHeOsgIg-19">
          <mxGeometry relative="1" as="geometry">
            <mxPoint x="660" y="388" as="sourcePoint" />
            <mxPoint x="320" y="278" as="targetPoint" />
          </mxGeometry>
        </mxCell>
        <mxCell id="tSqiZl5FNUn8lHeOsgIg-29" value="" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;exitX=0.5;exitY=0;exitDx=0;exitDy=0;endArrow=classic;endFill=1;dashed=1;startArrow=classic;startFill=1;entryX=0.5;entryY=1;entryDx=0;entryDy=0;" edge="1" parent="tSqiZl5FNUn8lHeOsgIg-41" source="tSqiZl5FNUn8lHeOsgIg-19" target="tSqiZl5FNUn8lHeOsgIg-8">
          <mxGeometry relative="1" as="geometry">
            <mxPoint x="490" y="388" as="sourcePoint" />
            <mxPoint x="520" y="288" as="targetPoint" />
            <Array as="points">
              <mxPoint x="400" y="318" />
              <mxPoint x="520" y="318" />
            </Array>
          </mxGeometry>
        </mxCell>
        <mxCell id="tSqiZl5FNUn8lHeOsgIg-33" value="" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;exitX=0.5;exitY=0;exitDx=0;exitDy=0;endArrow=classic;endFill=1;dashed=1;startArrow=classic;startFill=1;entryX=0.5;entryY=1;entryDx=0;entryDy=0;" edge="1" parent="tSqiZl5FNUn8lHeOsgIg-41" source="tSqiZl5FNUn8lHeOsgIg-19" target="tSqiZl5FNUn8lHeOsgIg-11">
          <mxGeometry relative="1" as="geometry">
            <mxPoint x="450" y="400" as="sourcePoint" />
            <mxPoint x="570" y="318" as="targetPoint" />
            <Array as="points">
              <mxPoint x="400" y="318" />
              <mxPoint x="720" y="318" />
            </Array>
          </mxGeometry>
        </mxCell>
        <mxCell id="tSqiZl5FNUn8lHeOsgIg-1" value="click1 - ClickHouse" style="rounded=1;whiteSpace=wrap;html=1;fontSize=14;align=left;verticalAlign=top;spacingTop=0;spacingLeft=6;container=0;" vertex="1" parent="tSqiZl5FNUn8lHeOsgIg-41">
          <mxGeometry x="40" y="196" width="160" height="80" as="geometry" />
        </mxCell>
        <mxCell id="tSqiZl5FNUn8lHeOsgIg-2" value="macros: &lt;br&gt;shard-01, replica=01" style="text;html=1;align=left;verticalAlign=middle;whiteSpace=wrap;rounded=0;fontSize=11;spacingLeft=6;fontFamily=Courier New;container=0;" vertex="1" parent="tSqiZl5FNUn8lHeOsgIg-41">
          <mxGeometry x="40" y="220" width="160" height="30" as="geometry" />
        </mxCell>
        <mxCell id="tSqiZl5FNUn8lHeOsgIg-5" value="click2 - ClickHouse" style="rounded=1;whiteSpace=wrap;html=1;fontSize=14;align=left;verticalAlign=top;spacingTop=0;spacingLeft=6;container=0;" vertex="1" parent="tSqiZl5FNUn8lHeOsgIg-41">
          <mxGeometry x="240" y="196" width="160" height="80" as="geometry" />
        </mxCell>
        <mxCell id="tSqiZl5FNUn8lHeOsgIg-6" value="macros: &lt;br&gt;shard-01, replica=02" style="text;html=1;align=left;verticalAlign=middle;whiteSpace=wrap;rounded=0;fontSize=11;spacingLeft=6;fontFamily=Courier New;container=0;" vertex="1" parent="tSqiZl5FNUn8lHeOsgIg-41">
          <mxGeometry x="240" y="220" width="160" height="30" as="geometry" />
        </mxCell>
        <mxCell id="tSqiZl5FNUn8lHeOsgIg-8" value="click3 - ClickHouse" style="rounded=1;whiteSpace=wrap;html=1;fontSize=14;align=left;verticalAlign=top;spacingTop=0;spacingLeft=6;container=0;" vertex="1" parent="tSqiZl5FNUn8lHeOsgIg-41">
          <mxGeometry x="440" y="196" width="160" height="80" as="geometry" />
        </mxCell>
        <mxCell id="tSqiZl5FNUn8lHeOsgIg-9" value="macros: &lt;br&gt;shard-02, replica=01" style="text;html=1;align=left;verticalAlign=middle;whiteSpace=wrap;rounded=0;fontSize=11;spacingLeft=6;fontFamily=Courier New;container=0;" vertex="1" parent="tSqiZl5FNUn8lHeOsgIg-41">
          <mxGeometry x="440" y="220" width="160" height="30" as="geometry" />
        </mxCell>
        <mxCell id="tSqiZl5FNUn8lHeOsgIg-11" value="click4 - ClickHouse" style="rounded=1;whiteSpace=wrap;html=1;fontSize=14;align=left;verticalAlign=top;spacingTop=0;spacingLeft=6;container=0;" vertex="1" parent="tSqiZl5FNUn8lHeOsgIg-41">
          <mxGeometry x="640" y="196" width="160" height="80" as="geometry" />
        </mxCell>
        <mxCell id="tSqiZl5FNUn8lHeOsgIg-12" value="macros: &lt;br&gt;shard-02, replica=02" style="text;html=1;align=left;verticalAlign=middle;whiteSpace=wrap;rounded=0;fontSize=11;spacingLeft=6;fontFamily=Courier New;container=0;" vertex="1" parent="tSqiZl5FNUn8lHeOsgIg-41">
          <mxGeometry x="640" y="220" width="160" height="30" as="geometry" />
        </mxCell>
        <mxCell id="tSqiZl5FNUn8lHeOsgIg-15" value="HAProxy" style="rounded=1;whiteSpace=wrap;html=1;fontSize=14;align=left;verticalAlign=top;spacingTop=0;spacingLeft=6;container=0;" vertex="1" parent="tSqiZl5FNUn8lHeOsgIg-41">
          <mxGeometry x="320" y="38" width="160" height="80" as="geometry" />
        </mxCell>
        <mxCell id="tSqiZl5FNUn8lHeOsgIg-16" value="&lt;font face=&quot;Courier New&quot;&gt;Балансировка&lt;br&gt;подключений&lt;/font&gt;" style="text;html=1;align=left;verticalAlign=middle;whiteSpace=wrap;rounded=0;fontSize=11;spacingLeft=6;fontFamily=Helvetica;container=0;" vertex="1" parent="tSqiZl5FNUn8lHeOsgIg-41">
          <mxGeometry x="320" y="62" width="160" height="30" as="geometry" />
        </mxCell>
        <mxCell id="tSqiZl5FNUn8lHeOsgIg-19" value="ZooKeeper" style="rounded=1;whiteSpace=wrap;html=1;fontSize=14;align=left;verticalAlign=top;spacingTop=0;spacingLeft=6;container=0;" vertex="1" parent="tSqiZl5FNUn8lHeOsgIg-41">
          <mxGeometry x="320" y="358" width="160" height="80" as="geometry" />
        </mxCell>
        <mxCell id="tSqiZl5FNUn8lHeOsgIg-20" value="&lt;font face=&quot;Courier New&quot;&gt;Координация кластера&lt;/font&gt;" style="text;html=1;align=left;verticalAlign=middle;whiteSpace=wrap;rounded=0;fontSize=11;spacingLeft=6;fontFamily=Helvetica;container=0;" vertex="1" parent="tSqiZl5FNUn8lHeOsgIg-41">
          <mxGeometry x="320" y="382" width="160" height="30" as="geometry" />
        </mxCell>
        <mxCell id="tSqiZl5FNUn8lHeOsgIg-38" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;exitX=0;exitY=0.5;exitDx=0;exitDy=0;entryX=1;entryY=0.5;entryDx=0;entryDy=0;fillColor=#0050ef;strokeColor=#001DBC;strokeWidth=1.5;" edge="1" parent="1" source="tSqiZl5FNUn8lHeOsgIg-36" target="tSqiZl5FNUn8lHeOsgIg-16">
          <mxGeometry relative="1" as="geometry" />
        </mxCell>
      </root>
    </mxGraphModel>
  </diagram>
</mxfile>