v1.7.4
1.Added telemetry_innodb_dir config option to store telemetry table on external storage
2.Bug fixes
How to enable external innodb directory on MySQL?
(Suppose the directory is /var/lib/mysqlext
)
0.Create directory, change permission
chown mysql:mysql /var/lib/mysqlext
1.Open /etc/mysql/mysql.conf.d/mysqld.cnf
and add
innodb_directories = /var/lib/mysqlext/ # this adds the directory to known innodb directory
secure-file-priv = /var/lib/mysqlext/ # this allows non-root user to create table with DATA DIRECTORY
2.Grant FILE
privilege to database user (which does not seems to be included in ALL
privileges)
3.Reload mysqld: systemctl restart mysql
4.Open /etc/apparmor.d/usr.sbin.mysqld
and add
/var/lib/mysqlext/ r,
/var/lib/mysqlext/** rwk,
5.Reload apparmor: service apparmor reload