This section describes installing and configuring steps to use MySQL with atomic write support on raw VxVM volumes.
Enabling the atomic write I/O support for MySQL on VxVM raw volumes
For information, see the SanDisk documentation.
Discover the devices:
# vxdisk scandisks
Display the devices that are available for VxVM use:
# vxdisk list
For example:
# vxdisk list DEVICE TYPE DISK GROUP STATUS fiodrive0_1 auto:none - - online invalid ssdtrim atomic-write
Initialize the disks:
# /etc/vx/bin/vxdisksetup -i fio_device
Verify that the disks are under VxVM control and have atomic write support:
# vxdisk list
For example:
# vxdisk list DEVICE TYPE DISK GROUP STATUS fiodrive0_1 auto:cdsdisk - - online ssdtrim atomic-write
# vxassist -A -g diskgroup make volume length mediatype:ssd
Where:
the -A option creates an atomic write capable volume of concatenated layout, on the atomic write capable disks.
# vxprint -g diskgroup -m volume \ | grep atomic atomic_wr_capable=on atomic_wr_iosize=16
Where:
atomic_wr_capable attribute indicates whether or not the volume supports atomic writes
atomic_wr_iosize indicates the supported size of the atomic write I/O.