Match the File System(s) to FlashArray Volume(s)

Linux/Unix

The operating system will be queried for the device serial number of the MySQL data volume(s) and then matched to a block storage device on FlashArray.

This example will use the r_volume_and_file_system_architectural_layout.html#r_volume_and_file_system_architectural_layout__r_volume_and_file_system_architectural_layout-tbl1 thus only one volume needs to be identified. The process is the same for any additional volumes used in a different layout.

Using the "df" command we query the mount point/directory on which the volume is mounted.

 df -h | grep /var/lib/mysql


[root@DB-01 ~]# df -h | grep /var/lib/mysql
/dev/mapper/3624a9370668f1ab9b15f4bc400011883   2.0T   71G  2.0T   4% /var/lib/mysql

Using the device name (/dev/mapper/<volume identifier>) udev is queried for the DM_SERIAL property.

udevadm info --query=all --name=<device name> | grep DM_SERIAL


[root@DB-01 ~]# udevadm info --query=all --name /dev/mapper/3624a9370668f1ab9b15f4bc400011883 | grep DM_SERIAL
E: DM_SERIAL=3624a9370668f1ab9b15f4bc400011883

Using the serial number returned for the device, it is possible to match it up to the block storage volume on a FlashArray. Note that the block volume serial number will be all of the characters after “3624a9370”.

Microsoft Windows

Execute the following command in PowerShell or Command Prompt to query all devices for the Name , SerialNumber and Size:

wmic diskdrive get name,size,SerialNumber


PS C:\Users\DBTest> wmic diskdrive get name,size,SerialNumber
Name                SerialNumber                      Size
\\.\PHYSICALDRIVE8  6000c2918160c0d53dc1237b7e3e3d19  1099506078720
\\.\PHYSICALDRIVE2  6000c2994e8572da6bfb90202edbed11  824633671680
\\.\PHYSICALDRIVE7  6000c29ef37e9a94dcf21be84f608af2  137436203520
\\.\PHYSICALDRIVE1  6000c29047b4551b50408c9b57e99e5a  824633671680
\\.\PHYSICALDRIVE4  6000c294abd48d0593e4e3016ac12e04  824633671680
\\.\PHYSICALDRIVE6  6000c29b57204022741f5058a00c11d3  1340029716480
\\.\PHYSICALDRIVE0  6000c29de05233d12724ad984a6d8c46  274872407040
\\.\PHYSICALDRIVE9  6000c290012fd2a5252f07966e6bfce1  549753039360
\\.\PHYSICALDRIVE3  6000c2962cfb818def338b473e4af34c  824633671680
\\.\PHYSICALDRIVE5  6000c29a62d616cb61296af759197574  2199020382720

Once the serial numbers have been identified

To see all of the volumes and their serial numbers using the FlashArray CLI execute the following:

purevol list

pureuser@flasharray> purevol list
Name                    Size   Source  Created                  Serial
DB-01-MySQL-Base        2T     -       2021-02-19 00:53:54 PST  668F1AB9B15F4BC400011883
DB-01-MySQL-Log         1T     -       2021-02-19 00:54:45 PST  668F1AB9B15F4BC40001188E
DB-01-MySQL-Undo        512G   -       2021-02-19 00:55:18 PST  668F1AB9B15F4BC40001189C
Warehouse01             768G   -       2021-02-23 06:20:17 PST  668F1AB9B15F4BC4000118A4
Warehouse02             768G   -       2021-02-23 06:20:17 PST  668F1AB9B15F4BC4000118A5
Warehouse03             768G   -       2021-02-23 06:20:17 PST  668F1AB9B15F4BC4000118A3
Warehouse04             768G   -       2021-02-23 06:20:17 PST  668F1AB9B15F4BC4000118A2

Once the volume(s) have been identified then a storage snapshot can be created for it.