Hi Guys,
I would like to set a MariaDB server inside a FreeNAS jail and I have a question regarding the zfs part..
On my database production server runing zfs, we had to run the following command to make sure the database work well on zfs system
When I install MariaDB inside FreeNAS jail, how do I deal with recordsize?
Should I run the command above in the FreeNAS host box? will the command survive a reboot?
Thank you all in advance
I would like to set a MariaDB server inside a FreeNAS jail and I have a question regarding the zfs part..
On my database production server runing zfs, we had to run the following command to make sure the database work well on zfs system
Code:
zfs create -o recordsize=16k -o primarycache=metadata zroot/usr/jails/mariadb/var/db/mysql-innodb zfs create -o recordsize=128k -o primarycache=metadata zroot/usr/jails/mariadb/var/db/mysql-innodb-logs zfs create -o recordsize=8k -o primarycache=metadata zroot/usr/jails/mariadb/var/db/mysql zfs set compression=off zroot/usr/jails/mariadb/var/db/mysql-innodb zfs set compression=off zroot/usr/jails/mariadb/var/db/mysql-innodb-logs zfs set compression=off zroot/usr/jails/mariadb/var/db/mysql /usr/jails/jails-data/mariadb-data/var/db /var/db nullfs rw 0 0 /usr/jails/jails-data/mariadb-data/var/db/mysql /var/db/mysql nullfs rw 0 0 /usr/jails/jails-data/mariadb-data/var/db/mysql-innodb /var/db/mysql-innodb nullfs rw 0 0 /usr/jails/jails-data/mariadb-data/var/db/mysql-innodb-logs /var/db/mysql-innodb-logs nullfs rw 0 0
When I install MariaDB inside FreeNAS jail, how do I deal with recordsize?
Should I run the command above in the FreeNAS host box? will the command survive a reboot?
Thank you all in advance