Upgrade to PRO for Only $50/Year—Limited-Time Offer! 🔥

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
  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
  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
  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
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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
  10. 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
  11. 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
  12. 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
  13. 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
  14. 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