OLTP中的MySQL HeatWave介绍（英文版）

MySQL HeatWave Overview

Introduction

• Purpose: Simplify and accelerate time to value by reducing costs and risks.
• Benefits:
  • Eliminate the need for manual system and database administration.
  • Provide complete automation for database lifecycle operations.
  • Ensure secure and unified data architecture.
  • Support multiple workload types.
  • Integrate transactions, analytics, and machine learning (ML).

MySQL HeatWave: Fully Automated Database as a Service

• Key Features:
  • Automation: Automatically configure, secure, update, tune, and scale databases.
  • Workload Optimizations: Unified platform for transactions and analytics.
  • Efficient Lifecycle Management: Eliminate infrastructure management by offloading it to Oracle.
  • Built-in Observability: Expanded database metrics and query performance diagnostics.

OLTP with MySQL HeatWave

• Server Side Capabilities:
  • InnoDB Transactional Storage Engine: ACID compliant, supports foreign key constraints, stored procedures, triggers, views, and SQL optimizers.
  • Performance Enhancements: Common Table Expressions, window functions, and invisible indexes.
  • Document Store: Supports both SQL and NoSQL document applications.
  • GIS: Enhanced support for geospatial data.
  • Security: OpenSSL as the default TLS/SSL library.
  • Query Acceleration: Performance schema with up to 30x faster queries.

MySQL HeatWave Components

• MySQL DB System:
  • Compute Instance: Resources defined by the associated shape.
  • Two Default Configurations: Standalone and HA.
  • Operating System: Oracle Linux OS.
  • Shapes: ECPU and OCPU.
  • Networking: Virtual Network Interface Card (VNIC) attached to a subnet of the Virtual Cloud Network (VCN).
  • Storage: Network-attached block storage using the OCI Block Volume service.
  • Performance: Up to 50,000 IOPS per volume, 680 MB/s throughput.

MySQL HeatWave Scalability

• Read Replicas:
  • Horizontal Read Elasticity: Increase capacity for read-intensive workloads.
  • Load Balancing: 5-tuple hash policy for load balancing.
  • Maximum Read Replicas: 18 per DB system.
  • Cross Region Replicas: Outbound replication to another OCI region, not managed by MySQL HeatWave.

Data Protection and Durability

• Backups:
  • Automatic Backups: Created at a specified interval with a retention period of 1 to 35 days.
  • Manual Backups: Created via the Console or REST API, retained for 1 to 365 days.
  • Operator Backups: Created by MySQL Support for issue investigation.
• Point-In-Time Recovery:
  • RPO: Approximately five minutes for an active DB system, 24 hours for daily backups.
  • Prerequisites: Enable automatic backups and point-in-time recovery.
  • Service: Takes initial full backup followed by incremental backups.

High Availability

• HA DB System:
  • Components: Primary instance and two secondary instances.
  • Uptime: SLA of 99.99%.
  • Failover: Automatic and manual switchover.
  • Upgrades: Rolling upgrades during maintenance with minimal downtime.
  • RTO and RPO: Detailed service level objectives for failure and maintenance events.

Summary

MySQL HeatWave offers a fully automated, managed database service designed to simplify database management, reduce costs, and enhance security and reliability. It supports various workloads and integrates seamlessly with existing systems, providing advanced features like automatic upgrades, comprehensive observability, and robust data protection mechanisms.