Work
A collection of things I’ve done, not already hosted on my personal site here.
Interactive Blogs
Blogs
- Increase IOPS and throughput with sharding
- Faster backups with sharding
- Dealing with large tables
- MySQL on a Raspberry Pi
- The MySQL adaptive hash index
- Displaying images in MySQL
- Profiling memory usage in MySQL
- Memory access patterns and performance
- Identifying and profiling problematic MySQL queries
- Turn images into contour maps
- Stylized image binning algorithm
Courses
Videos
- Are my indexes being used? Let’s find out.
- How we do PoCs with customers (Proof of Concept)
- Megabytes to Petabytes: the journey of scaling a database
- Case Study: Interview with Brian Anglin (Superwall)
- Use Slack? Get PlanetScale updates with webhooks.
- Case Study: Interview with Steven Tey (Dub)
- Learn Vitess - Introduction (part 1)
- Learn Vitess - Build and Run Vitess (part 2)
- Learn Vitess - Components of a Vitess cluster (part3)
- Learn Vitess - Vertical Sharding (part4)
- Learn Vitess - Horizontal Sharding (part 5)
- Learn Vitess - Multiple Machines (part 6)
- Learn Vitess - Sharding on Multiple Machines (part 7)
- Learn Vitess - Vitess on Kubernetes (part 8)
- Learn Vitess - Vitess at PlanetScale (part 9)
- Working with strings in MySQL
- Slow database? Replicas are here to help.
- Speed up your MySQL database with the buffer pool
- How Vitess powers your PlanetScale database
- Bad Schema? Improve it with this tool.
- Creating a 100 gigabyte index on 1 billion+ rows
- Watch me 100x a SQL query
- Increase speed and durability with MySQL replication
- Auto-generate MySQL schema diagrams with a custom Figma plugin
- I loaded 100,000,000 rows into MySQL