Kalidasan·Sep 3MySQL in a Weekend: Performance, JSON, Backups, and Running It for Real (Part 3)The closing course in the series — making slow queries fast, storing data that doesn’t fit neat columns, not losing everything to a bad…
Kalidasan·Sep 3MySQL in a Weekend: Transactions, Subqueries, and Real-World Access Control (Part 2)Picking up where Part 1 left off — the same bookshop database, now handling multi-step changes, harder questions, and more than one user.
Kalidasan·Sep 2MySQL in a Weekend: Databases, Tables, and Queries (Part 1)A hands-on path from “what’s a database” to writing joins and aggregates with confidence — no prior SQL experience needed. This is the…
Pavel Polikov·Aug 30Monitoring CPU and RAM pressure caused by queries on the MySQL/MariaDB server.Script goal: “Monitoring CPU and RAM pressure caused by queries on the MySQL/MariaDB server”
Nikita Nikumbh·Aug 20Upgrading Amazon RDS MySQL 8.0 to 8.4 Using a Snapshot-Based ApproachUpgrading a production database is always something that needs to be approached carefully. Unlike a normal application deployment, a…
