MySQL Programming Tutorials & Engineering Articles

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.

The article discusses how ClickHouse efficiently queries Parquet files, a key storage format for Lakehouse architectures, without requiring data ingestion.

The article discusses FixrLeak, a generative AI-based framework developed by Uber to automate the detection and repair of resource leaks in Java applications.

The article summarizes the key announcements and developments from Developer Week 2025, highlighting new features and tools added to Cloudflare's developer platform.

The article introduces sub-issues, a new feature on GitHub designed to enhance issue management by allowing users to break larger issues into smaller, manageable tasks.

The article discusses the newly announced support for MySQL in Cloudflare Workers and Hyperdrive, enabling developers to build applications that connect directly to MySQL databases regardless of th...

The article discusses the evolution of LinkedIn's Nuage control plane, highlighting its transition from a self-service platform to a comprehensive control plane solution for managing data infrastru...

The article discusses Profile-Guided Optimization (PGO) in Go programming, detailing its implementation at Uber to enhance performance through runtime profiling data.

The article discusses Uber's transition to a multi-architecture environment by adopting Arm-based hosts at scale.

The article discusses the MySQL fleet at Uber, which consists of over 2,300 independent clusters that support critical operations for the platform.

This article discusses the open sourcing of kubenetmon, a tool developed by ClickHouse to monitor data transfer in ClickHouse Cloud.

The article discusses how Uber leverages Neutrino, an internal fork of Presto, to efficiently serve millions of queries to Apache Pinot, a real-time OLAP database.

The article discusses Change Data Capture (CDC) at Pinterest, detailing its importance for real-time data processing and the implementation of a Generic CDC solution using Debezium.

The article discusses Uber's implementation of Presto Express, an enhancement to the Presto SQL query engine aimed at reducing the end-to-end Service Level Agreement (SLA) for short-running queries.

This article discusses the integration of ClickHouse, a high-performance columnar database, with Estuary Flow, a data integration platform, to enable real-time analytics on Salesforce data.

The article discusses Uber's migration of its batch data platform to the cloud, focusing on the implementation of DataMesh principles.

The article discusses how Uber utilizes Apache Pinot for low-latency offline table analytics, highlighting its capabilities in handling various use cases, including real-time and offline data inges...

The article discusses LinkedIn's transition to Azure Linux as its primary operating system, detailing the motivations, challenges, and strategies involved in the migration.

The article discusses the Sparkle framework developed by Uber to standardize modular ETL processes, enhancing developer productivity and data quality.

This article discusses the issue of deadlocks in MySQL during high concurrency environments and presents a solution using composite primary keys to mitigate these deadlocks.

This article discusses how to model machine learning data in OLAP databases, specifically using ClickHouse as an example.

The article discusses Uber's upgrade of its MySQL fleet from version 5. 7 to 8. 0, detailing the motivations, challenges, and solutions implemented during the process.

The article discusses Pinterest's migration from Druid to StarRocks for delivering faster analytics.