Blog
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. →
Learn how to solve a tree traversal N+1 query problem in your Rails application. →
Sharding and partitioning are two common ways to improve performance, manageability, and availability of larger databases. →
A detailed description of the multi-layered approach PlanetScale takes to ensure your data is safe. →
Learn the differences between datetimes and timestamps in MySQL, the DATE, YEAR, and TIME columns, timezones, and when to use each. →
Creating generated hash columns in MySQL for faster strict equality lookups. →
Using redundant conditions as a method to unlock obfuscated indexes and improve performance in MySQL. →
Understanding the differences between character sets and collations in MySQL. →
Learn the main differences between MariaDB and MySQL, why you might choose one over the other, scaling options, and how Vitess fits into the picture. →
Learn about safely using the expand, migrate, and contract pattern to make database schema changes without downtime and data loss. →
There are several reasons why MySQL might not consider your index, and in this article we’ll explore some of the most common ones. →
Learn how to create serverless Laravel applications by deploying them to AWS Lambda and using PlanetScale as the database. →
Learn how PlanetScale uses Git-like three-way diff to resolve schema change conflicts across database branches. →
Everything you need to know about MySQL as an application developer, with a focus on improving query performance. After covering the high-level overview, we’ll put the learnings to the test with some hands-on examples. →
An overview of the different ways to paginate in MySQL including limit/offset pagination and cursor pagination plus the pros and cons of each. →
Learn what database sharding is, how sharding works, and some common sharding frameworks and tools. →
Learn how to read the output in MySQL EXPLAIN plans so you can utilize them to improve query performance. →
Learn about the Ruby on Rails workflow that protects your database and application from accidental downtime and data loss. →
What does the MySQL 5.7 EOL means for your database? Learn considerations to upgrade 8.0 and how PlanetScale can help you upgrade with no downtime or data loss. →