01

Apr/24

Monitoring Boiler Flow Temperature

Filed Under Home Automation, Houseware, Infrastructure at 1st April 2024 0:01 by

Overview I have a basic gas boiler in a conventional setup. After watching Heat Geek channel and their videos on heat pumps, I too wanted to look at how efficient my boiler was running. I did not want to make … Continue reading →

04

Mar/24

Remove Windows Family Account

Filed Under Windows at 4th March 2024 0:01 by

A quick post to a video on how to remove a Microsoft Family account from a computer. When you disable an account from logging into the computer, their profile and all associate files remain on the computer. This is not … Continue reading →

05

Feb/24

Solar Assistant With EMQX Data Bridge

Filed Under Infrastructure at 5th February 2024 0:01 by

Overview My Growatt inverter has been lacking the integration to control the charging of the battery from the grid in Home Assistant. The feature exists in it’s own app and platform but it’s a real pain in the back side … Continue reading →

01

Jan/24

Moes Zigbee Thermostat

Filed Under Hardware at 1st January 2024 0:01 by

Overview I have an electric underfloor heating in one of the rooms. It uses the old version of the ProWarm Pro Digital Thermostat. It has the usual controls for a non connected thermostat such as schedule and manual heating controls. … Continue reading →

04

Dec/23

Smart Bulbs With Light Switches

Filed Under IOT at 4th December 2023 0:01 by

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/23

MariaDB/MySQL Database Size Sensor In Home Assistant

Filed Under Database, Home Automation at 6th November 2023 0:01 by

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/23

DigitalOcean Managed (Clustered) Database With WordPress

Filed Under Database, Infrastructure, Linux at 2nd October 2023 0:01 by

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/23

MySQL Consider increasing innodb_redo_log_capacity

Filed Under Database, Infrastructure at 4th September 2023 0:01 by

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 →