How Meta Uses MySQL

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

Logarithm is a serverless, multitenant logging engine developed internally at Meta to enhance AI training workflows and services.

The article details how Meta developed the infrastructure for Threads, which achieved over 100 million sign-ups in its first five days.

The article discusses Meta's Systematic Code and Asset Removal Framework (SCARF), which automates the identification and removal of dead code through a combination of static and dynamic analysis.

The article discusses the implementation and deployment of MySQL Raft at Meta, focusing on how it aims to replace semisynchronous databases with a more reliable and simpler distributed system.

The article provides an overview of Meta's event-driven asynchronous computing platform, detailing architectural changes that facilitate integration with various event sources and sharing insights ...

The article discusses SQL Notebooks, a tool developed at Meta that combines the functionalities of SQL IDEs and Jupyter Notebooks to enhance data analytics.

VESPA is a novel approach to static profiling for binary optimization, enhancing the performance of applications without the need for dynamic profiling.

The article discusses the evolution of the Facebook Ordered Queueing Service (FOQS) from a regional to a global deployment, emphasizing its disaster readiness and high availability.

The article discusses the development and implementation of the Power Loss Siren (PLS) at Meta, a system designed to enhance the resilience of data center services against power loss events.

The article discusses SLICK, a dedicated SLO store developed by Meta to enhance service reliability through the adoption of Service-Level Objectives (SLOs) and Service-Level Indicators (SLIs).

The article discusses Facebook's approach to autonomous testing of back-end services at scale, highlighting the challenges of maintaining a stable infrastructure for over 3 billion users.

The article discusses Facebook's migration from MySQL 5. 6 to MySQL 8. 0, detailing the challenges faced, the migration process, and the benefits of new features.

The article discusses Facebook's approach to enforcing encryption across its vast infrastructure, which supports thousands of services handling billions of requests per second.

The article discusses the Facebook Ordered Queueing Service (FOQS), a distributed priority queue designed to enhance asynchronous computing within Facebook's ecosystem.

The article discusses Facebook's implementation of asynchronous computing to enhance efficiency and developer productivity at scale.

The article provides a recap of the Systems @Scale 2019 conference, highlighting discussions on engineering challenges faced by operating systems serving millions of users.

The article discusses how Facebook has enhanced the Zstandard compression algorithm since its open-sourcing, focusing on five key improvements that optimize compression performance at scale.

The article discusses the migration of Facebook Messenger's storage system to enhance performance, reliability, and scalability.

The article discusses Facebook's migration of its main database (UDB) from InnoDB to MyRocks, a MySQL database engine designed for improved space and write efficiency.

The article discusses the rebuilding of OnlineSchemaChange, a tool initially developed in PHP for performing MySQL schema changes with minimal downtime, into a more flexible and user-friendly versi...

Beringei is a high-performance time series storage engine developed by Facebook to address the limitations of their previous HBase-backed time series database.

The article discusses Facebook's approach to continuous MySQL backup validation and the restoration of backups across its global data centers.

The article highlights key discussions and innovations presented at the @Scale 2016 conference, focusing on the challenges of building scalable applications and systems.

Facebook announced several new technologies at the @Scale 2016 conference, focusing on solutions for large-scale engineering challenges.

The article discusses Zstandard, a new data compression algorithm developed by Facebook that offers significant improvements in both compression and decompression speeds compared to existing algori...

MyRocks is an open-source MySQL storage engine developed by Facebook, integrating RocksDB to optimize space and write efficiency.

The article discusses Facebook's proactive approach to maintaining its production infrastructure through automation, specifically focusing on the Facebook Auto Remediation (FBAR) service and its en...

The article discusses the extensive use of Python in production engineering at Facebook, highlighting its significance in the infrastructure codebase and various operational tools.

The article discusses Dragon, a distributed graph query engine developed by Facebook to enhance the efficiency of complex queries on the social graph.

Hack Codegen is a library developed by Facebook for generating Hack code, enabling automated code generation that enhances abstraction levels in programming.

The article discusses Box's migration to HHVM (HipHop Virtual Machine) to enhance performance and reduce latency in their PHP application.

The article introduces XHP-JS, a tool that integrates Hack, React, and XHP to build efficient user interface components.

The article discusses the importance of embracing open source security, highlighting how open platforms can enhance communication and collaboration in the security industry.

Alibaba has officially joined the WebScaleSQL project, contributing their MySQL expertise and code.

The article discusses a complex metastable failure state encountered in Facebook's systems due to link imbalance in network traffic.

The @Scale 2014 conference's Data track focused on the challenges of building scalable data processing systems for applications serving hundreds of millions of users.

The article discusses the transformation of Facebook Messenger's infrastructure to a mobile-first approach, focusing on optimizing data synchronization and reducing data usage.

The article discusses Facebook's innovative approach to configuration management using Chef, highlighting the need for a scalable system that allows engineers to make changes through data-driven AP...

The article discusses the deployment of Global Transaction ID (GTID) in MySQL 5. 6 at Facebook, highlighting its benefits for failover, backup recovery, and replication.

In the first half of 2014, Facebook's open source program experienced significant growth, launching 64 new projects and increasing its codebase to 9. 9 million lines of code.

The article discusses the implementation of HDFS RAID at Facebook to enhance data storage efficiency by reducing the replication factor of files in HDFS.

WebScaleSQL is a collaborative initiative among major tech companies to enhance MySQL for large-scale deployments.

The article discusses the implementation of the MySQLi extension in HHVM, detailing the preparation, implementation, testing, and challenges faced during the process.

The article discusses Facebook's commitment to open source in 2013, highlighting significant projects and contributions across various domains such as mobile, web, data, and infrastructure.

The article discusses the engineering challenges and solutions involved in building a posts search feature at Facebook, which allows users to search through over one trillion posts.

The article discusses Facebook's MySQL Pool Scanner (MPS), a sophisticated automation tool that manages one of the world's largest MySQL database clusters.

The article discusses the evolution and performance enhancements of Flashcache at Facebook from 2010 to 2013.

The article discusses Windex, an automated system developed by Facebook for efficient database provisioning.

The article discusses TAO, Facebook's distributed data store designed to efficiently manage the social graph's complex data relationships.