Home > Storage > PowerFlex > White Papers > Deploying MySQL Database on Dell PowerFlex with NVMe over TCP > Solution architecture
This section describes the architecture and design used for deploying MySQL database on Dell PowerFlex.
The solution consists of a PowerFlex two-layer configuration with three bare metal servers acting as compute nodes and four servers acting as storage nodes running the PowerFlex embedded operating system. The compute nodes have SUSE Linux Enterprise Server 15 SP5 installed. Because this solution uses the NVMe/TCP initiators, SDC drivers are not installed on the compute nodes. The PowerFlex Manager and "Storage with NVMe/TCP" template is used for deployment of the four storage nodes with the SDT component. The storage nodes are configured as part of the same protection domain. Volumes for the database instances are provisioned from a storage pool consisting of all the disks attached to the storage nodes. MySQL stand-alone database instances are then installed and configured on the bare metal compute nodes.
Figure 5. MySQL With PowerFlex logical architecture
PowerFlex uses the SDT component as an NVMe target that works along with the SDS component on the storage nodes. For the NVMe/TCP configuration on the compute nodes, follow the steps in NVMe/TCP configuration.
To learn more about NVMe/TCP initiator-target communication, see PowerFlex with NVMe over TCP (NVMe/TCP).
For information about the hardware, see Hardware configuration details.
The following figure shows the network architecture of this solution:
Figure 6. Network design of bare metal nodes and PowerFlex storage-only nodes
At the physical layer, two supported Top of Rack (TOR) switches are used for redundancy and load-balancing purposes. A peer link is configured on both the TOR switches. VLANs are created to separate different traffic types on the network bonds.
The following table shows the different networks that are configured for this solution:
Table 2. Network details
Network type | VLAN ID |
Operating system management | 105 |
Operating system installation | 104 |
Hardware management | 101 |
PowerFlex management | 150 |
PowerFlex Data 1 | 151 |
PowerFlex Data 2 | 152 |