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
48 guides for “sql” · 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 Secure a Self-Hosted WordPress Site
WordPress powers a huge share of the web, which makes it a huge target. Harden your self-hosted install at the server, app, and login layers.
How to Secure a MySQL Database
An exposed or default-configured database is a breach waiting to happen. Lock down MySQL/MariaDB: bind to localhost, strong users, least privilege and TLS.
How to Protect a VPS from Brute-Force Attacks
Bots relentlessly guess logins against every public server. Here's a layered playbook — keys, firewall, rate limits and bans — to make brute-forcing pointless.
How to Set Up a UFW Firewall on Ubuntu
UFW makes Linux firewalling approachable. Learn to allow only the ports you need, set default-deny, rate-limit SSH, and verify your rules.
How to Install and Configure fail2ban
fail2ban watches your logs and automatically bans IPs that fail to log in too many times. Here's how to install it and write custom jails.
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.
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.