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/

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