Upgrade to Pro — share decks privately, control downloads, hide ads and more …

MySQL HeatWave Report - December 2022 update

MySQL HeatWave Report - December 2022 update

MySQL HeatWave is a fully managed database service that enables customers to run OLTP, OLAP, and Machine Learning workloads directly from their MySQL Database.

The following is just a summary of new features in MySQL HeatWave.
For a more thorough and exhaustive view please read the following:
- MySQL HeatWave Database Service Release Notes:
https://docs.oracle.com/en-us/iaas/releasenotes/services/mysql-database/

- MySQL HeatWave Release Notes:
https://dev.mysql.com/doc/relnotes/heatwave/en/

I also recommend:
- MySQL HeatWave Database Service Documentation:
https://docs.oracle.com/en-us/iaas/mysql-database/index.html

- MySQL HeatWave User Guide:
https://dev.mysql.com/doc/heatwave/en/

- MySQL 8.0 Reference Manual:
https://dev.mysql.com/doc/refman/8.0/en/

Olivier DASINI

January 05, 2023
Tweet

More Decks by Olivier DASINI

Other Decks in Technology

Transcript

  1. MySQL HeatWave Report
    December 2022 update
    Olivier DASINI
    MySQL Cloud Principal Solutions Architect
    Blog: www.dasini.net/blog/en
    Presentations: www.speakerdeck.com/freshdaz

    View Slide

  2. www.dasini.net/blog/en/
    2
    Me, Myself & I

    MySQL Geek
    ✔ Addicted to MySQL for 15+ years!
    ✔ Playing with databases for 20+ years

    MySQL Writer, Blogger and Speaker
    ✔ Also former : DBA, Consultant, Architect, Trainer, ...

    MySQL Cloud Principal Solutions Architect EMEA at Oracle

    Stay tuned!
    ✔ Blog: www.dasini.net/blog/en
    ✔ Presentations: www.speakerdeck.com/freshdaz
    ✔ Linkedin: www.linkedin.com/in/olivier-dasini
    Olivier DASINI

    View Slide

  3. www.dasini.net/blog/en/
    3
    The following is just a summary of new features in MySQL HeatWave.
    For a more thorough and exhaustive view please read the following:

    MySQL HeatWave Database Service Release Notes
    ✔ https://docs.oracle.com/en-us/iaas/releasenotes/services/mysql-database/

    MySQL HeatWave Release Notes
    ✔ https://dev.mysql.com/doc/relnotes/heatwave/en/
    I also recommend:

    MySQL HeatWave Database Service Documentation
    ✔ https://docs.oracle.com/en-us/iaas/mysql-database/index.html

    MySQL HeatWave User Guide
    ✔ https://dev.mysql.com/doc/heatwave/en/

    MySQL 8.0 Reference Manual
    ✔ https://dev.mysql.com/doc/refman/8.0/en/
    Disclaimer

    View Slide

  4. www.dasini.net/blog/en/
    4
    What is MySQL HeatWave?
    MySQL HeatWave is a fully managed database service
    that enables customers to run
    OLTP, OLAP, and Machine Learning workloads
    directly from their MySQL Database
    www.oracle.com/mysql/heatwave

    View Slide

  5. www.dasini.net/blog/en/
    5
    Highlights
    Read Replicas with Load Balancer
    Replication Filters
    Replication Sources Without GTIDs
    MySQL HeatWave for AWS

    View Slide

  6. www.dasini.net/blog/en/
    6
    Read Replicas with Load Balancer

    View Slide

  7. www.dasini.net/blog/en/
    7
    Read Replicas with Load Balancer

    Users can add and remove read replicas and load balancers to MySQL with just a
    few clicks, and the service takes care of deployment, configuration, monitoring, and
    maintenance

    Applications can connect directly to read replicas or to a read-only endpoint that
    automatically balances the queries across all the replicas

    Managed Read Replicas can be used in combination with the HA feature for an
    SLA of 99.99% and with Channels to deploy DR or cross-region topologies

    View Slide

  8. www.dasini.net/blog/en/
    8
    Read Replicas with Load Balancer

    View Slide

  9. www.dasini.net/blog/en/
    9
    Read Replicas with Load Balancer
    Resources

    Announcing MySQL HeatWave Read Replicas with Load Balancer
    ✔ https://blogs.oracle.com/mysql/post/announcing-oci-mysql-heatwave-database-service-managed-read-replicas-with-built-in-load-balancer

    Read Replicas and Load Balancer
    ✔ https://docs.oracle.com/en-us/iaas/mysql-database/doc/read-replicas-and-load-balancer.html

    View Slide

  10. www.dasini.net/blog/en/
    10
    Replication Filters

    View Slide

  11. www.dasini.net/blog/en/
    11
    MySQL HeatWave Replication Filters

    Users now have more flexibility to configure replication Channels for hybrid
    deployments or straightforward live migrations from on-premises or other cloud
    vendors

    Using the templates under the Channel filter options, you can easily replicate from
    other cloud vendors into OCI MySQL HeatWave Database Service

    The available templates help configure replication from :
    ✔ AWS RDS/Aurora
    ✔ Microsoft Azure
    ✔ Google Cloud
    ✔ Alibaba Cloud

    You can also manually configure your own MySQL replication filters for even more
    flexibility, like filtering out only specific tables or renaming the schema on the
    target

    View Slide

  12. www.dasini.net/blog/en/
    12
    MySQL HeatWave Replication Filters

    View Slide

  13. www.dasini.net/blog/en/
    13
    MySQL HeatWave Replication Filters
    Resources

    MySQL HeatWave Replication Filters and Sources Without GTIDs
    ✔ https://blogs.oracle.com/mysql/post/mysql-heatwave-database-service-replication-filters-and-sources-without-gtids

    Creating a Replication Channel
    ✔ https://docs.oracle.com/en-us/iaas/mysql-database/doc/creating-replication-channel.html

    Inbound Replication
    ✔ https://docs.oracle.com/en-us/iaas/mysql-database/doc/inbound-replication.html

    View Slide

  14. www.dasini.net/blog/en/
    14
    Replication Sources Without GTIDs

    View Slide

  15. www.dasini.net/blog/en/
    15
    MySQL HeatWave Replication Sources Without GTIDs

    Users now have the ability to handle MySQL sources that don't have GTID enabled

    Use the Channel Source connection positioning options and set the binary log file
    name and offset options

    View Slide

  16. www.dasini.net/blog/en/
    16
    Resources

    MySQL HeatWave Replication Filters and Sources Without GTIDs
    ✔ https://blogs.oracle.com/mysql/post/mysql-heatwave-database-service-replication-filters-and-sources-without-gtids

    Creating a Replication Channel
    ✔ https://docs.oracle.com/en-us/iaas/mysql-database/doc/creating-replication-channel.html

    Inbound Replication
    ✔ https://docs.oracle.com/en-us/iaas/mysql-database/doc/inbound-replication.html
    MySQL HeatWave Replication Sources Without GTIDs

    View Slide

  17. www.dasini.net/blog/en/
    17
    MySQL HeatWave for AWS

    View Slide

  18. www.dasini.net/blog/en/
    18
    MySQL HeatWave for AWS

    MySQL HeatWave capabilities are now available on AWS

    All components of the MySQL HeatWave service on AWS, namely the service
    console, control plane, and data plane, are built and optimized for AWS

    MySQL HeatWave runs natively inside AWS which enables customers with
    applications already deployed in AWS to benefit from MySQL HeatWave without
    incurring the latency associated with accessing a database service running outside
    of AWS

    Customers also don’t incur the high data egress fees charged by AWS that
    would be necessary to migrate data to a service running outside of AWS

    The tight integration of MySQL HeatWave with the AWS infrastructure, e.g. Amazon
    S3, CloudWatch, PrivateLink, makes it easy for developers to rely on MySQL
    HeatWave for new applications

    View Slide

  19. www.dasini.net/blog/en/
    19
    MySQL HeatWave for AWS

    On the 4TB TPC-H benchmark, MySQL HeatWave on AWS delivers 7x better price
    performance than Amazon Redshift, 10x better than Snowflake, 12x better than
    Google BigQuery and 4x better than Azure Synapse

    For machine learning, MySQL HeatWave on AWS is 25x faster than Redshift ML

    On a 10GB TPC-C workload, MySQL HeatWave offers up to 10x higher and
    sustained throughput compared to Amazon Aurora at high concurrency

    View Slide

  20. www.dasini.net/blog/en/
    20
    Resources

    MySQL HeatWave for AWS
    ✔ https://blogs.oracle.com/mysql/post/mysql-heatwave-for-aws

    MySQL HeatWave TPC-H
    ✔ https://github.com/oracle/heatwave-tpch
    MySQL HeatWave for AWS

    View Slide

  21. www.dasini.net/blog/en/
    21
    Try MySQL HeatWave for free

    View Slide

  22. www.dasini.net/blog/en/
    22
    Try MySQL HeatWave for free

    Get US$300 in credit and try Oracle MySQL HeatWave for 30 days

    Choose your cloud provider:
    ✔ Oracle Cloud Infrastructure (OCI) :
    ✔ Amazon Web Services (AWS) :

    Simplify operations with one MySQL Database service for transactions, analytics,
    and machine learning (ML)—eliminating the complexity and cost of separate
    analytics database, ML, and ETL services

    Get real-time analytics and improve security—eliminating the latency and risks of
    data movement between data stores

    Benefit from unmatched price performance and machine learning–powered
    automation—without changes to current MySQL applications

    View Slide

  23. www.dasini.net/blog/en/
    23
    Thanks for using !

    View Slide