MySQL Keynote at Oracle Open World 2016

Tomas Ulin made a number of key announcements at this year’s State of the Dolphin and Customer Experiences keynote. MySQL Public Cloud, MySQL 8.0 DMR, MySQL InnoDB Cluster, MySQL Group Replication (RC). Some tweets and points of the keynote:

• #MySQL announces the Oracle MySQL Cloud service at #oow16 http://cloud.oracle.com/mysql offering 5.7 enterprise edition, on demand or per month.

• Tomas Ulin, VP of #MySQL engineering talks database security for modern applications. #oow16

• Yeah! #MySQL 8.0 has native data dictionary. Removes myisam requirement. Large I_S performance improvements. #oow16

• #MySQL 8.0 has greatly improved #performance_schema query execution with support for indexes (zero overhead). #oow16

• #MySQL 5.7 GA now introduces new features via plugins like document store, group replication (RC) #oow16

• #MySQL VP @tomasulin announces MySQL InnoDB Cluster. Deploys in under < 15 mins. Performance results scales to 9 nodes. #oow16

• MySQL as a hybrid database: Rock solid reliability + flexibility being a RDBMS and a NoSQL Solution

• MySQL Enterprise Edition security covering authentication, encryption, firewall, auditing, backup and monitoring.

  • MySQL Cluster 7.5 announcement, 128TB nodes, MySQL 5.7 features including JSON, generated columns.
  • 20 years of constant improvements of MySQL as a relational database.
  • MySQL is the #1 open source database for web-based applications. Used by 9 of the top 10 web sites.
  There were also user stories by Nicolai Plum – Senior Systems Architect at Booking.com and Andrew Archibald – VP of Development at Churchill Downs.

Nicolai talked about how booking has evolved over the years starting with the traditional MySQL replication model, moving to a more complex sharded and partitioned architecture, and now a re-architecture towards a loosely coupled, write optimized and read optimized data model leveraging Redis queues. This work has enabled services to hide the complexity and need for developers to write SQL and leverage better data translation and interoperability, e.g. MySQL to Hadoop to MySQL. Booking.com is actively using MySQL 5.7, and is evaluating how to incorporate the new features of MySQL 8.0.

Andrew talked about how twinspires.com uses a multi data center master-master replication setup with MySQL 5.6 to manage critical availability needs for online wagering of horse races around the world. During peak times, load can increase 100x, similar to my own experiences handling 100x flash sales Improving performance – A full stack problem .

I have yet to discover how to deep link to this presentation at the OOW 2016 agenda to enable viewers to read the overview and speaker profiles.