I have a couple questions regarding filesystem permissions for the user running innobackupex/xtrabackup. I see the manual states:
“Once connected to the server, in order to perform a backup you will need READ, WRITE and EXECUTE permissions at a filesystem level in the server’s datadir.”
What is the recommended user to run innobackupex/xtrabackup via a cronjob? Is it recommended to run it under root or under a non-privileged user that has read-only access to the datadir? I prefer to run backup jobs under a non-root account if possible, but wanted to make sure it won’t cause any issues. The files in my datadir are owned by mysql:mysql and are chmod 600 or 660, so I would have to alter that to allow a non-root user to access them. Just curious how others set this up.
Does the user need write and execute privileges to the datadir or can it be read-only? In other words, does a backup write anything to the datadir?
Thanks for your help.