MySQL Summit

Thursday, March 23
Oracle Campus - Redwood Shores, California

Time Room 1 Room 2
09:00am Welcome
10:00-10:50am Keynote: State of the Dolphin
Video
11:00-11:25am Booking.com: Reliable Operations and Rapid Development with MySQL
Video | Slides
Accelerate Web, Ecommerce, and OLTP Applications with MySQL HeatWave
Video | Slides
11:35-12:00pm A MySQL HeatWave Overview for Every Developer
Video | Slides
MySQL High Availability and Disaster Recovery
Video | Slides
12:00-1:00pm Lunch
12:15-12:55pm Hands on Lab: Develop OLTP Applications with MySQL HeatWave Hands on Lab: Accelerating SQL Applications and Developing Machine Learning and Data Lake Applications with MySQL HeatWave
1:00-1:25pm Introduction to the New MySQL Management Service
Video | Slides
Application Development with MySQL HeatWave Using Oracle Analytics Cloud, APEX, OCI GoldenGate, and Notebooks
Video | Slides
1:35-2:00pm Query Processing on an Object Store with MySQL HeatWave
Video | Slides
Introduction to MySQL Operator for Kubernetes
Video | Slides
2:10-2:35pm Tetris.co: Accelerating Real-time Marketing Insights at Half the Cost with MySQL HeatWave
Video | Slides
Building Secure Applications with MySQL Enterprise Edition
Video | Slides
2:35-2:50pm Afternoon Break
2:50-3:15pm Developing Applications with MySQL HeatWave Natively in AWS
Video | Slides
Introduction to MySQL Shell for Visual Studio Code
Video | Slides
3:25-3:50pm JSON Data Improvements in MySQL 8.0
Video | Slides
MySQL Autopilot: Automating Application Development with MySQL HeatWave
Video | Slides
4:00-4:25pm Deep Dive for Machine Learning Development with MySQL HeatWave
Video | Slides
10 Tips for MySQL Performance Tuning
Video | Slides
4:25-5:25pm Reception / Happy Hour

Keynote: State of the Dolphin

Wim Coekaerts, Executive Vice President, Software Development

Join Wim Coekaerts, executive vice president of software development at Oracle, to learn about the latest MySQL innovations in the cloud and on premises. Wim will showcase recent enhancements in MySQL, MySQL database service, and MySQL HeatWave including high availability, analytics, machine learning, MySQL Autopilot, and record performance with MySQL HeatWave on a 400 TB lakehouse workload. The keynote will highlight new productivity tools for developers such as VSCode and announce new capabilities for performance monitoring, machine learning, and MySQL HeatWave service on AWS.

Reliable Operations and Rapid Development with MySQL

Nicolai Plum, Booking.com

Businesses demand high reliability from their databases as well as rapid software development. Uptime comes not only from "avoiding crashes" but also "avoiding maintenance windows". This talk will tell you ways to achieve high reliability and how to make database changes easily without downtime. We will cover multi-region Group Replication with scale-out replicas, automatic failure handling, and operations best practices. For software developers and architects we will cover best practices and tools for designing and changing your database schema easily and without downtime.

Accelerate Web, Ecommerce, and OLTP Applications with MySQL HeatWave

Airton Lastori, MySQL Senior Principal Product Manager

In this session, MySQL experts will walk you through the architecture of the fully-managed MySQL HeatWave database service for web, ecommerce, and OLTP applications. First, we'll review initial configuration and setup, provisioning instances, and backup and restore. Then, you'll see the simple path for moving from a single instance to a high-availability database cluster. We'll also show you how to add read replicas for increased scalability. Finally, we'll discuss how to best manage automatic upgrades and patching.

A MySQL HeatWave Overview for Every Developer

Nipun Agarwal, Senior Vice President, MySQL HeatWave Development

In this session, you'll learn how MySQL HeatWave provides a single database service for transaction processing, analytics, machine learning, and data lake applications. It eliminates the complexity of ETL operations and existing MySQL applications run without any changes. MySQL HeatWave provides the best price-performance among competing offerings and is offered on multiple clouds.

MySQL High Availability and Disaster Recovery

Kenny Gryp, MySQL Product Management Director

Together, InnoDB Cluster and InnoDB ClusterSet provide a complete solution for high availability and disaster recovery for MySQL. In this session, you'll start by learning how MySQL InnoDB Cluster provides high availability with built-in group membership management, data consistency guarantees, node failure detection, and database failover — all without the need for manual intervention. You'll also learn about MySQL InnoDB ClusterSet for disaster tolerance across different regional data centers.

Hands on Lab: Develop OLTP Applications with MySQL HeatWave

Airton Lastori, MySQL Senior Principal Product Manager

In this hands-on lab, you'll learn to build OLTP web applications with MySQL HeatWave. You'll learn how to do the initial configuration and setup, backup and restore, replication, and high availability. You'll also learn to manage automatic upgrades and patching. Attendees must bring their own laptop to participate. This hands-on lab is only available to in-person attendees.

Hands on Lab: Accelerating SQL Applications and Developing Machine Learning and Data Lake Applications with MySQL HeatWave

Mandy Pang, Senior Principal Product Manager

In this hands-on lab, you'll learn how to create, configure, and accelerate SQL applications with MySQL HeatWave by an order of magnitude. You'll build machine learning models easily and with good accuracy. We will also show a demo of how MySQL HeatWave can efficiently analyze hundreds of terabytes of data in a variety of file formats stored in the object store. Attendees must bring their own laptop to participate. This hands-on lab is only available to in-person attendees.

Introduction to the New MySQL Management Service

GP Gongloor, Vice President
Sriram Vrinda, Product Management

Effective monitoring of a MySQL database is critical to ensuring its performance, stability, and security. In this session, you'll learn about key metrics to monitor in MySQL and best practices for monitoring and troubleshooting. We'll explore the various aspects of MySQL performance, such as CPU utilization, memory usage, disk I/O, and query performance. You'll also learn how to identify and diagnose common performance issues in MySQL, such as slow queries, unused indexes, and more. By the end of this session, you'll have a comprehensive understanding of how to effectively monitor and maintain the health of your MySQL database in Oracle Cloud Infrastructure.

Application Development with MySQL HeatWave Using Oracle Analytics Cloud, APEX, OCI GoldenGate, and Notebooks

Salil Pradhan, Principal Product Manager

In this session, you'll learn how to build MySQL HeatWave applications using Oracle Application Express (APEX), integrate data from heterogenous data sources using Oracle Cloud Infrastructure (OCI) GoldenGate, and derive real-time insights using Oracle Analytics Cloud. Build machine learning applications using Jupyter and Zeppelin Notebooks with HeatWave AutoML.

Query Processing on an Object Store with MySQL HeatWave

Nipun Agarwal, Senior Vice President, MySQL HeatWave Development

Have you heard? A newly introduced capability in MySQL HeatWave enables processing hundreds of terabytes of data in object store in a variety of file formats. Learn how this capability enables developers to write applications that can access data in a database and the object store with a single service. We'll share performance benchmarks for a 400 TB workload comparing both the load and query performance with other services.

Introduction to MySQL Operator for Kubernetes

Kenny Gryp, MySQL Product Management Director

Discover how the MySQL Operator for Kubernetes supports the lifecycle of a high availability MySQL InnoDB cluster inside a Kubernetes cluster. Learn about Kubernetes concepts including pods, StatefulSets, and Sidecars. Understand how Kubernetes works and how the MySQL Operator integrates with it, so you can get the most value out of a cloud native architecture. We'll help you simplify the deployment of MySQL Server and MySQL Router instances, including management of TLS certificates and replication setup. You'll see how to use Kubernetes and MySQL for high availability, automatic rolling upgrades, and built-in backup and recovery.

Accelerating Real-time Marketing Insights at Half the Cost with MySQL HeatWave

Pablo Lemos, Tetris.co

After evaluating Google BigQuery and AWS Redshift, Tetris.co migrated from AWS Aurora to MySQL HeatWave on Oracle Cloud Infrastructure (OCI) to dramatically accelerate analytical queries and reduce costs. HeatWave easily enables Tetris.co staff to run OLTP and OLAP workloads directly from a MySQL database, eliminating the need for data movement and integration with a separate analytics database. During this session we will explore the lessons learned during this project, as well as share some of key technical architecture points to consider when pursing a migration to Oracle Cloud Infrastructure. We will also have a vision of how Tetris.co is implementing new Heatwave ML features.

Building Secure Applications with MySQL Enterprise Edition

Mike Frank, MySQL Product Management Director

Data protection and regulatory compliance are a critical necessity for all organizations. MySQL Enterprise Edition provides the advanced security features to help you secure your data to meet industry and government regulations, including General Data Protection Regulation (GDPR), Payment Card Industry Data Security Standard (PCI DSS), Health Insurance Portability and Accountability Act (HIPAA), and Defense Information Systems Agency Security Technical Implementation Guide (DISA STIG). Learn to build secure applications with security architecture, identity management, authentication, auditing, key management, data masking, database firewall, and security hardening guidelines in MySQL.

Developing Applications with MySQL HeatWave Natively in AWS

Mandy Pang, Senior Principal Product Manager

Learn how to build database applications on AWS with a single MySQL HeatWave service (instead of multiple services), without data egress charges, and at an unmatched price-performance. Explore the interactive console that facilitates development of database and machine learning applications.

Introduction to MySQL Shell for Visual Studio Code

Kenny Gryp, MySQL Product Management Director

Experience the ease of use and power of the world's most popular open source database combined with the world's most popular integrated development environment. Learn how MySQL Shell for Visual Studio Code (VS Code) makes it easy to connect to the database from VS Code, check server status, import and export data, run your queries, and much more. After this session, you'll be ready to leverage the power of the MySQL HeatWave Database Service through the easy-to-use interface of MySQL Shell for VS Code.

JSON Data Improvements in MySQL 8.0

Dave Stokes, Percona

The JSON data type was introduced in MySQL 5.7 and was dramatically improved in version 8.0. Chief among these changes was the introduction of JSON_TABLE(), which temporarily transforms JSON data into structured data for processing with SQL commands such as window functions. And you also gain the ability to test JSON data for required fields, range checks, and data type checks to ensure that bad data does not make it into your database instance. These and other MySQL 8.,0 JSON features will be covered in this session.

MySQL Autopilot: Automating Application Development with MySQL HeatWave

Nipun Agarwal, Senior Vice President, MySQL HeatWave Development

MySQL HeatWave offers a unique workload-aware, machine-learning–based way to automate various aspects of the application life cycle including provisioning, data management, query processing, and failure handling. These capabilities have been developed for supporting analytics, OLTP, and data lake applications, and they improve the performance of the system over time. Join this session to learn about these differentiated capabilities.

Deep Dive for Machine Learning Development with MySQL HeatWave

Sandeep Agrawal, Consulting Principal Member of Technical Staff

Discover how to write machine learning (ML) applications to train, predict, and explain models with the fully automated, in-database ML capabilities of MySQL HeatWave. Hear our experts discuss the fully automated ML lifecycle and the superior performance of training and models that never leave the database. Explore the HeatWave console capabilities for interactive and intuitive application development.

10 Tips for MySQL Performance Tuning

Mike Frank, MySQL Product Management Director

Do you want to deliver blazing fast MySQL applications? Are you developing new mission-critical applications for MySQL? Are you experiencing performance bottlenecks in your production MySQL applications? Can you identify and tune slow queries? Do you want to eliminate common mistakes? Led by MySQL experts, this session will address these questions with practical tips and best practices for troubleshooting and performance tuning MySQL.