--- title: Data Daz (dasini.net) – Data Systems, AI, and Real-World... description: An overview of five MySQL HeatWave capabilities relevant to transactional (OLTP) workloads on Oracle Cloud Infrastructure: Autopilot Indexing for... canonical: https://daily.dev/posts/data-daz-dasini-net-data-systems-ai-and-real-world-insights-wypxekwjz twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Data Daz (dasini.net) – Data Systems, AI, and Real-World Insights | daily.dev og:description: An overview of five MySQL HeatWave capabilities relevant to transactional (OLTP) workloads on Oracle Cloud Infrastructure: Autopilot Indexing for... og:url: https://daily.dev/posts/data-daz-dasini-net-data-systems-ai-and-real-world-insights-wypxekwjz og:image: https://api.daily.dev/og/posts/WYPxekWjZ.png og:image:alt: Data Daz (dasini.net) – Data Systems, AI, and Real-World Insights og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Data Daz (dasini.net) – Data Systems, AI, and Real-World Insights **[Planet MySQL](https://daily.dev/sources/planet-mysql)** · 7 min read · 0 upvotes · 0 comments ## Summary An overview of five MySQL HeatWave capabilities relevant to transactional (OLTP) workloads on Oracle Cloud Infrastructure: Autopilot Indexing for workload-aware index recommendations, High Availability with automatic failover across three instances, Read Scaling via managed Read Replicas with a built-in load balancer, enterprise-grade security features (encryption at rest/in transit, data masking, audit, IAM), and fast DB System cloning for dev/test and cross-region disaster recovery. Each capability is illustrated with documentation links and, where applicable, SQL examples. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Questions this post answers ### How do I get MySQL to recommend which indexes to create or remove for my workload? MySQL HeatWave Autopilot Indexing analyzes SQL workload history from Performance Schema and recommends secondary indexes to create or remove, weighing both query performance gains and index-maintenance cost. Run it with CALL sys.autopilot_index_advisor(NULL) for all schemas, or pass a target_schema JSON object to scope it to specific schemas like 'sakila'. It reports expected performance improvement, storage impact, and DDL statements. _daily.dev surfaces practical database tuning approaches like this for engineers optimizing MySQL performance._ ### Does the primary database IP change when MySQL HeatWave fails over to a secondary instance? No, the read/write endpoint IP address stays the same when a MySQL HeatWave primary instance fails and a secondary is promoted. A highly available DB System runs three instances (one primary, two secondary) spread across availability or fault domains, and failover provides zero data loss with minimal downtime while applications keep using the same endpoint. _Teams designing resilient MySQL architectures can track failover behavior details like this on daily.dev._ ### How does MySQL HeatWave load balance traffic across read replicas? MySQL HeatWave automatically creates a Read Replica Load Balancer as soon as the first read replica is provisioned. All replicas on the DB System are registered as backends automatically, and read traffic is distributed among active replicas, while updates from the primary replicate to them asynchronously and each replica also keeps its own individual endpoint. _daily.dev helps engineers comparing read-scaling options stay current on managed database features like this._ ## Similar posts on daily.dev - [AI is redrawing the database market](https://daily.dev/posts/ai-is-redrawing-the-database-market-pf0m4okv9) · ClickHouse · 3 upvotes · 0 comments - [Data warehousing in the AI era starts with sovereignty](https://daily.dev/posts/data-warehousing-in-the-ai-era-starts-with-sovereignty-kkwjnjhi7) · The Register · 0 upvotes · 0 comments - [Introducing intelligent database observability: from alerts to answers at scale](https://daily.dev/posts/introducing-intelligent-database-observability-from-alerts-to-answers-at-scale-bom3uzhsq) · Dynatrace · 0 upvotes · 0 comments --- Tags: [#database](https://daily.dev/tags/database), [#mysql](https://daily.dev/tags/mysql), [#oracle](https://daily.dev/tags/oracle) [View this post on daily.dev](https://daily.dev/posts/data-daz-dasini-net-data-systems-ai-and-real-world-insights-wypxekwjz) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"Data Daz (dasini.net) – Data Systems, AI, and Real-World Insights","url":"https://daily.dev/posts/data-daz-dasini-net-data-systems-ai-and-real-world-insights-wypxekwjz","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/data-daz-dasini-net-data-systems-ai-and-real-world-insights-wypxekwjz"},"datePublished":"2026-09-30T14:54:32.822Z","dateModified":"2026-09-30T14:55:12.131Z","description":"An overview of five MySQL HeatWave capabilities relevant to transactional (OLTP) workloads on Oracle Cloud Infrastructure: Autopilot Indexing for...","image":"https://i0.wp.com/dasini.net/blog/wp-content/uploads/2025/09/rc24-heatwave-logo.gif?resize=770%2C550&ssl=1","thumbnailUrl":"https://i0.wp.com/dasini.net/blog/wp-content/uploads/2025/09/rc24-heatwave-logo.gif?resize=770%2C550&ssl=1","isAccessibleForFree":true,"articleSection":"Planet MySQL","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"Planet MySQL","logo":"https://media.daily.dev/image/upload/s--UKAtmXTq--/f_auto,q_auto/v1780213421/logos/planet-mysql?_a=BAMAMiWQ0","url":"https://daily.dev/sources/planet-mysql"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/data-daz-dasini-net-data-systems-ai-and-real-world-insights-wypxekwjz","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"database,mysql,oracle","timeRequired":"PT7M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Planet MySQL","item":"https://daily.dev/sources/planet-mysql"},{"@type":"ListItem","position":3,"name":"Data Daz (dasini.net) – Data Systems, AI, and Real-World Insights"}]} {"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/data-daz-dasini-net-data-systems-ai-and-real-world-insights-wypxekwjz#faq","mainEntity":[{"@type":"Question","name":"How do I get MySQL to recommend which indexes to create or remove for my workload?","acceptedAnswer":{"@type":"Answer","text":"MySQL HeatWave Autopilot Indexing analyzes SQL workload history from Performance Schema and recommends secondary indexes to create or remove, weighing both query performance gains and index-maintenance cost. Run it with CALL sys.autopilot_index_advisor(NULL) for all schemas, or pass a target_schema JSON object to scope it to specific schemas like 'sakila'. It reports expected performance improvement, storage impact, and DDL statements. daily.dev surfaces practical database tuning approaches like this for engineers optimizing MySQL performance."}},{"@type":"Question","name":"Does the primary database IP change when MySQL HeatWave fails over to a secondary instance?","acceptedAnswer":{"@type":"Answer","text":"No, the read/write endpoint IP address stays the same when a MySQL HeatWave primary instance fails and a secondary is promoted. A highly available DB System runs three instances (one primary, two secondary) spread across availability or fault domains, and failover provides zero data loss with minimal downtime while applications keep using the same endpoint. Teams designing resilient MySQL architectures can track failover behavior details like this on daily.dev."}},{"@type":"Question","name":"How does MySQL HeatWave load balance traffic across read replicas?","acceptedAnswer":{"@type":"Answer","text":"MySQL HeatWave automatically creates a Read Replica Load Balancer as soon as the first read replica is provisioned. All replicas on the DB System are registered as backends automatically, and read traffic is distributed among active replicas, while updates from the primary replicate to them asynchronously and each replica also keeps its own individual endpoint. daily.dev helps engineers comparing read-scaling options stay current on managed database features like this."}}]} ```