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
F13858148: D3890.id.diff
Tue, Nov 25, 11:20
F13858119: D3890.diff
Tue, Nov 25, 11:20
F13858077: D3890.id10073.diff
Tue, Nov 25, 11:20
F13858071: D3890.id10075.diff
Tue, Nov 25, 11:20
F13858067: D3890.id10074.diff
Tue, Nov 25, 11:20
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