/var/run/mysqld not present after reboot

Symptoms: after installation Mysql UP and work properly, but after first reboot isn't start because can't create pid/socket in /var/run/mysqld
Root cause is deb package create /var/lib/mysqld during installation 

percona-xtradb-cluster-server-5.7_5.7.25-31.35-1.stretch_amd64.deb/deb://DEBIAN/preinst
...
MYSQLRUN=/var/run/mysqld
...
if [ ! -d ${MYSQLRUN} -a ! -L ${MYSQLRUN} ];
then
    mkdir ${MYSQLRUN}
    chown mysql:mysql ${MYSQLRUN}
    chmod 755 ${MYSQLRUN}
fi
...
but after reboot, /run (/var/run is symlink to /run) recreated from scratch and /var/run/mysqld directory not present anymore. For Debian/Ubuntu/Centos correct way for solve this problem is tmpfiles.d 
#cat /etc/tmpfiles.d/mysqld.conf
d    /var/run/mysqld    0755    mysql    mysql    -    -

Comments

Post a Comment

Popular posts from this blog

FreeRadius and Google Workspace LDAP

This is the first time when I used FreeRadius, this program reminds me of Postfix, I mean similar complicated and powerful tool. Only one big difference - very bad documentation and not enough examples. In the maillists a lot of questions without answers from FreeRadius guru. Here I provided examples of how I solved some problems or where I took too much time…
Read more

pssh (parallel-ssh) problems on Debian 10 with Python 3.7

Python reminds me of PHP many years ago with totally incompatible versioning on one server. Do you need another version? The best way - new servers, because any update or installation can break all global environments. Half a year after “Sunsetting Python 2” but main distributions continue to push python2 during installation and it’s a big challenge not to replace the default version after some update or installing a new package.
Read more