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
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/ 5 Highlights Read Replicas with Load Balancer Replication Filters Replication Sources Without GTIDs MySQL HeatWave for AWS
6. www.dasini.net/blog/en/ 6 Read Replicas with Load Balancer
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
8. www.dasini.net/blog/en/ 8 Read Replicas with Load Balancer
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
10. www.dasini.net/blog/en/ 10 Replication Filters
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
12. www.dasini.net/blog/en/ 12 MySQL HeatWave Replication Filters
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
14. www.dasini.net/blog/en/ 14 Replication Sources Without GTIDs
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
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
17. www.dasini.net/blog/en/ 17 MySQL HeatWave for AWS
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
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
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
21. www.dasini.net/blog/en/ 21 Try MySQL HeatWave for free
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
23. www.dasini.net/blog/en/ 23 Thanks for using !