NFS mount for DB machine will work for mongodb but NOT mysql

[willkara]

So my setup is as follows:

• FreeNAS- Simple file server. Meant to serve up a mounted endpoint for the data directories
• deebee- A VM (using XenServer) that'll act as the VM for all of the databases.

I've attached pictures of the current setup for the storage system AND the share I'm using.

And here's what the share looks like on the vm side.

• The mount point in /

• The dirs in /deebee_storage

And then in the respective .conf files for each program I have the datadir set as those. Each server is running as its normal user (mongo/mysql)

MongoDB works no problem, but everytime I try to get mysql to start up with the mounted point as its data_dir, it fails with the "cant write" problem.

2016-05-19T03:30:20.947435Z 0 [Warning] Can't create test file /deebee_storage/mysql_data/deebee.lower-test
2016-05-19T03:30:20.947521Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.12-0ubuntu1) starting as process 15456 ...
2016-05-19T03:30:20.953217Z 0 [Warning] Can't create test file /deebee_storage/mysql_data/deebee.lower-test
2016-05-19T03:30:20.953295Z 0 [Warning] Can't create test file /deebee_storage/mysql_data/deebee.lower-test


2016-05-19T03:30:21.005178Z 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2016-05-19T03:30:21.005333Z 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable


So, is it a permissions problem with the share.... a problem with MySQL.... I'm pretty stuck at this point :/

 

[dlavigne]

Does changing ownership of mysql_data to mysql/mysql fix it? I'm pretty sure that mysql demands to own that directory...

 

[m0nkey_]

Does changing ownership of mysql_data to mysql/mysql fix it? I'm pretty sure that mysql demands to own that directory...

I concur with @dlavigne on this one. The MySQL database directory needs to be owned by the MySQL user.

 

[Mirfster]

Are you really sure you want "Other" to have all those rights as well?