Blog
MySQL has built-in functionality for collecting statistics on and profiling your MySQL queries. Learn how to leverage these features to identify problems. →
Understand the different versions of UUIDs and why using them as a primary key in MySQL can hurt database performance. →
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. →
Learn about a few common mistakes when designing your MySQL database schema. →
Learn the key differences between Amazon Aurora blue/green deployments and PlanetScale branching. →
Learn different considerations and best practices for quickly and efficiently recovering your database when downtime hits. →
In this blog post, we explore how complex data and geographic features can be represented in MySQL. →
Learn about how Amazon Aurora replication works, and how it compares to the traditional MySQL replication strategy used by PlanetScale. →
Learn about the various isolation levels used by MySQL to allow concurrency in your database. →
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. →
Learn what HTAP is, how HTAP compares to OLAP and OLTP, and some pros and cons of HTAP. →
Learn what went into building PlanetScale webhooks from a security perspective. This article covers SSRF, webhook validation, DDoS, and more. →
There is more to sharding than simply increasing data throughput. In this article, we explore three different benefits of sharding your database. →
Learn the best practices for configuring MySQL replication, and how to ensure your data is always available. →
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. →
Maximizing performance while minimizing costs is integral for engineering large-scale applications with massive data volumes. Learn more about cost-effective sharding in this tech talk. →
Learn about what database replication is and some real-world use cases of MySQL replication that can benefit your database scalability strategy. →
Learn what distributed caching systems are, how they complement MySQL databases, and potential issues you might face when implementing them. →
Learn the basics of MySQL partitioning, including partitioning with range, list, and key strategies, as well as how partitioning relates to database sharding. →
Deep dive into MySQL’s connection handling mechanisms for optimal connection pooling and improved concurrency. →
Ayrton |
Learn how we utilized Markdoc to create custom, extendable product onboarding at PlanetScale. →
Not sure when to shard your MySQL or Postgres database? This article covers when you should consider horizontal sharding as a scaling strategy in MySQL and Postgres, and some other scaling options before then. →
Historically, there has been the belief that you cannot horizontally scale and shard MySQL, learn how Vitess has made MySQL sharding at the database layer a reality. →
Why PlanetScale deploys branch changes near-atomically, and how it applies concurrency and dependency resolution without impacting production databases. →
How we built a scalable telemetry pipeline with Apache Kafka and PlanetScale. →