In this article, we explore how our HTTP/3 API compares to the latency of a traditional MySQL client.
Jan
04
2023
Oct
31
2022
Gain a deeper understanding of the MySQL integer types by exploring the different options (INT, BIGINT, MEDIUMINT, etc) and how they are stored.
Oct
04
2022
Learn how to index JSON in MySQL with generated columns and functional indexes.
Sep
30
2022
In this entry of the series, we explore using VARCHAR and CHAR data types in your database and give some pointers on which type is best to use and when.
Sep
23
2022
Learn what the MySQL JSON data type is, when to use MySQL JSON, and some caveats to using JSON documents in relational databases.
Sep
01
2022
Discover how PlanetScale handles one million queries per second (QPS) with horizontal sharding in MySQL
Oct
22
2020
For developers building out a web application, a transactional datastore is the obvious and proven choice, but with success comes scale limitations.
Aug
14
2020
Rate Puppies in a Rust app with Sharded MySQL Database
May
20
2020
Feb
14
2020
In the past year, GitHub engineers shipped GitHub Packages, Actions, Sponsors, Mobile, security advisories and updates, notifications, code navigation, and more. Needless to say, the development pace at GitHub is accelerated.
With MySQL serving our backends, updating code requires changes to the underlying database schema. New features may require new tables, columns, changes to existing columns or indexes, dropping unused tables, and so on. On average, we have two schema migrations running daily on our production servers. Some days we have a half dozen migrations to run. We’ll cover how this amounted to a significant toil on the database infrastructure team, and how we searched for a solution to automate the manual parts of the process.
At first …
[Read more]