Home > Storage > PowerFlex > White Papers > Deploying MySQL Database on Dell PowerFlex with NVMe over TCP > PowerFlex snapshot for new MySQL instance
This section describes the steps for mapping snapshots of the database volumes to a new instance of MySQL database server for testing and development purposes.
Map the snapshots:
Perform these steps to mount the snapshot on a MySQL database server:
$ lsblk
NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINTS
sda 8:0 0 160G 0 disk
├─sda1 8:1 0 512M 0 part /boot/efi
├─sda2 8:2 0 10G 0 part /
├─sda3 8:3 0 86.7G 0 part /home
└─sda4 8:4 0 62.8G 0 part [SWAP]
sr0 11:0 1 1024M 0 rom
nvme1n1 259:3 0 2T 0 disk
└─nvme1n1p1 259:9 0 2T 0 part
nvme1n2 259:14 0 1T 0 disk
└─nvme1n2p1 259:16 0 1024G 0 part
nvme1n3 259:27 0 256G 0 disk
└─nvme1n3p1 259:29 0 256G 0 part
nvme1n4 259:36 0 256G 0 disk
└─nvme1n4p1 259:38 0 256G 0 part
$ mount /dev/nvme1n1p1 /MySQL_Data
$ mount /dev/nvme1n2p1 /Binary_Logs
$ mount /dev/nvme1n3p1 /RedoLogs
$ mount /dev/nvme1n4p1 /UndoLogs
$ lsblk
NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINTS
sda 8:0 0 160G 0 disk
├─sda1 8:1 0 512M 0 part /boot/efi
├─sda2 8:2 0 10G 0 part /
├─sda3 8:3 0 86.7G 0 part /home
└─sda4 8:4 0 62.8G 0 part [SWAP]
sr0 11:0 1 1024M 0 rom
nvme1n1 259:3 0 2T 0 disk
└─nvme1n1p1 259:9 0 2T 0 part /MySQL_Data
nvme1n2 259:14 0 1T 0 disk
└─nvme1n2p1 259:16 0 1024G 0 part /Binary_Logs
nvme1n3 259:27 0 256G 0 disk
└─nvme1n3p1 259:29 0 256G 0 part /RedoLogs
nvme1n4 259:36 0 256G 0 disk
└─nvme1n4p1 259:38 0 256G 0 part /UndoLogs
$ systemctl start mysql.service;
$ mysqlcheck --databases "Database Name" -u root -p
If table names are available, you can run the following command:
$ CHECKSUM TABLE customer, district,history,item,new_order,order_line,orders,stock,warehouse extended;
A PowerFlex database snapshot to a dev/test server is mounted and the database is ready for use.