The Nxeon Blog
Guides for people who run their own servers.
Straight-talking tutorials and comparisons on VPS hosting, game servers, Linux and security. No fluff, just what actually works. 346 guides from the team that runs the servers.
Search results
30 guides for “sql” in Tutorials · Clear search
How to Set Up Health Checks and Auto-Restart for Services
Services crash. With systemd restart policies, watchdogs and simple health checks, yours come back automatically instead of staying down until you notice.

How to Tune Linux Performance for a Busy Server
When traffic climbs, defaults hold you back. Tune file limits, network buffers, sysctl parameters and services to squeeze more out of your VPS.

How to Set Up Automated Backups on a VPS
A backup you never tested isn't a backup. Build an automated, offsite, restorable backup routine for files and databases with rsync, cron and the 3-2-1 rule.

How to Self-Host FreshRSS on a VPS
Take back control of your reading with a self-hosted RSS reader. Install FreshRSS on a VPS with Docker and sync it to your favourite mobile app.

How to Self-Host Grafana and Prometheus for Monitoring
The classic open-source monitoring stack. Install Prometheus and Grafana on a VPS with Docker, collect server metrics, and build dashboards that actually help.

How to Self-Host Ghost Blog on a VPS
Ghost is a fast, focused publishing platform with built-in memberships and newsletters. Install it on a VPS with Docker and HTTPS in under half an hour.

How to Self-Host n8n (Workflow Automation) on a VPS
A self-hosted Zapier alternative with no per-task fees. Install n8n on a VPS with Docker and HTTPS and automate anything with hundreds of integrations.

How to Self-Host Nextcloud on a VPS
For anyone who wants Dropbox-style file sync without the subscription or the snooping: install Nextcloud on your own VPS with Docker Compose and HTTPS.

How to Migrate WordPress to a New VPS
Moving WordPress to a new VPS without downtime is straightforward if you do it in the right order. This guide walks the manual method and the low-risk cutover.

How to Install WordPress on a VPS (LEMP Stack)
A complete, copy-paste walkthrough to install WordPress on Ubuntu with Nginx, MariaDB and PHP — the fast LEMP stack — plus free HTTPS at the end.

How to Install code-server (VS Code in the Browser)
Run VS Code in your browser from your VPS: install code-server on Ubuntu 24.04, secure it behind Nginx with HTTPS, and code from anywhere.

How to Run Staging and Production on One VPS
Host both a staging and production environment on a single VPS: separate directories, ports, subdomains, databases, and Nginx server blocks.
Deploy your first server in under a minute.
Creating an account is free and takes no card details. Every guide here runs on a Nxeon VPS or game server.