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"