hostinfo.sh

I created a new script hostinfo.sh, it works a little like this:

-------------------
Mon Mar 27 00:13:55 [bash:5.1.16 jobs:0 error:0 time:0]
jj5@charm:/home/jj5
$ hostinfo.sh
id.............: 218-jj-wrk-8-charm-prod-home

fqdn...........: charm.jj5.net
host...........: charm
host-prod......: charm
host-test......: charm-test
domain.........: jj5.net

sysid..........: 218
system.........: jj-wrk-8
realm..........: jj
class..........: wrk
typenum........: 8

deployment.....: prod
provider.......: home
environment....: home
netenv.........: prod
net............: GREEN

instance-type..: None
-------------------

Arlec Single Outlet Safety Switch

Thanks to my mate Raz I now have an Arlec Single Outlet Safety Switch from Bunnings. It’s a 30mA residual-current device (RCD), which is a type of earth-leakage circuit breaker (ELCB).

Over here:

You can see my bench UPS in the bottom right:

It’s a PowerShield Defender 1200VA.

The UPS then has the Arlec device in the back of it, which then powers the rest of my bench (behind the scissors):

You can see I still have my Xbox power cable plugged in. We’re not sure exactly what that does. In addition to an electronic fuse maybe an RCD or maybe an arc-fault circuit interrupter (AFCI) or maybe all of the above.

Two simple ways to version control your MariaDB schema changes

Over on Two simple ways to version control your MariaDB schema changes I learned a neat hack you can use to check for database schema revisions by reporting off the binlog.

The example command given was:

$ mysqlbinlog --no-defaults -R -u foo -p -d foodb -h db.home.arpa mysqld-bin.000001 > foodb.txt