Major features & latest MySQL innovations (2023)

Discover the latest 🐬 MySQL technological advances that will improve your productivity and help you enhance your data 💪

Transcript

1. Major features & latest MySQL innovations
   A summary of what you need to know about MySQL
   Olivier Dasini
   MySQL Cloud Principal Solutions Architect EMEA
   olivier.dasini@oracle.com
   Blogs : www.dasini.net/blog/en
   : www.dasini.net/blog/fr
   Linkedin: www.linkedin.com/in/olivier-dasini
   Twitter : @freshdaz
   May 25, 2023
   

   View Slide

2. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
   2
   Me, Myself & I
   
   MySQL Geek
    Addicted to MySQL for 15+ years
    Playing with databases for 20+ years
   
   MySQL Writer, Blogger and Speaker
    Also: DBA, Consultant, Architect, Trainer, ...
   
   MySQL Cloud Principal Solutions Architect EMEA at Oracle
   
   Stay up to date!
    Blog: www.dasini.net/blog/en
    Linkedin: www.linkedin.com/in/olivier-dasini/
    Twitter: @freshdaz
   Olivier DASINI
   

   View Slide

3. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
   Agenda
   1. MySQL – A short review
   2. High Availability & Security
   3. Developer Productivity
   4. Analytics, Machine Learning, Autopilot
   5. Lakehouse: Processing on Object Store
   6. Management & Observability
   7. Multi Cloud
   3
   

   View Slide

4. MySQL – A short review
   Copyright © 2023, Oracle and/or its affiliates
   

   View Slide

5. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
   5
   The evolution of MySQL over the past decade
   • Refactoring
   • Modularizing
   • Adding interfaces
   • Adding functionality as plugins
   • Remove functionality from core, e.g. Query cache
   • Transactional storage engines (InnoDB)
   • UTF8
   • Modernizing the tool chain
   • and much more...
   MySQL has been an Oracle Global Business Unit since 2010
   MySQL has been an Oracle Global Business Unit since 2010
   https://archive.fosdem.org/2020/schedule/event/mysql8
   

   View Slide

6. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
   6
   Innovative organizations run their business on MySQL
   Social E-Commerce SaaS Finance Manufacturing
   

   View Slide

7. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
   7
   MySQL powers Open Source applications
   Custom Apps
   Development
   Content management
   and eCommerce
   Learning platforms
   

   View Slide

8. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
   8
   The MySQL universe - The view from the moon…
   MySQL Commercial/Enterprise
   MySQL Community +
   MySQL Enterprise Backup
   MySQL Enterprise Monitor
   MySQL Enterprise Authentication
   MySQL Enterprise Audit
   MySQL Enterprise TDE
   MySQL Enterprise Masking
   MySQL Enterprise Firewall
   MySQL Technical Support
   …
   MySQL Cluster CGE
   MySQL Cluster NDB + MySQL Enterprise +
   MySQL Cluster Manager
   MySQL Community
   MySQL Server
   MySQL Client, Workbench
   MySQL Shell
   MySQL GR plugin & InnoDB Cluster & Router
   MySQL Operator for Kubernetes
   MySQL Connector (C API, Java, Node.js, others)
   MySQL Support for MS VS Code (Preview)
   …
   MySQL Cluster NDB
   MySQL NDB Storage Engine
   MySQL NDB Operator for Kubernetes
   MySQL Cloud Services
   MySQL HeatWave Databases Services (for OLTP)
   MySQL HeatWave (for Analytics)
   MySQL HeatWave AutoML
   MySQL HeatWave on AWS
   MySQL HeatWave on Azure
   MySQL HeatWave Lakehouse (Preview)
   Community, Enterprise, Cloud Service (HeatWave)
   Community, Enterprise, Cloud Service (HeatWave)
   https://www.mysql.com/products
   

   View Slide

9. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
   9
   MySQL Enterprise Edition
   Data protection and regulatory compliance
   Data protection and regulatory compliance
   MySQL Enterprise
   Masking
   De-identify,
   Anonymize Sensitive
   Data
   MySQL Enterprise
   Firewall
   Block SQL Injection
   Attacks, Intrusion
   Detection
   MySQL Enterprise
   TDE
   AES 256 encryption,
   Key Management
   MySQL Enterprise
   Audit
   User Activity Auditing,
   Regulatory
   Compliance
   MySQL Enterprise
   Authentication
   External
   Authentication
   Modules
   MySQL Enterprise
   Monitor
   Monitor Changes in Database
   Configurations, User
   Permissions, Database
   Schema, Passwords
   MySQL Enterprise
   Encryption
   Public/Private Key
   Cryptography,
   Asymmetric Encryption
   MySQL Enterprise
   Backup
   Secure Backups, AES
   256 encryption
   

   View Slide

10. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
    10
    Areas of innovation
    High Availability & Security
    Developer Productivity
    Analytics, Machine Learning, Autopilot
    Lakehouse: Processing on Object Store
    Management & Observability
    Multi Cloud
    

    View Slide

11. High Availability & Security
    Copyright © 2023, Oracle and/or its affiliates
    

    View Slide

12. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
    12
    MySQL InnoDB Cluster: Group Replication, Router & Shell
    MySQL InnoDB Cluster
    • MySQL Group Replication: Automatic membership
    changes, network partition handling, consistency...
    • MySQL Shell Configuring, Adding, Removing members
    • MySQL Router to route application traffic
    • InnoDB CLONE to automatically provision members, fully
    integrated in InnoDB
    • RPO = 0
    • RTO = seconds
    A complete High Availability solution for MySQL
    A complete High Availability solution for MySQL
    

    View Slide

13. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
    13
    MySQL InnoDB ClusterSet
    .High Availability (Failure Within a Region)
    • RPO = 0
    • RTO = seconds (automatic failover)
    Disaster Recovery (Region Failure)
    • RPO != 0
    • RTO = minutes or more (manual failover)
    • No write performance impact
    Features
    • Easy to use
    • Familiar interface and usability mysqlsh,
    CLONE, ...
    • Add/remove nodes/clusters online
    • Router integration, no need to reconfigure
    application if the topology changes
    Disaster tolerance for InnoDB Cluster deployments
    Disaster tolerance for InnoDB Cluster deployments
    

    View Slide

14. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
    14
    MySQL InnoDB ReplicaSet
    Administer a set of instances running replication
    Administer a set of instances running replication
    • Think “asynchronous Replication”
    • Asynchronous Replication Architecture
    • RPO = ! 0 / RTO = minutes
     Read Scaleout
     Simple Replication architecture
    • Operations based on the idea of MySQL InnoDB Cluster
    • MySQL Shell Configuring, Adding, Removing members
    • CLONE Plugin used to automatically provision members,
    • Fully integrated MySQL Router to route application traffic
    

    View Slide

15. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
    15
    Latest authentication methods
    • MySQL Enterprise Edition extend Community Authentication and provides ready to use
    external authentication modules to easily integrate existing security
    • Supports Linux PAM, Windows Active Directory, native LDAP…
    • MySQL 8.0 now support
    • Kerberos
     Authentication using Kerberos requires a KDC server
     Applications and MySQL servers are able to mutually authenticate users and MySQL services
    • FIDO (Fast IDentity Online)
     Enables authentication to MySQL Server using devices such as smart cards, security keys, and biometric readers
     Because authentication can occur other than by providing a password, FIDO enables password less authentication
     Device authentication is often used in conjunction with password authentication
    

    View Slide

16. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
    16
    Multifactor Authentication (MFA)
    • New system variable – authentication_policy
    • Controls how many authentication factors can be used and types of authentication permitted for each factor
    • Specify MFA using CREATE USER and ALTER USER
    • Add/Modify/Drop authentication methods for new/existing accounts
    • New authentication factors stored in mysql.user table in USER_ATTRIBUTES column
    • Accounts can now have up to three authentication values
    • Client programs have now --password1, --password2, and --password3 options
    

    View Slide

17. Developer Productivity
    Copyright © 2023, Oracle and/or its affiliates
    

    View Slide

18. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
    18
    MySQL Long-Term Support (LTS) Releases
    • stable: bugfix & security patches only
    • backwards compatibility
    • every 2 years
    • support lifecycle: 5y premier + 3y extended
    MySQL Versioning: LTS & Innovation Releases
    MySQL Innovation Releases
    • leading-edge innovations
    • easy migration between LTS & Innovation
    • every quarter
    • support lifecycle: short term
    

    View Slide

19. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
    19
    MySQL embraces Cloud Native
    https://dev.mysql.com/doc/refman/8.0/en/docker-mysql-getting-started.html
    • Lots of new features in MySQL 8.0
    • set persist, restart, performance_schema.error_log
    • MySQL is easy to run in containers
    • Oracle MySQL Community Edition image
    •
    Server, Router, k8s Operator, NDB Cluster, …
    •
    https://hub.docker.com/u/mysql
    • Oracle MySQL Enterprise Edition image
    • Support for DNS SRV (since MySQL 8.0.18+)
    • MySQL Connector support for DNS SRV (RFC 2782)
    • DNS request for service results in list of results
    • JDBC, .NET, ODBC, NodeJS, Connector/C, Python…
    • https://dev.mysql.com/doc/refman/8.0/en/connecting-using-dns-srv.html
    

    View Slide

20. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
    20
    • Developed by MySQL (InnoDB Cluster) team @ Oracle
    • Designed to operate a MySQL InnoDB Cluster in Kubernetes
    • Integrated with MySQL InnoDB Cluster
    • Coordinated development between both projects
    • MySQL Operator for Kubernetes
    • K8s Operator leverages MySQL InnoDB Cluster to deploy the declared architecture
    
    Keeps cluster healthy
    
    Replaces instances when another fails
    
    Recovers complete cluster goes offline
    
    Can recover in certain quorum majority loss situations
    • Backup & Recovery
    MySQL Operator for Kubernetes
    Published on GitHub:
    https://github.com/mysql/mysql-operator
    

    View Slide

21. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
    21
    MySQL Operator for Kubernetes - Features
    • Automated deployment and management of
    ●
    MySQL Server
    ●
    MySQL Router Self-healing
    • Backup & Restore
    • Scaleup/Scaledown of Router & Server
    Level III Maturity Operator
    • Rolling upgrades with minimal downtime
    • Configuration Management
    • Deploy from InnoDB CLONE
    • Private container registries
    Next step: Level IV
    

    View Slide

22. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
    22
    MySQL
    Server 5.7
    MySQL 8.0
    Upgrade Checker
    Prompt Themes
    Auto Completion
    &
    Command History
    MySQL
    Server 8.0
    Document Store
    X Dev API
    SQL CLI
    Output Formats
    (Table, JSON, Tabbed)
    Batch Execution
    JavaScript
    Python
    SQL
    importJSON Dump Utilities
    InnoDB Cluster /
    ReplicaSet /
    ClusterSet
    etc...
    MySQL Shell Overview
    Interface for Development and Administration of MySQL
    Interface for Development and Administration of MySQL
    https://dev.mysql.com/doc/mysql-shell/8.0/en
    

    View Slide

23. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
    23
    • Supports dump and load of instances, schemas and tables
    • Parallel loading of tables or table chunks
    • Progress state tracking
    • Resume and reset capability
    • Can add invisible columns with primary keys to tables
    • Splits larger tables in smaller chunks (reads 2GB/s+)
    • Loads chunks in parallel (writes 200MB/s+)
    • Support for native storage in OCI Object Storage
    • Recommended tool to migrate data to MySQL Database Services
    • Commands
    • util.dumpInstance() dump an entire database instance, including
    users
    • util.dumpSchemas() dump a set of schemas
    • util.dumpTables() dump a set of schemas
    • util.loadDump() load a dump into a target database
    MySQL Shell: Load & Dump utilities
    Create logical dumps & do logical restores, with a focus on ease of use, performance & integration
    Create logical dumps & do logical restores, with a focus on ease of use, performance & integration
    https://dev.mysql.com/blog-archive/mysql-shell-dump-load-part-1-demo/
    

    View Slide

24. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
    24
    MySQL Shell Debugging and Diagnostics Utilities
    • Enable you to analyze the performance of your servers (5.7+) and generate diagnostics
    reports on overall health, performance under load, and individual queries
    • Generates files in both TSV and YAML format
    • Standalone servers, members of replication topologies, InnoDB Clusters
    • The topology is detected automatically and diagnostics are generated for that topology
    • The diagnostic report is generated as a zip file
    to either the local directory or a specified path
    MySQL JS>
    util.debug.collectDiagnostics()
    util.debug.slowQueryDiagnostics()
    util.debug.collectHighLoadDiagnostics()
    Analyze the performance of your servers & generate diagnostics reports
    Analyze the performance of your servers & generate diagnostics reports
    https://dev.mysql.com/doc/mysql-shell/8.0/en/mysql-shell-utilities-diagnostics.html
    

    View Slide

25. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
    25
    MySQL Shell for VS Code (preview)
    World’s most popular open source database + world’s most popular IDE
    World’s most popular open source database + world’s most popular IDE
    DB Notebook Interface
    • Write, Execute, Edit
    MySQL Shell GUI Console
    • Full Power of MySQL Shell
    Full MySQL HeatWave Integration
    • Manage MySQL HeatWave Instances
    https://blogs.oracle.com/mysql/post/introducing-mysql-shell-for-vs-code
    https://marketplace.visualstudio.com/items?itemName=Oracle.mysql-shell-for-vs-code
    

    View Slide

26. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
    26
    Fast, Secure HTTPS Access for your MySQL Data
    Fast, Secure HTTPS Access for your MySQL Data
    MySQL REST Service (preview)
    https://blogs.oracle.com/mysql/post/introducing-the-mysql-rest-service
    • The MySQL REST Service (MRS) enables fast and secure HTTPS access for your MySQL data
    • Implemented as a MySQL Router feature, MRS provides the ability to publish RESTful Web Services
    for interacting with the data stored in MySQL solutions
    

    View Slide

27. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
    27
    Available for your
    Available for your On-Premise MySQL Solutions & MySQL HeatWave instances
    On-Premise MySQL Solutions & MySQL HeatWave instances
    MySQL REST Service - Architecture Overview
    https://blogs.oracle.com/mysql/post/introducing-the-mysql-rest-service
    A MRS setup consists of the
    following elements:
    • Standalone MySQL Server,
    MySQL InnoDB Cluster(Set),
    MySQL HeatWave on OCI
    for serving the application data
    • MySQL Shell & MySQL Shell for VS
    Code, for configuring & managing
    MRS, as well as enabling RESTful Web
    Service support for selected database
    schema objects
    • MySQL Routers, serving JSON data
    via RESTful Web Services
    

    View Slide

28. Analytics, Machine Learning, Autopilot
    Copyright © 2023, Oracle and/or its affiliates
    MySQL HeatWave: the cloud service 100% developed, managed, & supported
    by the MySQL team
    

    View Slide

29. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
    29
    MySQL HeatWave – Single database for OLTP, OLAP, ML
    Valorizing your data has never been so easy!
    Valorizing your data has never been so easy!
    https://www.mysql.com/products/mysqlheatwave
    

    View Slide

30. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
    30
    MySQL HeatWave Cloud Service
    100% developed, managed, and supported by the MySQL team
    100% developed, managed, and supported by the MySQL team
    Automation MySQL HeatWave
    Database
    High Availability
    Read Replicas
    Backup
    Query Acceleration
    AutoPilot
    AutoML
    Security Patch & Upgrade
    Provision & Configure
    OS
    OS Security Patch & Upgrade
    OS Installation
    Server Hardware Provisioning & Maintenance
    Storage Storage Provisioning & Maintenance
    Data Center
    Rack & Space
    Power, HVAC, Networking
    

    View Slide

31. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
    31
    *Benchmark queries are derived from the TPC-H benchmark, but results are not comparable to published TPC-H benchmark results since they do not comply with the TPC-H specification
    400G, 64 cores
    400G, 64 cores
    MySQL HeatWave dramatically speeds up analytic queries
    

    View Slide

32. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
    32
    See documented performance comparisons that show how HeatWave is 6.5X faster than Amazon Redshift at half the cost, 1400X faster than Amazon Aurora at half the cost, and 5400X faster than Amazon RDS for MySQL at two-thirds the cost
    30TB TPCH, MySQL HeatWave is
    30TB TPCH, MySQL HeatWave is faster
    faster,
    , cheaper
    cheaper &
    & easier
    easier to use than all the competitive database services
    to use than all the competitive database services
    MySQL HeatWave performance and price comparison
    www.oracle.com/mysql/heatwave/performance
    

    View Slide

33. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
    33
    MySQL HeatWave AutoML
    Accelerate ML initiatives, increase security, and reduce costs
    Build, train, deploy, & explain machine learning models within MySQL HeatWave, at no additional cost
    Build, train, deploy, & explain machine learning models within MySQL HeatWave, at no additional cost
    https://dev.mysql.com/doc/heatwave/en/mys-hwaml-machine-learning.html
    

    View Slide

34. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
    34
    MySQL HeatWave AutoML automates the ML lifecycle
    Dataset
    Data preprocessing
    Algorithm selection
    Adaptive sampling
    Feature selection
    Hyper-parameter tuning
    Tuned model
    Model explainer
    Prediction explainer
    Regulatory compliance
    Fairness
    Repeatability
    Causality
    Trust
    All models can be explained!
    All models can be explained!
    https://blogs.oracle.com/mysql/post/mysql-heatwave-new-machine-learning-multicloud-capabilities
    Support of:
    ●
    Regression
    ●
    Classification
    ●
    Recommender systems
    ●
    Unsupervised anomaly detection
    ●
    Multi-variate time series forecasting
    

    View Slide

35. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
    35
     Produces more accurate results
     Trains models 25X faster on average
     1% of the cost
     Scales as more modes are added
    HeatWave ML vs Redshift ML: Benchmarks summary
    See Benchmark details:
    https://www.oracle.com/mysql/heatwave/performance/
    

    View Slide

36. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
    36
    MySQL HeatWave - OLTP + OLAP + ML
    Example : Loan Approval
    Example : Loan Approval
    

    View Slide

37. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
    37
    Automate the most important & challenging aspects of achieving high query performance at scale
    Automate the most important & challenging aspects of achieving high query performance at scale
    MySQL Autopilot: Machine Learning Based Automation
    https://www.mysql.com/products/mysqlheatwave/autopilot
    

    View Slide

38. Lakehouse: Processing on Object Store
    Copyright © 2023, Oracle and/or its affiliates
    

    View Slide

39. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
    39
    Now in Beta
    Now in Beta
    MySQL HeatWave Lakehouse
    InnoDB
    mysql> CREATE TABLE Sensor (date DATE, degree INT)
    ENGINE=DATALAKE ENGINE_ATTRIBUTE = ‘{“dialect”:
    {“format”:”csv”}, “file”:[{“prefix”:”temp_sensor_1.csv”}]}’
    SECONDARY_ENGINE=RAPID;
    mysql> ALTER TABLE Sensor SECONDARY_LOAD;
    mysql> SELECT count(*) FROM Sensor, SALES WHERE Sensor.degrees
    >30 and Sensor.date=SALES.date;
    Object Store
    Devices Social Voice
    Sensors Events
    https://www.mysql.com/products/mysqlheatwave/lakehouse
    

    View Slide

40. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
    40
    MySQL HeatWave can process data from multiple data sources
    Oracle Golden Gate
    OCI Object Storage
    AWS Aurora
    AWS Redshift
    Data can be in a file or other databases
    Data can be in a file or other databases
    • Query data across MySQL, the object store, or
    both—using standard MySQL commands
    • Up to 400 TB of data—the HeatWave cluster
    scales to 512 nodes
    • Querying the database is as fast as querying the
    object store
    https://www.mysql.com/products/mysqlheatwave/lakehouse
    

    View Slide

41. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
    41
    Query performance of MySQL HeatWave Lakehouse
    Annual provisioned cost for HeatWave $1,589,036; for Redshift $2,261,760; for Snowflake $2,242,560
    Pricing for Redshift is based on 1-year reserved instance, paid upfront. Snowflake is based on standard edition
    *Benchmark queries are derived from the TPC-H benchmarks, but results are not comparable to published TPC-H benchmark results since these do not comply with the TPC-H specifications.
    17x
    17x faster than Snowflake,
    faster than Snowflake, 6x
    6x faster than Redshift
    faster than Redshift
    https://github.com/oracle/heatwave-tpch
    

    View Slide

42. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
    42
    Load performance of MySQL HeatWave Lakehouse
    Annual provisioned cost for HeatWave $1,589,036; for Redshift $2,261,760; for Snowflake $2,242,560
    Pricing for Redshift is based on 1-year reserved instance, paid upfront. Snowflake is based on standard edition
    *Benchmark queries are derived from the TPC-H benchmarks, but results are not comparable to published TPC-H benchmark results since these do not comply with the TPC-H specifications.
    8x
    8x faster than Redshift,
    faster than Redshift, 2.7x
    2.7x faster than Snowflake
    faster than Snowflake
    https://github.com/oracle/heatwave-tpch
    

    View Slide

43. Management & Observability
    Copyright © 2023, Oracle and/or its affiliates
    

    View Slide

44. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
    44
    Metrics
    • MySQL metrics to diagnose and troubleshoot
    problems
    • Create alarms on key metrics based on thresholds
    Fleet monitoring
    • Unified fleet view of MySQL databases across
    Oracle Cloud and on-premises
    Drill down to a specific MySQL from the Fleet
    • Quickly identify expensive queries that impact
    the performance of their applications
    • Visualize query activity to gain further insight into
    performance beyond query statistics
    • Filter for specific query problems like full table
    scans and bad indexes using advanced global
    search options
    MySQL Observability in OCI
    

    View Slide

45. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
    45
    Predictive Insights
    • Insights and recommendations to right size your
    infrastructure and optimize resource utilization
    • Forecast demand for changing workloads
    • Quickly isolate the largest, most utilized, and
    fastest growing databases
    • Detect performance degradation in business-critical
    SQL
    • Aggregate and compare across databases
    • Trend and forecast metrics seasonality via custom
    analytics for solving specific issues
    MySQL Capacity and Performance Management
    

    View Slide

46. Multi Cloud
    Copyright © 2023, Oracle and/or its affiliates
    98% of Enterprises Using Public Cloud Have Adopted a Multicloud
    Infrastructure Provider Strategy
    https://www.oracle.com/lu/news/announcement/98-percent-enterprises-adopted-multicloud-strategy-2023-02-09
    

    View Slide

47. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
    47
    • MySQL HeatWave is available in 40+ Oracle Cloud Regions
    • … but also on Oracle Cloud@Customer
    • … and also in Amazon Web Services & Microsoft Azure
    MySQL HeatWave - Ready for the distributed cloud
    Optimized to deliver the best price performance in each cloud
    Optimized to deliver the best price performance in each cloud
    

    View Slide

48. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
    48
    Follow us on Social Media
    

    View Slide

49. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
    49
    Merci!
    Q&R
    Olivier Dasini
    MySQL Cloud Principal Solutions Architect EMEA
    olivier.dasini@oracle.com
    Blogs : www.dasini.net/blog/en
    : www.dasini.net/blog/fr
    Linkedin: www.linkedin.com/in/olivier-dasini
    Twitter : @freshdaz
    

    View Slide

50. View Slide

51. Copyright © 2023, Oracle and/or its affiliates
    Oracle Live Labs
    Self-paced learning
    MySQL HeatWave Live Labs
    51
    

    View Slide

52. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
    52
    • The best MySQL releases ever, as widely acknowledged by the MySQL Community
    • Commitment to open source, with continued code contributions (as opposed to AWS,
    who forked MySQL to create the closed source Aurora)
    • A constant stream of innovation, with new products and services—including MySQL
    HeatWave—helping users and customers tackle the new challenges that they are facing
    • Unparalleled MySQL Database expertise from Oracle, the leading database company
    Oracle is committed to MySQL
    ’s success
    

    View Slide

53. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
    53
    • Modernize transactional applications using Amazon Aurora, RDS for MySQL, Azure
    Database for MySQL, Google’s Cloud SQL for MySQL with supporting analytical
    workloads from Amazon Redshift, Snowflake, Azure Synapse, and Google BigQuery
    • Modernize mixed workload applications using Amazon Aurora, RDS for MySQL, Azure
    Database for MySQL, GCP Cloud SQL for MySQL (initially without separate analytics
    database)
    • Modernize mixed workload applications using MySQL either on-premises or in the
    cloud
    • Rely on MySQL HeatWave for in-database machine learning to avoid using a
    separate machine learning service with data coming from MySQL, MySQL-based
    services, or analytics databases
    Modernizing applications with MySQL HeatWave
    Key use cases
    Key use cases
    

    View Slide

54. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
    54
    Performance of MySQL HeatWave on AWS
    *Benchmark queries are derived from the TPC-H benchmarks, but results are not comparable to published TPC-H benchmark results since these do not comply with the TPC-H specifications.
    20x
    20x faster than Redshift,
    faster than Redshift, 16x
    16x faster than Snowflake,
    faster than Snowflake, 16x
    16x faster than BigQuery
    faster than BigQuery
    

    View Slide

55. Copyright © 2023, Oracle and/or its affiliates. All rights reserved.
    55
    Discovering MySQL Database Service
    ●
    Discovering MySQL Database Service – Episode 1 – Introduction
    – http://dasini.net/blog/2021/08/03/discovering-mysql-database-service-episode-1-introduction/
    ●
    Discovering MySQL Database Service – Episode 2 – Create a compartment
    – http://dasini.net/blog/2021/08/10/discovering-mysql-database-service-episode-2-create-a-compartment/
    ●
    Discovering MySQL Database Service – Episode 3 – Create a Virtual Cloud Network
    – http://dasini.net/blog/2021/08/17/discovering-mysql-database-service-episode-3-create-a-virtual-cloud-network/
    ●
    Discovering MySQL Database Service – Episode 4 – Dump your MySQL data into an Object Storage bucket
    – http://dasini.net/blog/2021/08/24/discovering-mysql-database-service-episode-4-dump-your-mysql-data-into-an-object-storage-bucket/
    ●
    Discovering MySQL Database Service – Episode 5 – Create a MySQL DB system from a MySQL Shell dump
    – http://dasini.net/blog/2021/08/31/discovering-mysql-database-service-episode-5-create-a-mysql-db-system-from-a-mysql-shell-dump/
    ●
    Discovering MySQL Database Service – Episode 6 – Update the Private Subnet Security List
    – http://dasini.net/blog/2021/09/07/discovering-mysql-database-service-episode-6-update-the-private-subnet-security-list/
    ●
    Discovering MySQL Database Service – Episode 7 – Use a Bastion SSH port forwarding session
    – http://dasini.net/blog/2021/09/14/discovering-mysql-database-service-episode-7-use-a-bastion-ssh-port-forwarding-session/
    ●
    Discovering MySQL Database Service – Episode 8 – Connect to MySQL Database Service Using MySQL Shell
    – http://dasini.net/blog/2021/09/21/discovering-mysql-database-service-episode-8-connect-to-mysql-database-service-using-mysql-shell/
    ●
    Discovering MySQL Database Service – Episode 9 – Connect to MySQL Database Service Using MySQL Workbench
    – http://dasini.net/blog/2021/09/28/discovering-mysql-database-service-episode-9-connect-to-mysql-database-service-using-mysql-workbench/
    ●
    Discovering MySQL Database Service – Episode 10 – Connect to MySQL Database Service Using OCI Cloud Shell
    – http://dasini.net/blog/2021/10/05/discovering-mysql-database-service-episode-10-connect-to-mysql-database-service-using-oci-cloud-shell/
    ●
    ...
    Tutorials where I show you, step by step, how to use MDS and some other OCI services
    Tutorials where I show you, step by step, how to use MDS and some other OCI services
    http://dasini.net/blog/en
    

    View Slide