MySQL and HeatWave Summit: Sessions
Wednesday, May 1, 2024
Oracle Conference Center, 350 Oracle Parkway, Redwood City, California 94065
Keynote: State of the Dolphin
Wim Coekaerts, Executive Vice President, Software Development, Oracle
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 database and MySQL HeatWave service. He will cover high availability, monitoring, analytics, lakehouse, machine learning, MySQL Autopilot, and support for generative AI, vector store, and multicloud (OCI, AWS, Azure). We will showcase record performance with MySQL HeatWave on a 400 TB lakehouse workload. We will also explore JSON acceleration, native JavaScript support, and MySQL Shell for VSCode.
Building New Applications using HeatWave Generative AI and Vector Store
Nipun Agarwal, Senior Vice President, MySQL HeatWave, Oracle
You will learn HeatWave's new generative AI and vector store capabilities that enable a whole new class of applications that interact with MySQL HeatWave in natural language and efficiently search documents in various file formats in the Object Store. You will also learn how HeatWave supports access to external LLMs from Cohere or Meta, as well as run an in-HeatWave LLM.
From Days to Minutes - Automate Machine Learning in your Enterprise with HeatWave AutoML
Learn how multiple Fortune 1000 companies have used HeatWave AutoML for predictive analytics to solve anomaly detection problems, build recommendation systems and forecasting capabilities . Also learn how HeatWave AutoML is integrated with generative AI and data lakes.
Data Warehouse and Lakehouse Analytics at the Speed of Thought with MySQL HeatWave
Gaurav Chadha, Senior Development Manager, Oracle
Get deeper insights into how MySQL HeatWave provides the best performance in the industry for real-time data warehouse and lakehouse analytics, both for structured and semi-structured (JSON) data. The data can be stored in OCI object storage or AWS S3.
Replace Five Services with One - Using MySQL HeatWave Natively on AWS
Mandy Pang, Senior Principal Product Manager, MySQL HeatWave, Oracle
Learn how you can replace five AWS services with one data processing service - MySQL HeatWave, running natively inside AWS - with better performance, reduced complexity, lower cost, and real-time insights.
100x Acceleration on Analytics and Machine Learning with HeatWave on Transactional Data Outside MySQL databases
Mandy Pang, Senior Principal Product Manager, MySQL HeatWave, Oracle
Hear how customers running Big Query, Redshift, SAP HANA, SQL Server, Aurora, DB2, and other databases have leveraged HeatWave to achieve 100x acceleration on analytics and machine learning processing tasks and lower costs at the same time.
The Present and the Future of MySQL HeatWave
Nipun Agarwal, Senior Vice President, MySQL HeatWave, Oracle
In this session, we will summarize the new capabilities added to MySQL HeatWave and the features expected to be rolled in the near future, including Generative AI, Vector store processing, processing of unstructured data in lakehouse. We will also share the latest benchmarking results for lakehouse, machine learning, and transaction processing with MySQL HeatWave
What’s New in MySQL?
Nipun Agarwal, Senior Vice President, MySQL HeatWave, Oracle
99.99% SLAs with MySQL HA
Nipun Agarwal, Senior Vice President, MySQL HeatWave, Oracle
Luís Soares, Senior Software Development Director, Oracle
Introduction to MySQL HeatWave for OLTP
Sriram Vrinda, MySQL Product Manager Director, Oracle
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.
Managing and Monitoring MySQL: What’s New?
Sriram Vrinda, MySQL Product Management Director, Oracle
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.
Security and Compliance with MySQL
Mike Frank, MySQL Product Management Director, Oracle
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.
Faster Application Development for MySQL
Mike Frank, MySQL Product Management Director, Oracle
Experience the most popular open source database combined with the most popular integrated development environment. MySQL Shell for VSCode integrates MySQL Shell directly into Visual Studio Code—providing an intuitive interface and streamlining day-to-day database development tasks. Learn how to build rich applications with stored procedures and functions in JavaScript executing natively inside MySQL HeatWave. Discover how the MySQL Operator for Kubernetes supports the lifecycle of a high availability MySQL InnoDB cluster inside a Kubernetes cluster. Deploy MySQL REST Service endpoints to securely query and update your MySQL HeatWave tables.
10 Tips for MySQL Performance Tuning
Mike Frank, MySQL Product Management Director, Oracle
Urvashi Oswal, Principal Member of Technical Staff, MySQL HeatWave, Oracle
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.
Keeping Your MySQL Database Safe: Tips and Tricks for Enhancing Security
In this presentation, we will discuss the best practices for securing a MySQL database. We will cover various aspects of MySQL security, including user management, access control, data encryption, and auditing.
We will start by discussing the importance of user management and how to create strong, unique passwords for all users, we will discuss access control and how to use firewalls and network segmentation to limit access to the database. This session cover how to use SSL/TLS to encrypt data in transit and protect against man-in-the-middle attacks.
We will then move on to data encryption and how to use MySQL's built-in encryption features to protect sensitive data at rest. we will discuss auditing and how to use MySQL's auditing features to track user activity and detect suspicious behavior.
We will also cover how to use third-party tools to monitor database activity and receive alerts when anomalies are detected.
By following these best practices, you can help ensure the security and integrity of your MySQL database and protect it from unauthorized access and data breaches.
Converting Data Sets: Prioritizing Uptime and Data Accuracy
Scott Lemaster, Paycom
Scott Rodden, Paycom
As technology has evolved, data needs and defaults have as well. How can you responsibly get your legacy character sets to modern standards? There are multiple strategies on how to achieve based on available architecture and priorities such as uptime, accessibility, or data accuracy. This discussion will focus on those various approaches.
MySQL High Availability and Disaster Recovery
Ravi Kumar Yenugula, INFOLOB
Arun Samayam, American Airlines
This presentation provides comprehensive guidance on establishing a high availability (HA) and disaster recovery (DR) framework within your enterprise, leveraging the robust capabilities of MySQL.
Participants will gain practical insights into building a resilient infrastructure by integrating essential tools such as MySQL Shell, MySQL Router, MySQL Group Replication, MySQL InnoDB Cluster, and ClusterSet.
Key learning points include:
- Understanding the functionalities and advantages of MySQL Shell, Router, Group Replication, InnoDB Cluster, and ClusterSet in ensuring high availability and disaster recovery.
- Practical demonstrations and case studies illustrating the implementation of HA and DR solutions using MySQL tools in real-world scenarios.
- Using MySQL's powerful toolset, participants will be equipped with the knowledge and skills to design, deploy, and maintain a robust high availability and disaster recovery architecture tailored to their enterprise needs.
MySQL at Panasonic - Handling Terabytes of Data in Avionics
Managing vast amounts of data is crucial in the avionics industry, where terabytes of data are generated weekly. MySQL, a powerful and reliable open-source relational database management system, offers essential features for handling such extensive datasets. This presentation explores how MySQL's views and indexes can be leveraged effectively to streamline data management in avionics, providing a cost-effective and efficient solution. We'll also discuss the key benefits of using MySQL over other database systems in the avionics industry.
Deep Dive into MySQL InnoDB
Tomoaki Otsuka, LY Corporation
Understanding InnoDB Redo Log and analyzing how MySQL works. I will explain how MySQL works as disk-based DBMS from InnoDB redo logs with dump tool of InnoDB redo logs.
InnoDB's redo logs contain all updates that MySQL persists to disk for crash recovery. By analyzing redo logs, we can trace how MySQL manages updates during execution of transactions.
I am interested in this log and created a tool to dump InnoDB redo log contents. I will explain the architecture of MySQL and InnoDB that I learned through the process of analyzing redo logs.
MySQL Community Edition at CERN
CERN, the European Organization for Nuclear Research, is where physicists and engineers are probing the fundamental structure of the universe.
In the world's largest particle physics laboratory, the Database-on-Demand service provides an on premise DBaaS for its scientific community.
Among the three different database flavors offered by the service, MySQL Community Edition stands out as the most popular technology within our user community.
During this presentation we will cover how MySQL Community Edition and MySQL InnoDB Cluster integrate within the service that supports more than one thousand database servers.
Crafting the Ultimate Outdoor Adventure Forecast Using MySQL HeatWave
Craig Shallahamer, Viscosity North America
In this presentation, I will share the development journey of my forecasting application, highlighting the use of Oracle technologies and AI to solve a common yet complex problem. You will learn about the technical underpinnings, practical applications, and the broader implications of employing AI for environmental data analysis. You can also download the application code so you can play with the technology. Then we can get outside... and stay dry!
I like to hike with minimal gear, but I don't like to get wet. Living in the Pacific Northwest makes this challenging. Using traditional forecasts, I usually either return home wet or end up carrying worthless gear. What I need is a high precision near-term hyper-local rain forecast. This presentation demonstrates how I built this solution.
I began by leveraging Oracle Cloud Infrastructure (OCI) and Oracle MySQL, utilizing the built-in machine learning capabilities of MySQL Heatwave. This made it easier to integrate weather data from nearby airports and my personal weather station through authenticated APIs. Then I applied a sophisticated Multi-layer Perceptron (MLP) neural network model.
This AI-powered forecast, accessible directly from your smartphone, offers unprecedented precision in rain predictions up to six hours ahead.