MySQL Summit 2023 is right around the corner. If you consider yourself a *true* fan of the Dolphin, but haven’t made plans to attend this free event either in-person (Redwood Shores, CA) or online, you’ll be missing out on a critical chance to hone your MySQL skills by learning best practices directly from MySQL engineers. Seeking MySQL tips and tricks across on-premises and the cloud? We’ve got you covered. Looking to ask a MySQL expert about your most complex technical questions? MySQL Summit is the perfect forum to do just that.   

Take advantage of this unique, no-cost opportunity to spend a day with the MySQL engineering team, community experts, and customers:

• Try a hands-on-lab during lunch, or mingle with peers over a beer at happy hour.
• Grab some MySQL swag, and stay to hear the latest MySQL product announcements.
• Chat with MySQL engineers during coffee breaks to troubleshoot your current MySQL projects.
• Learn how application developers use Java, PHP, Python, Ruby, Go, Rust, and node.js for MySQL.
• MySQL experts will also share the latest innovations, best practices, tips and tricks, across on-premises and the cloud.
• Gain real-world tips and strategies on the following topics: developing MySQL applications, database performance tuning, high availability, security, cloud, MySQL HeatWave Analytics, HeatWave AutoML, HeatWave Lakehouse, and more.

Whether you’re a developer, DBA, data architect, data scientist, data analyst, or other database user, we have sessions for you – take a look.

MySQL Summit schedule:

10:00 AM - 10:50 AM

State of the Dolphin

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.

11:00 AM - 11:25 AM

Accelerate Web, Ecommerce, and OLTP Applications with MySQL HeatWave

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.

11:35 AM - 12:00 PM

A MySQL HeatWave Overview for Every Developer

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

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.

12:15 PM - 12:55 PM: LUNCH (provided) and Hands-on Labs!

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

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.

Hands-On Lab: Develop OLTP Applications with MySQL HeatWave

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.

1:00 PM - 1:25 PM

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

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.

Introduction to the New MySQL Management Service

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.

1:35 PM - 2:00 PM

Query Processing on an Object Store with MySQL HeatWave

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

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.

2:10 PM - 2:35 PM

Building Secure Applications with MySQL Enterprise Edition

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.

2:50 PM - 3:15 PM

Developing Applications with MySQL HeatWave Natively in AWS

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

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.

3:25 PM - 3:50 PM

MySQL Autopilot: Automating Application Development with MySQL HeatWave

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.

4:00 PM - 4:25 PM

Deep Dive for Machine Learning Development with MySQL HeatWave

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

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.

4:25 PM - 5:25 PM: HAPPY HOUR