MySQL Programming Tutorials & Engineering Articles

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 Ways to Parse Dates and DateTimes in ClickHouse

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.

Discover how Postgres managed by ClickHouse compares to its peers in a reproducible, open benchmark.

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.

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’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…

How we used SKIP LOCKED, composite primary keys, and connection visibility to hit our scale targets.

How Airbnb built a lightweight workflow engine to solve durable execution.

Learn how Github uses eBPF to detect and prevent circular dependencies in its deployment tooling.

Slurm is an open source cluster management and job scheduling system for Linux. It manages job scheduling for over 65% of TOP500 systems.

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.

The article discusses Pinterest's transition to a next-generation database ingestion framework designed to address the limitations of legacy systems.

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...

The article discusses the development of chDB, a Python library that integrates ClickHouse with Pandas DataFrames for high-performance SQL querying.

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...

The article discusses Uber's collaboration with Oracle Cloud Infrastructure (OCI) and Ampere Computing to optimize the OCI AmpereOne M A4 Compute instances.

The article discusses ClickHouse's journey of integrating Rust into its predominantly C++ codebase without undertaking a complete rewrite.

This article discusses Uber's implementation of Apache Pinot to manage and analyze its extensive inventory and catalog data efficiently.

This article discusses how Uber improved MySQL cluster uptime by adopting MySQL Group Replication (MGR) at scale.

This article discusses the improvements made to MySQL cluster uptime at Uber through the implementation of MySQL Group Replication (MGR).

The article discusses Uber's implementation of I/O observability for its massive petabyte-scale data lake, focusing on the challenges and solutions in monitoring data access patterns across its hyb...

The article discusses Meta's evolution in infrastructure over 21 years, highlighting the significant changes brought about by AI.

Uber's migration from Spark 2. 4 to Spark 3. 3 involved upgrading over 2 million Spark applications, utilizing innovative automation tools like Iron Dome.

This article serves as a practical guide for building ClickHouse-powered APIs in web applications, specifically using React and MooseStack.

This article discusses the architecture and implementation of Uber's HiveSync, a critical service for data replication across its massive data lake.

This article discusses how Uber's CacheFront serves over 150 million reads per second while ensuring stronger consistency guarantees.

This article discusses the implementation of Change Data Capture (CDC) from Delta Lake to ClickHouse, detailing the architecture, components, and a reference implementation in Python.

The article explores the potential need for Object-Relational Mappers (ORMs) in Online Analytical Processing (OLAP) environments, particularly focusing on ClickHouse.

The article discusses Uber's implementation of encryption at rest and disk isolation at scale using their Stateful Platform, Odin.

This article discusses how ClickHouse addresses the challenges of row-level updates in column stores by treating updates as inserts.

The article discusses Finch, Uber's conversational AI data agent designed to streamline financial data retrieval within the Slack environment.

The article introduces Northguard and Xinfra, two innovative systems developed by LinkedIn to enhance log storage scalability and operability.

Phoenix. new is a fully-online coding agent designed for Elixir and Phoenix, enabling rapid development of collaborative, real-time applications.

This article details Uber's migration from Apache Hive to Apache Spark SQL for ETL workloads, highlighting the motivations behind the transition, the architecture involved, and the challenges faced...

The article discusses Uber's implementation of a configuration-driven archival and retrieval framework designed to manage vast amounts of regulatory data efficiently.

The article discusses Uber's robust database backup recovery system, highlighting its importance for business continuity and disaster recovery.

Litestream is an open-source tool designed to enhance the reliability of SQLite applications by enabling them to recover data from object storage.

This article explores the implementation of Change Data Capture (CDC) for MySQL databases using ClickPipes, ClickHouse's native data integration solution.