#

MySQL Programming Tutorials & Engineering Articles

430 MySQL tutorials, guides, and engineering insights from Uber, Meta, ClickHouse, and more

MySQL Articles & Tutorials

Filter:
ClickHouse logo
ClickHouse
Advanced
Loom gives coding agents shared memory and a code index grounded in the repository, so each session can build on what the last one learned.
Airbnb logo
Airbnb
Intermediate
Durable workflows, running inside your service with no separate orchestration cluster.
Andriy Sergiyenko
7 min read
Includes Code
--
Hitarth Trivedi, Jay Narale, Jianjian Xie, Aerial view of a busy multi-level highway interchange with cars and bright streetlights at night., Yunfei Chen, Sanah Imani
15 min read
--
ClickHouse logo
ClickHouse
Advanced
The MongoDB CDC connector for ClickPipes is now generally available, with parallel snapshotting, structured ingestion into typed columns, lag and resource metrics, and Terraform and OpenAPI support.
NVIDIA logo
NVIDIA
Intermediate
As distributed AI training scales, failures across hardware and software dependencies increasingly disrupt training progress, making fast…
Elizabeth Goodman
12 min read
Includes Code
--
ClickHouse logo
ClickHouse
Intermediate
Shipsidekick moved from Neon to ClickHouse Managed Postgres in a single weekend, cutting CPU usage from 100% to 5-10% and making queries about 10x faster.
ClickHouse logo
ClickHouse
Advanced
Offload settled Postgres data to ClickHouse to reduce storage and query costs while keeping active transactions in Postgres.
Airbnb logo
Airbnb
Intermediate
How we capture real production database traffic at Airbnb and replay it offline to load-test, plan capacity, and de-risk upgrades.
ClickHouse logo
ClickHouse
Advanced
LinkedIn expanded its ClickHouse observability stack from distributed tracing to metric discovery and analytics, consolidating 13B+ metrics into one index serving 150k+ queries per minute.
ClickHouse logo
ClickHouse
Intermediate
ClickHouse Workload for Microsoft Fabric brings sub-second analytics to OneLake data through a native Fabric workload, with dedicated ClickHouse Cloud compute for agents, dashboards, and applications.
ClickHouse logo
ClickHouse
Beginner
Notes from three days in the Netherlands, featuring a lightning talk on pg_clickhouse and pg_stat_ch at PGDay Lowlands and a session on PostgreSQL 19 monitoring at Percona Live Amsterdam.
8 min read
Includes Code
--
ClickHouse logo
ClickHouse
Intermediate
Use ClickHouse to load Parquet files into MySQL, explore remote data, and run MySQL queries with table functions and named collections.
7 min read
Includes Code
--
ClickHouse logo
ClickHouse
Intermediate
Google's MCP Toolbox for Databases embeds agent text into vectors on insert and search, then lets ClickHouse rank the results - no embedding service to build or maintain. Here's how to set it up, and what it looks like end to end.
ClickHouse logo
ClickHouse
Intermediate
Replicate MySQL and MariaDB data into ClickHouse Cloud with the generally available MySQL CDC connector, featuring faster parallel snapshots, safer production defaults, improved observability, and infrastructure-as-code support.
Pinterest Engineering
12 min read
--
Nimish Sheth, Manas Kelshikar, Dhirendra Kumar Singh, Rajan Jana, Wasim Raza
8 min read
--
ClickHouse logo
ClickHouse
Advanced
clickhousectl v0.4.0 adds horizontal autoscaling for Cloud services, ClickPipe schema discovery, finer control over ClickPipe ingestion, and opt-out anonymous usage telemetry.
5 min read
Includes Code
--
Prakhar Agarwal, Avinash Varma Sagi, Abhay Singh Chauhan, Kranthi Reddy, Divya Rai
11 min read
--
ClickHouse logo
ClickHouse
Intermediate
5 Ways to Parse Dates and DateTimes in ClickHouse
5 min read
Includes Code
--
ClickHouse logo
ClickHouse
Advanced
Ten best practices for getting the most out of ClickHouse, from primary key design and data types to materialized views, ReplacingMergeTree, and join optimization — illustrated with benchmarks on a 150M row dataset.
ClickHouse logo
ClickHouse
Intermediate
Discover how Postgres managed by ClickHouse compares to its peers in a reproducible, open benchmark.
ClickHouse logo
ClickHouse
Intermediate
ClickHouse was released in open source on Jun 15 2016, ten years ago. Since then, it became the most popular open source analytical database with more than 2000 contributors.
ClickHouse logo
ClickHouse
Advanced
chDB embeds a full ClickHouse query engine inside an agent's own process, turning data access, memory, and federation into local function calls instead of network round trips, cutting the latency, retries, and token waste that come with remote queries.
Meta logo
Meta
Advanced
Meta’s data ingestion system, which our engineering teams leverage for up-to-date snapshots of the social graph, has recently undergone a significant revamp to enhance its reliability at scale.  Mo…
Zihao Tao
11 min read
--
Shopify logo
Shopify
Intermediate
How we used SKIP LOCKED, composite primary keys, and connection visibility to hit our scale targets.
Emilie Noel
11 min read
Includes Code
--
Airbnb logo
Airbnb
Advanced
How Airbnb built a lightweight workflow engine to solve durable execution.
Ricardo Gamba
15 min read
Includes Code
--
GitHub logo
GitHub
Intermediate
Learn how Github uses eBPF to detect and prevent circular dependencies in its deployment tooling.
Lawrence Gripper
9 min read
Includes Code
--
NVIDIA logo
NVIDIA
Intermediate
Slurm is an open source cluster management and job scheduling system for Linux. It manages job scheduling for over 65% of TOP500 systems.
Anton Polyakov
9 min read
Includes Code
--
Airbnb logo
Airbnb
Advanced
The article reviews Airbnb's significant advancements in research and technology throughout 2025, focusing on their participation in key conferences and the impactful papers presented.
Malay Haldar
12 min read
Has Summary
--
Pinterest logo
Pinterest
Intermediate
The article discusses Pinterest's transition to a next-generation database ingestion framework designed to address the limitations of legacy systems.
Pinterest Engineering
10 min read
Includes Code
Has Summary
--
Fly.io logo
Fly.io
Beginner
Stop context-switching. Give each project its own environment, its own AI context, and its own checkpoint history.
Daniel Botha
5 min read
Includes Code
--
Uber logo
Uber
Advanced
This article details Uber's multi-year evolution from static, quota-based rate limiting to an intelligent, priority-aware load management system for their distributed databases (Docstore and Schema...
Dhyanam Vaidya, Prathamesh Deshpande, Mike Ma, Chaitanya Yalamanchili
15 min read
Has Summary
--
ClickHouse logo
ClickHouse
Intermediate
The article discusses the development of chDB, a Python library that integrates ClickHouse with Pandas DataFrames for high-performance SQL querying.
Xiaozhe Yu Auxten Wang
10 min read
Includes Code
Has Summary
--
ClickHouse logo
ClickHouse
Intermediate
The article presents a curated list of technology blogs that focus on performance optimizations, algorithms, database development, and more, aimed at helping software engineers find valuable resour...
Alexey Milovidov
8 min read
Has Summary
--
Uber logo
Uber
Intermediate
The article discusses Uber's collaboration with Oracle Cloud Infrastructure (OCI) and Ampere Computing to optimize the OCI AmpereOne M A4 Compute instances.
Vikrant Soman, Dan Royal, Nav Kankani, Kamran Zargahi
7 min read
Has Summary
--
ClickHouse logo
ClickHouse
Intermediate
The article discusses ClickHouse's journey of integrating Rust into its predominantly C++ codebase without undertaking a complete rewrite.
Alexey Milovidov
14 min read
Includes Code
Has Summary
--
Uber logo
Uber
Intermediate
This article discusses Uber's implementation of Apache Pinot to manage and analyze its extensive inventory and catalog data efficiently.
Suraj Modi, Ankit Sultana, Tarun Mavani
11 min read
Has Summary
--
Uber logo
Uber
Advanced
This article discusses how Uber improved MySQL cluster uptime by adopting MySQL Group Replication (MGR) at scale.
Siddharth Singh, Raja Sriram Ganesan, Amit Jain, Debadarsini Nayak
13 min read
Has Summary
--