DEV Community

#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.
MySQL to Redshift Without DMS: A Binlog CDC Tutorial Through AWS Glue

MySQL to Redshift Without DMS: A Binlog CDC Tutorial Through AWS Glue

Comments
10 min read
The BIGINT Problem Explained

The BIGINT Problem Explained

1
Comments
4 min read
UPDATE without WHERE: what MySQL's safe-updates mode stops, and what it lets through

UPDATE without WHERE: what MySQL's safe-updates mode stops, and what it lets through

Comments
6 min read
MySQL EXPLAIN: Read the Output and Fix Slow Queries

MySQL EXPLAIN: Read the Output and Fix Slow Queries

Comments
9 min read
Port 22 and port 3306 exposed: what it means and how to close them

Port 22 and port 3306 exposed: what it means and how to close them

Comments
8 min read
Preventing Duplicate Orders in PHP and MySQL: Transactions, Idempotency and Safe Retry Handling

Preventing Duplicate Orders in PHP and MySQL: Transactions, Idempotency and Safe Retry Handling

Comments 1
8 min read
MySQL vs PostgreSQL: DDL, DML

MySQL vs PostgreSQL: DDL, DML

Comments
3 min read
MySQL to ClickHouse with Binlog CDC: A Copy-Paste Walkthrough Through Polaris

MySQL to ClickHouse with Binlog CDC: A Copy-Paste Walkthrough Through Polaris

Comments
13 min read
MySQL Slow Query Log: Enable, Read and Find Slow Queries

MySQL Slow Query Log: Enable, Read and Find Slow Queries

Comments
8 min read
MySQL utf8mb3 to utf8mb4: What CONVERT TO CHARACTER SET Locks, Refuses and Silently Changes

MySQL utf8mb3 to utf8mb4: What CONVERT TO CHARACTER SET Locks, Refuses and Silently Changes

Comments
11 min read
MySQL 1226 max_connections_per_hour on Shared Hosting

MySQL 1226 max_connections_per_hour on Shared Hosting

Comments
11 min read
MySQL to Databricks: Replicate the Binlog Into Unity Catalog in Seven Steps

MySQL to Databricks: Replicate the Binlog Into Unity Catalog in Seven Steps

Comments
12 min read
RDS MySQL 8.0 Has Been Billing Extended Support Since August: Find It and Price It

RDS MySQL 8.0 Has Been Billing Extended Support Since August: Find It and Price It

5
Comments
10 min read
GitHub Actions for Laravel: Run Tests with PHP Matrix, MySQL

GitHub Actions for Laravel: Run Tests with PHP Matrix, MySQL

Comments
6 min read
Shipping a Database Index Without an Outage on WordPress VIP

Shipping a Database Index Without an Outage on WordPress VIP

Comments
5 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.