Console Login

#MySQL 5.7

All articles tagged with MySQL 5.7

#MySQL 5.7

Database Sharding: The Nuclear Option for Scaling High-Traffic Apps in 2018

Sharding is complex, expensive, and necessary when vertical scaling fails. Learn how to implement horizontal partitioning strategies using MySQL and PostgreSQL without breaking GDPR compliance.

Zero-Downtime Database Migration: A Survival Guide for Norwegian Sysadmins (2018 Edition)

Downtime is a resume-generating event. Learn how to migrate MySQL 5.7 and PostgreSQL 10 workloads without killing your SLA, compliant with the new GDPR regulations.

Database Sharding Strategies: Why You Should Probably Scale Up Instead (And How to Shard If You Must)

It is April 2018. GDPR is looming, your master database is choking on IOPS, and you think sharding is the answer. As a battle-hardened sysadmin, I'm here to tell you: upgrading your vertical stack on CoolVDS is usually smarter. But if you truly have 'Facebook-scale' problems, here is the manual on how to shard without destroying your data integrity.

Surviving the Switch: Zero-Downtime Database Migration Strategies for High-Traffic Nodes

A battle-hardened guide to migrating MySQL 5.7 and PostgreSQL workloads without melting your servers or your uptime. Features master-slave replication tactics, NIX peering insights, and GDPR-ready infrastructure.

Disaster Recovery for Norwegian Ops: When `rm -rf /` Happens to You

Hardware fails, and fat fingers destroy databases. In this 2017 guide, we ditch the fluff and build a battle-tested Disaster Recovery plan using MySQL 5.7 replication, lsyncd, and Norwegian data sovereignty principles.

When Root Melts: A Pragmatic Disaster Recovery Strategy for Norwegian Systems (2016 Edition)

Post-Mirai botnet analysis: Why your 'backup script' isn't a Disaster Recovery Plan. We break down Master-Slave replication on Ubuntu 16.04, the legal reality of data residency in Norway, and why NVMe restores save jobs.

Zero-Downtime Database Migration: A Survival Guide for Norwegian Systems (2016 Edition)

Migrating a live production database is heart surgery on a runner. This guide covers replication strategies for MySQL 5.7 and PostgreSQL 9.6, handling NIX latency, and why NVMe storage matters for data integrity.

Disaster Recovery in 2016: Why Your "Backups" Won't Save You When the Server Melts

It is November 2016. Ransomware is exploding, and the EU-US Privacy Shield is shaky. Here is a battle-tested Disaster Recovery guide using MySQL 5.7 GTID, BorgBackup, and Norwegian data sovereignty principles.

Surviving the Apocalypse: A Norwegian Sysadmin’s Guide to Disaster Recovery (2016 Edition)

RAID is not a backup. Snapshots are not a strategy. We define a battle-tested Disaster Recovery plan using MySQL 5.7 GTID replication, Lsyncd, and off-site Norwegian cold storage to keep your RTO under 15 minutes.