Installing Mariadb in jail

[Fred974]

Hi,

As TrueNAS is a ZFS filesystem, could anyone please provide me with some information on the dataset I need to create in order to run MariaDB server inside a TrueNAS jail?
Can the primarycache bet set in the web interface or is it command line only? I couldn't find the option when creating dataset.
I found this blog that seem good but not use if it still up to date. Also got question about compression. Should we be using lz4 now?

Installing a MariaDB server on FreeNAS

Learn how to install a MariaDB server on FreeNAS. Configure ZFS datasets to store the data and log files and optimize the throuput of your databases. You can configure the server to accept connections locally or from remote hosts over the network.

www.ricalo.com

Thank you

 

[sretalla]

Make sure to check this:

Workload Tuning — OpenZFS documentation

openzfs.github.io

Can the primarycache bet set in the web interface or is it command line only?

With CLI, no GUI option for it. zfs set primarycache=metadata pool/dataset

 

[Fred974]

@sretalla thank you for the link you provided. Any suggestion when it come to the compression level for the dataset?

 

[sretalla]

Lz4 usually presents no penalty (but may not deliver much compression)

You may be better to set it to none if performance is an objective.

 

[Patrick M. Hausen]

The information to create separate datasets for InnoDB tables and logfiles and complicated adjustment of ZFS parameters is according to Allan Jude and others who work on OpenZFS outdated.
Simply putting all of your database file in the same dataset with the default blocksize of 128k will in most cases result in better performance ever since compressed ARC was introduced.