pt-table-checksum & Waiting to check replicas for differences: 0% 00:00 remain
Kedar
This post discuss the pt-table-checksum & error “Waiting to check replicas for differences: 0% 00:00 remain” with a use-case and solution.
How to Add Remote MySQL Server to Nagios Monitoring
We already have seen two articles for setting up MySQL Monitoring with Nagios and Percona Monitoring Tools for Nagios. Those posts covers configuration of nagios on single instance. Though following…
MySQL Permission denied error 13 and solution
MySQL ERROR 1018 (HY000): Can’t read dir of ‘./sakila/’ (errno: 13 – Permission denied) caused due to moving database to a different partition and using softlink on CentOS and it’s fix for SELinux.
How to monitor MySQL backups
It’s important to monitor the (database) backups after you set-it-up. In this post we will answer a few how to monitor MySQL Database backups solutions – monitoring methods. We should…
Install Percona Monitoring Tools for Nagios – MySQL Plugins
Recently a friend asked about Installing Percona Monitoring Tools for Nagios as he was facing a few issues. I managed to set-it-up on my ubuntu VM. Sharing the the work-log…
UMASK & UMASK_DIR – changing default MySQL file dir permissions
UMASK and UMASK_DIR are amongst few MySQL Environment variables which defines directory and file creation modes (file permissions). In this post we will understand using UMASK & UMASK_DIR for changing the database directory and file permissions from it’s default to what we need.
One response to “UMASK & UMASK_DIR – changing default MySQL file dir permissions”
Hi, I need some help managing user to start MariaDB.
In my case I make a clean installation and is installed in /var/lib/mysql and the owner of the files and folder is mysql:mysql.
I’ve created another user ‘mariadb’, then I want to change owner of data to mariadb:mariadb. If i change all by ‘chown -R..’ under ../mysql/ path I can’t start the process.
Another thing I need to do is change the path and create a symbolic link from the /var/lib/mysql to the new path. But its not work also with the mysql:mysql owner.
How must be the best practice to do it? Thanks