Hi
I’ve been running my MariaDB server on my Synology NAS (DS212j) which has worked fine for the past few years. However recently a notification is shown in Home Assistant with a suggestion to upgrade the MariaDB server to 10.5.17 or later to resolve a significant performance issue.
My assumption:
- Create docker container with MariaDB, configure database name + user and grant access
- Login to Synology NAS MariaDB (phpmyadmin) and create export of all databases
- Login to docker MariaDB and import all databases
- Update MariaDB configuration in HA and restart
Is it as simple as that?
Most data is of no importance to me except for the historic solar information. Do I need to stop the recorder first from writing to the current database or not? I assume I obviously lose information between the export + import & configuration switch, but that would (hopefully) be minimal.
I haven’t noticed anything of the performance issues but the warning is bothering me