Centos – MySQL with NFS as datadir on CentOS

centosMySQLnfs

I'm trying to set up MySQL using a NFS mount as datadir on CentOS.

When starting mysqld while using a mount I get this error:

chown: changing ownership of '/srv/mysql': Operation not permitted

I need to know which options I have to set to the NFS exports so MySQL can start and chown the mounted folders and files.

Best Answer

If possible I would make sure there is a mysql user and group on client and server with the same UID and GID. Make sure that the directory being exported and all the contents are owned by mysql:mysql. I'm not 100% but you may want to make the mountpoint on the client mysql:mysql before mounting the NFS share.

Running MySQL with its data files on NFS is not a particularly good design though. I hope you're not trying to run multiple servers from the same data files. I was amazed to have an I.T guy ask me if he could do this just the other day.

Related Solutions

Linux – How to mount multiple folders with nfs4 on centos

In order to share the subdirectories, I had to share the parent folder first with fsid=0. So on the server /etc/exports looks like this:

/var/shared 192.168.200.101(rw,fsid=0,sync)
/var/shared/folder1 192.168.200.101(rw,sync)
/var/shared/folder2 192.168.200.101(rw,sync)

then on the client /etc/fstab looks like:

192.168.200.201:/folder1 /home/nfsmnt/folder1 nfs4 rw 0 0
192.168.200.201:/folder2 /home/nfsmnt/folder2 nfs4 rw 0 0

I can then mount the folders as expected:

mount /home/nfsmnt/folder1

Linux – How should I install NFS on a linux system

yum -y install nfs-utils portmap

Prepare and modify /etc/exports for sharing files, that would similar to as shown below

/home/NFS-files 192.168.100.0/24(ro,sync)

/home/NFS-share */26(rw,sync)

/ISO 192.168.100.0/24(ro,sync)

service portmap start

service nfs start

Best Answer

Related Solutions

Linux – How to mount multiple folders with nfs4 on centos

Linux – How should I install NFS on a linux system

Related Topic