MySQL as smart JSON storage
I’ve been using this semi-relational, or SemiSQL, if you’d like, approach to SQL since around 2009. At first, I’d store the data as text or longtext types using PHP’s serialize(), but then I quickly moved to JSON.
In late 2015, with MySQL 5.7.8, our prayers were answered and the native support for JSON datatype was introduced. 🙏
Let’s have a look at the best practices using JSON in MySQL 8.
Cron backups into remote chroot using rsync [Linux how to]
A lot of us use cron & rsync -e ssh for backups. On the backup server, we’d love to chroot for many obvious reasons, but chroot breaks rsync. I’m sure you’ve tried & seen something like this:
protocol version mismatch -- is your shell clean?
Here’s my full solution on automated backups using chroot.
TLDR; if you’re only interested in making rsync work, head near the end.