Hydra

Database512MB+ RAM

Postgres-compatible columnar database for fast analytics queries

Download Server Compass View Documentation

databasecolumnaranalyticspostgres-compatible

Deploy Hydra in 3 Steps

Connect Your VPS

Add your server credentials to Server Compass

Select Hydra

Choose from our template library

Deploy & Configure

Fill in settings and click Deploy

No Docker knowledge required

Self-Deploy Guide

DIY Hydra Deployment

Learn how to self-host Hydra with this hands-on deployment guide.

Start a Secure Shell Session

Open your terminal and connect to your server. Replace the IP address with your VPS IP.

terminal

# SSH into your server
ssh root@your-server-ip

# Using a custom SSH key
ssh -i ~/.ssh/id_rsa root@your-server-ip

First time? Need Docker? Install it: curl -fsSL https://get.docker.com | sh

Prepare Your Workspace

Set up a clean directory for your application.

terminal

# Create and navigate to project directory
mkdir -p ~/apps/hydra
cd ~/apps/hydra

Set Up Container Configuration

Set up the container stack using this Docker Compose configuration:

docker-compose.yml

services:
  hydra:
    image: ghcr.io/hydradatabase/hydra:latest
    ports:
      - "5432:5432"
    environment:
      - POSTGRES_USER=hydra
      - POSTGRES_PASSWORD=<your-postgres-password>
      - POSTGRES_DB=hydra
    volumes:
      - hydra_data:/var/lib/postgresql/data
    restart: unless-stopped
    healthcheck:
      test: ["CMD-SHELL", "pg_isready -U hydra -d hydra"]
      interval: 10s
      timeout: 5s
      retries: 5

volumes:
  hydra_data:

Setup Variables

PORTHost port(default: 5432)

POSTGRES_USERUsername(default: hydra)

POSTGRES_PASSWORDPassword

POSTGRES_DBDatabase(default: hydra)

Bring Up the Application

Launch your application stack in the background.

terminal

# Start the containers in detached mode
docker compose up -d

# Check if containers are running
docker compose ps

# View logs
docker compose logs -f

Configure Firewall

Configure your firewall to permit external connections.

terminal

# Allow the application port through firewall
sudo ufw allow 5432/tcp
sudo ufw reload

# Access your app at:
# http://your-server-ip:5432

Skip the Terminal

Prefer a visual interface? Use Server Compass.

Let Server Compass handle the complexity. Deploy Hydra with a simple, intuitive interface.

Visual configuration UI
One-click deployment
Automatic SSL setup
Zero-downtime updates
Built-in monitoring
One-click rollbacks

Download Server Compass$29 one-time • Lifetime license

After Deployment

After deploying Hydra with Server Compass, complete these steps to finish setup

Connect with psql or any Postgres client

Create columnar tables with USING columnar

Load data for analytics

Need help? Check out our documentation for detailed guides.

Hydra FAQ

Common questions about self-hosting Hydra

How do I deploy Hydra with Server Compass?

Simply download Server Compass, connect to your VPS, and select Hydra from the templates list. Fill in the required configuration and click Deploy. The entire process takes under 3 minutes.

What are the system requirements for Hydra?

Hydra requires a minimum of 512MB RAM. We recommend a VPS with at least 1024MB RAM for optimal performance. Any modern Linux server with Docker support will work.

Can I migrate my existing Hydra data?

Yes! Server Compass provides volume mapping that allows you to import existing data. You can also use standard Hydra backup and restore procedures.

How do I update Hydra to the latest version?

Server Compass makes updates easy. Simply click the Update button in your deployment dashboard, and the latest Hydra image will be pulled and deployed with zero downtime.

Is Hydra free to self-host?

Hydra is open-source software. You only pay for your VPS hosting (typically $5-20/month) and optionally Server Compass ($29 one-time). No subscription fees or per-seat pricing.