MySQL HeatWave on OCI: Five Capabilities for Transactional Workloads

OCI Open Source Service Update – Sept. 2026
Explore how MySQL HeatWave on Oracle Cloud Infrastructure helps optimize, protect, and scale MySQL applications.
Covers Autopilot Indexing, high availability with automatic failover, managed read replicas, enterprise security, and fast DB system cloning for development, testing, and regional recovery.

Transcript

1. OCI Open Source Service Update – Sept. 2026 MySQL HeatWave Core Capabilities Five capabilities for transactional MySQL workloads Olivier DASINI MySQL Solution Architect Open Source Data Black Belt @ Oracle
2. MySQL HeatWave: the OLTP picture Requirement MySQL HeatWave capability Optimize transactional performance Autopilot Indexing Protect against instance or infrastructure failure High Availability Scale read-intensive applications Managed Read Replicas Protect sensitive and regulated data MySQL Enterprise Security Provision copies and prepare for regional recovery DB System Cloning A managed platform for index analysis, failover, replica management, security, and database provisioning. 2
3. Autopilot Indexing Workload-aware index recommendations for OLTP
4. Autopilot Indexing Workload-aware index recommendations for OLTP SQL workload history Performance and index cost Performance Schema supplies the workload history used to recommend secondary indexes to create or remove. Recommendations balance query performance with the storage and write overhead of maintaining indexes. Decision support Actionable recommendations Review expected performance gains, storage impact, index creation time, and the most affected queries. The advisor provides DDL statements and an explanation for each recommendation. 4
5. Autopilot Indexing examples Analyze all user schemas CALL sys.autopilot_index_advisor(NULL); Analyze a specific schema CALL sys.autopilot_index_advisor( JSON_OBJECT( 'target_schema', JSON_ARRAY('sakila') ) ); 5
6. High Availability with Automatic Failover Built-in resilience for business-critical MySQL workloads
7. High Availability Three MySQL instances One primary and two secondary instances. Instances span availability domains or fault domains, depending on the region and network configuration. 7
8. Automatic failover The same endpoint The service promotes a secondary when the primary fails. Zero data loss and minimal downtime. The read/write endpoint IP address stays the same. 8
9. Read Scaling with Managed Read Replicas Scale read-intensive applications without scaling the primary database
10. Read scaling with managed replicas Independent read capacity Asynchronous replication offloads read workloads. Use individual replica endpoints or the automatically created Read Replica Load Balancer. 10
11. Enterprise-Grade Security Built In MySQL Enterprise Edition capabilities as a managed service
12. Enterprise security built in MySQL Enterprise Edition capabilities as a managed service Encryption at rest Data masking Protect DB System storage and backups with OCI-managed keys or customer-managed keys in OCI Vault. Hide or transform sensitive values with SQL functions for email addresses, payment cards, and other personal data. MySQL Enterprise Audit OCI IAM Record database connections, disconnections, and access to databases and tables. Apply least-privilege policies to MySQL HeatWave resources at tenancy and compartment level. 12
13. Encrypted application connections TLS protects data in transit between applications and MySQL. Require encryption for an individual MySQL user CREATE USER 'app_user'@'10.0.1.%' IDENTIFIED BY 'S€curP@s5W0rd&' REQUIRE SSL; Replace the placeholder password with the application user’s credential. 13
14. Fast Cloning for Development, Testing, & Disaster Recovery Create a new DB System directly from an existing database
15. Cloning for development and testing Separate environments Create a new DB System directly from an existing one. Provision realistic development and test databases without manually coordinating backups and restores. 15
16. Cloning for regional recovery Another OCI region Clone within a region or into another region. The cloning workflow can optionally configure a replication channel between the source and the clone. 16
17. Traditional cross-region setup Several manual steps Back up the source. Copy the backup to the target region. Restore the DB System. Configure replication. 17
18. Resources
19. Resources: performance and availability Autopilot Indexing MySQL HeatWave — Autopilot Indexing documentation Autopilot Indexing examples Removing the index guesstimate with MySQL Autopilot Indexing High Availability MySQL HeatWave — High Availability overview MySQL HeatWave — Failover MySQL Database Service with High Availability 19
20. Resources: scaling, security, and cloning Read Replicas MySQL HeatWave — Read Replica documentation Announcing MySQL HeatWave Read Replicas with Load Balancer Enterprise Security MySQL HeatWave — Security Best Practices MySQL HeatWave — Data Masking MySQL HeatWave — MySQL Enterprise Audit DB System Cloning MySQL HeatWave — Creating a DB System Clone Create Replica DB System Made Easy for MySQL HeatWave Service on OCI 20