← Back to team overview

maria-discuss team mailing list archive

Re: Maria-db refuses to start


Am 13.10.22 um 14:54 schrieb Jogchum Reitsma:
frankly why don#t you move the datadir out of your suerhome and change the path to the datadir in the config?
25 years ago I decided that the data is only useful to me, so why place it anywhere else than in my home directory? After all, that's where all my personal files reside, so why treat this data otherwise?

but database files are not normal user files and can't be backuped while the service is running in a safe way like your personal document files

so it makes little sense to handle different beasts identical

There I have plenty of room in a raid6 configuration, where the default location is much smaller, and populated by the infamous (well, with me at least) btrfs filesystem.

you can put the data in /home/mysql, make a bind-mount from /var/lib/mysql to /home/mysql and change the config to use /var/lib/mysql

voila, ProtectHome no longer hits because from the viewpoint of systemd and mariadb the datadir isn't below /home


Follow ups