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.
Choosing the Right Database: 3 Questions to End Your Confusion Forever | By Ariful Haque Sajib
Cover image for Choosing the Right Database: 3 Questions to End Your Confusion Forever | By Ariful Haque Sajib

Choosing the Right Database: 3 Questions to End Your Confusion Forever | By Ariful Haque Sajib

3
Comments 1
2 min read
How to Build an ETL Pipeline with Python and MySQL

How to Build an ETL Pipeline with Python and MySQL

5
Comments
6 min read
AWS Disk Full? Why Deleting Logs Might Kill Your Database (And How to Fix It)

AWS Disk Full? Why Deleting Logs Might Kill Your Database (And How to Fix It)

Comments
3 min read
Does Apache SeaTunnel MySQL CDC Support Timestamp-Based Startup?

Does Apache SeaTunnel MySQL CDC Support Timestamp-Based Startup?

Comments
4 min read
When Disk Space is Not Enough: A Lesson in Challenging MySQL Database Cleansing
Cover image for When Disk Space is Not Enough: A Lesson in Challenging MySQL Database Cleansing

When Disk Space is Not Enough: A Lesson in Challenging MySQL Database Cleansing

5
Comments
3 min read
Beyond Surrogate Pairs: Hidden Pitfalls in JS Character Counting with PHP/MySQL

Beyond Surrogate Pairs: Hidden Pitfalls in JS Character Counting with PHP/MySQL

Comments
7 min read
MySQL slow query log — 6 steps to identify and fix performance issues
Cover image for MySQL slow query log — 6 steps to identify and fix performance issues

MySQL slow query log — 6 steps to identify and fix performance issues

1
Comments
5 min read
MySQL backup best practices — 12 essential strategies for MySQL backup and recovery
Cover image for MySQL backup best practices — 12 essential strategies for MySQL backup and recovery

MySQL backup best practices — 12 essential strategies for MySQL backup and recovery

Comments
11 min read
Portabase: A self-hosted tool for database backup & restore
Cover image for Portabase: A self-hosted tool for database backup & restore

Portabase: A self-hosted tool for database backup & restore

5
Comments 1
3 min read
Haunted House: A MySQL Normalization Story
Cover image for Haunted House: A MySQL Normalization Story

Haunted House: A MySQL Normalization Story

2
Comments
5 min read
Ubuntu 24.04 Setup Script: Nginx/Apache, PHP-FPM, MySQL/MariaDB, Docker, UFW
Cover image for Ubuntu 24.04 Setup Script: Nginx/Apache, PHP-FPM, MySQL/MariaDB, Docker, UFW

Ubuntu 24.04 Setup Script: Nginx/Apache, PHP-FPM, MySQL/MariaDB, Docker, UFW

Comments
7 min read
How POSTGRES indexing is more efficient than MYSQL
Cover image for How POSTGRES indexing is more efficient than MYSQL

How POSTGRES indexing is more efficient than MYSQL

1
Comments
2 min read
PostgreSQL vs MySQL: A 2026 Production Decision Framework

PostgreSQL vs MySQL: A 2026 Production Decision Framework

1
Comments
5 min read
🚀 Real-Time Data Replication Using MySQL, Debezium, Kafka, and Docker (CDC Guide)

🚀 Real-Time Data Replication Using MySQL, Debezium, Kafka, and Docker (CDC Guide)

1
Comments
4 min read
The Index You Can Turn Off: MySQL 8 Invisible Indexes
Cover image for The Index You Can Turn Off: MySQL 8 Invisible Indexes

The Index You Can Turn Off: MySQL 8 Invisible Indexes

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