HOME ASSISTANT - FASTER AND MORE RELIABLE WITH MARIA DB

Published at : 18 Dec 2025

Welcome to our step-by-step guide on installing and configuring MariaDB for a faster and more reliable Home Assistant setup!

In this video, we’ll walk you through the entire process of setting up MariaDB as your database for Home Assistant. We’ll cover everything from installation to configuration, ensuring you have all the knowledge you need to get your Home Assistant running smoothly, with the added speed and reliability that MariaDB brings.

Check out the handy dandy link for migration of a SQL Lite to MariaDB database. Let us know how you go in the comments.

What you’ll learn:
- The benefits of using MariaDB over other databases.
- How to install MariaDB on your system.
- How to configure MariaDB for optimal performance with Home Assistant.
- How to test your setup to ensure everything is working correctly.
Join us on this journey and improve the speed and reliability of your Home Assistant today!'

___📢 Don't Miss Out 📢 ___
👍 Like this video if you found it helpful! 👍
📩 Subscribe for more smart home content – https://tinyurl.com/5n8h5dft 🚀
🎮 Join us on Discord - https://discord.gg/zEB633Dv 🎮
🔔 Hit the bell icon so you never miss an update! 🔔

___💙 Want to support the channel 💙 ___
➡️ Become a Member for exclusive perks & early access! 🔥
🙏 Become a channel member - https://tinyurl.com/y7z464jv 🙏

____ ☕ Buy Me A Coffee! ☕ ___
PayPal Donation - https://www.paypal.com/donate/?hosted_button_id=AHZFTRKKUCU2W
Buy Me A Coffee - https://tinyurl.com/4sy69eds

Script available on Buy Me A Coffee (members) - https://www.buymeacoffee.com/smarthomeaustralia/home-assistant-mariadb-faster-more-efficient

#homeassistant #database #tutorial

=== Timestamp===
00:00 – Introduction
01:41 - Installation
02:58 - Configuration
03:47 - Verification of installation and configuration
04:15 - Optional - Deletion of default database
06:04 - Roundup

=== Handy Dandy Information ===
Migration of SQL Lite to MariaDB - https://hevodata.com/learn/sqlite-to-mariadb/
Studio Code Server Installation - https://youtu.be/xexz23v10ek
SSH and Web Terminal Advanced Installation and Configuration - https://youtu.be/fw69Tf9F5DU

== Affiliate Links ===
NordVPN (Get 72% off NordVPN + a Saily eSIM data gift) - https://go.nordvpn.net/SH8jJ

Sonoff discount, *SMARTHOMEAUS*, has now been increased to 15% on ALL products!!
ZB Dongle-E - https://urlday.cc/jjb33
Zigbee Bridge Ultra - https://urlday.cc/zca9m
ZBMicro - https://urlday.cc/i5fmd
SNZB-01P - Zigbee Wireless Switch - https://urlday.cc/5o8k6
SNZB-02P - Zigbee Temp and Humidity Sensor - https://urlday.cc/ss33w
SNZB-02D - Zigbee Temp and Humidity Display - https://urlday.cc/qq1ez
SNZB-03P - PIR Motion Sensor - https://urlday.cc/86w5y
SNZB-04P - Door Contact Sensor - https://urlday.cc/j8ifs
SNZB-06P - Zigbee Human Presence Sensor - https://urlday.cc/4uy62

SwitchBot Lineup
International - https://bit.ly/3FFtBcr (includes 30% OFF for all products for a limited time)

Home Assistant Server (HP EliteDesk 800 G4)
US - https://amzn.to/3DcEjG8
AU - https://amzn.to/44hsyZW

Raspberry Pi 4 B 8GB (Full kit: inc. Power Supply, case, Micro SD, heat sink etc.)
Ali-Express - https://s.click.aliexpress.com/e/_Dm3oM5t

Broadlink RM4 Pro (IR and RF)
US - https://amzn.to/3QNcADV
AU - https://amzn.to/45DgPpN

Broadlink RM4 Mini (IR Only)
US - https://amzn.to/3qHFEls
AU - https://amzn.to/3Esx0e9

Broadlink RM3 Mini (IR Only)
US - https://amzn.to/3swyAbO
AU - https://amzn.to/45kl6Pf

Cielo Breez Lite (AC Control)
US - https://amzn.to/3KBvsSb
AU - https://amzn.to/47CQ8TU

Meross Smart Garage Door Opener Remote
US - https://amzn.to/45tLPIQ
International - https://s.click.aliexpress.com/e/_DF91Cnz

Aqara Cube (T1 Pro version)
US - https://amzn.to/3ruViR8
AU - https://amzn.to/3P7v2WI

ConBee II The Universal Zigbee USB Gateway
US - https://amzn.to/3pFmE6S
AU - https://amzn.to/3P5NtLo

Aeotec Z-Stick Gen5 Plus Z-wave USB Hub
US- https://amzn.to/3ro41om
AU - https://amzn.to/3E5kQYj

Aqara FP1 Human Presence Sensor
US - https://amzn.to/3pIWRKZ
International - https://s.click.aliexpress.com/e/_DBxn5vl

The site receives a small commission if you order from any of the links above. This does not cost you anything and is paid by the supplier.