Profiling memory usage in MySQL
Learn how to visualize the memory usage of a MySQL connection
How PlanetScale makes schema changes
Learn how PlanetScale uses GitHub Actions and PlanetScale to automate schema changes on our own application.
Identifying and profiling problematic MySQL queries
MySQL has built-in functionality for collecting statistics on and profiling your MySQL queries. Learn how to leverage these features to identify problems.
The Problem with Using a UUID Primary Key in MySQL
Understand the different versions of UUIDs and why using them as a primary key in MySQL can hurt database performance.
Amazon Aurora Pricing: The many surprising costs of running an Aurora database
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.
Three common MySQL database design mistakes
Learn about a few common mistakes when designing your MySQL database schema.
PlanetScale branching vs. Amazon Aurora blue/green deployments
Learn the key differences between Amazon Aurora blue/green deployments and PlanetScale branching.
Considerations for building a database disaster recovery plan
Learn different considerations and best practices for quickly and efficiently recovering your database when downtime hits.
Working with Geospatial Features in MySQL
In this blog post, we explore how complex data and geographic features can be represented in MySQL.
PlanetScale vs Amazon Aurora replication
Learn about how Amazon Aurora replication works, and how it compares to the traditional MySQL replication strategy used by PlanetScale.
MySQL isolation levels and how they work
Learn about the various isolation levels used by MySQL to allow concurrency in your database.
Introducing the schemadiff command line tool
We are releasing schemadiff, an open source command line tool to generate diffs between two MySQL databases.
The challenges of supporting foreign key constraints
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.
What is HTAP?
Learn what HTAP is, how HTAP compares to OLAP and OLTP, and some pros and cons of HTAP.
Webhook security: a hands-on guide
Learn what went into building PlanetScale webhooks from a security perspective. This article covers SSRF, webhook validation, DDoS, and more.
Three surprising benefits of sharding a MySQL database
There is more to sharding than simply increasing data throughput. In this article, we explore three different benefits of sharding your database.
MySQL replication: Best practices and considerations
Learn the best practices for configuring MySQL replication, and how to ensure your data is always available.
A guide to HTML email with Ruby on Rails and Tailwind CSS
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.
What is MySQL replication and when should you use it?
Learn about what database replication is and some real-world use cases of MySQL replication that can benefit your database scalability strategy.
Distributed caching systems and MySQL
Learn what distributed caching systems are, how they complement MySQL databases, and potential issues you might face when implementing them.
What is MySQL partitioning?
Learn the basics of MySQL partitioning, including partitioning with range, list, and key strategies, as well as how partitioning relates to database sharding.
Personalizing your onboarding with Markdoc
Learn how we utilized Markdoc to create custom, extendable product onboarding at PlanetScale.
How to Scale your Database and when to Shard MySQL
Not sure when to shard your MySQL database? This article covers when you should consider horizontal sharding as a scaling strategy in MySQL and some other scaling options before then.
Scaling hundreds of thousands of database clusters on Kubernetes
Explore what to consider when deploying databases to Kubernetes, and how PlanetScale utilizes Kubernetes and Vitess to run hundreds of thousands of databases.
Horizontal sharding for MySQL made easy
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.
Deploying multiple schema changes at once
Why PlanetScale deploys branch changes near-atomically, and how it applies concurrency and dependency resolution without impacting production databases.
Storing time series data in sharded MySQL to power Query Insights
How we built a scalable telemetry pipeline with Apache Kafka and PlanetScale.
How brand design works at PlanetScale
Learn how the Brand team designs and builds marketing experiences at PlanetScale.
Performant database tree traversal with Rails
Learn how to solve a tree traversal N+1 query problem in your Rails application.