The MySQL adaptive hash index
The adaptive hash index help to improve performance of the already-fast B-tree lookups
Introducing global replica credentials
With global replica credentials, you can now automatically route reads to the closest replica.
Changelog
Go to changelogConnecting to PlanetScale privately on AWS
You can now privately connect to your Scaler Pro databases using AWS PrivateLink
Read moreInsights query latency percentile filtering
You can now filter Insights query patterns by query latency
Read moreCharacter set and collation upgrade recommendations
You will now receive recommendations to upgrade legacy character sets and collations.
Read moreProfiling memory usage in MySQL
Learn how to visualize the memory usage of a MySQL connection
Summer 2023: Fuzzing Vitess at PlanetScale
My experience working as an intern in the Vitess query serving team for PlanetScale.
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.
Announcing Vitess 19
Vitess 19 is now generally available.
PlanetScale forever
PlanetScale is committed to providing a reliable and sustainable platform for our customers, not just in the short-term, but forever. For this reason, we are prioritizing profitability.
Introducing schema recommendations
Automatically receive recommendations to improve database performance, reduce memory and storage, and improve your schema based on production database traffic.
Foreign key constraints are now generally available
You can now enable foreign key constraints to enforce referential integrity in your PlanetScale database.
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.
OAuth applications are now available to everyone
You can now build integrations that seamlessly authenticate with PlanetScale and allow management access to your users’ organizations and databases from your application.
One million connections
Learn how to use PlanetScale to safely include your database in your serverless functions without hitting connection limits in MySQL.
Building PlanetScale with PlanetScale
How PlanetScale uses database branching and non-blocking schema changes to build PlanetScale.
Deprecating the Scaler plan
Today, in our effort to continue being the best database for serverless and applications that require massive scale, we are deprecating the Scaler plan.
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.
Introducing the Vantage and PlanetScale integration
The Vantage + PlanetScale integration is now available.
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.
$ pscale ping
How close am I to PlanetScale? Use our new CLI command, pscale ping, to find out.
Announcing foreign key constraints support
You can now use foreign key constraints in PlanetScale 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.
Introducing Insights Anomalies
This new update to PlanetScale Insights introduces smart query monitoring to detect slower than expected queries in your database.
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.