04
Dec/23Smart Bulbs With Light Switches
Borrowing this idea from Tom McGuinness. This is the ultimate setup to allow features of a smart bulb like changing colours, Zigbee/Matter repeater and still retain the functional use of your light switch. The concept is to disconnect the bulb … Continue reading
06
Nov/23MariaDB/MySQL Database Size Sensor In Home Assistant
A quick little tip to get the size of your database into Home Assistant. The example below will get the Home Assistant database size from MySQL. This should also work for MariaDB using the Recorder integration. Assuming the database schema … Continue reading
02
Oct/23DigitalOcean Managed (Clustered) Database With WordPress
Overview I have an existing WordPress site running on DigitalOcean on a self managed instance (Droplet). It was time for an OS upgrade and generally I like to start from scratch rather than doing an in place upgrade. Ideally, I … Continue reading
04
Sep/23MySQL Consider increasing innodb_redo_log_capacity
Overview I started getting the following warnings in the log from MySQL: 2023-03-18T05:12:59.566053Z 0 [Warning] [MY-013865] [InnoDB] Redo log writer is waiting for a new redo log file. Consider increasing innodb_redo_log_capacity. Redo logs are stored transactions that are used to … Continue reading
07
Aug/23Salt Level For Water Softener With ESPHome
overview We got a water softener installed near the water mains coming into the house. It’s a “dumb” softener so that it does not rely on using electricity. This means it will continue to work in a power outage but … Continue reading
03
Jul/23Unraid
Overview I have been using Unraid for over 2 years now and it has a great in-between a full solution such as a NAS dedicated hardware and a homelab DIY solution. The idea was to use it as a server … Continue reading
05
Jun/23Increase Growatt Shine Update Interval
A quick, at your own risk tutorial to change the reporting frequency of your Growatt Shine sensor data. This won’t change the data being reported on the Growatt dashboard / ShinePhone app however it will show up things like grott … Continue reading
01
May/23Home Assistant Continuous Integration Workflow 2023
Overview Previously, I was using TravisCI to perform checks on any changes to Home Assistant files. Since then, TravisCI has introduced caps and pricing plans and on the free tier I ran out of credits very quickly which broke the … Continue reading