Blog
Connection pooling reduces the overhead of establishing new database connections. Learn how connection pooling works and how it is handled in Vitess. →
JD Lien |
Learn what you should look out for when upgrading an existing database from MySQL 5.7 to 8 and how to change your database to be compatible with the new version. →
What does the MySQL 5.7 EOL means for your database? Learn considerations to upgrade 8.0 and how PlanetScale can help you upgrade with no downtime or data loss. →
Learn how to use Python SQLAlchemy with MySQL by working through an example of creating tables, inserting data, and querying data with both raw SQL and SQLAlchemy ORM. →
Vitess 16 is now generally available with updates to VDiff v2, VTOrc, MySQL compatibility, and more. →
Join PlanetScale’s Lead Infrastructure Engineer for Edge connectivity for an explainer on our findings regarding HTTP/3 and the MySQL protocol. →
Learn how to migrate from Postgres to MySQL, Postgres vs MySQL incompatibilities, and more. →
An overview of some common MySQL error codes you may run into, what they mean, and how to solve them. →
Learn about sharding, connection pooling, and more from PlanetScale Technical Solutions Architect Jonah Berquist. →
In this article we explore how our HTTP/3 API compares to the latency of a traditional MySQL client. →
PlanetScale Vitess is more than just a drop-in replacement for MySQL. Learn about everything PlanetScale can do for you. →
Gain a deeper understanding of the MySQL integer types by exploring the different options (INT BIGINT MEDIUMINT etc) and how they are stored. →
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. →
JD Lien |
Learn how and when to use inner joins, outer joins, left joins, and right joins in MySQL. →
Learn how to index JSON in MySQL with generated columns and functional indexes. →
In this entry of the series we explore using VARCHAR and CHAR data types in your database and give some pointers on which type is best to use and when. →
Learn what the MySQL JSON data type is when to use MySQL JSON and some caveats to using JSON documents in relational databases. →
Learn how to use Atlas CLI with PlanetScale to define your database as code. →
Discover how PlanetScale handles one million queries per second (QPS) with horizontal sharding in MySQL →
Learn how PlanetScale protects against downtime due to human error system immaturity and app issues. →
Learn how to safely drop tables in MySQL by checking if the table is still in use and how PlanetScale makes this process much easier. →
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 →