MySQL 8.0: SQL and NoSQL Scalability
summary
MySQL 8.0 adds a document store on top of InnoDB so JSON is stored in binary form with automatic validation and path access, collections map to two-column InnoDB tables (id + JSON) and support CRUD via the X Protocol and Shell. It supplies InnoDB cluster orchestration, Group Replication with virtual synchronous replication, automatic conflict detection/resolution and fast failover, and a lightweight MySQL Router for read/write routing. Recommended deployments start at three nodes; caveats include primary-key requirements, certain transactional limits on collections, and network latency sensitivity.
AI-written summary · about
chapters (10)
- 0:00Introduction and overview
- 2:19Data scaling challenges
- 7:43JSON document storage in MySQL
- 15:33MySQL Shell for document operations
- 17:04Limitations of classic replication
- 20:17Group Replication overview
- 25:44Group Replication mechanics
- 31:19Group Replication architecture
- 35:46Production deployment tips
- 42:44Q&A session
