Blog
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. →
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. →