Home > Workload Solutions > Oracle > Guides > Design Guide — MySQL InnoDB Cluster on Dell EMC PowerStore T > Creating a DEV database from the PROD snapshot
After creating a thin clone from the snapshot, create a DEV database based on the snapshot by mounting the thin clone to DEV VM through the ESXi host.
To create a DEV database using the thin clone snapshot of DATA, LOG and TEMP:
The following table shows all the DEV database volumes or volume groups that are mapped to DEV host. The OS volume is the actual storage volume, while the volumes in DATA, LOG, and TEMP are the thin clone snapshots of the corresponding storage volumes in 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 |
Note: Manual recovery is not required for the MySQL database application to bring the database back up. Database recovery depends on the size of the IB log file. The larger the size of the file, the longer the recovery time.