Page MenuHomeDevCentral
Differential D3890

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

Authored by ptdradmin on Mon, Nov 24, 14:30.
Tags
None
Referenced Files
F18655112: D3890.id10073.diff
Sat, Dec 20, 04:43
F18511652: D3890.id10073.diff
Fri, Dec 19, 15:51
Unknown Object (File)
Thu, Dec 18, 12:45
Unknown Object (File)
Sun, Dec 14, 21:22
Unknown Object (File)
Sun, Dec 14, 04:49
Unknown Object (File)
Sun, Dec 14, 04:49
Unknown Object (File)
Thu, Dec 11, 20:57
Unknown Object (File)
Thu, Dec 11, 20:57
View All 46 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.Mon, Nov 24, 14:30
dereckson created this revision.
Harbormaster completed remote builds in B6199: Diff 10073.Mon, Nov 24, 14:30
dereckson foisted this revision upon ptdradmin.Mon, Nov 24, 14:30
dereckson added a reviewer: dereckson.
dereckson added a reviewer: dereckson.
dereckson updated this revision to Diff 10074.Tue, Nov 25, 09:59

Update also the datadir path at service level

Harbormaster completed remote builds in B6200: Diff 10074.Tue, Nov 25, 09:59
dereckson accepted this revision.Tue, Nov 25, 10:02
dereckson edited the summary of this revision. (Show Details)
This revision is now accepted and ready to land.Tue, Nov 25, 10:03
dereckson added a comment.Tue, Nov 25, 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 WhyTue, Nov 25, 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