Maniphest T2074

mysql
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	dereckson
	Oct 26 2024, 21:58

Description

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

Revisions and Commits

rOPS Nasqueron Operations
	D3890	rOPSfc387282b35f Mount MySQL root ZFS dataset as /var/db/mysql/data

Event Timeline

dereckson triaged this task as High priority.Oct 26 2024, 21:58

dereckson created this task.

dereckson added a project: good-first-issue.

dereckson moved this task from Backlog to Ops on the good-first-issue board.

dereckson moved this task from Backlog to Servers on the DBA board.Oct 12 2025, 10:40

dereckson assigned this task to ptdradmin.Mon, Nov 24, 14:07

dereckson moved this task from Backlog to Working on on the Servers board.

dereckson added a revision: D3890: Mount MySQL root ZFS dataset as /var/db/mysql/data.Mon, Nov 24, 14:30

Avancement sur T2074

Modifié le fichier roles/dbserver-mysql/mysql-server/zfs.sls : changement du point de montage de mysql-root de /var/db/mysql vers /var/db/mysql/data.
Cette première étape prépare la restructuration complète. Les systèmes de fichiers mysql-innodb-data et mysql-innodb-logs restent temporairement sous /var/db/mysql/.

Prochaine étape : Déployer sur WindRiver pour valider la modification.

dereckson added a commit: rOPSfc387282b35f: Mount MySQL root ZFS dataset as /var/db/mysql/data.Tue, Nov 25, 10:05

Deployed on WindRiver.

Next: deploy on db-B-001

Mounting the ZFS datasets mysql-innodb-data and mysql-innodb-logs outside of /var/db/mysql, then deploying them to db-B-001: operation completed and functional.

Mount mysql-innodb-data and mysql-innodb-logs ZFS datasets outside /var/db/mysqlClosed, ResolvedPublicActions

Description

Revisions and Commits

Event Timeline

Mount mysql-innodb-data and mysql-innodb-logs ZFS datasets outside /var/db/mysql
Closed, ResolvedPublic
Actions