MatrixOne on Ubuntu 24.04 LTS by cloudimg

MatrixOne on Ubuntu 24.04 LTS

MatrixOne is an open source hyperconverged database that serves transactional and analytical workloads from a single engine, so the same system that records rows can also answer aggregate queries over them without a separate warehouse or a pipeline to copy data between the two. It speaks the MySQL wire protocol, so existing MySQL clients, drivers, BI tools and application code connect to it unchanged. Alongside ordinary relational tables it provides native vector columns with distance functions for similarity search and fulltext indexing with MATCH AGAINST queries, so one database can back semantic retrieval, keyword lookup and conventional reporting at the same time. This cloudimg image installs MatrixOne 4.1.2 from the official upstream release, SHA 256 verified, and runs it as a standalone single node deployment.

What is included

• MatrixOne 4.1.2, installed from the official upstream release archive and SHA 256 verified
• A standalone single node deployment run by systemd, serving the MySQL protocol on port 6001
• Native vector columns with distance functions, and fulltext indexing with MATCH AGAINST
• A unique per VM database password generated on first boot, with no shared default credential
• Database storage on a dedicated 40 GiB Azure data disk
• Memory limits that adapt automatically to the size of the VM you run
• 24/7 cloudimg support

Secure by default

Upstream MatrixOne bootstraps two built in accounts that both use a well known published password. This image never ships that credential. The database store is empty in the image, and on first boot the catalogue is created with a password generated uniquely for your VM, so the published default never exists on your instance; first boot deliberately fails rather than completing if either account would still accept it. Credentials are written to a root only file and the database port is not exposed by the network security group, so the engine is reached over an SSH tunnel or a rule you add yourself.

Licensing and support

MatrixOne is licensed under the Apache License 2.0 and is free. The cloudimg charge of 0.04 US dollars per vCPU hour covers packaging, security patching, image maintenance and 24/7 expert support. Standard_B4ms is a good starting point. Guide: https://www.cloudimg.co.uk/guides/matrixone-on-ubuntu-24-04-azure/