Blog
Learn the best practices for configuring MySQL replication, and how to ensure your data is always available. →
Vitess 18 is now generally available, with a number of new enhancements designed to improve usability, performance, and MySQL compatibility. →
Learn about what database replication is and some real-world use cases of MySQL replication that can benefit your database scalability strategy. →
Learn how to sync user data from a Clerk project into your PlanetScale MySQL database with webhooks using Netlify and Netlify Functions. →
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. →
Nick Van Wiggeren [@NickVanWig] |
We are adding vector storage and search to MySQL, enabling you to use PlanetScale for your AI use cases. →
Guide to scaling your database: When to shard MySQL and Postgres
[Engineering, PostgreSQL, Vitess, MySQL]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. →
Explore what to consider when deploying databases to Kubernetes, and how PlanetScale utilizes Kubernetes and Vitess to run hundreds of thousands of databases. →
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. →
Learn about all of the tech driving every PlanetScale database. →
Learn how middleware technology works, the pitfalls of application-level sharding, and how Vitess enables horizontal sharding of MySQL for near infinite scale. →
How we built a scalable telemetry pipeline with Apache Kafka and PlanetScale. →
In this release of Vitess, several significant enhancements have been introduced to improve the compatibility, performance, and usability of the system. →
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. →
See how Vitess acts as a database proxy that creates an illusion of a single database when technically, the query is sent to multiple MySQL instances. →
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. →
There are several reasons why MySQL might not consider your index, and in this article we’ll explore some of the most common ones. →
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 how to read the output in MySQL EXPLAIN plans so you can utilize them to improve query performance. →