PlanetScale for Postgres is here. Request early access
Navigation

Blog


By Max Englander |

The principles and processes we follow for fault tolerance.


By Ben Dicken |

Benchmarking Postgres in a transparent, standardized and fair way is challenging. Here, we look at the process of how we did it in-depth


By Vicent Martí |

A novel technique for implementing dynamic language interpreters in Go, applied to the Vitess SQL evaluation engine


By Nick Van Wiggeren |

Our experience running AWS EBS at scale for critical workloads


By Ben Dicken |

Take an interactive journey through the history of IO devices, and learn how IO device latency affects performance.


By Rafer Hazen |

Our experience upgrading the Query Insights database to PlanetScale Metal


By Richard Crowley |

Learn how PlanetScale Metal was built and how we ensured it is safe.


By Manan Gupta |

Learn how PlanetScale keeps its private fork of Vitess up-to-date with OSS


By Ben Dicken |

Learn about the database sharding scaling pattern in this interactive blog.


By Shlomi Noach |

Design considerations for implementing a database throttler


By Shlomi Noach |

Design considerations for implementing a database throttler with a comparison of singular vs distributed throttler deployments.


By Ben Dicken |

B-trees are used by many modern DBMSs. Learn how they work, how databases use them, and how your choice of primary key can affect index performance.


By Shlomi Noach |

Learn about some design considerations for implementing a database throttler.


By Ben Dicken |

For big databases, IOPS and throughput can become a bottleneck in database performance. Learn how sharding helps scale out IOPS and throughput beyond the limitations of a single server.


By Ben Dicken |

Sharding a database comes with many benefits: Scalability, failure isolation, write throughput, and more. However, one of the lesser-known benefits comes from improved backups and restore performance.


By Shlomi Noach |

Learn about the options for running non-blocking schema changes natively to MySQL, using Vitess, or other tools


By Ben Dicken |

Large databases often have a small number of very large tables that makes scaling difficult. How can you scale with these while keeping your database performant? This article covers three techniques.


By Holly Guevara |

Learn about the different types of sharding: directory-based, range-based, and hash-based plus some of the pros and cons of each.


By Ben Dicken |

The adaptive hash index helps to improve performance of the already-fast B-tree lookups


By Ben Dicken |

Learn how to visualize the memory usage of a MySQL connection


By Mike Coutermarsh |

Learn how PlanetScale uses GitHub Actions and PlanetScale to automate schema changes on our own application.


By Ben Dicken |

MySQL has built-in functionality for collecting statistics on and profiling your MySQL queries. Learn how to leverage these features to identify problems.


By Brian Morrison II |

Understand the different versions of UUIDs and why using them as a primary key in MySQL can hurt database performance.


By Brian Morrison II |

Amazon Aurora is pitched as a straightforward and scalable database service on AWS, but there are associated costs that you might not be aware of.


By Brian Morrison II |

Learn about a few common mistakes when designing your MySQL database schema.

← Previous