Skip to content

Blog

🚧 Pardon our dust while we transition our blog to our new website.
What is MySQL partitioning?
Engineering

What is MySQL partitioning?

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

Brian Morrison II
MySQL High Availability: Connection handling and concurrency
Engineering

MySQL High Availability: Connection handling and concurrency

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

Matthias Crauwels
Personalizing your onboarding with Markdoc
Engineering

Personalizing your onboarding with Markdoc

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

Ayrton
PlanetScale is bringing vector search and storage to MySQL
Company

PlanetScale is bringing vector search and storage to MySQL

We are adding vector storage and search to MySQL, enabling you to use PlanetScale for your AI use cases.

Nick Van Wiggeren
PlanetScale Managed is now PCI compliant
Product

PlanetScale Managed is now PCI compliant

PlanetScale Managed on AWS is now PCI compliant.

Frank Fink
How to Scale your Database and when to Shard MySQL
Engineering

How to Scale your Database and when to Shard MySQL

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.

Jonah Berquist
Scaling hundreds of thousands of database clusters on Kubernetes
Vitess

Scaling hundreds of thousands of database clusters on Kubernetes

Explore what to consider when deploying databases to Kubernetes, and how PlanetScale utilizes Kubernetes and Vitess to run hundreds of thousands of databases.

Brian Morrison II
The art and science of database sharding
Product

The art and science of database sharding

Grasping when and how to shard, selecting the ideal shard keys, and managing cross-shard queries effectively can prove difficult even for seasoned engineers. Learn how to do this, and more in this tech talk.

Liz van Dijk
Streamline database management using the PlanetScale Netlify integration
Product

Streamline database management using the PlanetScale Netlify integration

Learn how to use the new PlanetScale Netlify integration to simplify the process of wiring up a database to your Netlify applications.

Taylor Barnett
Emulating foreign key constraints with Drizzle relationships
Tutorials

Emulating foreign key constraints with Drizzle relationships

Learn how to build virtual relationships between tables in PlanetScale while using the Drizzle TypeScript ORM.

Brian Morrison II
Horizontal sharding for MySQL made easy
Engineering

Horizontal sharding for MySQL made easy

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.

Lucy Burns, Taylor Barnett
Deploying multiple schema changes at once
Engineering

Deploying multiple schema changes at once

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

Shlomi Noach
What makes up a PlanetScale database?
Product

What makes up a PlanetScale database?

Learn about all of the tech driving every PlanetScale database.

Brian Morrison II
Vitess for us all
Vitess

Vitess for us all

Learn how middleware technology works, the pitfalls of application-level sharding, and how Vitess enables horizontal sharding of MySQL for near infinite scale.

Deepthi Sigireddi
Introducing IP restrictions
Product

Introducing IP restrictions

PlanetScale now supports IP restrictions for database passwords as another tool to operate your database securely.

Iheanyi Ekechukwu, David Graham, Ayrton
Storing time series data in sharded MySQL to power Query Insights
Engineering

Storing time series data in sharded MySQL to power Query Insights

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

Rafer Hazen
Is your database bleeding money?
Product

Is your database bleeding money?

Databases can cost your company millions if they don’t function as they should. What are the biggest pitfalls, and how can you avoid them?

Sam Lambert
Database caching: Optimizing performance
Product

Database caching: Optimizing performance

Dive into the complexities of database caching, covering materialized views, cache invalidation, and other techniques with a special demo of the new and exciting caching technology behind PlanetScale Boost.

Rick Branson
How PlanetScale unlocks developer productivity
Product

How PlanetScale unlocks developer productivity

A guide on what slows developers down, why it matters, and how a better database can unlock developer productivity.

Justin Gage
Incorporating databases into your CI/CD pipeline
Product

Incorporating databases into your CI/CD pipeline

In this tech talk, we demo how to build your own CI/CD pipelines, where to incorporate the database, and why the database has historically been left out of CI/CD.

Mike Coutermarsh
Performant database tree traversal with Rails
Engineering

Performant database tree traversal with Rails

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

Mike Coutermarsh
Announcing PlanetScale Scaler Pro
Company

Announcing PlanetScale Scaler Pro

See how Scaler Pro combines the best of our current plans for companies of all sizes while enabling you to grow with the best database for serverless.

Nick Van Wiggeren
Introduction to PlanetScale
Product

Introduction to PlanetScale

This video is an introduction to the PlanetScale database platform and how it can increase developer velocity, including a demo of features, such as branching, deploy requests, and query insights.

Taylor Barnett
How PlanetScale keeps your data safe
Engineering

How PlanetScale keeps your data safe

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

Sam Lambert
Announcing Vitess 17
Vitess

Announcing Vitess 17

In this release of Vitess, several significant enhancements have been introduced to improve the compatibility, performance, and usability of the system.

Matt Lord
Action on your product data in real time
Product

Action on your product data in real time

PlanetScale and Hightouch cover how you can make use of one of your most valuable company assets: product data.

Brian Morrison II
Datetimes versus timestamps in MySQL
Engineering

Datetimes versus timestamps in MySQL

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

Aaron Francis
Generated Hash Columns in MySQL
Engineering

Generated Hash Columns in MySQL

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

Aaron Francis
Using PlanetScale with Serverless Framework Node applications on AWS
Tutorials

Using PlanetScale with Serverless Framework Node applications on AWS

Learn how to integrate PlanetScale with Node applications built using the Serverless Framework on AWS.

Matthieu Napoli