MatrixOne HTAP Database - MySQL Compatible

This is a repackaged open source software product wherein additional charges apply for cloudimg support services.

## Overview

MatrixOne is the open source hyperconverged database that serves transactional and analytical workloads from a single engine. The same system that records rows can also answer aggregate queries over them, so an HTAP deployment needs neither a separate warehouse nor a pipeline to copy data between the two. MatrixOne speaks the MySQL network protocol, so existing MySQL clients, drivers, BI tools and application code connect to it unchanged and familiar SQL works as written. This AMI delivers a fully configured, security hardened MatrixOne node that accepts queries within minutes of launch, eliminating the manual installation, runtime configuration and credential hardening a bare install requires.

## Why This Image Over Alternatives

Upstream MatrixOne ships two built in accounts that both use a well known published password. Rather than change them after the fact, this image bootstraps the catalogue with a password generated uniquely on each instance first boot, so the published credential never exists on your instance at all, and first boot refuses to complete if either account would still accept it. Where a self managed install co locates database files on the OS disk, this image isolates the entire MatrixOne data store on a dedicated, independently resizable EBS volume. Memory limits adapt automatically to the instance size you run, so the same image behaves correctly from a small evaluation node to a large analytical instance.

## What Is Included

• MatrixOne 4.1.2 installed from the official upstream release archive and SHA-256 verified, running as a standalone single node deployment
• MySQL wire protocol on port 6001, so any MySQL client, driver or tool connects unchanged
• Native vector columns (VECF32) with distance functions for similarity search
• Fulltext indexing with MySQL compatible MATCH ... AGAINST keyword search
• Dedicated data volume for the catalogue, transaction log and fileservice caches
• Prometheus metrics exposed on port 7001 for monitoring

## Secure First Boot

On first boot a one shot service generates a cryptographically strong password for the root account, unique to that instance, seeds it before the catalogue is ever created, gives the built in dump account its own separate secret, and writes both to a file readable only by root. No shared or default database credential ever exists in the image, and first boot fails closed if the published upstream password would still authenticate.

## AWS Integration Points

• Amazon EBS - the MatrixOne data store lives on a dedicated EBS volume; use EBS Snapshots for point in time backups or resize storage independently of the OS disk.
• Amazon VPC - deploy within private subnets and control access with security groups; the database port 6001 is closed by default and opened only where you choose.
• AWS Backup - schedule automated, policy driven backups of the data volume without custom scripting.

## Ready To Use

Connect over SSH, read the generated root password from the root only credentials file, and open any MySQL client against port 6001 to create databases and tables, run vector similarity search, and run fulltext keyword search. The node runs as a standalone single node deployment by default.

## Use Cases

• Real time transactional and analytical processing - record rows and answer aggregate queries over them in one engine, with no extract step and no second system to keep in sync, so finance teams can generate dashboards from the same engine that records transactions instead of waiting on end of day reconciliation.
• Similarity search and recommendation - store product embeddings in native vector columns and rank nearest neighbours with distance functions next to your relational catalog, surfacing personalized recommendations without a separate vector store or a nightly ETL job.
• Keyword and semantic retrieval - back fulltext keyword lookup and vector retrieval from the same database that holds the source rows, powering hybrid search features for SaaS applications without operating multiple backends.
• MySQL compatible workloads - run applications and BI tools that speak the MySQL protocol against a database you operate on your own infrastructure, with no driver changes.

## cloudimg Support

24/7 technical support by email and live chat. Our engineers assist with deployment, connectivity, data modeling, performance tuning, and database administration. Critical issues receive a one hour average response time.

All product and company names are trademarks or registered trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.