MySQL and HeatWave Summit: Sessions
April 22-23, 2025
Oracle Conference Center - Redwood Shores, California
Keynote: State of the Dolphin
Wim Coekaerts, Executive Vice President, Software Development, Oracle
Trends in Data Processing and Innovations in HeatWave
Nipun Agarwal, Senior Vice President, MySQL HeatWave, Oracle
Join us to hear the latest enhancements in HeatWave, including generative AI, machine learning, vector processing, lakehouse, transaction processing, and multicloud capabilities and how enterprises have leveraged them to develop modern data processing applications
Enhancing MySQL Cluster Uptime: Advanced Detection, Mitigation, and Consensus with Group Replication
Primary Promotion is one of the most critical operations being performed in MySQL Clusters. In this presentation, we will look at different techniques we employed in optimizing the primary failover time. We will also look at the deployment model of MySQL Group Replication in the clusters around how we efficiently deploy to withstand outages like failure of an entire zone. We will look at the following topics in detail. Faster Primary Failovers - Detection, Group Replication Deployment and Operations Increased Reliability - Tolerance for AZ failure and not compromising latency. Data Integrity - Mitigating Errant GTID issues. Different Consistency Guarantees. Operational Efficiency.
Build Generative AI Applications Faster with HeatWave GenAI and Vector Store
Nipun Agarwal, Senior Vice President, MySQL HeatWave, Oracle
Explore how HeatWave GenAI is enabling innovative use cases that are reshaping businesses. Discover how HeatWave’s integrated, automated, and secure generative AI capabilities— including in-database large language models (LLMs) and an automated, in-database vector store—can help you rapidly build new GenAI apps without requiring AI expertise, without the hassle of external LLM integration, and without data duplication to a separate vector database.
MySQL Performance for Application Developers
As an application developer, this talk teaches you what MySQL performance really means and how to achieve it. MySQL performance in general is a large and complicated topic, but there is a simple and effective path to learning only what you need to know to get the best performance with MySQL and your application. If you're a developer and new to MySQL, definitely attend this talk because it will save you a lot of time and fast-track your success with MySQL.
Simplicity Meets Innovation - Accelerate Your Machine Learning Journey with HeatWave AutoML
Jayant Sharma, Senior Director, HeatWave Product Management , Oracle
Learn how Fortune 100 companies have used HeatWave AutoML for various purposes, including predictive maintenance, fraud detection, and personalized recommendations—all without needing machine learning expertise and while keeping data secure within the database. Also, explore how HeatWave AutoML offers explanations for its predictions and seamlessly integrates with generative AI, processing data from both Object Store and MySQL.
A 5-Star Upgrade: Users, Reviews, Businesses, and MySQL 8
With MySQL, major version upgrades for large scale environments can feel like navigating a labyrinth of dependencies and unforeseen obstacles. At Yelp, though our upgrade from 5.7 to 8.0 was no exception, we planned and developed solutions that could serve as a roadmap to future migrations. Our database engineers tackled complex problems from: sourcing Change Data Capture (CDC) using Vitess, transitioning from asynchronous to semi-synchronous replication, and adapting to the introduction of TempTable as default memory storage. We found the real treasure lies in the lessons learned and the best practices we developed completing this journey. By sharing our experiences, we aim to empower your team to expedite upgrades safely and efficiently.
Speed of Thought Analytics at Scale with HeatWave Lakehouse
Gaurav Chadha, Senior Development Manager, MySQL & HeatWave Development, Oracle
Learn how HeatWave Lakehouse simplies analytics and provides the best performance and price-performance for 100s of TBs of structured, semi-structured, and unstructured data stored in OCI Object Storage or Amazon S3. Also hear about the upcoming Lakehouse features.
How PlanetScale Offers Unlimited Scaling for MySQL
Deepthi Sigireddi, PlanetScale
Are you bumping up against scaling limitations today or considering how you'll be able to scale your MySQL usage in the future as your needs grow? If so then this talk will be of interest to you. We'll go over what the PlanetScale DBaaS offers for MySQL users and how it's implemented — giving you battle tested and proven models, methods, and solutions that you can apply in your environment.
Leverage HeatWave’s Multicloud Strategy and Replace six Services with One – HeatWave
Mandy Pang, Senior Principal Product Manager, HeatWave, Oracle
Join us to know HeatWave’s Multicloud strategy across OCI, AWS, and Azure. Also learn how you can replace six AWS services with one data processing service - HeatWave, running natively inside AWS – with complete HeatWave capabilities including generative AI, machine learning, real-time analytics, and transaction processing and provides you better performance and reduced complexity at a lower cost.
Innovations in MySQL
Nipun Agarwal, Senior Vice President, MySQL HeatWave, Oracle
Join us to hear how the innovations in MySQL have improved performance, availability, security, observability and enriched developer experience of applications built on MySQL. Learn about the latest enhancements in optimizer, InnoDB, group replication, MySQL Shell.
In-depth MySQL Monitoring: From Metrics to Insights
Sriram Vrinda, Senior Director, MySQL Product Management, Oracle
Desiree Abrokwa, Product Manager, Observability and Management, Oracle
Effective monitoring is essential for maintaining the performance, stability, and security of your MySQL database on-premises or in the cloud. In this session, we’ll explore the key metrics to track in MySQL and share best practices for monitoring, troubleshooting, and ensuring optimal performance. Dive into critical performance areas, including CPU utilization, memory usage, disk I/O, and query performance, while learning how to identify and resolve common issues like slow queries and unused indexes. Additionally, we’ll introduce solutions for long-term analysis by leveraging Oracle Cloud observability tools such as Ops Insights to identify trends and make data-driven optimizations. By the end of this session, you’ll have a comprehensive strategy to effectively monitor, maintain, and enhance the health of your MySQL database over time.
MySQL Indexes and Histograms – How They Speed Up Your Queries
Frederic Descamps, MySQL Community Manager, Oracle
MySQL, the most popular Open Source Database, is easy to use. Designing tables that aren't optimal and executing inefficient queries is surprisingly easy. Optimize your queries by using indexes and histograms. Join this session to learn how to create effective indexes and histograms for improved query performance.
You will discover how to display and analyze the Query Execution Plan of your queries, allowing you to identify which ones require optimization. This session includes various queries and examples designed to help you understand workload management and the best practices for designing indexes.
Building AI-Powered MySQL Database Applications: A Developer's Fast Track to Production
Craig Shallahamer, Viscocity North America
Ever felt overwhelmed by the complexity of integrating LLMs with database applications? Join me as I demonstrate building a fully functional desktop web application that connects to on-premises MySQL and Oracle Gen AI Services in just 20 minutes. Through live coding, I'll show you how a well-structured API and carefully crafted LLM prompts can dramatically accelerate development time. This isn't just about rapid prototyping – it's about revolutionizing how we approach database-driven AI applications. Whether you're a seasoned DBA or a MySQL developer exploring AI integration, you'll walk away with practical insights to transform your development workflow.
Discover the Power of HeatWave with Simplified App Development and Enhanced Security
Mandy Pang, Senior Principal Product Manager, HeatWave, Oracle
Hear how customers running Big Query, Redshift, SQL Server, Teradata, Aurora, and other databases have leveraged HeatWave to achieve operational efficiency and accelerate innovation. Also learn how HeatWave implements additional security measures to protect data throughout its lifecycle and help comply with regulatory requirements.
Scaling MySQL for the Future: How ProxySQL Powers High-Performance Architectures
Modern MySQL deployments must handle massive concurrency, minimize query latency, and optimize backend resources—challenges that ProxySQL is designed to solve. This session will dive into scaling strategies using ProxySQL, covering connection pooling, query caching, load balancing, and failover automation. We’ll discuss how companies use ProxySQL to offload MySQL servers, improve replication performance, and ensure HA.
Enhance Your Business Continuity with New High Availability Features for MySQL Enterprise Edition
Luís Soares, Senior Software Development Director, Oracle
Group Replication is a critical component of many High Availability solutions using MySQL, including the MySQL HeatWave Service. This mature technology serves as the foundation of popular turnkey solutions like InnoDB Cluster and Cluster Sets.
High Availability is complex, requiring coordination of multiple components. Observability and ease of operation are essential. To address this, new MySQL Enterprise Edition enhancements improve Group Replication observability and introduce automation that reduces operational overhead, simplifying cluster management.
This session explores the evolution of Group Replication, highlighting the latest MySQL Enterprise Edition enhancements. Together with important tools, such as MySQL Enterprise Backup, they provide users a compelling business continuity framework. Join our engineers to discover powerful MySQL features and tools that allow building a resilient database infrastructure.<
Effortless Business Continuity with HeatWave MySQL
Luís Soares, Senior Software Development Director, Oracle
Oracle Cloud offers the HeatWave MySQL Service built on top of the most advanced MySQL and OCI technology. Battle-tested, and always adjusting and improving, the HeatWave MySQL technology continuously evolves to meet scalability and business continuity requirements. MySQL Replication is at the core of the service as it is the foundation to build High Availability, Inbound Replication, Outbound Replication, Disaster Recovery, Point-in-time restore, Read Scaleout, and more. Moreover, the service deploys the most advanced enterprise extensions (EE), gives access to the ever enticing and feature rich HeatWave ecosystem, while safekeeping data with an advanced backup framework. This makes it a great fit for all types of demanding and business critical workloads.
This session presents the latest and greatest replication, high availability and backup features. You will learn how replication and its derivatives are used in the service and how it brings different components together to deliver advanced and compelling functionality. Come and join us on a lively conversation into all things replication and high availability in HeatWave MySQL.
The Next Generation Optimizer in MySQL
Norvald Ryeng, Software Development Director, Oracle
After 30 years, MySQL has redesigned its query optimizer. This is a huge undertaking that has been in development for many years, and it solves long-standing issues with query planning in MySQL. In this session, you will learn more about why a new optimizer was necessary, how it works, what it means for you, how you can start using it today, and why you should.
Hidden Gems in MySQL Shell
Scott Stroz, MySQL Developer Advocate, Oracle
MySQL Shell is a modern CLI for connecting to, and interacting with, MySQL Instances. But there is so much more!! In this session we will demonstrate some of the cooler, but lesser known, features of MySQL Shell. These features include but are not limited to creating sandbox instances for testing, managing MySQL replication, and dumping data to (and loading data from) a cloud storage bucket.
Turbocharge your MySQL with Readyset - Faster Queries, Lower Costs
Experienced database professionals are well aware that transactional workloads frequently exhibit a Zipfian distribution, where a small number of queries dominate database resource consumption. However, most modern scaling solutions rely on broad, indiscriminate approaches—such as adding infrastructure or implementing complex, high-maintenance fixes. This presentation highlights query caching as a targeted, cost-effective alternative that can significantly enhance infrastructure efficiency with minimal engineering effort. If you're seeking a smarter, more streamlined approach to scaling, query caching could be the game-changing solution you've been searching for. Join us as we explore Readyset, the result of a decade of research from MIT resulting in a solution that seamlessly addresses these challenges through the integration of Data Flow Graphs, Partial Materialized Views, and Replication, while implementing the wire protocol of MySQL, requiring zero code changes.
Predictive Asset Maintenance using MySQL Heatwave Lakehouse
Bhushan Arora, Principal Cloud Architect, Oracle
Learn how MySQL HeatWave on OCI enables a modern data platform to handle streaming and batch data for enterprise reporting. This session explores an end-to-end predictive maintenance (PdM) use case, leveraging real-time sensor data to forecast equipment failures and optimize asset management.
MySQL for the Modern Developer
Mike Frank, Director, MySQL Product Management, Oracle
Scott Stroz, MySQL Developer Advocate, Oracle
MySQL is an optimized and highly scalable database system which provides best in class tools for password-less authentication, JSON-based REST APIs and MySQL Connectors to easily deploy progressive web apps (PWAs). With Multilingual Engine Component, users can execute complex data manipulation logic directly within the database using a more flexible programming language than standard SQL. This is especially useful for analytic dashboard development and custom data processing.
The go-mysql library as a Swiss Army Knife
The go-mysql library is a Go library that has: a high level MySQL client, a low level MySQL client, the ability to read a replication stream (binlogs) and the ability to implement the server side of the MySQL protocol. This session as demonstrations on all of these.
Modernize your relational database with HeatWave MySQL
Sriram Vrinda, Senior Director, MySQL Product Management, Oracle
Join us for an engaging session that explores the architecture of HeatWave MySQL, a fully managed database service designed for high-performance web, ecommerce, and OLTP applications. Discover how to easily set up and configure your database, from provisioning instances to implementing effective backup and restore strategies. Learn the steps to transition from a single instance to a high-availability cluster and scale your workloads seamlessly with read replicas. Finally, gain insights into managing automatic upgrades and patching, ensuring your database remains secure, efficient, and always up to date.
Routing Guidelines – Smarter Query Routing for InnoDB Cluster
Alfredo Kojima, Software Development Director, Oracle
This session provides an overview of the Routing Guidelines feature in MySQL InnoDB Cluster, designed to further enhance operations of MySQL topologies for High Availability, Disaster Recovery, and Read Scaling. Attendees will be introduced to the concept of custom routing rules in MySQL Router, which allow for tailored responses during failovers and optimized resource utilization during normal operations. The session will describe the key features of Routing Guidelines, including how to distribute application load based on criteria such as host addresses, MySQL usernames, schemas, session attributes and more.
Lessons Learned in Switching MySQL Monitoring from MySQL Enterprise Monitor to Oracle Enterprise Manager
Krishna Mamillapalli, Datavail
With MySQL Enterprise Monitor (MEM) being EOL in 2024, most enterprise MySQL customers are moving to Oracle Enterprise Manager (OEM) for monitoring their enterprise MySQL systems. In this session, you'll learn about the features of OEM for MySQL, the steps involved in migrating from MEM to OEM, and the best practices of this process.
Unlocking Database Freedom: Migration from Microsoft SQL Server to MySQL Using GenAI Services
Henrique Leandro, Director, MySQL Solution Engineering, Oracle
Migrating your database from Microsoft SQL Server to MySQL can seem complex, but with the right approach and tools, it can be a smooth and efficient process.
In this session, we will walk you through the best practices for migration, including necessary changes in database, considerations for data types, and leveraging the powerful new features of MySQL Enterprise Edition, like Vector Datatype support.
We’ll cover how to use Visual Studio Code and Oracle Code Assist (Generative AI services) as your Migration Assistant.
By the end of this session, you'll be equipped to handle the migration with confidence and understand the significant benefits of using MySQL Enterprise Edition to reduce cost and improve security while achieving best performance.
RIP mysql_native_password
After decades being the default authentication method for user access to a MySQL database, this method is no longer available in the latest version of MySQL, and has been deprecated and disabled in prior versions. In this presentation I will be discussing: * The history behind this plugin * Why is this plugin insecure * What alternative authentication options exist * How to migrate seamlessly to the current default * New authentication features in upcoming community and enterprise versions.
Achieving Best Performance with MySQL
Seema Sundara, Architect, Oracle
Learn about some of the new features such as bulk load, a new cost based optimizer etc. that improve the performance of data load and query execution in MySQL. In this session we will share the latest performance numbers for load and query execution across different workloads and share some insights into achieving optimal performance
MySQL on IaaS for Mission-Critical Cloud Applications and Multi-Cloud Strategies
Benjamin Wood, MySQL Master Solution Engineer, Oracle
Modern applications demand high availability, performance, and security—and organizations are increasingly turning to multi-cloud strategies to meet these needs. Learn how customers achieve these objectives by running MySQL on Infrastructure as a Service (IaaS).
In this session, we will explore technical best practices for deploying and managing MySQL, reinforced by real-world case studies. You’ll learn how organizations successfully navigate multi-cloud/hybrid architectures, optimize for scalability and security, and ensure business continuity with MySQL.
Key takeaways:
- Actionable insights on how MySQL on IaaS enables customers to meet high-end performance, availability, and security requirements.
- How MySQL on IaaS enables multi-cloud and hybrid deployments with applications that span different clouds and workload portability between clouds.
The Wherever PC to Anywhere with Oracle Enterprise Solutions
Pinkbyte/Mazzzing.com is a Toronto-based start-up which has developed a low-cost solution allowing users with limited resources to access a private desktop from smart TVs, gaming consoles, Chromebooks, and practically any device that connects to the internet. Starting at 5 US Dollars per month, Mazzzing’s Cluo application opens doors to online shopping, programs such as MS Office and Adobe Creative Suite and equips subscribers with the opportunity to install personal apps on their account. Mazzzing’s private desktop solution promises to leave no history, files, or any other traces on user devices, thus guaranteeing users online security in a cyber world plagued by malware and viruses.
Hands-on Lab (HOL) - MySQL Monitoring and Observability: What's New and Best Practices
Effective monitoring and observability of a MySQL database is critical to ensuring its performance, stability, and security. In this session, you'll learn about what’s new, key metrics to monitor in MySQL and best practices for observability 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.
Tools:
- OCI Database Management, Ops Insights, Logging Analytics and Application Performance Monitoring
- Enterprise Manager Plug-in for MySQL
Attendees will be able to pick and choose from the following topics:
- Observability & Management for Cloud (HeatWave)
- Observability & Management for On-premises MySQL
- Oracle Enterprise Manager for On-premises MySQL