July 2023 Summaries

The text discusses optimizing database performance through caching techniques such as materialized views and cache invalidation. It also introduces an upcoming demonstration of a novel caching technology, PlanetScale Boost. This topic is relevant for those interested in improving the efficiency of their databases.

PlanetScale Boost is now available to the public beta, offering up to 1,000× faster database queries with just a few clicks. The feature can make your application's queries up to 1,000× faster without requiring caching logic or infrastructure. PlanetScale Boost works with MySQL-compatible queries and enables cached queries on a connection with a single `USE` statement. To get started, clients can access the documentation on how to use PlanetScale Boost, which includes information on optimal scenarios for its usage.

PlanetScale is a platform that helps unlock developer productivity by addressing the challenges posed by traditional database management processes, such as manual review and approval cycles, schema changes, and inefficient tools. By bringing the database into the DevOps cycle, PlanetScale provides features like branching, deploy requests, and insights to make change management simple and efficient. This allows developers to focus on shipping code faster, reducing friction between teams, and improving overall productivity. With its scalable platform and world-class operations, PlanetScale helps organizations overcome the bottleneck of their database and achieve innovation.

We built a scalable telemetry pipeline using Apache Kafka and a sharded PlanetScale database to collect, store, and serve telemetry data for our Insights query performance tool. To power Insights search, we use a hybrid solution that combines Prometheus for database-level aggregations and MySQL for storing query-pattern level statistics and individual slow query events. The Insights pipeline begins in VTGate, which sends aggregate summaries and slow query events to Kafka every 15 seconds. We sharded the Insights database cluster based on customer database ID to ensure scalability and built a custom binary format for reading and writing sketches in MySQL, allowing us to calculate percentiles without pulling underlying data into our application. We chose MySQL as a time series database due to its high cardinality of primary dimension, infrequent changes, ability to filter the dataset, natural shard key, and operational overhead being manageable with sharded Vitess and Kafka.

The text discusses a technical presentation that demonstrates how to create Continuous Integration/Continuous Deployment (CI/CD) pipelines while incorporating databases. It also explains why databases have traditionally been excluded from CI/CD processes and provides insights on where to integrate them effectively.

We solved a performance problem in our Rails API when performing a tree traversal by creating an in-memory cache to store the snapshots and preloading it with recent snapshots from each branch. This reduced the number of database queries from thousands to just a few, solving the N+1 query problem. We also tested and refined the solution using feature flags and data on hits and misses, and considered alternative solutions such as using a recursive common table expression or materialized path in the database.

PlanetScale has announced a new generation of plans and pricing, replacing its Teams plan with Scaler Pro, which combines the best of current plans for companies of all sizes. Scaler Pro allows customers to select exactly the resources they need for their workloads, offering more control than traditional serverless models and clarity on how it compares to products like Amazon RDS and Google Cloud SQL. The new pricing model is based on a combination of resources (CPU and memory) and disk storage, with no charge for binary logs or metadata. Scaler Pro databases are designed to provide predictability, stability, and availability, while also offering competitive pricing compared to established Database-as-a-Service solutions. The new plans have been updated, and customers can now easily migrate existing Developer or Scaler databases to the new Scaler Pro plan, with support for larger workloads available through the sales team.