How to convert Home Assistant database to MariaDB
Thank you for watching. In this video we will change the Home Assistant database to run on MariaDB, which is a relational database. It is faster and more reliable than the default SQLite database included with Home Assistant.
Due to the higher number of disk writes in MariaDB, do not use this if you are running your Home Assistant instance on an SD card. Upgrade to an SSD (tutorial video to follow) or a virtual machine on Proxmox (https://youtu.be/arKoIPQ5_YU) or another hypervisor.
Please like and subscribe, and click on the notification bell so you can be alerted to new videos.
If you would like us to create videos on a particular topic, technology or product, please leave a comment below.
When browsing to your Home Assistant instance, this is usually – homeassistant.local:8123. If this does not work, try homeassistant:8123. If all else fails, check your router’s device listing for the IP address.
Chapter links:
0:00 – Intro
0:06 – Installing MariaDB
1:40 – Configuration
2:27 – Replacing HA database
4:23 – Testing
4:55 – Deleting old database
The below is completely optional but this will help us to purchase kit for review, and to keep up with channel expenses (studio kit, etc).
Amazon link (no cost to you but buying through the link helps my channel) – https://amzn.to/3fj2S8a
Ko-Fi – https://ko-fi.com/smarthomeaddict
Buymeacoffee – https://www.buymeacoffee.com/smarthomeaddict
Patreon – https://www.patreon.com/smarthomeaddict
Finally, please visit our website at https://smarthomeaddict.co.uk
Comments are closed.