Showing entries 1 to 10 of 22
10 Older Entries »
Displaying posts with tag: engineering (reset)
Faster MySQL with HTTP/3

In this article, we explore how our HTTP/3 API compares to the latency of a traditional MySQL client.

Read the full story

MySQL Integers: INT, BIGINT, and more

Gain a deeper understanding of the MySQL integer types by exploring the different options (INT, BIGINT, MEDIUMINT, etc) and how they are stored.

Read the full story

Indexing JSON in MySQL

Learn how to index JSON in MySQL with generated columns and functional indexes.

Read the full story

MySQL data types: VARCHAR and CHAR

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.

Read the full story

The MySQL JSON data type

Learn what the MySQL JSON data type is, when to use MySQL JSON, and some caveats to using JSON documents in relational databases.

Read the full story

One million queries per second with MySQL

Discover how PlanetScale handles one million queries per second (QPS) with horizontal sharding in MySQL

Read the full story

Horizontal Sharding for MySQL Made Easy

For developers building out a web application, a transactional datastore is the obvious and proven choice, but with success comes scale limitations.

Read the full story

Learn Horizontal Scaling on PlanetScaleDB with Vitess — Rate Puppies in a Rust app with Sharded MySQL Database

Rate Puppies in a Rust app with Sharded MySQL Database

Read the full story

Three bugs in the Go MySQL Driver
Automating MySQL schema migrations with GitHub Actions and more

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.

What’s in a migration?

At first …

[Read more]
Showing entries 1 to 10 of 22
10 Older Entries »