Using a external MySQL server with Hass.io for Recorder

[VDRainer]

Here is a monster topic about using mysql database.

Large homeassistant database files

Hey guys, Keep running into the following problem, even from older to current versions of HomeAssistant. My HomeAssistant database files keep getting very large >100mb. When this happens, I can’t restart home assistant from the UI. I run HomeAssistant in a docker, so must do docker restart home-assistant. Restarting becomes really really slow. On the 16th of August, my home_assistant_v2.db file got to 244mb. I renamed it, and let a new DB get generated after a reboot On the 29th of August, m…