Jail

zfs create ship/r-db
zfs set compression=gzip ship/r-db
zfs set recordsize=128k ship/r-db
zfs set atime=off ship/r-db
zfs set sync=disabled ship/r-db

zfs create ship/r-db/log
zfs create ship/r-db/data
zfs set recordsize=16k ship/r-db/data
zfs set primarycache=metadata ship/r-db/data

zfs get compression,recordsize,atime ship/r-db

#Since MySQL uses it’s own cache, it isn’t necessary to cache both metadata and data in the ARC. Set the dataset to only cache metadata.

export JAIL=r-db
export JAILHOSTNAME=db
export JAILDOMAIN=beyondbell.com
export JAILIP=76
export JAILUSER=r
export JAILUSERID=2002
export JAILUSERVNC=false

/root/FreeBSD/jails/create.sh $JAIL $JAILHOSTNAME $JAILDOMAIN $JAILIP $JAILUSER $JAILUSERID $JAILUSERVNC

iocage fstab -r $JAIL /mnt/ship/certs /mnt/certs nullfs ro 0 0

iocage exec $JAIL "mkdir  /var/db/mysql"
iocage exec $JAIL "mkdir  /var/db/mysql-log"
iocage fstab -a $JAIL /mnt/ship/db/data /var/db/mysql nullfs rw 0 0
iocage fstab -a $JAIL /mnt/ship/db/log /var/db/mysql-log nullfs rw 0 0
iocage fstab -l $JAIL

iocage exec $JAIL "pkg install -y mariadb105-server"

iocage exec $JAIL "sysrc mysql_enable=YES"
iocage exec $JAIL "cp /mnt/config/my.cnf /usr/local/etc/mysql/my.cnf"
iocage exec $JAIL "cp /mnt/config/server.cnf /usr/local/etc/mysql/conf.d/server.cnf"
iocage exec $JAIL "chown -R mysql:mysql /var/db/mysql*"
iocage exec $JAIL "service mysql-server start"