---
title: "Deploy MariaDB ColumnStore"
description: "[Jul'26] Open-source MariaDB columnar database for analytics"
category: "Analytics"
url: https://railway.com/deploy/mariadb-columnstor-1
---

# Deploy MariaDB ColumnStore

[Jul'26] Open-source MariaDB columnar database for analytics

**[Deploy MariaDB ColumnStore on Railway](https://railway.com/template/mariadb-columnstor-1)**

Machine-readable deploy manifest (JSON, validated by TemplateCI): https://railway.com/deploy/mariadb-columnstor-1/manifest.json

- **Creator:** codestorm
- **Category:** Analytics
- **Total deploys:** 2

## Template content

### columnstore https://elest.io/images/softwares/357/logo.png

- **Image:** mariadb/columnstore:latest

## Documentation

# Deploy and Host MariaDB ColumnStore on Railway

MariaDB ColumnStore is an open-source columnar database built on MariaDB Server for analytical SQL workloads. Unlike traditional row-based databases, it stores data by columns, making it suitable for BI dashboards, reporting, aggregations, and large-scale read-heavy analytics where queries often scan selected columns across many rows.

## About Hosting MariaDB ColumnStore

Hosting MariaDB ColumnStore on Railway provides a simple way to deploy a self-hosted columnar analytics database without manually managing servers or infrastructure. This template runs MariaDB ColumnStore as a single-node database service with persistent storage, making it useful for testing OLAP workloads, running analytical SQL queries, building reporting backends, and experimenting with columnar database performance.

MariaDB ColumnStore is best suited for read-heavy analytical workloads such as `GROUP BY`, `COUNT`, `SUM`, filtering, and reporting queries. It is not intended to replace a standard MariaDB or MySQL database for high-frequency transactional application workloads.

## Common Use Cases

* BI dashboards and analytical SQL workloads
* Reporting databases for aggregated business data
* Columnar database testing, prototyping, and learning

## Dependencies for MariaDB ColumnStore Hosting

* MariaDB ColumnStore Docker image
* Railway persistent volume for ColumnStore data

### Deployment Dependencies

* MariaDB ColumnStore Docker image: `mariadb/columnstore`
* Railway TCP Proxy for external database access
* Railway Volume mounted to persist ColumnStore data

### Implementation Details

This template uses MariaDB ColumnStore as a single-node analytics database. The service exposes the standard MariaDB/MySQL port:

```txt
3306
```

Recommended volume mount path:

```txt
/var/lib/columnstore
```

Recommended environment variables:

```env
ADMIN_HOST=%
ADMIN_USER=Admin
ADMIN_PASS=C0lumnStore!
CEJ_USER=cej
CEJ_PASS=C0lumnStore!
CGROUP=./
CMAPI_KEY=somekey123
PM1=${{RAILWAY_PRIVATE_DOMAIN}}
USE_S3_STORAGE=false
```

Optional S3-related variables can be configured when external object storage is required:

```env
S3_ACCESS_KEY_ID=
S3_SECRET_ACCESS_KEY=
S3_BUCKET=
S3_ENDPOINT=
S3_REGION=
```

To connect from outside Railway, enable TCP Proxy and connect using a MySQL-compatible client:

```bash
mysql -h  -P  -u Admin -p
```

Example ColumnStore table:

```sql
CREATE DATABASE analytics;

USE analytics;

CREATE TABLE sales_events (
  id BIGINT,
  customer_id BIGINT,
  country VARCHAR(64),
  amount DECIMAL(12,2),
  created_at DATETIME
) ENGINE=Columnstore;
```

Example analytical query:

```sql
SELECT country, SUM(amount) AS total_amount
FROM sales_events
GROUP BY country;
```

## Why Deploy MariaDB ColumnStore on Railway?

Railway is a singular platform to deploy your infrastructure stack. Railway will host your infrastructure so you don't have to deal with configuration, while allowing you to vertically and horizontally scale it.

By deploying MariaDB ColumnStore on Railway, you are one step closer to supporting a complete full-stack application with minimal burden. Host your servers, databases, AI agents, and more on Railway.


## Similar templates

- [Plausible WordPress](https://railway.com/deploy/deploy-plausible-for-wordpress-sites) — Cookie-free WordPress stats from your own Plausible
- [Typesense Multilingual](https://railway.com/deploy/deploy-typesense-multilingual-search) — Locale-aware multilingual search with Typesense
- [Formbricks](https://railway.com/deploy/formbricks-surveys) — Surveys, NPS and in-app feedback on your own Postgres, Hub and Cube

Open this page in a browser: https://railway.com/deploy/mariadb-columnstor-1
