On db-B cluster, SHOW DATABASES; shows some specific ZFS dataset as subfolders (and so potential database):
#mysql50#mysql-innodb-data #mysql50#mysql-innodb-logs mysql-innodb-data mysql-innodb-logs
When running that command the following errors are logged in /var/log/mysql/mysqld.err:
2024-10-26 23:35:19 574563 [ERROR] Invalid (old?) table or database name 'mysql-innodb-data' 2024-10-26 23:35:19 574563 [ERROR] Invalid (old?) table or database name 'mysql-innodb-logs'
This is because mounting points for ZFS datasets are in /var/db/mysql:
https://devcentral.nasqueron.org/source/operations/browse/main/roles/dbserver-mysql/mysql-server/zfs.sls
They contain the following data:
$ cd /var/db/mysql $ ls mysql-innodb-data ib_buffer_pool ibdata1 ibtmp1 $ ls mysql-innodb-logs ib_logfile0
Paths need also to be updated here: https://devcentral.nasqueron.org/source/operations/browse/main/roles/dbserver-mysql/mysql-server/zfs.sls