Blog
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 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 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. →
By Shlomi Noach |
Learn about the options for running non-blocking schema changes natively to MySQL, using Vitess, or other tools →
By Ben 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 Ben Dicken |
The adaptive hash index helps 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 Ben 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. →
By Brian Morrison II |
Learn the best practices for configuring MySQL replication, and how to ensure your data is always available. →
By Ayrton |
Learn how to build HTML emails using Rails and Tailwind CSS. We also cover how to overcome some common obstacles such as Gmail message clipping, large file size, Apple autolinking, and more. →