Session on where MySQL is at and what is coming up.
- MySQL is #1 database for the web
- 2nd most popular behind Oracle (DB Engines is the source for this)
- Most popular according to stack overflow
- MySQL 5.7
- 3x better performance
- replication enhancements
- json
- improved security
- MySQL InnoDB Cluster
- mysql group replication
- mysql router
- mysql shell
- MySQL 8.0
- Data Dictionary
- Roles
- Unicode 9
- CTEs
- Window Functions
- Cloud information about Oracles cloud
- Freudian slip, as the speaker said cloud would make us more expensive (he meant responsive and quickly correct it)
- Oracle cloud machine info
- Has MySQL Cloud service on it
- Booking
- Engineering Updates
- MySQL 8.0
- JSON Document Store
- Improved GIS support
- utf8mb4 is now default
- New collation based on DUCET, Japanese and Russian added
- Improved performance
- MySQL Shell
- Customizable prompt – includes context and session info
- Custom font support
- Persistent command line
- DBA Admin API
- used to set up InnoDB cluster
- Showed how to use syntax to embed json inside SQL Statements
- Common Table Expressions
- Window Functions
- InnoDB Cluster
- Router – Routes client to a server online with the correct role
- Group Replication – “virtually synchronous”
- Better Handling of Hot Row Contention – NOWAIT and SKIP LOCKED
- Invisible Indexes
- Hidden to Optimizer
- For soft delete of index (recycle bin) and staged rollout
- Performance Schema
- Histograms
- Indexes
- Data Lock Instrumentation
- SQL Errors instrumentation
- Variables instrumentation
- Table plugin
- Improved defaults
- over 30x faster
- Transactional Data Dictionary
- Common data dictionary for db and inoodb
- crash-safe & atomic DDL
- meta-data locking for FK constraints
- Scalable Information schema
- Faster Table/Range Scans
- Histograms
- Parallel Replication
- Improved Cost Model
- Resource Groups
- bind operations to cores – i.e updated to a # of cores
- Most application today are mobile first
- MySQL 8.0
moderndba 