I’m finally getting around to using the systemd version of mariadb and having trouble getting the database to start.
Past/background: Starting with 12 sp1 suse went from a init.d script to systemd to run mariadb. Well that didn’t work to well for as we had many DB servers running multiple instances and the systemd didn’t handle it well. So what we did was:
- add “.off” to the service files in /usr/lib/systemd/system
- copy the init.d script from 12 sp0 to /etc/init.d
- then run systemctl daemon-reload.
This has worked for every DB server we had.
Now every time there’s an update to mariadb we have had to do this process. I’m trying to get away from it but i’m running into this problem.
Little more info: the database files are not in the default location that suse places them. We do use /etc/my.cnf and specify the file locations in here. That includes the multiple DB instances.
Not sure why it’s not working but after looking at the mysql-systemd-helper it appears to require that the files be in the default locations.
Any other ideas are welcome. Thanks