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 →

06

Jun/22

MySQL caching_sha2_password: the specified module could not be found.

Filed Under Database at 6th June 2022 0:01 by

Upgrading from MySQL 5.x to 8 has caused an error with existing accounts. The fix is to set the authentication to use. More details can be found here. MySQL 8.0.11 error connect to caching_sha2_password the specified module could not be … Continue reading →

07

Sep/20

Upgrading MySQL Running In Docker (Compose)

Filed Under Container, Database at 7th September 2020 0:01 by

Overview I wanted to try and upgrade my MySQL database from 5.7 to 8.0 however I have containerised my database install. What I thought was a immutable container would be a simple burn and switch turned out to be a … Continue reading →

07

May/18

Cannot load from mysql.proc. The table is probably corrupted

Filed Under Database at 7th May 2018 0:01 by

I was trying to update accounts in MySQL and got the following error message: Cannot load from mysql.proc. The table is probably corrupted A little bit scary if my data was corrupted. Turns out there is an upgrade command which … Continue reading →

05

Dec/16

Post MySQL Install

Filed Under Database at 5th December 2016 0:01 by

After installing MySQL you can run the below command to secure your install: sudo mysql_secure_installation The script will ask a bunch of questions and act accordingly so it is only as secure as you want it to be but it … Continue reading →

22

Feb/16

Migrating From Ubuntu 14.04 To 16.04

Filed Under Container, Database, Infrastructure, Linux at 22nd February 2016 0:01 by

Overview I have written migration plans for Ubuntu upgrades before. What makes it different this time is the hybrid Docker containers that I have used in places and the support for virtual IP (VIP) in Digital Ocean, my current hosting … Continue reading →