Utilize Maria-DB for SQL store

[dcmartin]

Apparently utilizing Maria DB for the SQL store is much faster than the standard SQL3 database.

I tried to setup the homeassistant/recorder.yaml to utilize the MariaDB addon, but it didn't work properly.

I tried to run MariaDB in a container (see sh/mariadb.sh), but HA throws errors trying to use the DB for some updates; IDK.

Any help appreciated.

[dcmartin]

Configuration of Home Assistant through the recorder component has commented-out directive:

#db_url: !secret mariadb-url

The secret mariadb-url is defined using a template:

mysql://homeassistant:${MARIADB_PASSWORD}@${MARIADB_HOST}/homeassistant?charset=utf8mb4

• MARIADB_PASSWORD should match MariaDB add-on configuration; default is HomeAssistant1234
• MARIADB_HOST default is core-mariadb; alternative server IP address may be used

Starting the MariaDB from the standard add-on store repository will provide the required SQL services.

See https://github.com/dcmartin/motion-ai/blob/master/docs/MARIADB.md