Der Wikipedia-Artikel zum Thema Energieverbrauch ist wirklich interessant.

Schaut man sich zum Beispiel diese Grafik (oder die Tabelle, auf der sie basiert) an, dann sieht man:

Primärenergieverbrauch Deutschland 1990 bis jetzt

Wie man sieht, ist der Primärenergieverbrauch von Deutschland seit 1990 fast konstant geblieben. Wikipedia schreibt im Detail: “Zwischen 1990 und 2011 nahm das reale Bruttoinlandprodukt um 34 % zu, der Energieverbrauch nahm jedoch um 9 % ab.” Rechnet man um, sind es bummelig 14000 Petajoule, was circa 4000 TWh entspricht.

Another Friday, another replication hierarchy lost.

The error from June, July edition?

The errors reported look awfully familiar: Binlog position is supposedly 4, and the error message has text about “max_allowed_packet”. Could it be another instance of this bug from early last month?

Indeed, one symptom was “a large binlog, larger than max_binlog_size”. We check.

-rw-r----- 1 mysql mysql 1073794077 Jul  1 06:39 binlog.000914
-rw-r----- 1 mysql mysql 1073869075 Jul  1 07:09 binlog.000915
-rw-r----- 1 mysql mysql 1073741881 Jul  1 09:28 binlog.000916
-rw-r----- 1 mysql mysql 2038358667 Jul  1 11:21 binlog.000917

Log ends at 11:21, at twice the expected size. Meh.

We got our solar roof around 1st of April. I am describing our setup here . Today we got the bill for Summer 2021 to Summer 2022.

What I measured

I installed a P1 interface on my electricity counter late in April, so my data does not cover all of the lifetime of the Solar Roof. Starting the graph at 01-Apr-2022, I get this:

At this resolution, not very helpful.

I am on a Mac or on a Windows machine, and always I have to develop for a Linux target. On Windows, this is easy, because most Jetbrains environment already support working inside WSL2, so simply choosing this is a no-brainer.

On MacOS, I can create a “Docker Container” do develop in, but it is kind of a joke. That is, because MacOS cannot run Linux cgroups and namespaces natively, so you actually get a lightweight VM with Linux running, and then a container inside that. You might as well run Linux in VMware and start the Jetbrains thing inside that. It will hurt probably less than trying to edit inside a docker filesystem.

MySQL 8.0.29 adds ALGORITHM=INSTANT as a way to run ALTER TABLE commands with less wait. The documentation can be found in Online DDL Operators and instant column operations can be found here .

Example Syntax looks like this:

mysql> use kris;
mysql> create table t (id serial, d varchar(20));
Query OK, 0 rows affected (0.12 sec)

mysql> alter table t add column i integer not null, algorithm=instant;
Query OK, 0 rows affected (0.07 sec)
Records: 0  Duplicates: 0  Warnings: 0

Limited TOTAL_ROW_VERSIONS

The manual explains a new concept:

After getting a solar roof we have been looking at electric mobility solutions. But existing electrical cars seemed pretty much oversized. We do not really need a 4-seater with 650km range and two tons of total empty weight. Katja Diehl coined the german tongue-in-cheek term “Maximaleventualbedarfsauto” for it, the car that meets biggest use-case you could possibly reasonably have.

Looking around, we test drove a Carver.Earth , which was the right size, but limited to 45 km/h (and bike pathes in some areas). Then Carver started to offer the “Carver S+”.

I have been asked what kind of bike I ride and how to choose one.

Gazelle Grenoble 2017, with vaude Aquaback plus.

I am over 50 years old, over 200cm tall and weigh more than 120 kilo before I dresss. Back when we still had an office, that was a 22km trip, each direction.

I need an upright sitting position, a soft and comfortable seat. I need to be able to carry luggage, and a return-home guarantee. I need to be able to get useful service on the bike, because at my age I prefer to use money instead of time to keep the bike running.

(Twitter thread , reproduction in english, and update)

On Friday, 2022-06-03, 14:42, we lost a replication hierarchy, on the primary, all replicas down. At 16:30 the escalation hits my desk, because this one is special.

Replication stops, and wants more max_allowed_packet

There is a sequence of binlogs, each 1 GB in size, as configured, except for the broken one, which is 3 GB. Replication stops with

Got fatal error 1236 from master when reading data from binary log: 'log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master; the first event '' at 4, the last event read from '../log/binlog.002558' at 19959785, the last byte read from '../log/binlog.002558' at 19959804

Trying to run mysqldump -vvv ... on the broken binlog fails and produces no output useful for diagnostics.

Where I work, we manage databases in an automated way . Not as automated as I wish it to be, but largely without touching boxes.

We have been doing so for a long time.

Over ten years ago, I set the team the challenge “be on an arbitrary version of MySQL within 20 workdays (one calendar month), no matter how many servers we have”. We are there now, in a way: we are on a 30-day refresh cycle for our bare metal cloud, and we match that cycle for our virtualized fleet. It was a long road.

Der Schnuppel ist jetzt in der niederländischen Groep 8, also in der 6. und letzten Klasse der Grundschule. Die letzten Tests sind geschrieben, die Schulempfehlungen sind raus und bindend, die Folgeschule steht fest und hat die Anmeldung bestätigt. Das Schuljahr ist also noch lange nicht zu Ende, aber alle Arbeit ist getan.

Das Snackphone One, Zubehör und Nachfolgemodelle im Webshop.

Letzten Freitag kam der Schnuppel aus der Schule und berichtete davon, daß er mit einigen Freunden und Banknachbarn “Mobiltelefone” gebaut habe. Also, auf Papier gezeichnet und als Bastelset ausgeschnittene Mobiltelefonmodelle. Man habe jeweils unterschiedliche “Firmen gegründet” und den Schulkameraden jeweils sein Modell vermarktet.