Blog
By Shlomi Noach |
Design consideration for implementing a database throttler with a comparison of singular vs distributed throttler deployments. →
By Benjamin 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 Benjamin 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 Benjamin 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. →
By Shlomi Noach |
Learn about the options for running non-blocking schema changes natively to MySQL, using Vitess, or other tools →
By Benjamin Dicken |
Large databases often have a small number of very large tables that makes scaling difficult. How can you scale with these while keeping your database performant? This article covers three techniques. →
By Holly Guevara |
Learn about the different types of sharding: directory-based, range-based, and hash-based plus some of the pros and cons of each. →
By Benjamin Dicken |
The adaptive hash index help to improve performance of the already-fast B-tree lookups →
By Mike Coutermarsh |
Learn how PlanetScale uses GitHub Actions and PlanetScale to automate schema changes on our own application. →
By Benjamin Dicken |
MySQL has built-in functionality for collecting statistics on and profiling your MySQL queries. Learn how to leverage these features to identify problems. →
By Brian Morrison II |
Understand the different versions of UUIDs and why using them as a primary key in MySQL can hurt database performance. →
By Brian Morrison II |
Amazon Aurora is pitched as a straightforward and scalable database service on AWS, but there are associated costs that you might not be aware of. →
By Brian Morrison II |
Learn about a few common mistakes when designing your MySQL database schema. →
By Brian Morrison II |
Learn the key differences between Amazon Aurora blue/green deployments and PlanetScale branching. →
By Brian Morrison II |
Learn different considerations and best practices for quickly and efficiently recovering your database when downtime hits. →
By Savannah Longoria |
In this blog post, we explore how complex data and geographic features can be represented in MySQL. →
By Brian Morrison II |
Learn about how Amazon Aurora replication works, and how it compares to the traditional MySQL replication strategy used by PlanetScale. →
By Brian Morrison II |
Learn about the various isolation levels used by MySQL to allow concurrency in your database. →
By Shlomi Noach, Manan Gupta |
Today, PlanetScale launched support for foreign key constraints. This article covers some of the behind-the-scenes technical challenges we had to overcome to support them. →
By Savannah Longoria |
Learn what HTAP is, how HTAP compares to OLAP and OLTP, and some pros and cons of HTAP. →
By Mike Coutermarsh |
Learn what went into building PlanetScale webhooks from a security perspective. This article covers SSRF, webhook validation, DDoS, and more. →
By Brian Morrison II |
There is more to sharding than simply increasing data throughput. In this article, we explore three different benefits of sharding your database. →