Home Assistant 0.103.6 更改MySQL数据库

Home Assistant的SQLite数据库在默认的配置文件夹的home-assistant_v2.db文件，随着使用容量会越来越大，稳定性变差，我们现在使用MySQL数据库来替换SQLite数据库。

视频教程如下：

https://youtu.be/Q25AEpWMmXE

安装MySQL:

sudo apt-get -y install mariadb-server python3-pymysql python-pymysql
sudo systemctl enable mysql
sudo systemctl restart mysql 创建mysql用户名密码： CREATE DATABASE hass;
CREATE USER 'hass'@'%' IDENTIFIED BY 'hass123456';
GRANT ALL ON *.* TO 'hass'@'%';
FLUSH PRIVILEGES;

Home Assistant配置文件增加：

purge_keep_days：代表保留几天的日志

recorder:
  purge_keep_days: 5
  db_url: mysql+pymysql://hass:hass123456@localhost/hass?charset=utf8

参考下面例子可以排除记录和仅记录某些内容：

recorder:
  purge_days: 5
  db_url: mysql://dbuser:password@localhost/dbname?charset=utf8
  exclude:
    domains:
      - automation
      - weblink
      - updater
    entities:
      - sun.sun   # Don't record sun data
      - sensor.last_boot
      - sensor.date
  include:
    domains:
      - sensor
      - switch
      - media_player
  exclude:
    entities:
     - sensor.last_boot
     - sensor.date