This section describes installing and configuring steps to use MySQL with atomic write support for VxFS file systems on VxVM volumes.
Enabling the atomic write I/O support for MySQL for VxFS file systems on VxVM 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 fusionio_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.
# mkfs.vxfs /dev/vx/rdsk/diskgroup/volume
# mount.vxfs /dev/vx/dsk/diskgroup/volume /mnt1
# mysql MariaDB [(none)]> select @@innodb_use_atomic_writes ; +---------------------------+ | @@innodb_use_atomic_writes| +---------------------------+ | 1| +---------------------------+ 1 row in set (0.00 sec)