MySQL External DB Connection Loss & Stability of Hass

Configuration
1

I am running hassio and I want to set up an external MySQL database for the recorder component. However, I’m wondering, if I do so… what then happens if the mySQL DB fails… does HASS quit? or does it just continue on and throw errors until I config it to use the SQLite DB again? or fix the MySQL DB? Any insight would be helpful in planning.

I just don’t want to add any instability to my hassio instance that runs very well on a Pi3. Just want to speed it up and bit by offloading the DB to a docker instance, elsewhere. Thanks.

2

I have two pi’s, a mac and a windows pc (offsite through vpn) all running HA and all connect to the mac’s mysql database. (one database track 4 HA instances)

I don’t ever remember HA not starting or losing stability because it couldn’t reach the mac’s mysql. I think it just creates a local database but I can’t remember.

1 Like