Blog
Get the RSS feedBy Ben Dicken |
Benchmarking Postgres in a transparent, standardized and fair way is challenging. Here, we look at the process of how we did it in-depth →
By Patrick Reynolds |
You can now use vector search and storage in your PlanetScale MySQL database. →
By Vicent Martí |
A novel technique for implementing dynamic language interpreters in Go, applied to the Vitess SQL evaluation engine →
By Ben Dicken |
Take an interactive journey through the history of IO devices, and learn how IO device latency affects performance. →
By Ben Dicken |
Run Vitess workflows right from within PlanetScale. Migrate data from unsharded to sharded keyspaces, manage traffic cutover, and easily revert when problems arise. →
By Holly Guevara |
You can now use the vector data type for vector search and storage in your PlanetScale MySQL database. →
By Shlomi Noach |
Design considerations for implementing a database throttler with a comparison of singular vs distributed throttler deployments. →
By Ben Dicken |
B-trees are used by many modern DBMSs. Learn how they work, how databases use them, and how your choice of primary key can affect index performance. →
By Shlomi Noach |
PlanetScale now supports instant DDL. Where eligible, you can run deploy requests that complete near-instantly. →
By Ben Dicken |
For big databases, IOPS and throughput can become a bottleneck in database performance. Learn how sharding helps scale out IOPS and throughput beyond the limitations of a single server. →
By Matt Lord |
Data migrations are a critical part of the database lifecycle, and are sometimes necessary for version upgrades, sharding, or moving to a new platform. In many cases, migrations are painful and error-prone. In this article, we walk through how migrations are performed at PlanetScale, and offer advice on how to improve the migration experience. →
By Ben Dicken |
Sharding a database comes with many benefits: Scalability, failure isolation, write throughput, and more. However, one of the lesser-known benefits comes from improved backups and restore performance. →