Home > Workload Solutions > Oracle > Guides > Design Guide — MySQL InnoDB Cluster on Dell EMC PowerStore T > Snapshot database storage design
To implement the data protection strategy with MySQL, you must design the storage layout accordingly. Dell Technologies recommends that you create two volumes for MySQL. Three volumes are added to the MySQL_DEV volume group for OS and Temp.
A single volume is usually sufficient for the operating system for the DEV environment. In this case, because we are taking snapshots from PROD, we have allocated three volumes for the DEV.
The following table shows the details of these added volumes for the DEV database. The table includes the DATA volumes and LOG volumes of DEV databases to be based on the snapshot of the DATA and LOG volumes of the PROD database.
Volume group |
Name |
Description |
Size |
Number of volumes |
Data reduction |
Thick |
OS |
DEV_VM |
Guest VM operating system |
600 GB |
1 |
Yes |
Yes |
Snapshot volume design |
||||||
DATA |
PROD_DATA |
Data files |
2 TB |
1 |
Yes |
Yes |
LOG |
PROD_LOG |
Log |
2 TB |
1 |
Yes |
Yes |
TEMP |
PROD_TEMP |
Temporary |
100 GB |
1 |
Yes |
Yes |
To map these snapshot database volumes to one DEV database server, we created the host group MySQL_Dev_Host_Group. This host group consists of one server as shown in the following figure: