Engineering Blog

Blog posts tagged 'MySQL'

Divij RajkumarProduction Engineer at Facebook

Continuous MySQL backup validation: Restoring backups

Posted about 4 months ago

Our system continuously tests our ability to restore our databases from backups, ensuring that we can quickly and reliably recover from an outage. Read more...

Yoshinori MatsunobuDatabase Engineer at Facebook

MyRocks: A space- and write-optimized MySQL database

Posted about 6 months ago
blog post · Data · Infra · Storage · MySQL · Backend · Data Infrastructure

Deploying MyRocks to a database tier in one of our data center regions enabled a 50 percent reduction in storage requirements. Read more...

Steaphan GreeneEngineering

Alibaba joins WebScaleSQL

Posted about 2 years ago
blog post · Open Source · MySQL

Alibaba joins WebScaleSQL. Read more...

Lessons from Deploying MySQL GTID at Scale

Posted about 2 years ago
blog post · Data · MySQL · Production Engineering · Open Source

Global Transaction ID (GTID) is one of the most compelling new features of MySQL 5.6. It provides major benefits in failover, point-in-time backup recovery, and hierarchical replication, and it's a prerequisite for crash-safe multi-threaded replication. Over the course of the last few months, we enabled GTID on every production MySQL instance at Facebook. In the process, we learned a great deal about deployment and operational use of the feature. We plan to open source many of our server-side fixes via WebScaleSQL, as we believe others in the scale community can learn from this and benefit from the work we've done. Read more...

Steaphan GreeneEngineering

WebScaleSQL: A collaboration to build upon the MySQL upstream

Posted about 3 years ago
blog post · Data · MySQL · Production Engineering

To help the more than 1.23 billion people who use Facebook to share and connect with each other, we’ve had to build an expansive and incredibly advanced infrastructure -- including one of the largest deployments of MySQL in the world. Along the way, we’ve learned and benefited from code changes made by the MySQL community. Today we’re announcing WebScaleSQL, a collaboration among engineers from several companies that face similar challenges in running MySQL at scale and seek greater performance from a database technology tailored to their needs. Read more...

Emil HesslowSoftware Engineer at Facebook

HHVM - Implementing MySQLi

Posted about 3 years ago

The MySQLi extension is very popular amongst PHP developers. We knew we had to support it in our HHVM runtime, and thought it would be interesting to share the process we went through to implement it. Read more...

Shlomo PriymakEngineering

Under the hood: MySQL Pool Scanner (MPS)

Posted about 3 years ago
blog post · Data · Infra · MySQL

Facebook has one of the largest MySQL database clusters in the world. This cluster comprises many thousands of servers across multiple data centers on two continents. Read more...

Tim ArmstrongEngineering

LinkBench: A database benchmark for the social graph

Posted about 4 years ago
blog post · Data · Infra · Graph · MySQL · Performance · Optimization · Open Source · Testing · Storage

MySQL offers a good mix of flexibility, performance, and administrative ease, but the database engineering team continues to explore alternatives to MySQL for storing social graph data. There are several generic open-source benchmarks that could provide a starting point for comparing database systems. However, the gold standard for database benchmarking is to test the performance of a system on the real production workload, since synthetic benchmarks often don't exercise systems in the same way. When making decisions about a significant component of Facebook's infrastructure, we need to understand how a database system will really perform in Facebook's production workload. Read more...

MySQL and Database Engineering: Mark Callaghan

Posted about 5 years ago

Mark Callaghan joined Facebook in 2009. Now, working from home in Oregon on the database infrastructure team, he does whatever it takes to keep the database running and users like Trekkie George Takei, a favorite person to get updates from amongst Mark's team, happy. Read on for Mark's insights into fast-storage challenges, Facebook's MySQL roadmap, and more. Read more...

Sanjeev KumarDirector Engineering at Facebook

How Project Triforce Prepared our Software Stack for Prineville

Posted about 6 years ago
blog post · Infra · Data · Compute · Hardware · Open Compute · Prineville · Data Centers · MySQL

For the first few years of Facebook’s existence, we served our users from data centers in a single region in Northern California. As the site grew, we added a second region of data centers in Virginia in 2007, and this year, we launched our third region in Prineville, Oregon. Read more...

Nagavamsi PonnekantiEngineering at Facebook

Hybrid Incremental MySQL Backups

Posted about 6 years ago
blog post · Infra · Web · Data · MySQL · PHP · Storage · Performance

This post discusses enhancements to our database backups. As we deploy these enhancements to production servers, we may write additional posts about other improvements made along the way. Read more...

Dhruba BorthakurEngineering

Looking at the code behind our three uses of Apache Hadoop

Posted about 6 years ago
blog post · Data · Infra · Open Source · MySQL · Storage · Messages

The size of the data warehouse cluster at Facebook has been increasing tremendously over the past few years. We use several pieces of open source software in our data warehouse including Apache Hadoop, Apache Hive, Apache HBase, Apache Thrift and Facebook Scribe. Together they keep this data processing engine humming. Read more...

Keep Updated

Stay up-to-date via RSS with the latest open source project releases from Facebook, news from our Engineering teams, and upcoming events.

Subscribe
Facebook © 2017