{"id":8978,"date":"2026-09-30T15:28:19","date_gmt":"2026-09-30T14:28:19","guid":{"rendered":"https:\/\/dasini.net\/blog\/?p=8978"},"modified":"2026-09-30T15:40:53","modified_gmt":"2026-09-30T14:40:53","slug":"mysql-heatwave-core-capabilities-september-2026","status":"publish","type":"post","link":"https:\/\/dasini.net\/blog\/2026\/09\/30\/mysql-heatwave-core-capabilities-september-2026\/","title":{"rendered":"MySQL HeatWave Core Capabilities (September 2026)"},"content":{"rendered":"<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"770\" height=\"550\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2025\/09\/rc24-heatwave-logo.gif?resize=770%2C550&#038;ssl=1\" alt=\"\" class=\"wp-image-8340\" style=\"object-fit:contain;width:257px;height:183px\"\/><\/figure>\n<\/div>\n\n\n<div style=\"height:25px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">MySQL HeatWave is a fully managed MySQL cloud service built on <strong>MySQL Enterprise Edition<\/strong>. Beyond HeatWave analytics, AI, and Lakehouse capabilities, it provides a strong platform for traditional <strong>OLTP workloads<\/strong>, with built-in automation, high availability, read scaling, enterprise security, and simplified database cloning. (<a href=\"https:\/\/www.oracle.com\/mysql\/\" target=\"_blank\" rel=\"noreferrer noopener\"><em>documentation<\/em><\/a>)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For this first edition of the <strong>OCI Open Source Services Update<\/strong>, we highlight five capabilities particularly relevant to <strong>transactional MySQL workloads<\/strong>.<\/p>\n\n\n\n<div style=\"height:25px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Download this report<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">This report is available in the following formats:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/speakerdeck.com\/freshdaz\/mysql-heatwave-on-oci-five-capabilities-for-transactional-workloads-45d1a5d4-8ad5-4c0a-be67-d04e8b6b26e5\" target=\"_blank\" rel=\"noreferrer noopener\">Download the full report (PDF)<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/speakerdeck.com\/freshdaz\/mysql-heatwave-on-oci-five-capabilities-for-transactional-workloads\" target=\"_blank\" rel=\"noreferrer noopener\">Download the slide deck (PDF)<\/a><\/li>\n<\/ul>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h1 class=\"wp-block-heading\">Autopilot Indexing<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Workload-aware index recommendations for OLTP<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Choosing the right indexes is essential for OLTP performance, but finding the right balance can be difficult. Too few indexes can result in slow queries, while too many increase storage consumption and add overhead to INSERT, UPDATE, and DELETE operations.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>MySQL Autopilot Indexing<\/strong> analyzes SQL workload history collected in Performance Schema and recommends secondary indexes to <strong>create or remove<\/strong>. It considers both query performance and index-maintenance cost. (<a href=\"https:\/\/dev.mysql.com\/doc\/heatwave\/en\/mys-hw-advisor-auto-indexing.html\" target=\"_blank\" rel=\"noreferrer noopener\"><em>documentation<\/em><\/a>)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For each recommendation, Autopilot Indexing can provide:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Expected workload performance improvement<\/li>\n\n\n\n<li>Storage impact<\/li>\n\n\n\n<li>Index creation time<\/li>\n\n\n\n<li>DDL statements<\/li>\n\n\n\n<li>Explanation of the recommendation<\/li>\n\n\n\n<li>Estimated performance improvement for the most affected queries<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">This helps DBAs make evidence-based indexing decisions instead of relying only on manual analysis or guesswork.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Example<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Analyze all user schemas:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">CALL sys.autopilot_index_advisor(NULL);<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Or analyze a specific schema:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">CALL sys.autopilot_index_advisor(\n  JSON_OBJECT(\n    'target_schema',\n    JSON_ARRAY('sakila')\n  )\n);<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">The advisor can then recommend indexes to create or remove and report their expected performance and storage impact. (<a href=\"https:\/\/dev.mysql.com\/doc\/heatwave\/en\/mys-hw-advisor-auto-indexing-examples.html\" target=\"_blank\" rel=\"noreferrer noopener\"><em>documentation<\/em><\/a>)<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Resources<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/dev.mysql.com\/doc\/heatwave\/en\/mys-hw-advisor-auto-indexing.html\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL HeatWave \u2014 Autopilot Indexing documentation<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/dev.mysql.com\/doc\/heatwave\/en\/mys-hw-advisor-auto-indexing-examples.html\" target=\"_blank\" rel=\"noreferrer noopener\">Autopilot Indexing examples<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/blogs.oracle.com\/mysql\/removing-the-index-guesstimate-with-mysql-autopilot-indexing\" target=\"_blank\" rel=\"noreferrer noopener\">Removing the index guesstimate with MySQL Autopilot Indexing<\/a><\/li>\n<\/ul>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h1 class=\"wp-block-heading\">High Availability with Automatic Failover<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Built-in resilience for business-critical MySQL workloads<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A highly available MySQL HeatWave DB System consists of <strong>three MySQL instances: one primary and two secondary instances<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Depending on the OCI region and network configuration, the instances are distributed across different <strong>availability domains or fault domains<\/strong>, protecting the database against infrastructure failures. (<a href=\"https:\/\/docs.oracle.com\/en-us\/iaas\/mysql-database\/doc\/high-availability.html\" target=\"_blank\" rel=\"noreferrer noopener\"><em>d<\/em><em>oc<\/em><em>umentation<\/em><\/a>)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If the primary instance fails, MySQL HeatWave automatically promotes one of the secondary instances to become the new primary. The service provides <strong>zero data loss and minimal downtime<\/strong> during failover. (<a href=\"https:\/\/docs.oracle.com\/en-us\/iaas\/mysql-database\/doc\/overview-high-availability.html\" target=\"_blank\" rel=\"noreferrer noopener\"><em>d<\/em><em>oc<\/em><em>umentation<\/em><\/a>)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Applications continue to use the same read\/write endpoint: <strong>the IP address of the DB System endpoint does not change when the primary moves to another instance<\/strong>. (<a href=\"https:\/\/docs.oracle.com\/en-us\/iaas\/mysql-database\/doc\/failover.html\" target=\"_blank\" rel=\"noreferrer noopener\"><em>d<\/em><em>oc<\/em><em>umentation<\/em><\/a>)<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Why it matters<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">High Availability removes much of the operational complexity traditionally associated with running a resilient MySQL architecture.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Normal operation<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"533\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/09\/image-1.png?resize=800%2C533&#038;ssl=1\" alt=\"\" class=\"wp-image-8981\" srcset=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/09\/image-1.png?resize=800%2C533&amp;ssl=1 800w, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/09\/image-1.png?resize=300%2C200&amp;ssl=1 300w, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/09\/image-1.png?resize=768%2C512&amp;ssl=1 768w, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/09\/image-1.png?w=1200&amp;ssl=1 1200w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">After a primary failure<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"533\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/09\/image.png?resize=800%2C533&#038;ssl=1\" alt=\"\" class=\"wp-image-8979\" srcset=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/09\/image.png?resize=800%2C533&amp;ssl=1 800w, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/09\/image.png?resize=300%2C200&amp;ssl=1 300w, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/09\/image.png?resize=768%2C512&amp;ssl=1 768w, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/09\/image.png?w=1200&amp;ssl=1 1200w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Failover, instance promotion, and recovery of the failed instance are managed by the service. (<a href=\"https:\/\/docs.oracle.com\/en-us\/iaas\/mysql-database\/doc\/automatic-recovery-preventive-operations.html\" target=\"_blank\" rel=\"noreferrer noopener\"><em>d<\/em><em>oc<\/em><em>umentation<\/em><\/a>)<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Resources<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/docs.oracle.com\/en-us\/iaas\/mysql-database\/doc\/overview-high-availability.html\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL HeatWave \u2014 High Availability overview<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/docs.oracle.com\/en-us\/iaas\/mysql-database\/doc\/failover.html\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL HeatWave \u2014 Failover<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/blogs.oracle.com\/mysql\/mysql-database-service-with-high-availability\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL Database Service with High Availability<\/a><\/li>\n<\/ul>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h1 class=\"wp-block-heading\">Read Scaling with Managed Read Replicas<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Scale read-intensive applications without scaling the primary database<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For applications that generate substantially more reads than writes, sending every query to the primary database can eventually become a scalability bottleneck.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">MySQL HeatWave <strong>Read Replicas<\/strong> provide read-only copies of the primary MySQL instance that can be used to offload read-intensive workloads and reduce query latency. Updates from the primary are replicated asynchronously to the replicas. (<a href=\"https:\/\/docs.oracle.com\/en-us\/iaas\/mysql-database\/doc\/overview-read-replica.html\" target=\"_blank\" rel=\"noreferrer noopener\"><em>documentation<\/em><\/a>)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Each replica has its own endpoint, allowing an application to target an individual replica when required.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">MySQL HeatWave also simplifies connection management: when the first read replica is created, the service automatically creates a <strong>Read Replica Load Balancer<\/strong>. All replicas belonging to the DB System are automatically registered as backends, and traffic is distributed among active replicas.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Typical architecture<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"533\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/09\/image-1.png?resize=800%2C533&#038;ssl=1\" alt=\"\" class=\"wp-image-8980\" srcset=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/09\/image-1.png?resize=800%2C533&amp;ssl=1 800w, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/09\/image-1.png?resize=300%2C200&amp;ssl=1 300w, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/09\/image-1.png?resize=768%2C512&amp;ssl=1 768w, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/09\/image-1.png?w=1200&amp;ssl=1 1200w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">This is particularly useful for:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Read-heavy web applications<\/li>\n\n\n\n<li>Reporting workloads<\/li>\n\n\n\n<li>APIs with high read concurrency<\/li>\n\n\n\n<li>Product catalogs<\/li>\n\n\n\n<li>Dashboards<\/li>\n\n\n\n<li>Applications where read capacity needs to scale independently of write capacity<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Resources<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/docs.oracle.com\/en-us\/iaas\/mysql-database\/doc\/read-replica.html\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL HeatWave \u2014 Read Replica Documentation<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/blogs.oracle.com\/mysql\/announcing-oci-mysql-heatwave-database-service-managed-read-replicas-with-built-in-load-balancer\" target=\"_blank\" rel=\"noreferrer noopener\">Announcing MySQL HeatWave Read Replicas with Load Balancer<\/a><\/li>\n<\/ul>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h1 class=\"wp-block-heading\">Enterprise-Grade Security Built In<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">MySQL Enterprise Edition capabilities as a managed service<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The MySQL DB System used by MySQL HeatWave runs <strong>MySQL Enterprise Edition<\/strong>, bringing enterprise security capabilities directly into the managed cloud service. (<a href=\"https:\/\/dev.mysql.com\/doc\/heatwave\/en\/mys-hw-about-heatwave.html\" target=\"_blank\" rel=\"noreferrer noopener\"><em>documentation<\/em><\/a>)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Security capabilities include multiple complementary layers.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Encryption at rest<\/strong> protects DB System storage and backups. OCI-managed encryption keys are used by default, while organizations that require greater control can use <strong>customer-managed keys<\/strong> stored in OCI Vault. (<a href=\"https:\/\/docs.oracle.com\/en-us\/iaas\/mysql-database\/doc\/features-mysql-heatwave-service.html\" target=\"_blank\" rel=\"noreferrer noopener\"><em>documentation<\/em><\/a>)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Encryption in transit<\/strong> protects connections between applications and MySQL using TLS. Encryption can also be made mandatory for individual MySQL users.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For example:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">CREATE USER 'app_user'10.0.1.%'\nIDENTIFIED BY 'S\u20accur3P@s5W0rd&amp;'\nREQUIRE SSL;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Data masking<\/strong> provides SQL functions that can hide or transform sensitive information such as email addresses, payment-card numbers, telephone numbers, and other personally identifiable data. (<a href=\"https:\/\/docs.oracle.com\/en-us\/iaas\/mysql-database\/doc\/data-masking.html\" target=\"_blank\" rel=\"noreferrer noopener\"><em>d<\/em><em>o<\/em><em>c<\/em><em>umentation<\/em><\/a>)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>MySQL Enterprise Audit<\/strong> can record database activity including connections, disconnections, and access to databases and tables, helping organizations build database audit trails. (<a href=\"https:\/\/docs.oracle.com\/en-us\/iaas\/mysql-database\/doc\/mysql-enterprise-audit-plugin.html\" target=\"_blank\" rel=\"noreferrer noopener\"><em>d<\/em><em>oc<\/em><em>umentation<\/em><\/a>)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>OCI Identity and Access Management (IAM)<\/strong> controls access to MySQL HeatWave cloud resources through policies and permissions, allowing administrators to apply least-privilege access at the tenancy and compartment level. (<a href=\"https:\/\/docs.oracle.com\/en-us\/iaas\/mysql-database\/doc\/iam-policies.html\" target=\"_blank\" rel=\"noreferrer noopener\"><em>d<\/em><em>oc<\/em><em>umentation<\/em><\/a>)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Together, these capabilities provide security controls at the <strong>cloud infrastructure, database, identity, connection, and data levels<\/strong>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Resources<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/docs.oracle.com\/en-us\/iaas\/mysql-database\/doc\/security-best-practices.html\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL HeatWave \u2014 Security Best Practices<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/docs.oracle.com\/en-us\/iaas\/mysql-database\/doc\/data-masking.html\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL HeatWave \u2014 Data Masking<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/docs.oracle.com\/en-us\/iaas\/mysql-database\/doc\/mysql-enterprise-audit-plugin.html\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL HeatWave \u2014 MySQL Enterprise Audit<\/a><\/li>\n<\/ul>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h1 class=\"wp-block-heading\">Fast Cloning for Development, Testing, and Disaster Recovery<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Create a new DB System directly from an existing database<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">MySQL HeatWave cloning provides a streamlined way to create a new DB System directly from an existing one, without requiring users to manually perform the traditional backup-and-restore workflow.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A DB System can be cloned <strong>within the same OCI region or into another region<\/strong>. During the clone operation, MySQL HeatWave can also optionally configure a replication channel between the source DB System and the clone. (<a href=\"https:\/\/docs.oracle.com\/en-us\/iaas\/mysql-database\/doc\/cloning-db-system.html\" target=\"_blank\" rel=\"noreferrer noopener\"><em>documentation<\/em><\/a>)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This makes cloning useful for several scenarios.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Development and testing<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Teams can quickly provision a separate database based on an existing DB System:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"533\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/09\/MHW_5_clone_1.1_little.png?resize=800%2C533&#038;ssl=1\" alt=\"\" class=\"wp-image-8993\" srcset=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/09\/MHW_5_clone_1.1_little.png?resize=800%2C533&amp;ssl=1 800w, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/09\/MHW_5_clone_1.1_little.png?resize=300%2C200&amp;ssl=1 300w, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/09\/MHW_5_clone_1.1_little.png?resize=768%2C512&amp;ssl=1 768w, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/09\/MHW_5_clone_1.1_little.png?w=1200&amp;ssl=1 1200w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">This simplifies the creation of realistic development or testing environments compared with manually coordinating backups and restores.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Cross-region disaster recovery<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The same mechanism can be used to create a DB System in another OCI region:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"400\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/09\/MHW_5_clone_1.2_little.png?resize=800%2C400&#038;ssl=1\" alt=\"\" class=\"wp-image-8994\" srcset=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/09\/MHW_5_clone_1.2_little.png?resize=800%2C400&amp;ssl=1 800w, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/09\/MHW_5_clone_1.2_little.png?resize=300%2C150&amp;ssl=1 300w, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/09\/MHW_5_clone_1.2_little.png?resize=768%2C384&amp;ssl=1 768w, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/09\/MHW_5_clone_1.2_little.png?resize=1536%2C768&amp;ssl=1 1536w, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/09\/MHW_5_clone_1.2_little.png?w=1600&amp;ssl=1 1600w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">For cross-region deployments, the cloning workflow can optionally establish the replication channel during provisioning.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Previously, creating this type of replica could require several separate operations:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"533\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/09\/image-2.png?resize=800%2C533&#038;ssl=1\" alt=\"\" class=\"wp-image-8984\" srcset=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/09\/image-2.png?resize=800%2C533&amp;ssl=1 800w, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/09\/image-2.png?resize=300%2C200&amp;ssl=1 300w, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/09\/image-2.png?resize=768%2C512&amp;ssl=1 768w, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/09\/image-2.png?w=1200&amp;ssl=1 1200w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">The cloning workflow brings these steps together into a much simpler operation, reducing the effort required to provision replica DB Systems for disaster recovery and other operational scenarios.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Resources<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/docs.oracle.com\/en-us\/iaas\/mysql-database\/doc\/cloning-db-system.html\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL HeatWave \u2014 Creating a DB System Clone<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/blogs.oracle.com\/mysql\/create-replica-db-system-made-easy-for-mysql-heatwave-service-on-oci\" target=\"_blank\" rel=\"noreferrer noopener\">Create Replica DB System Made Easy for MySQL HeatWave Service on OCI<\/a><\/li>\n<\/ul>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h1 class=\"wp-block-heading\">Summary<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">MySQL HeatWave: the OLTP Picture<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Taken together, these capabilities address several of the core requirements of running production MySQL applications in the cloud:<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table class=\"has-fixed-layout\"><thead><tr><th class=\"has-text-align-left\" data-align=\"left\"><strong>Requirement<\/strong><\/th><th class=\"has-text-align-left\" data-align=\"left\"><strong>MySQL HeatWave capability<\/strong><\/th><\/tr><\/thead><tbody><tr><td class=\"has-text-align-left\" data-align=\"left\">Optimize transactional performance<\/td><td class=\"has-text-align-left\" data-align=\"left\"><strong>Autopilot Indexing<\/strong><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Protect against instance or infrastructure failure<\/td><td class=\"has-text-align-left\" data-align=\"left\"><strong>High Availability<\/strong><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Scale read-intensive applications<\/td><td class=\"has-text-align-left\" data-align=\"left\"><strong>Managed Read Replicas<\/strong><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Protect sensitive and regulated data<\/td><td class=\"has-text-align-left\" data-align=\"left\"><strong>MySQL Enterprise Security<\/strong><\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Provision copies and prepare for regional recovery<\/td><td class=\"has-text-align-left\" data-align=\"left\"><strong>DB System Cloning<\/strong><\/td><\/tr><\/tbody><\/table><figcaption class=\"wp-element-caption\"><em><strong><span style=\"text-decoration: underline;\">OLTP requirements and MySQL HeatWave capabilities<\/span><\/strong><\/em><\/figcaption><\/figure>\n\n\n\n<div style=\"height:25px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">The result is a managed MySQL platform where many traditionally complex DBA and infrastructure tasks, like index analysis, failover, replica management, security integration, and database provisioning, are provided directly by the service.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"#top\"><em>Back to top<\/em><\/a><\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/www.linkedin.com\/groups\/12524512\/\" target=\"_blank\" rel=\"noopener\" title=\"Olivier DASINI on Linkedin\">Follow me on Linkedin<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Watch my videos on my <a href=\"https:\/\/www.youtube.com\/channel\/UC12TulyJsJZHoCmby3Nm3WQ\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"Olivier's MySQL Channel\">YouTube channel<\/a> and <a href=\"https:\/\/www.youtube.com\/channel\/UC12TulyJsJZHoCmby3Nm3WQ\/?sub_confirmation=1\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"Subscribe\">subscribe<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">My <a href=\"https:\/\/speakerdeck.com\/freshdaz\/\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"Olivier DASINI on Speaker Deck\">Speaker Deck account<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">My <a href=\"https:\/\/www.slideshare.net\/freshdaz\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"Olivier DASINI on Slideshare\">Slideshare account<\/a> (<em>archive<\/em>).<\/p>\n\n\n\n<div style=\"height:25px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-vivid-red-color has-text-color wp-block-paragraph\"><strong>Thanks for using HeatWave &amp; MySQL!<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>OCI Open Source Service Update \u2013 Sept. 2026<br \/>\nExplore how MySQL HeatWave on Oracle Cloud Infrastructure helps optimize, protect, and scale MySQL applications.<br \/>\nCovers Autopilot Indexing, high availability with automatic failover, managed read replicas, enterprise security, and fast DB system cloning for development, testing, and regional recovery.<\/p>\n","protected":false},"author":2,"featured_media":8340,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","jetpack_post_was_ever_published":false},"categories":[1694,1719,203],"tags":[306,1697,383],"class_list":["post-8978","post","type-post","status-publish","format-standard","hentry","category-heatwave-en","category-mds-en","category-mysql-en","tag-cloud","tag-heatwave-fr-en","tag-mysql-enterprise"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.2 - aioseo.com -->\n\t<meta name=\"description\" content=\"MySQL HeatWave is a fully managed MySQL cloud service built on MySQL Enterprise Edition. Beyond HeatWave analytics, AI, and Lakehouse capabilities, it provides a strong platform for traditional OLTP workloads, with built-in automation, high availability, read scaling, enterprise security, and simplified database cloning. (documentation) For this first edition of the OCI Open Source Services Update,\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Olivier DASINI\"\/>\n\t<meta name=\"google-site-verification\" content=\"HN6x37mM2NBzUxcsZUKC8OY_DxAioI6oKazYPPNq02c\" \/>\n\t<meta name=\"keywords\" content=\"cloud,heatwave,mysql enterprise,mds,mysql\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/dasini.net\/blog\/2026\/09\/30\/mysql-heatwave-core-capabilities-september-2026\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.2\" \/>\n\t\t<meta property=\"og:locale\" content=\"fr_FR\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Data Daz (dasini.net) - Data Systems, AI, and Real-World Insights | Exploring Beyond the Limits of Knowledge\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"MySQL HeatWave Core Capabilities (September 2026) | Data Daz (dasini.net) - Data Systems, AI, and Real-World Insights\" \/>\n\t\t<meta property=\"og:description\" content=\"MySQL HeatWave is a fully managed MySQL cloud service built on MySQL Enterprise Edition. Beyond HeatWave analytics, AI, and Lakehouse capabilities, it provides a strong platform for traditional OLTP workloads, with built-in automation, high availability, read scaling, enterprise security, and simplified database cloning. (documentation) For this first edition of the OCI Open Source Services Update,\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/dasini.net\/blog\/2026\/09\/30\/mysql-heatwave-core-capabilities-september-2026\/\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2026-09-30T14:28:19+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2026-09-30T14:40:53+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:site\" content=\"@freshdaz\" \/>\n\t\t<meta name=\"twitter:title\" content=\"MySQL HeatWave Core Capabilities (September 2026) | Data Daz (dasini.net) - Data Systems, AI, and Real-World Insights\" \/>\n\t\t<meta name=\"twitter:description\" content=\"MySQL HeatWave is a fully managed MySQL cloud service built on MySQL Enterprise Edition. Beyond HeatWave analytics, AI, and Lakehouse capabilities, it provides a strong platform for traditional OLTP workloads, with built-in automation, high availability, read scaling, enterprise security, and simplified database cloning. (documentation) For this first edition of the OCI Open Source Services Update,\" \/>\n\t\t<meta name=\"twitter:creator\" content=\"@freshdaz\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2026\\\/09\\\/30\\\/mysql-heatwave-core-capabilities-september-2026\\\/#article\",\"name\":\"MySQL HeatWave Core Capabilities (September 2026) | Data Daz (dasini.net) - Data Systems, AI, and Real-World Insights\",\"headline\":\"MySQL HeatWave Core Capabilities (September 2026)\",\"author\":{\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/author\\\/freshdaz\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/dasini.net\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/09\\\/rc24-heatwave-logo.gif?fit=770%2C550&ssl=1\",\"width\":770,\"height\":550},\"datePublished\":\"2026-09-30T15:28:19+01:00\",\"dateModified\":\"2026-09-30T15:40:53+01:00\",\"inLanguage\":\"fr-FR\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2026\\\/09\\\/30\\\/mysql-heatwave-core-capabilities-september-2026\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2026\\\/09\\\/30\\\/mysql-heatwave-core-capabilities-september-2026\\\/#webpage\"},\"articleSection\":\"HeatWave, MDS, MySQL, Cloud, Heatwave, MySQL Enterprise, English\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2026\\\/09\\\/30\\\/mysql-heatwave-core-capabilities-september-2026\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/dasini.net\\\/blog\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/category\\\/mysql-en\\\/#listItem\",\"name\":\"MySQL\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/category\\\/mysql-en\\\/#listItem\",\"position\":2,\"name\":\"MySQL\",\"item\":\"https:\\\/\\\/dasini.net\\\/blog\\\/category\\\/mysql-en\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2026\\\/09\\\/30\\\/mysql-heatwave-core-capabilities-september-2026\\\/#listItem\",\"name\":\"MySQL HeatWave Core Capabilities (September 2026)\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2026\\\/09\\\/30\\\/mysql-heatwave-core-capabilities-september-2026\\\/#listItem\",\"position\":3,\"name\":\"MySQL HeatWave Core Capabilities (September 2026)\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/category\\\/mysql-en\\\/#listItem\",\"name\":\"MySQL\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/#person\",\"name\":\"Olivier DASINI\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2026\\\/09\\\/30\\\/mysql-heatwave-core-capabilities-september-2026\\\/#personImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d46da4fb4b99ea9ce527a93ce9b998a446577e42e1f132d8437235fa5b963636?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Olivier DASINI\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/author\\\/freshdaz\\\/#author\",\"url\":\"https:\\\/\\\/dasini.net\\\/blog\\\/author\\\/freshdaz\\\/\",\"name\":\"Olivier DASINI\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2026\\\/09\\\/30\\\/mysql-heatwave-core-capabilities-september-2026\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d46da4fb4b99ea9ce527a93ce9b998a446577e42e1f132d8437235fa5b963636?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Olivier DASINI\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2026\\\/09\\\/30\\\/mysql-heatwave-core-capabilities-september-2026\\\/#webpage\",\"url\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2026\\\/09\\\/30\\\/mysql-heatwave-core-capabilities-september-2026\\\/\",\"name\":\"MySQL HeatWave Core Capabilities (September 2026) | Data Daz (dasini.net) - Data Systems, AI, and Real-World Insights\",\"description\":\"MySQL HeatWave is a fully managed MySQL cloud service built on MySQL Enterprise Edition. Beyond HeatWave analytics, AI, and Lakehouse capabilities, it provides a strong platform for traditional OLTP workloads, with built-in automation, high availability, read scaling, enterprise security, and simplified database cloning. (documentation) For this first edition of the OCI Open Source Services Update,\",\"inLanguage\":\"fr-FR\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2026\\\/09\\\/30\\\/mysql-heatwave-core-capabilities-september-2026\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/author\\\/freshdaz\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/author\\\/freshdaz\\\/#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/dasini.net\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/09\\\/rc24-heatwave-logo.gif?fit=770%2C550&ssl=1\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2026\\\/09\\\/30\\\/mysql-heatwave-core-capabilities-september-2026\\\/#mainImage\",\"width\":770,\"height\":550},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2026\\\/09\\\/30\\\/mysql-heatwave-core-capabilities-september-2026\\\/#mainImage\"},\"datePublished\":\"2026-09-30T15:28:19+01:00\",\"dateModified\":\"2026-09-30T15:40:53+01:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/dasini.net\\\/blog\\\/\",\"name\":\"dasini.net - Diary of a MySQL expert\",\"description\":\"Exploring Beyond the Limits of Knowledge\",\"inLanguage\":\"fr-FR\",\"publisher\":{\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"MySQL HeatWave Core Capabilities (September 2026) | Data Daz (dasini.net) - Data Systems, AI, and Real-World Insights","description":"MySQL HeatWave is a fully managed MySQL cloud service built on MySQL Enterprise Edition. Beyond HeatWave analytics, AI, and Lakehouse capabilities, it provides a strong platform for traditional OLTP workloads, with built-in automation, high availability, read scaling, enterprise security, and simplified database cloning. (documentation) For this first edition of the OCI Open Source Services Update,","canonical_url":"https:\/\/dasini.net\/blog\/2026\/09\/30\/mysql-heatwave-core-capabilities-september-2026\/","robots":"max-image-preview:large","keywords":"cloud,heatwave,mysql enterprise,mds,mysql","webmasterTools":{"google-site-verification":"HN6x37mM2NBzUxcsZUKC8OY_DxAioI6oKazYPPNq02c","miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dasini.net\/blog\/2026\/09\/30\/mysql-heatwave-core-capabilities-september-2026\/#article","name":"MySQL HeatWave Core Capabilities (September 2026) | Data Daz (dasini.net) - Data Systems, AI, and Real-World Insights","headline":"MySQL HeatWave Core Capabilities (September 2026)","author":{"@id":"https:\/\/dasini.net\/blog\/author\/freshdaz\/#author"},"publisher":{"@id":"https:\/\/dasini.net\/blog\/#person"},"image":{"@type":"ImageObject","url":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2025\/09\/rc24-heatwave-logo.gif?fit=770%2C550&ssl=1","width":770,"height":550},"datePublished":"2026-09-30T15:28:19+01:00","dateModified":"2026-09-30T15:40:53+01:00","inLanguage":"fr-FR","mainEntityOfPage":{"@id":"https:\/\/dasini.net\/blog\/2026\/09\/30\/mysql-heatwave-core-capabilities-september-2026\/#webpage"},"isPartOf":{"@id":"https:\/\/dasini.net\/blog\/2026\/09\/30\/mysql-heatwave-core-capabilities-september-2026\/#webpage"},"articleSection":"HeatWave, MDS, MySQL, Cloud, Heatwave, MySQL Enterprise, English"},{"@type":"BreadcrumbList","@id":"https:\/\/dasini.net\/blog\/2026\/09\/30\/mysql-heatwave-core-capabilities-september-2026\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/dasini.net\/blog\/#listItem","position":1,"name":"Home","item":"https:\/\/dasini.net\/blog\/","nextItem":{"@type":"ListItem","@id":"https:\/\/dasini.net\/blog\/category\/mysql-en\/#listItem","name":"MySQL"}},{"@type":"ListItem","@id":"https:\/\/dasini.net\/blog\/category\/mysql-en\/#listItem","position":2,"name":"MySQL","item":"https:\/\/dasini.net\/blog\/category\/mysql-en\/","nextItem":{"@type":"ListItem","@id":"https:\/\/dasini.net\/blog\/2026\/09\/30\/mysql-heatwave-core-capabilities-september-2026\/#listItem","name":"MySQL HeatWave Core Capabilities (September 2026)"},"previousItem":{"@type":"ListItem","@id":"https:\/\/dasini.net\/blog\/#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/dasini.net\/blog\/2026\/09\/30\/mysql-heatwave-core-capabilities-september-2026\/#listItem","position":3,"name":"MySQL HeatWave Core Capabilities (September 2026)","previousItem":{"@type":"ListItem","@id":"https:\/\/dasini.net\/blog\/category\/mysql-en\/#listItem","name":"MySQL"}}]},{"@type":"Person","@id":"https:\/\/dasini.net\/blog\/#person","name":"Olivier DASINI","image":{"@type":"ImageObject","@id":"https:\/\/dasini.net\/blog\/2026\/09\/30\/mysql-heatwave-core-capabilities-september-2026\/#personImage","url":"https:\/\/secure.gravatar.com\/avatar\/d46da4fb4b99ea9ce527a93ce9b998a446577e42e1f132d8437235fa5b963636?s=96&d=mm&r=g","width":96,"height":96,"caption":"Olivier DASINI"}},{"@type":"Person","@id":"https:\/\/dasini.net\/blog\/author\/freshdaz\/#author","url":"https:\/\/dasini.net\/blog\/author\/freshdaz\/","name":"Olivier DASINI","image":{"@type":"ImageObject","@id":"https:\/\/dasini.net\/blog\/2026\/09\/30\/mysql-heatwave-core-capabilities-september-2026\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/d46da4fb4b99ea9ce527a93ce9b998a446577e42e1f132d8437235fa5b963636?s=96&d=mm&r=g","width":96,"height":96,"caption":"Olivier DASINI"}},{"@type":"WebPage","@id":"https:\/\/dasini.net\/blog\/2026\/09\/30\/mysql-heatwave-core-capabilities-september-2026\/#webpage","url":"https:\/\/dasini.net\/blog\/2026\/09\/30\/mysql-heatwave-core-capabilities-september-2026\/","name":"MySQL HeatWave Core Capabilities (September 2026) | Data Daz (dasini.net) - Data Systems, AI, and Real-World Insights","description":"MySQL HeatWave is a fully managed MySQL cloud service built on MySQL Enterprise Edition. Beyond HeatWave analytics, AI, and Lakehouse capabilities, it provides a strong platform for traditional OLTP workloads, with built-in automation, high availability, read scaling, enterprise security, and simplified database cloning. (documentation) For this first edition of the OCI Open Source Services Update,","inLanguage":"fr-FR","isPartOf":{"@id":"https:\/\/dasini.net\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/dasini.net\/blog\/2026\/09\/30\/mysql-heatwave-core-capabilities-september-2026\/#breadcrumblist"},"author":{"@id":"https:\/\/dasini.net\/blog\/author\/freshdaz\/#author"},"creator":{"@id":"https:\/\/dasini.net\/blog\/author\/freshdaz\/#author"},"image":{"@type":"ImageObject","url":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2025\/09\/rc24-heatwave-logo.gif?fit=770%2C550&ssl=1","@id":"https:\/\/dasini.net\/blog\/2026\/09\/30\/mysql-heatwave-core-capabilities-september-2026\/#mainImage","width":770,"height":550},"primaryImageOfPage":{"@id":"https:\/\/dasini.net\/blog\/2026\/09\/30\/mysql-heatwave-core-capabilities-september-2026\/#mainImage"},"datePublished":"2026-09-30T15:28:19+01:00","dateModified":"2026-09-30T15:40:53+01:00"},{"@type":"WebSite","@id":"https:\/\/dasini.net\/blog\/#website","url":"https:\/\/dasini.net\/blog\/","name":"dasini.net - Diary of a MySQL expert","description":"Exploring Beyond the Limits of Knowledge","inLanguage":"fr-FR","publisher":{"@id":"https:\/\/dasini.net\/blog\/#person"}}]},"og:locale":"fr_FR","og:site_name":"Data Daz (dasini.net) - Data Systems, AI, and Real-World Insights | Exploring Beyond the Limits of Knowledge","og:type":"article","og:title":"MySQL HeatWave Core Capabilities (September 2026) | Data Daz (dasini.net) - Data Systems, AI, and Real-World Insights","og:description":"MySQL HeatWave is a fully managed MySQL cloud service built on MySQL Enterprise Edition. Beyond HeatWave analytics, AI, and Lakehouse capabilities, it provides a strong platform for traditional OLTP workloads, with built-in automation, high availability, read scaling, enterprise security, and simplified database cloning. (documentation) For this first edition of the OCI Open Source Services Update,","og:url":"https:\/\/dasini.net\/blog\/2026\/09\/30\/mysql-heatwave-core-capabilities-september-2026\/","article:published_time":"2026-09-30T14:28:19+00:00","article:modified_time":"2026-09-30T14:40:53+00:00","twitter:card":"summary","twitter:site":"@freshdaz","twitter:title":"MySQL HeatWave Core Capabilities (September 2026) | Data Daz (dasini.net) - Data Systems, AI, and Real-World Insights","twitter:description":"MySQL HeatWave is a fully managed MySQL cloud service built on MySQL Enterprise Edition. Beyond HeatWave analytics, AI, and Lakehouse capabilities, it provides a strong platform for traditional OLTP workloads, with built-in automation, high availability, read scaling, enterprise security, and simplified database cloning. (documentation) For this first edition of the OCI Open Source Services Update,","twitter:creator":"@freshdaz"},"aioseo_meta_data":{"post_id":"8978","title":null,"description":null,"keywords":null,"keyphrases":{"focus":{"keyphrase":"","score":0,"analysis":{"keyphraseInTitle":{"score":0,"maxScore":9,"error":1}}},"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"Article","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","location":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":{"faqs":[],"keyPoints":[],"schemas":[],"titles":[],"descriptions":[],"socialPosts":{"email":{"subject":"","preview":"","content":""},"linkedin":[],"twitter":[],"facebook":[],"instagram":[]}},"created":"2026-09-29 08:52:23","updated":"2026-09-30 18:36:29","seo_analyzer_scan_date":null,"focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9LfWW-2kO","jetpack-related-posts":[{"id":8792,"url":"https:\/\/dasini.net\/blog\/2026\/07\/01\/mysql-mysql-heatwave-report-june-2026\/","url_meta":{"origin":8978,"position":0},"title":"MySQL &amp; MySQL HeatWave Report \u2013 June 2026","author":"Olivier DASINI","date":"1 juillet 2026","format":false,"excerpt":"Keeping up with the MySQL ecosystem is becoming increasingly challenging. Every release introduces new features, performance improvements, security enhancements, and cloud capabilities. While the official documentation is comprehensive, it is not always easy to quickly identify what really matters. To help with that, I've published a new edition of my\u2026","rel":"","context":"Dans &quot;AI&quot;","block_context":{"text":"AI","link":"https:\/\/dasini.net\/blog\/category\/ai\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":4662,"url":"https:\/\/dasini.net\/blog\/2021\/08\/03\/discovering-mysql-database-service-episode-1-introduction\/","url_meta":{"origin":8978,"position":1},"title":"Discovering MySQL Database Service &#8211; Episode 1 &#8211; Introduction","author":"Olivier DASINI","date":"3 ao\u00fbt 2021","format":false,"excerpt":"This is the first episode of \u201cDiscovering MySQL Database Service\u201c, a series of tutorials where I will show you, step by step, how to use MySQL Database Service and some other Oracle Cloud Infrastructure services. Like any series, in this episode I\u2019m going to give you some context and set\u2026","rel":"","context":"Dans &quot;Cloud&quot;","block_context":{"text":"Cloud","link":"https:\/\/dasini.net\/blog\/category\/cloud\/"},"img":{"alt_text":"MySQL Database Service","src":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2021\/06\/MDS_car_801x600.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2021\/06\/MDS_car_801x600.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2021\/06\/MDS_car_801x600.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2021\/06\/MDS_car_801x600.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":8808,"url":"https:\/\/dasini.net\/blog\/2026\/07\/21\/oci-cache-and-mysql-heatwave-better-together-for-high-performance-applications\/","url_meta":{"origin":8978,"position":2},"title":"OCI Cache and MySQL HeatWave: Better Together for High-Performance Applications","author":"Olivier DASINI","date":"21 juillet 2026","format":false,"excerpt":"Modern applications are expected to deliver instant responses while processing increasingly large volumes of data. Achieving this level of performance isn't simply a matter of making the database faster.It requires placing the right workload on the right layer of the architecture. Some operations require ultra-fast repeated reads, others demand transactional\u2026","rel":"","context":"Dans &quot;Coding&quot;","block_context":{"text":"Coding","link":"https:\/\/dasini.net\/blog\/category\/coding\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/07\/valkey-logo-og.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":5915,"url":"https:\/\/dasini.net\/blog\/2022\/07\/05\/interactively-explore-visualize-your-mysql-heatwave-data-with-apache-zeppelin\/","url_meta":{"origin":8978,"position":3},"title":"Interactively explore &#038; visualize your MySQL HeatWave data with Apache Zeppelin","author":"Olivier DASINI","date":"5 juillet 2022","format":false,"excerpt":"In this article I will show you how to properly configure Apache Zeppelin in order to take advantage of the Analytics and Machine Learning capabilities of MySQL HeatWave the MySQL in-memory query accelerator.","rel":"","context":"Dans &quot;Machine Learning&quot;","block_context":{"text":"Machine Learning","link":"https:\/\/dasini.net\/blog\/category\/machine-learning-en\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2022\/06\/Configure-Heatwave-Cluster.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2022\/06\/Configure-Heatwave-Cluster.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2022\/06\/Configure-Heatwave-Cluster.png?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2022\/06\/Configure-Heatwave-Cluster.png?resize=700%2C400 2x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2022\/06\/Configure-Heatwave-Cluster.png?resize=1050%2C600 3x"},"classes":[]},{"id":7929,"url":"https:\/\/dasini.net\/blog\/2025\/07\/03\/heatwave-mysql-database-audit\/","url_meta":{"origin":8978,"position":4},"title":"HeatWave MySQL Database Audit","author":"Olivier DASINI","date":"3 juillet 2025","format":false,"excerpt":"HeatWave MySQL Database Audit brings powerful enterprise-grade auditing capabilities to the cloud, allowing organizations to monitor and track database activity for security, compliance, and performance optimization. With features like customizable filters, real-time monitoring, minimal overhead, and seamless integration with MySQL tools, it enables administrators to log critical operations, detect threats,\u2026","rel":"","context":"Dans &quot;HeatWave&quot;","block_context":{"text":"HeatWave","link":"https:\/\/dasini.net\/blog\/category\/heatwave-en\/"},"img":{"alt_text":"HeatWave","src":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2024\/12\/HeatWave_logo.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2024\/12\/HeatWave_logo.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2024\/12\/HeatWave_logo.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2024\/12\/HeatWave_logo.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":5762,"url":"https:\/\/dasini.net\/blog\/2022\/06\/09\/explore-visualize-your-mysql-heatwave-data-with-superset\/","url_meta":{"origin":8978,"position":5},"title":"Explore &#038; visualize your MySQL HeatWave data with Superset","author":"Olivier DASINI","date":"9 juin 2022","format":false,"excerpt":"In this article I will show you how to properly configure Apache Superset in order to take advantage of a high performance, in-memory query accelerator: MySQL HeatWave.","rel":"","context":"Dans &quot;MySQL&quot;","block_context":{"text":"MySQL","link":"https:\/\/dasini.net\/blog\/category\/mysql-en\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2022\/06\/Configure-Heatwave-Cluster.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2022\/06\/Configure-Heatwave-Cluster.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2022\/06\/Configure-Heatwave-Cluster.png?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2022\/06\/Configure-Heatwave-Cluster.png?resize=700%2C400 2x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2022\/06\/Configure-Heatwave-Cluster.png?resize=1050%2C600 3x"},"classes":[]}],"jetpack_likes_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2025\/09\/rc24-heatwave-logo.gif?fit=770%2C550&ssl=1","_links":{"self":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/8978","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/comments?post=8978"}],"version-history":[{"count":24,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/8978\/revisions"}],"predecessor-version":[{"id":9013,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/8978\/revisions\/9013"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/media\/8340"}],"wp:attachment":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/media?parent=8978"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/categories?post=8978"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/tags?post=8978"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}