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.
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.
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.
How we built a scalable telemetry pipeline with Apache Kafka and PlanetScale.
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.
Understanding the differences between character sets and collations in MySQL.
There are several reasons why MySQL might not consider your index, and in this article we’ll explore some of the most common ones.