Created: 2024-01-08 | Updated: 2024-08-11
MySQL
New (v0.3.20)
Table of contents
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="<b>Name</b>: arn:aws:mysql:eu-west-1:123456789012/MainDB<BR><b>ARN</b>: arn:aws:mysql:eu-west-1:123456789012<BR>-----------<BR><b>records</b>: 224000<BR><b>engine</b>: InnoDB<BR><b>volume</b>: 2048Mb<BR><b>cpu</b>: 512<BR><b>memory</b>: 2048<BR><b>version</b>: 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
: