Blog
Data migrations are a critical part of the database lifecycle, and are sometimes necessary for version upgrades, sharding, or moving to a new platform. In many cases, migrations are painful and error-prone. In this article, we walk through how migrations are performed at PlanetScale, and offer advice on how to improve the migration experience. →
Learn the basics of Change Data Capture (CDC) and how to leverage Vitess VStream API to build data pipelines. →
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. →
Harshit Gangal, Deepthi Sigireddi |
How we implemented a consistent lookup Vindex in Vitess to ensure data consistency without using 2PC →
My experience working as an intern in the Vitess query serving team for PlanetScale. →
We are releasing schemadiff, an open source command line tool to generate diffs between two MySQL databases. →
Vitess 18 is now generally available, with a number of new enhancements designed to improve usability, performance, and MySQL compatibility. →
Explore what to consider when deploying databases to Kubernetes, and how PlanetScale utilizes Kubernetes and Vitess to run hundreds of thousands of databases. →
Learn how middleware technology works, the pitfalls of application-level sharding, and how Vitess enables horizontal sharding of MySQL for near infinite scale. →
In this release of Vitess, several significant enhancements have been introduced to improve the compatibility, performance, and usability of the system. →
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. →
Connection pooling reduces the overhead of establishing new database connections. Learn how connection pooling works and how it is handled in Vitess. →
Vitess 16 is now generally available with updates to VDiff v2, VTOrc, MySQL compatibility, and more. →
Vitess 15 is now generally available with updates to VTOrc, VTAdmin, MySQL compatibility, and more. →
Learn what Vitess is, how it works, and how it can improve your database‘s resilience, scalability, and performance. →
Florent Poinsard, Harshit Gangal |
Learn how we detected and optimized two slow queries in arewefastyet using PlanetScale Insights. →
In the final installment of the consensus algorithm series we pull everything together with some final thoughts. →
In part 7 of the Consensus algorithm series we combine everything we’ve worked at to cover propagating requests →
Learn about what was just released in Vitess 14 →
Vitess is a database proxy that creates an illusion of a single database when in reality the query is sent to multiple MySQL instances. →