Blog

By Matt Lord | July 29, 2024

Learn the basics of Change Data Capture (CDC) and how to leverage Vitess VStream API to build data pipelines. →

By Shlomi Noach | July 23, 2024

Learn about the options for running non-blocking schema changes natively to MySQL, using Vitess, or other tools →

By Andres Taylor | July 22, 2024

The Vitess query planner takes multiple passes over a query plan to optimize it as much as possible before execution. A recent tricky bug report led to an improvement in how the optimizer functions. →

By Ben Dicken | July 10, 2024

Large databases often have a small number of very large tables that makes scaling difficult. How can you scale with these while keeping your database performant? This article covers three techniques. →

By Holly Guevara | July 8, 2024

Learn about the different types of sharding: directory-based, range-based, and hash-based plus some of the pros and cons of each. →

By Vitess Engineering Team | June 27, 2024

Vitess 20 is now generally available. →

By Holly Guevara | May 24, 2024

PlanetScale and Vitess have a close relationship. Learn what it looks like to run Vitess on your own vs using PlanetScale. We cover cost, time to implement, management, and more. →

By Harshit Gangal, Deepthi Sigireddi | April 29, 2024

How we implemented a consistent lookup Vindex in Vitess to ensure data consistency without using 2PC →

By Ben Dicken | April 24, 2024

The adaptive hash index helps to improve performance of the already-fast B-tree lookups →

By Matt Robenolt, Iheanyi Ekechukwu | April 17, 2024

With global replica credentials, you can now automatically route reads to the closest replica. →

By Ben Dicken | April 11, 2024

Learn how to visualize the memory usage of a MySQL connection →

By Arvind Murty | April 9, 2024

My experience working as an intern in the Vitess query serving team for PlanetScale. →

By Mike Coutermarsh | April 4, 2024

Learn how PlanetScale uses GitHub Actions and PlanetScale to automate schema changes on our own application. →

By Ben Dicken | March 29, 2024

MySQL has built-in functionality for collecting statistics on and profiling your MySQL queries. Learn how to leverage these features to identify problems. →

By Brian Morrison II | March 19, 2024

Understand the different versions of UUIDs and why using them as a primary key in MySQL can hurt database performance. →

By Vitess Engineering Team | March 8, 2024

Vitess 19 is now generally available. →

By Sam Lambert | March 6, 2024

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

By Taylor Barnett, Rafer Hazen | February 28, 2024

Automatically receive recommendations to improve database performance, reduce memory and storage, and improve your schema based on production database traffic. →

By Taylor Barnett, Rick Branson | February 16, 2024

You can now enable foreign key constraints to enforce referential integrity in your PlanetScale database. →

By Brian Morrison II | February 15, 2024

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

By Brian Morrison II | February 13, 2024

Learn about a few common mistakes when designing your MySQL database schema. →

By Taylor Barnett | February 6, 2024

You can now build integrations that seamlessly authenticate with PlanetScale and allow management access to your users’ organizations and databases from your application. →

By Nick Van Wiggeren | February 5, 2024

Today, in our effort to continue being the best database for serverless and applications that require massive scale, we are deprecating the Scaler plan. →

By Brian Morrison II | February 2, 2024

Learn the key differences between Amazon Aurora blue/green deployments and PlanetScale branching. →

By Rick Branson | January 31, 2024

Learn about the three main aspects of database scaling: storage, compute, and network. →