Upgrading Query Insights to Metal
Since PlanetScale Metal is now generally available, I wanted to share a post describing our experience migrating the PlanetScale database that powers the Query Insights feature to Metal. Data collection in Query Insights First, a bit about how we collect the data for Query Insights. The basic steps are: Collect query-pattern telemetry from the Vitess layer of your PlanetScale database Publish the data to Kafka Consume the data from Kafka and write to several MySQL tables, aggregated by time. The
