Blazing fast NVMe drives with unlimited IOPS now available. Read about PlanetScale Metal
Navigation

Blog


By Savannah Longoria |

In this blog post, we explore how complex data and geographic features can be represented in MySQL.


By Brian Morrison II |

Learn about how Amazon Aurora replication works, and how it compares to the traditional MySQL replication strategy used by PlanetScale.


By Brian Morrison II |

Learn about the various isolation levels used by MySQL to allow concurrency in your database.


By Shlomi Noach, Manan Gupta |

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.


By Savannah Longoria |

Learn what HTAP is, how HTAP compares to OLAP and OLTP, and some pros and cons of HTAP.


By Mike Coutermarsh |

Learn what went into building PlanetScale webhooks from a security perspective. This article covers SSRF, webhook validation, DDoS, and more.


By Brian Morrison II |

There is more to sharding than simply increasing data throughput. In this article, we explore three different benefits of sharding your database.


By Brian Morrison II |

Learn the best practices for configuring MySQL replication, and how to ensure your data is always available.


By 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.


By David Bravant |

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.


By Brian Morrison II |

Learn about what database replication is and some real-world use cases of MySQL replication that can benefit your database scalability strategy.


By Brian Morrison II |

Learn what distributed caching systems are, how they complement MySQL databases, and potential issues you might face when implementing them.


By Brian Morrison II |

Learn the basics of MySQL partitioning, including partitioning with range, list, and key strategies, as well as how partitioning relates to database sharding.


By Matthias Crauwels |

Deep dive into MySQL’s connection handling mechanisms for optimal connection pooling and improved concurrency.


By Ayrton |

Learn how we utilized Markdoc to create custom, extendable product onboarding at PlanetScale.


By Jonah Berquist |

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.


By Lucy Burns, Taylor Barnett |

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.


By Shlomi Noach |

Why PlanetScale deploys branch changes near-atomically, and how it applies concurrency and dependency resolution without impacting production databases.


By Rafer Hazen |

How we built a scalable telemetry pipeline with Apache Kafka and PlanetScale.


By Mike Coutermarsh |

Learn how to solve a tree traversal N+1 query problem in your Rails application.


By PlanetScale |

Sharding and partitioning are two common ways to improve performance, manageability, and availability of larger databases.


By Sam Lambert |

A detailed description of the multi-layered approach PlanetScale takes to ensure your data is safe.


By Aaron Francis |

Learn the differences between datetimes and timestamps in MySQL, the DATE, YEAR, and TIME columns, timezones, and when to use each.


By Aaron Francis |

Creating generated hash columns in MySQL for faster strict equality lookups.


By Aaron Francis |

Using redundant conditions as a method to unlock obfuscated indexes and improve performance in MySQL.