Best of MySQL — April 2025

1. 1
   Article

   ByteByteGo·1y

   How YouTube Supports Billions of Users with MySQL and Vitess

   YouTube scaled its backend to manage billions of users by implementing Vitess on top of MySQL. Vitess acts as a smart intermediary, enabling horizontal scaling, efficient query routing, and automated database management tasks. Key strategies included replication, sharding, vertical splitting, and enhancements like connection pooling, query safety mechanisms, and a specialized row cache. These measures addressed issues like replication lag, data consistency, and high write loads, ensuring YouTube's backend remained efficient and resilient.

   230

   3
2. 2
   Article

   Community Picks·1y

   Online SQL Playground for MySQL, PostgreSQL, and SQL Server

   RunSQL is an online SQL playground designed for learning, testing, and sharing SQL queries for MySQL, PostgreSQL, and SQL Server. Users can easily create and manipulate database schemas using DBML, collaborate on SQL projects, conduct interviews, and create web-based database documentation without needing local database setup. It provides a shared environment tailored for developers and data analysts.

   192

   6
3. 3
   Article

   Hacker News·1y

   antiwork/gumroad

   The post provides a comprehensive guide on setting up a development environment for the 'antiwork/gumroad' project. It includes installation instructions for necessary dependencies like Ruby, Docker, MySQL, ImageMagick, libvips, FFmpeg, PDToolkit, Bundler, dotenv, and npm. The guide also covers creating SSL certificates, starting Docker services, and running the application along with Rails, a JavaScript build system, and Sidekiq worker. Additional setup steps like reindexing Elasticsearch and configuring git hooks are included.

   82

   2
4. 4
   Article

   Last9·1y

   How to Use MySQL Performance Analyzer

   Dealing with slow MySQL queries? Performance analyzers can help identify bottlenecks and optimize database performance. Understand key metrics such as query response time, CPU usage, and buffer pool efficiency. Discover top tools like Last9, PMM, and MySQL Enterprise Monitor for effective monitoring. Learn setup steps for PMM and essential commands for quick troubleshooting. Explore advanced techniques like partitioning and read/write splitting to further enhance performance.

   29

   1
5. 5
   Video

   Laravel Daily·1y

   I've Tried to Seed 10M Rows into MySQL...

   Successfully seeding 10.5 million records into MySQL with Laravel requires careful memory management and batch processing. Testing on both a local MacBook Pro and a $6 Digital Ocean server showed the task is feasible, though the process is slower on cheaper cloud servers. Despite the heavy load, MySQL's performance in querying large datasets remains efficient.

   10