Upgrade MariaDB Minor Versions Without Panic
Run a MariaDB minor upgrade as a rehearsal: dump, hold check, package update, mariadb-upgrade, and a rollback path you have already typed out.
Databases9 min read
NetBay journal
Databases
40 practical Databases articles from Netbay Engineering — written for operators running Linux and Windows VPS in India.
40 articles in this topic
AllLinuxLinux AdministrationWindowsLinux SecurityLinux NetworkingContainersContainers & OrchestrationKubernetesCI/CDGitHubSelf-HostingBackups & DataDatabasesApp DeploymentDNS & TLSObservabilityEmailAI AgentsAI InfrastructureAPI & AutomationProxiesCloud ArchitectureHardware & PerformanceDevOps Practices
Move PostgreSQL Off the OS Disk onto Its Volume
Stop the cluster, rsync the data directory onto a dedicated High-Speed SSD volume, and point PostgreSQL 16 at that new data location safely.
Databases8 min read
SQLite Multi-Process Writes: Queue, One Writer, or Postgres
Serialize SQLite writes with a queue or a single writer process, and graduate to Postgres when several processes must commit at once on a VPS.
Databases8 min read
How to Backup and Restore a Redis RDB Snapshot
Take a consistent Redis RDB with BGSAVE, copy dump.rdb off the VPS, and restore it on a fresh instance without mixing live AOF files into the recovery.
Databases8 min read
Autovacuum, Bloat, and PostgreSQL Table Care
Read n_dead_tup, tune autovacuum for busy tables, and run targeted VACUUM so PostgreSQL 16 reclaims the heap and index space before bloat wins.
Databases9 min read
Move the MariaDB Datadir to a Dedicated Disk
Move the MariaDB datadir onto a dedicated High-Speed SSD volume with a clean stop, copy, permission fix, and a systemd-aware restart you can reverse.
Databases9 min read
systemd Unit, Restart, and Log Rotation for Redis
Run Redis under the distro systemd unit with a sensible restart policy, then rotate logs so a busy instance cannot fill High-Speed SSD with redis.log.
Databases8 min read
SQLite vs Postgres: A Decision You Can Defend
Defend SQLite or Postgres with host count, writer count, and ops load, not fashion, so a VPS app does not outgrow the wrong engine by surprise.
Databases8 min read
Connection Pooling PostgreSQL with PgBouncer
Put PgBouncer in front of PostgreSQL 16 so app workers share a small pool of backends instead of opening one backend process per HTTP request.
Databases9 min read
When a MariaDB Replica on a Second VPS Is Worth It
Know when a MariaDB replica on a second VPS earns its keep for reads and backups, and when it only adds lag, failover fiction, and extra cost.
Databases9 min read
redis-cli Diagnostics: INFO, SLOWLOG, MEMORY
Diagnose a live Redis with INFO, SLOWLOG, and MEMORY so you can catch slow commands, memory growth, and eviction pressure before the VPS starts swapping.
Databases8 min read
SQLite .backup and VACUUM INTO While the App Runs
Take a consistent SQLite snapshot from a live app with VACUUM INTO or .backup, then restore beside the original without stopping writes in production.
Databases8 min read