Learn
All topics

CLI

0 tutorials · 10 guides

Tutorials

Intermediate

How to Install Ghost CMS on Ubuntu 24.04 with Nginx

Install Ghost CMS on Ubuntu 24.04 with Nginx, Node.js 22, MySQL 8, Ghost-CLI, HTTPS, backups, rollback, and current Ghost 6 deployment guidance.

25 min read
Ghost CMSUbuntu 24.04Nginx
Intermediate

How to Self-Host Plausible Analytics on Ubuntu 24.04 with Docker

Self-host Plausible Analytics CE on Ubuntu 24.04 with Docker Compose, automatic HTTPS, protected secrets, health checks, backups, and safe upgrades.

21 min read
Plausible AnalyticsPlausible CEDocker Compose
Beginner

How to Use Raff S3-Compatible Object Storage with AWS CLI

Use AWS CLI with Raff S3-compatible object storage on Ubuntu 24.04. Configure scoped credentials, transfer files, sync safely, and create presigned URLs.

16 min read
Object StorageS3AWS CLI

Guides

For: Data engineers and platform teams monitoring ClickHouse query health, ingestion freshness, merges, replication, and production capacity.

ClickHouse Monitoring: Queries, Merges, Replication & Alerts

Monitor ClickHouse query latency, rows read, memory, parts, merges, mutations, replication, Keeper, disk growth, and ingestion freshness with actionable alerts.

12 min read
ClickHouseMonitoringQueries
For: Data engineers and platform teams designing ClickHouse replication, backups, restore testing, and disaster recovery for production analytics.

ClickHouse Backup & Replication: Availability, Recovery & Restore

Plan ClickHouse backups and replication: distinguish replicas from backups, define RPO/RTO, monitor Keeper, and test restores.

13 min read
ClickHouseBackupReplication
For: Data engineers and platform teams designing ClickHouse MergeTree partitioning, TTL retention, and lifecycle operations for production analytics.

ClickHouse Partitioning & TTL: MergeTree & Retention Trade-Offs

Design ClickHouse partitioning and TTL for MergeTree: choose coarse partitions, use ORDER BY for queries, and manage retention without excess parts.

12 min read
ClickHousePartitioningTTL
For: Data engineers, developers, and platform teams using ClickHouse materialized views to accelerate repeated analytical queries and rollups.

ClickHouse Materialized Views: Pre-Aggregation & Query Trade-Offs

Compare ClickHouse materialized views for pre-aggregation: incremental vs refreshable designs, backfills, write costs, and correctness trade-offs.

12 min read
ClickHouseMaterialized ViewsAnalytics
For: Developers, founders, SaaS teams, and small businesses comparing database hosting services for production applications.

Database Hosting Services: How to Choose for Production Apps

Compare database hosting services for production apps by engine support, backups, PITR, HA, private networking, connections, pricing, migration, and support.

15 min read
Database HostingManaged DatabasesPostgreSQL
For: Data engineers and developers optimizing ClickHouse tables and queries for production dashboards, event analytics, and high-concurrency analytical workloads.

ClickHouse Performance Tuning: ORDER BY, Keys & Query Optimization

Improve ClickHouse query performance with better ORDER BY and sorting keys, lower scan volume, and controlled memory, joins, and concurrency.

13 min read
ClickHousePerformance TuningQuery Optimization
For: Developers, data engineers, founders, and platform teams deciding whether to use managed ClickHouse or operate ClickHouse themselves for production analytics.

Managed ClickHouse vs Self-Hosted ClickHouse: Cost, Scaling & Ownership

Compare managed and self-hosted ClickHouse across pricing models, scaling, backups, HA, operational ownership, and total cost for production analytics.

16 min read
ClickHouseManaged DatabasesDatabase Hosting
For: MSP owners, cloud architects, and operations teams designing isolated client networks, technician access, shared-service paths, recovery boundaries, and offboarding for managed cloud customers.

Private Cloud Networking for MSPs: Secure Client Isolation

Private cloud networking for MSPs: design per-client VPCs, client isolation, network segmentation, admin access, peering, VPNs, recovery, and offboarding.

16 min read
MSPPrivate NetworkingVPC
For: Developers, data engineers, founders, and small platform teams designing ClickHouse ingestion, schema, retention, query performance, and production ownership

ClickHouse Architecture for Production Analytics: Ingestion & Operations

Understand ClickHouse architecture for production analytics across ordering keys, ingestion, partitions, TTL, materialized views, replication, and monitoring.

15 min read
ClickHouseAnalyticsManaged Databases
For: Developers, founders, and platform teams building reviewable and recoverable infrastructure automation on Raff

Infrastructure Automation on Raff: Scripts, Cloud-Init, APIs, and IaC

Understand infrastructure automation on Raff across Terraform, API, CLI, cloud-init, credentials, drift, approvals, recovery, and operating boundaries.

13 min read
Infrastructure AutomationInfrastructure as CodeTerraform

Learn something new every week

The tutorials, guides, and comparisons we publish, rounded up in one weekly email. Unsubscribe anytime.

Put it into practice

Spin up a Linux or Windows server and follow any tutorial here on real infrastructure. RDP and SSH ready, 14-day money-back guarantee.

Deploy a server