Distributed SQLite Replication with LiteFS and FUSE on Linux
Run distributed SQLite across multiple VPS nodes using LiteFS FUSE filesystem mounts for microsecond read latency and automated leader failover.
Databases6 min read
NetBay journal
Databases
44 practical Databases articles from Netbay Engineering — written for operators running Linux and Windows VPS in India.
44 articles in this topic
AllLinuxLinux AdministrationWindowsLinux SecurityLinux NetworkingContainersContainers & OrchestrationKubernetesCI/CDGitHubSelf-HostingBackups & DataDatabasesApp DeploymentDNS & TLSObservabilityEmailAI AgentsAI InfrastructureAPI & AutomationProxiesCloud ArchitectureHardware & PerformanceDevOps Practices
High-Velocity Time-Series Analytics with ClickHouse on a Single VPS
Deploy and tune ClickHouse on an Intel Xeon Linux instance with High-Speed SSD to ingest millions of log rows per second with columnar compression.
Databases8 min read
Migrating to Valkey 8 on Linux VPS: High-Throughput In-Memory Caching
Seamlessly replace Redis 7 with open-source Valkey 8 on Ubuntu 24.04, tuning multi-threaded IO and memory overcommit for zero-latency operations.
Databases7 min read
Tuning pgvector HNSW Indexes for Sub-Millisecond Search in 2026
Optimize pgvector 0.7+ HNSW indexes on PostgreSQL 16 with memory-tuned maintenance_work_mem, vector quantisation, and calibrated ef_search settings.
Databases8 min read
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
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