OpenWorld 2017: The State of the Dolphin & Customer Experiences

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
  • Facebook
  • 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

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s