backup – Page 5 – Türker Yıldırım

data_free, and the 80% of the file that is nothing

NoteJanuary 20, 20221 min read

InnoDB reuses freed space within a table and does not return it to the filesystem, so a table deleted from daily can be mostly empty and full size.…

The on-call rotation for a team of four

Deep diveDecember 3, 202010 min read

One person had the phone for two years. A rotation of four is a week in four, which is enough to be tiring and not enough to build…

The migration that squashed two hundred files

Deep diveNovember 5, 20209 min read

A test suite spending ninety seconds replaying six years of schema history. Squashing is a good idea with two failure modes worth knowing first.

Secrets that are not in the repository and not in the image

Deep diveSeptember 29, 202010 min read

The database password was in the repository, then in the image, then in an environment variable readable by anything that could run ps. Where it went next.

Auto-updates, and the site that changed underneath you

Deep diveAugust 6, 202010 min read

5.5 turns on plugin auto-updates per plugin, and a managed site is not a hobby site. A plugin updated at 03:00 and a checkout broken at 09:00.

predict_linear for a disk, not a percentage

NoteJuly 9, 20201 min read

Eighty percent on a disk growing a percent a quarter is not a problem, and eighty percent on one that gained fifteen points overnight is — a single…

An SLO is a number somebody agreed to

Deep diveMay 20, 202014 min read

Everyone wanted the site to be fast and nobody could say what fast meant. An indicator, an objective and a window — and the error budget is what…

Scanning history for a leaked key, and what to do next

NoteMay 12, 20202 min read

A secret committed and then removed is still in the history, and the history is on every clone, every fork and every CI cache. Assuming the secret is…

A for clause on every rule, or it fires on noise

NoteApril 30, 20202 min read

A threshold evaluated instantaneously fires on every transient spike, and transient spikes are constant — which is how a channel accumulates three hundred alerts a month. The for…

A runbook is more useful for what it says not to do

NoteMarch 5, 20202 min read

An alert that states a number crossed a threshold hands the receiver a research project, and at three in the morning three sentences beat any precision in the…