In this article, we explore how our HTTP/3 API compares to the latency of a traditional MySQL client.
Gain a deeper understanding of the MySQL integer types by exploring the different options (INT, BIGINT, MEDIUMINT, etc) and how they are stored.
Learn how to index JSON in MySQL with generated columns and functional indexes.
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.
Learn what the MySQL JSON data type is, when to use MySQL JSON, and some caveats to using JSON documents in relational databases.
Discover how PlanetScale handles one million queries per second (QPS) with horizontal sharding in MySQL
For developers building out a web application, a transactional datastore is the obvious and proven choice, but with success comes scale limitations.
Rate Puppies in a Rust app with Sharded MySQL Database
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]