Forem

# mysql

Posts on tips and tricks, using and learning about MySQL for database development and analysis.

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
Consolidating TechsFree Platform from 2 Servers to 1

Consolidating TechsFree Platform from 2 Servers to 1

2
Comments
4 min read
What is MySQL's Optimizer Trace? Why is it Essential for SQL Optimization?
Cover image for What is MySQL's Optimizer Trace? Why is it Essential for SQL Optimization?

What is MySQL's Optimizer Trace? Why is it Essential for SQL Optimization?

1
Comments
4 min read
MySQL 8.0 vs 9.0: The Upgrade That Almost Broke Production
Cover image for MySQL 8.0 vs 9.0: The Upgrade That Almost Broke Production

MySQL 8.0 vs 9.0: The Upgrade That Almost Broke Production

2
Comments
4 min read
Import CSV to MySQL

Import CSV to MySQL

3
Comments
4 min read
How I Deployed a Full-Stack Web App on Azure with a Production-Grade Network Architecture
Cover image for How I Deployed a Full-Stack Web App on Azure with a Production-Grade Network Architecture

How I Deployed a Full-Stack Web App on Azure with a Production-Grade Network Architecture

3
Comments
6 min read
20 Essential MySQL Optimization Tips for Better Database
Cover image for 20 Essential MySQL Optimization Tips for Better Database

20 Essential MySQL Optimization Tips for Better Database

Comments
5 min read
Building a Hotjar-Class Analytics Platform in PHP: Heatmaps, Replays, Funnels, and Feedback
Cover image for Building a Hotjar-Class Analytics Platform in PHP: Heatmaps, Replays, Funnels, and Feedback

Building a Hotjar-Class Analytics Platform in PHP: Heatmaps, Replays, Funnels, and Feedback

3
Comments
4 min read
How to Create Indexes in MySQL: A Complete Guide
Cover image for How to Create Indexes in MySQL: A Complete Guide

How to Create Indexes in MySQL: A Complete Guide

Comments
5 min read
MySQL backup to cloud — Backing up MySQL databases to AWS S3 and Google Cloud
Cover image for MySQL backup to cloud — Backing up MySQL databases to AWS S3 and Google Cloud

MySQL backup to cloud — Backing up MySQL databases to AWS S3 and Google Cloud

Comments
8 min read
myanon — how I anonymize 200GB of MySQL nightly for GDPR-safe dev

myanon — how I anonymize 200GB of MySQL nightly for GDPR-safe dev

Comments
1 min read
The "bus factor" risk in MongoDB, MariaDB, Redis, MySQL, PostgreSQL, and SQLite
Cover image for The "bus factor" risk in MongoDB, MariaDB, Redis, MySQL, PostgreSQL, and SQLite

The "bus factor" risk in MongoDB, MariaDB, Redis, MySQL, PostgreSQL, and SQLite

4
Comments
4 min read
Why Your Backend Needs an Agentic Loop: My Research on the Musfique Decision Loop (MDL).

Why Your Backend Needs an Agentic Loop: My Research on the Musfique Decision Loop (MDL).

Comments
1 min read
Optimizing Eloquent Queries with Eager Loading and Model Logic Extraction

Optimizing Eloquent Queries with Eager Loading and Model Logic Extraction

2
Comments
2 min read
Fix Laravel Migration Unknown Database Type Enum Error

Fix Laravel Migration Unknown Database Type Enum Error

3
Comments
2 min read
How to use mysqldump — the only MySQL backup guide you need
Cover image for How to use mysqldump — the only MySQL backup guide you need

How to use mysqldump — the only MySQL backup guide you need

2
Comments
9 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.