24 articles
Knowledge Base
Other databases
24 articles in the Other databases category.
- Cross-region MySQL replication over the public internet — TLS, compression, lag monitoring Full installer for a MySQL 8.0 cross-region replica over the public internet — TLS-only replication, connection compression (zstd), GTID, lag alerting, automated reconnect.
- Deploying VictoriaMetrics cluster mode on Ubuntu 22.04 (vminsert + vmstorage + vmselect) Stand up a self-hosted VictoriaMetrics cluster on Ubuntu 22.04 — sharded vmstorage, vminsert + vmselect with replication factor, retention, and a vmagent ingest path.
- Deploying QuestDB on Ubuntu 22.04 with WAL replication to a read replica Stand up a self-hosted QuestDB primary on Ubuntu 22.04, plus a read replica using WAL shipping to object storage — including the operational checks that detect replication drift before the dashboard does.
- Read-replica routing with ProxySQL — query-pattern rules and lag-aware fallback to writer How to split read and write traffic in front of MySQL with ProxySQL — host groups, query rules by regex, mirror queries, and the lag threshold that yanks a stale replica out of rotation.
- Recovering a Galera cluster from split-brain Detection, bootstrap selection by seqno, the safe_to_bootstrap flag, and the safest path back to a Primary cluster after a partition or full outage.
- Deploying ClickHouse on AlmaLinux 9 with ClickHouse Keeper for replication Stand up a production ClickHouse on AlmaLinux 9 — ClickHouse Keeper for ZooKeeper-free coordination, 1 shard / 2 replicas, users.xml hardening, TLS on every port.
- Migrating from MySQL 5.7 to 8.0 without breaking your app MySQL 5.7 is end-of-life. The 8.0 upgrade is mostly safe — but the parts that are not safe will silently break SQL that ran for years. Here is the order we run it in.
- Postgres logical decoding to a downstream analytics warehouse with wal2json End-to-end installer: wal2json output plugin, a replication slot, a Python consumer that ships JSON change events to a warehouse loader, idempotent merge semantics, lag monitoring.
- Deploying Milvus 2.x standalone with etcd + MinIO on AlmaLinux 9 Production-grade single-node Milvus on AlmaLinux 9 — etcd for metadata, MinIO for object storage, systemd-managed Docker Compose, with backup and metrics wiring.
- Deploying a 3-node Qdrant cluster with raft consensus and S3 snapshots on Ubuntu 22.04 Stand up a self-hosted Qdrant cluster with raft consensus, mTLS between peers, sharding + replication on production collections, and snapshot rotation to S3.
- Deploying a 3-node Weaviate cluster on Ubuntu 22.04 with TLS gRPC and anonymous access disabled Stand up a self-hosted Weaviate cluster across three VMs with persistent volumes, raft consensus, API-key auth, and TLS on the gRPC interface.
- Adding a new node to a running Galera cluster without taking writes SST vs IST, donor selection, gcache sizing, and the operational steps to grow a Galera cluster from 3 to 4 nodes without write downtime.
- Deploying Percona XtraDB Cluster 8 + ProxySQL on Ubuntu 22.04 A 3-node Percona XtraDB Cluster on Ubuntu 22.04 with ProxySQL in front — hostgroup-aware routing, replication-lag awareness, query rules.
- Deploying a ScyllaDB 5.x 3-node cluster (Cassandra-compatible) with seeds and NTP Stand up a self-hosted ScyllaDB 5.x cluster on three Ubuntu 22.04 VMs — seed nodes, NTP discipline, scylla_setup tuning, snapshot strategy on the data volume.
- Deploying NATS 2.x with JetStream on a 3-node Ubuntu 22.04 cluster Stand up a self-hosted NATS 2.x cluster with JetStream persistence on Ubuntu 22.04 — mTLS between nodes, account/user isolation, stream + consumer skeleton.
- Deploying a TiDB cluster (PD + TiKV + TiDB) on AlmaLinux 9 with tiup Stand up a self-hosted TiDB cluster on AlmaLinux 9 — PD for placement, TiKV for storage, TiDB for SQL — fully orchestrated by tiup with topology, certs, and snapshot plan.
- Deploying a RabbitMQ 3.13 cluster with quorum queues on AlmaLinux 9 Stand up a 3-node RabbitMQ 3.13 cluster on AlmaLinux 9 — quorum queues, classic peer discovery, management UI behind nginx + Let's Encrypt, definitions export.
- Deploying Vitess (sharded MySQL) on Ubuntu 22.04 — vtgate + vttablet topology Stand up a Vitess cluster on Ubuntu 22.04 — topology service (etcd), vttablet wrapping MySQL on each shard, vtgate as the smart client-facing proxy.
- Deploying Valkey 7.x cluster on Ubuntu 22.04 — and migrating from Redis Stand up a Valkey 7 cluster on Ubuntu 22.04, with TLS and ACLs, and walk through the migration path from a Redis Cluster of the same shape — including the gotchas.
- Building a Debezium CDC pipeline from MySQL to Kafka on Ubuntu 22.04 Full installer for a Debezium 2.x change-data-capture pipeline — Kafka 3.7 (KRaft), Kafka Connect, MySQL connector, Confluent Schema Registry, monitoring, and connector smoke test.
- Deploying InfluxDB 3.x cluster on AlmaLinux 9 with object storage backing Stand up a self-hosted InfluxDB 3.x cluster on AlmaLinux 9 — token auth, retention policies, S3-compatible object storage, mTLS, and operational checks that catch silent ingest gaps.
- Deploying ChromaDB in server mode on Ubuntu 22.04 with token auth and SQLite backups Move ChromaDB out of embedded-in-the-app mode onto a dedicated VM with the FastAPI server, token-based auth, persistent storage, and a backup strategy that survives a restart.
- Setting up read replicas on managed MySQL A read replica on managed MySQL is a 10-minute provision and a multi-week behavior change in the application. Here is the order we do it in.
- Backup strategies for managed databases — beyond the default Daily automated backups with point-in-time recovery are the floor, not the ceiling. Here is how we layer backups on managed MySQL, Postgres, and Redis for production.