The State of the Dolphin
summary
MySQL 8.0 features covered include the Document Store, InnoDB Cluster and a new InnoDB ReplicaSet implementation, with MySQL Router and MySQL Shell used to bootstrap, clone and manage nodes. The talk demonstrates physical cloning as the fastest provisioning method, shows the Shell plugin model for automation, and presents a new write buffer claimed to be about 15× faster plus end-to-end open-source packaging with demos of cloning and automated failover.
AI-written summary · about
chapters (27)
- 0:00Intro
- 0:21Safe Harbor Statement
- 1:33DB-Engines 2020 Database Ranking
- 1:47MySQL is the DBMS of the Year 2019!
- 2:11Happy 25th Anniversary MySQL
- 2:34MySQL 8.0: one giant leap for SQL
- 3:16SQL: RECURSION / CTES
- 3:49SQL: LATERAL
- 4:02SQL: Analytical / Window Functions
- 4:13SQL: JSON_TABLE
- 4:35SQL: JSON_VALUE NEW in 8.0.21
- 5:37MySQL supports JSON & CRUD operations
- 6:25MySQL New Iterator Executor
- 7:42EXPLAIN ANALYZE
- 9:16Hash Join: performance
- 9:59Redo logging can now be enabled and disabled Very useful during initial data load!
- 10:57New Binlog Compression!
- 11:26and of course MySQL Clone
- 12:57SOURCE_CONNECTION_AUTO_FAILOVER With MySQL 8.0.22 there is new asynchronous connection failover mechanism to automatically establish an asynchronous (source to replica) replication connection to a new source after the existing connection from a replica to its source fails.
- 15:17MySQL InnoDB Replicaset
- 17:17MySQL InnoDB Cluster & ReplicaSet - Goals
- 18:11Solutions Easy to Deploy
- 19:38MySQL Database Architecture Summary Single Region
- 20:43MySQL Shell - Extensible
- 22:30MySQL Database Service
- 23:19Terminology Changes We decided to change terminology in our products. From commands, output, manuals, source code and more!
- 26:04Join us on MySQL Community Slack
