#REPLACE MARIADB INSTALL#
#REPLACE MARIADB PASSWORD#

Using the “File editor” add-on, click on the folder icon. You will need to edit two configuration files so that Home Assistant will use the MariaDB database. It is a pretty simple add-on to configure.

#REPLACE MARIADB INSTALL#

That is all you need to do to install MariaDB. You may want to enable the “Watchdog” so that the database service will restart if it crashes. Go back to the “Info” tab and click the “Start” button. You may leave the username and database with the default name of homeassistant.

#REPLACE MARIADB PASSWORD#

If you do not already have MariaDB installed, you will need to go to the “Settings > Add-ons” page.Ĭlick the “Install” button to install the add-on.īefore clicking the “Start” button, go to the “Configuration” tab so that you can set the password for the default user.Įnter your desired password in the “Logins” section.

I do not know if it is possible to migrate the data from SQLite to MariaDB. Warning: You will lose any current history when switching to MariaDB.

If you are already using MariaDB for other purposes such as for Nginx Proxy Manager, you can also use it for Home Assistant itself so that is convenient. This guide will use the official MariaDB add-on. Database reliability may be another reason you may wish to switch to MariaDB. In the year or more of running Home Assistant using the default database, I did not see it happen, but I am also running it in a virtual machine on my server rather than on a Raspberry Pi which uses a microSD card. I do not know how prevalent this issue issue is. When looking up information about changing the database Home Assistant uses, I saw some say one reason for switching is to have a more reliable database since the SQLite database can randomly become corrupt.

If your Home Assistant produces a lot of data, switching databases is one way you can boost performance as long as your hardware is not too slow (I would not recommend using an older Raspberry Pi, for example). However, you can use other databases such as MariaDB which perform better for larger datasets even though MariaDB is is heavier on hardware resources than SQLite. By default, Home Assistant uses a SQLite database to store all its historical data.

Replace mariadb