Created: 2024-01-08 | Updated: 2024-05-17

MySQL

New (v0.3.20)

Table of contents

1. Node Type: mysql
2. Rendering:
3. Code Snippet:
4. drawio mysql vertex:
5. Advanced for Geeks:
   1. Style:
   2. Vertex size:
   3. Full XML dump:
   4. drawio file:

---

Node Type: mysql

Rendering:

Code Snippet:

# given
mcd = MultiCloudDiagrams()

# when
mysql_arn = 'arn:aws:mysql:eu-west-1:123456789012'
mysql_name = 'arn:aws:mysql:eu-west-1:123456789012/MainDB'
metadata = {
    "records": "224000",
    "engine": "InnoDB",
    "volume": "2048Mb",
    "cpu": "512",
    "memory": "2048",
    "version": 5.72,
}
mcd.add_vertex(node_id=mysql_arn, node_name=mysql_name, node_type='mysql', metadata=metadata)

drawio mysql vertex:

<mxCell id="vertex:mysql:arn:aws:mysql:eu-west-1:123456789012" parent="1" vertex="1">
    <mxGeometry width="60" height="64.5" as="geometry"/>
</mxCell>

---

Advanced for Geeks:

Style:

style="outlineConnect=0;dashed=0;verticalLabelPosition=bottom;verticalAlign=top;align=left;html=1;shape=mxgraph.aws3.mysql_db_instance;fillColor=#2E73B8;gradientColor=none;labelBackgroundColor=none;"

attribute	value
align	left
dashed	0
fillColor	#2E73B8
gradientColor	none
html	1
labelBackgroundColor	none
outlineConnect	0
shape	mxgraph.aws3.mysql_db_instance
verticalAlign	top
verticalLabelPosition	bottom

Vertex size:

attribute	value
width	60
height	64.5

Full XML dump:

<mxfile host="multicloud-diagrams" agent="PIP package multicloud-diagrams. Generate resources in draw.io compatible format for Cloud infrastructure. Copyrights @ Roman Tsypuk 2023. MIT license." type="MultiCloud">
    <diagram id="diagram_1" name="AWS components">
        <mxGraphModel dx="1015" dy="661" grid="1" gridSize="10" guides="1" tooltips="1" connect="1" arrows="1" fold="1" page="1" pageScale="1" pageWidth="850" pageHeight="1100" math="0" shadow="1">
            <root>
                <mxCell id="0"/>
                <mxCell id="1" parent="0"/>
                <mxCell id="vertex:mysql:arn:aws:mysql:eu-west-1:123456789012" value="&lt;b&gt;Name&lt;/b&gt;: arn:aws:mysql:eu-west-1:123456789012/MainDB&lt;BR&gt;&lt;b&gt;ARN&lt;/b&gt;: arn:aws:mysql:eu-west-1:123456789012&lt;BR&gt;-----------&lt;BR&gt;&lt;b&gt;records&lt;/b&gt;: 224000&lt;BR&gt;&lt;b&gt;engine&lt;/b&gt;: InnoDB&lt;BR&gt;&lt;b&gt;volume&lt;/b&gt;: 2048Mb&lt;BR&gt;&lt;b&gt;cpu&lt;/b&gt;: 512&lt;BR&gt;&lt;b&gt;memory&lt;/b&gt;: 2048&lt;BR&gt;&lt;b&gt;version&lt;/b&gt;: 5.72" style="outlineConnect=0;dashed=0;verticalLabelPosition=bottom;verticalAlign=top;align=left;html=1;shape=mxgraph.aws3.mysql_db_instance;fillColor=#2E73B8;gradientColor=none;labelBackgroundColor=none;" parent="1" vertex="1">
                    <mxGeometry width="60" height="64.5" as="geometry"/>
                </mxCell>
            </root>
        </mxGraphModel>
    </diagram>
</mxfile>

drawio file:

Download generated mysql.drawio:

Download