Page MenuHomeDevCentral
Differential D3890

Mount MySQL root ZFS dataset as /var/db/mysql/data
ClosedPublic
Actions

Authored by ptdradmin on Nov 24 2025, 14:30.
Tags
None
Referenced Files
Unknown Object (File)
Mon, Jun 1, 01:41
Unknown Object (File)
Fri, May 29, 06:18
Unknown Object (File)
Thu, May 28, 22:00
Unknown Object (File)
Mon, May 25, 18:20
Unknown Object (File)
Mon, May 25, 14:48
Unknown Object (File)
Mon, May 25, 06:03
Unknown Object (File)
Sat, May 23, 10:10
Unknown Object (File)
Sat, May 23, 05:22
View All Files
Subscribers
None

Details

Reviewers
dereckson
Maniphest Tasks
T2074: Mount mysql-innodb-data and mysql-innodb-logs ZFS datasets outside /var/db/mysql
Commits
rOPSfc387282b35f: Mount MySQL root ZFS dataset as /var/db/mysql/data
Summary

When mounting InnoDB ZFS datasets directly in /var/db/mysql,
and using that directory as root data directory,
MySQL server tries to read those InnoDB directories as databases.

Ref T2074

Signed-off-by: Sébastien Santoro <dereckson@espace-win.org>

Test Plan

Deploy on WindRiver

Diff Detail

Repository
rOPS Nasqueron Operations
Lint
Lint Passed
Unit
No Test Coverage
Branch
mysql-zfs-dir-structure
Build Status
Buildable 6200
Build 6484: arc lint + arc unit

Event Timeline

dereckson requested review of this revision.Nov 24 2025, 14:30
dereckson created this revision.
Harbormaster completed remote builds in B6199: Diff 10073.Nov 24 2025, 14:30
dereckson foisted this revision upon ptdradmin.Nov 24 2025, 14:30
dereckson added a reviewer: dereckson.
dereckson added a reviewer: dereckson.
dereckson updated this revision to Diff 10074.Nov 25 2025, 09:59

Update also the datadir path at service level

Harbormaster completed remote builds in B6200: Diff 10074.Nov 25 2025, 09:59
dereckson accepted this revision.Nov 25 2025, 10:02
dereckson edited the summary of this revision. (Show Details)
This revision is now accepted and ready to land.Nov 25 2025, 10:03
dereckson added a comment.Nov 25 2025, 10:04
  • deployed successfully on WindRiver (with service fix)
  • peer session for deployment/review
Closed by commit rOPSfc387282b35f: Mount MySQL root ZFS dataset as /var/db/mysql/data (authored by ptdradmin, committed by dereckson). · Explain WhyNov 25 2025, 10:05
This revision was automatically updated to reflect the committed changes.
dereckson added a commit: rOPSfc387282b35f: Mount MySQL root ZFS dataset as /var/db/mysql/data.

Revision Contents
Changeset List

PathSize
roles/
dbserver-mysql/
mysql-server/
6 lines
files/
conf.d/
2 lines
2 lines
12 lines
2 lines

Diff 10074

View Options

roles/dbserver-mysql/mysql-server/cnf.sls

Loading...
View Options

roles/dbserver-mysql/mysql-server/files/conf.d/server.cnf

Loading...
View Options

roles/dbserver-mysql/mysql-server/files/mysql.rc

Loading...
View Options

roles/dbserver-mysql/mysql-server/software.sls

Loading...
View Options

roles/dbserver-mysql/mysql-server/zfs.sls

Loading...
Nasqueron DevCentral · If it had been much bigger the moon would have had a core of ice. · Powered by Phabricator