With MariaDB, Can I MANUALLY edit the 'my.cnf' file? (it keeps recovered after reboot)


My HA have MariaDB for recorder, command line access.
And (since I’m a professional DB admin) want to manually, permanently edit the
MariaDB setting for the performance.

At the ‘/etc/my.cnf’ file,
I can edit the file. But once reboot, it appears.

  1. Is there any specific option to be allowed?
  2. How to prevent the rolling back the my.cnf?

What kind of MariaDB installation do you have?
AFAICT, the HA addon do not use “my.cnf” but “/etc/my.cnf.d/mariadb-server.cnf”

Using the HA addon version.
by the way,
the “/etc/my.cnf.d/mariadb-server.cnf” file also reset(means rollback after system reboot) as well.
Any clue to solve the issue?

(HA rasbp image + HA addon MariaDB + SSH & Web Terminal without protected mode)

IDK. You’re not supposed to lose the overlay after a reboot, but it’s anyway a bad idea to do modifications like this because you’ll lose them for sure after an addon update