MySQL HeatWave cluster

ociData warehouseoci-mysql-heatwave-cluster

In-memory hybrid columnar accelerator attached to a MySQL HeatWave DB system for analytics without ETL.

Provider
oci
Category
Data
Properties · 4 set by this component
propertytypevaluesrequiredkind defaultthis component
autoMl · component propertyboolean—no—inherited
formatenumcolumnar | rownocolumnar▸ columnar
lakehouse · component propertyboolean—no—inherited
managedboolean—nofalse▸ true
realtimeboolean—nofalse▸ true
upsertboolean—nofalse▸ true
Rules that apply · 0

Every rule whose selector covers this component's kind or its category. Whether a rule fires depends on the design: its properties, its edges and its groups.

No rule reads this kind yet. That is a gap, not a guarantee.
Use it in a design
nodes:
  - { id: "mysql-heatwave-cluster", component: "oci-mysql-heatwave-cluster" }
Other Data warehouse products · 39
AnalyticDBalibaba-analyticdbalibabaclouddata-warehouseApsaraDB for ClickHousealibaba-clickhousealibabaclouddata-warehouseHologresalibaba-hologresalibabaclouddata-warehouseMaxComputealibaba-maxcomputealibabaclouddata-warehouseApsaraDB for SelectDBalibaba-selectdbalibabaclouddata-warehouseAmazon Athenaaws-athenaawsdata-warehouseAmazon Redshiftredshiftawsdata-warehouseAzure Analysis Servicesazure-analysis-servicesazuredata-warehouseMicrosoft Fabricazure-fabricazuredata-warehouseAzure Synapse Analyticsazure-synapseazuredata-warehouseR2 SQLcloudflare-r2-sqlcloudflaredata-warehouseClickHouseclickhousedata-warehouseGeneric data warehousedata-warehousedata-warehouseDatabricks SQLdatabricks-sqldata-warehouseApache Dorisdorisdata-warehouseDremiodremiodata-warehouseApache Drilldrilldata-warehouseApache Druiddruiddata-warehouseDuckDBduckdbdata-warehouseExasolexasoldata-warehouseFireboltfireboltdata-warehouseGreenplumgreenplumdata-warehouseApache Hivehivedata-warehouseApache Impalaimpaladata-warehouseApache Kylinkylindata-warehouseMonetDBmonetdbdata-warehouseMotherDuckmotherduckdata-warehouseApache Pinotpinotdata-warehousePrestoprestodata-warehouseSnowflakesnowflakedata-warehouseStarRocksstarrocksdata-warehouseTeradata Vantageteradatadata-warehouseTrinotrinodata-warehouseVerticaverticadata-warehouseGoogle BigQuerybigquerygcpdata-warehouseDb2 Warehouse as a Serviceibm-db2-warehouseibmdata-warehouseNetezza Performance Server as a Serviceibm-netezzaibmdata-warehouseIBM watsonx.dataibm-watsonx-dataibmdata-warehouseAutonomous AI Lakehouseoci-autonomous-data-warehouseocidata-warehouse
Source
# yaml-language-server: $schema=../../schema/component.schema.json
# MySQL HeatWave cluster: the in-memory query accelerator added to a MySQL HeatWave DB system.
# "Features of MySQL HeatWave Service" describes it as a distributed, scalable, shared-nothing,
# in-memory, hybrid columnar query processing engine loaded from InnoDB, so analytics run on the
# transactional data with no ETL copy; it is added to a DB system, not created on its own.
schemaVersion: "1"
type: "component"
id: "oci-mysql-heatwave-cluster"
kind: "data-warehouse"
provider: "oci"
docs: "https://docs.oracle.com/en-us/iaas/mysql-database/doc/features-mysql-heatwave-service.html"
defaults:
  managed: true
  realtime: true
  format: "columnar"
  upsert: true
properties:
  lakehouse:
    type: "boolean"
  autoMl:
    type: "boolean"

The same page as markdown, for an agent: /catalogue/components/oci-mysql-heatwave-cluster.md