I am attempting to run Percona Server on CentOS 7 in a VM on Windows Azure. This is using an attached disk for the data storage.
Unfortunately when I try and get the server to start with the datadir being on the attached disk, it fails for the following reason:
: /usr/bin/mysqld_safe: line 184: /datadrive/mysqldata/binlogs/udb6.log: Permission denied
May 16 06:05:20 pppudb6 mysqld_safe[50758]: touch: cannot touch ‘/datadrive/mysqldata/binlogs/udb6.log’: Permission denied
May 16 06:05:20 pppudb6 mysqld_safe[50758]: chown: cannot access ‘/datadrive/mysqldata/binlogs/udb6.log’: Permission denied
May 16 06:05:20 pppudb6 mysqld_safe[50758]: chmod: cannot access ‘/datadrive/mysqldata/binlogs/udb6.log’: Permission denied
May 16 06:05:20 pppudb6 mysqld_safe[50758]: 150516 06:05:20 mysqld_safe mysqld from pid file /var/lib/mysql/mysql.pid ended
May 16 06:05:20 pppudb6 mysqld_safe[50758]: /usr/bin/mysqld_safe: line 147: /datadrive/mysqldata/binlogs/udb6.log: Permission denied
May 16 06:05:20 pppudb6 systemd[1]: mysqld.service: main process exited, code=exited, status=1/FAILURE
May 16 06:08:54 pppudb6 systemd[1]: Stopping MySQL Percona Server…
May 16 06:08:54 pppudb6 systemd[1]: Stopped MySQL Percona Server.
May 16 06:08:54 pppudb6 systemd[1]: Unit mysqld.service entered failed state.
Permissions look fine as per:
drwxr-xr-x. 76 mysql mysql 4.0K May 15 03:48 2015-05-12_03-06-22 * This is the mysql data dir
drwxr-xr-x. 2 mysql mysql 4.0K May 15 04:36 binlogs * binlogs dir
Yet, when it attempts to run it says there is the permission issue. If I run it using default settings in /var/lib/mysql it works, just not on the attached disk which would be useful if I could get it to work!
Any ideas? I can get this to run fine on Ubuntu, but not on CentOS.