MySQL, an open source database developed by Oracle, powers some of Facebook’s most important workloads. We actively develop new features in MySQL to support our evolving requirements. These features change many different areas of MySQL, including client connectors, storage engine, optimizer, and replication. Each new major version of MySQL requires significant time and effort to migrate our workloads. The challenges include:
- Porting our custom features to the new version
- Ensuring replication is compatible between the major versions
- Minimizing changes needed for existing application queries
- Fixing performance regressions that prevent the server from supporting our workloads
Our last major version upgrade, to MySQL 5.6, took more than a year to roll out. When version 5.7 was released, we were still in the …
[Read more]