ngosangns Knowledge Base

#mysql

  • Storage Engines
    Comparison of MySQL storage engines (MyISAM, InnoDB, MEMORY) and a deep dive into InnoDB pages, rows, row-size limits, and off-page storage formats.
  • ProxySQL Connection Multiplexing
    How ProxySQL connection multiplexing lets many frontend connections share few MySQL backend connections, when it is disabled, and how to tune it.
  • Vitess Distributed Database Best Practices
    Community-derived best practices for Vitess MySQL sharding, covering cross-shard transactions, CDC and the outbox pattern, distributed transaction patterns, and deployment.
  • MySQL
    Guide to MySQL, the popular open-source RDBMS, covering storage engines, data types, CRUD, indexing, views, procedures, triggers, replication, and best practices.
  • YouTube Architecture
    Summarizes how YouTube scaled its backend to serve billions of users by putting Vitess on top of MySQL to enable horizontal scaling.