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
F25528618: D3890.id.diff
Thu, Apr 16, 05:43
F25513324: D3890.id10074.diff
Thu, Apr 16, 00:14
Unknown Object (File)
Tue, Apr 14, 17:00
Unknown Object (File)
Fri, Apr 10, 16:17
Unknown Object (File)
Fri, Apr 10, 03:20
Unknown Object (File)
Wed, Apr 8, 16:08
Unknown Object (File)
Wed, Apr 8, 09:30
Unknown Object (File)
Wed, Apr 8, 00:53
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 6199
Build 6483: 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
12 lines
2 lines

Diff 10073

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/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