Full database portfolio — for every workload
Picking a database is a multi-year decision. Give yourself options. PostgreSQL for transactions, ClickHouse for analytics, MongoDB for documents, Redis for cache. All hosted by 4hosting in the EU with guaranteed SLA. For Polish companies: data physically in the EU (not just logically), VAT invoice in PLN, GDPR compliance and free DPA included.
Relational — Postgres + MariaDB
PostgreSQL 17
The SQL gold standard. Full JSONB support, pgvector for AI, partitioning, logical replication, hot standby. Ideal for SaaS and fintech. We enable parallel query, JIT, asynchronous replication slots.
MariaDB 10.11
MySQL-compatible, light, fast. Best for WordPress, WooCommerce, Magento and traditional LAMP apps. ColumnStore engine for mixed OLTP+OLAP, MaxScale for load balancing.
Analytical — ClickHouse
When you need to query billions of rows per second. ClickHouse is a columnar database tuned for OLAP. Used by Cloudflare, Uber, Spotify. Available on VPS from 32 GB RAM. Ideal for logs, metrics, event tracking, business intelligence and real-time reports.
NoSQL and cache — MongoDB, Redis
MongoDB 7
Document database. For apps with a flexible schema (CMS, IoT, real-time analytics). Replica set + sharding ready. Time-series collections for metrics.
Redis 7
In-memory cache, queues, pub/sub. Sub-1 ms latency. Required for any web app above 100 req/s. Redis Streams, RedisJSON, RediSearch modules available.
Memcached
Classic key-value cache. Simpler than Redis, ideal for session store and lightweight caching. Higher throughput than Redis for simple ops.
Migrating a database from another provider
The most common customer concerns: how long it takes, whether there will be downtime, whether data is lost. Our playbook is proven — 100 GB+ database migrations are usually zero-downtime thanks to logical replication. Here are the three most common scenarios with commands.
MySQL/MariaDB from home.pl, nazwa.pl, cyberfolks
Classic mysqldump with --single-transaction --routines --events flags. On the target side we import with index cleanup for fastest load.
mysqldump -h source-host -u user -p --single-transaction --routines --events db | gzip > backup.sql.gzPostgreSQL from AWS RDS / Heroku Postgres
pg_dump with custom format (-Fc) is fastest. Parallel restore with --jobs=4 uses multiple CPU cores. For zero-downtime: logical replication slot.
pg_dump -h source -U user -Fc -f db.dump dbname && pg_restore -h target -U user -d newdb --jobs=4 db.dumpMongoDB from Atlas or another platform
mongodump + mongorestore. For very large databases (1 TB+) we use MongoDB Cluster-to-Cluster sync — differential, without a full dump.
mongodump --uri="mongodb+srv://[email protected]" --out=./dump && mongorestore --uri="mongodb://target" ./dumpHigh Availability — replication and failover
For business-critical apps, a single database is a single point of failure. We set up replicated clusters (master + 1-3 replicas) with automatic failover. RTO < 30 seconds, RPO < 1 minute with synchronous replication.
Master + replicas
Writes to master, reads spread across replicas. Read scaling linear with replica count. Lag monitoring and alerts.
Automatic failover
Repmgr (Postgres), MHA (MySQL), MongoDB elections. On master failure, a replica takes over in < 30 seconds.
Multi-region (EU)
Replication between EU DCs (Frankfurt + Warsaw or Frankfurt + Paris). Cross-region failover on full DC outage.
Connection pooling
PgBouncer for Postgres, ProxySQL for MariaDB. Thousands of app connections handled with a pool of 50-100 physical connections to the DB.
What you get in the package
Automatic backups
Every database has 24h full backups and 1h WAL/binlog backups. 30-day retention on dedicated plans. Geo-redundant copies in a second EU DC — free on managed plans.
Master-replica replication
We set up logical or physical replication, including cross-region. Failover under 30 seconds. PgBouncer for connection pooling, ProxySQL for MariaDB, MongoDB replica sets ready.
Workload tuning
We tune work_mem, shared_buffers, max_connections, innodb_buffer_pool_size and the rest for your app — free on managed plans. Performance review every 90 days.
Free migration
We migrate from other providers — mysqldump, pg_dump, mongodump. Zero downtime, with integrity check on the target. Logical replication for zero-downtime migrations.
GDPR for databases with personal data
Databases usually hold the most personal data — emails, phone numbers, customer IPs. For full GDPR compliance we offer encryption, audit logging and retention policies built into the database.
- At-rest disk encryption (LUKS) — free on every VPS
- Column-level encryption (e.g. national ID, phone) via pgcrypto or Vault Transit
- DDL/DML audit log — who, when, what (pgaudit, MySQL Enterprise Audit, MongoDB Auditing)
- Retention policies — automatic deletion after defined periods (e.g. 5 years for invoices)
- Dedicated DPO role — we help configure policies via the customer panel
- Free DPA compliant with GDPR Article 28 + technical audit documentation
Frequently asked questions
Do you offer managed databases?
Yes, on VPS 32 GB and up and all dedicated servers. We handle tuning, backups, replication, security patches. Your job: just SQL queries.
How big a database fits on a VPS?
Practical limit: 200-300 GB on VPS 32G, 1 TB+ on VPS 64G. Above that we recommend a dedicated server with fast RAID or u.2 NVMe. PostgreSQL/MariaDB scale well to 5 TB on a single node.
Can I move an existing database from AWS RDS?
Yes, we migrate from AWS RDS, Azure Database, Google Cloud SQL, Heroku Postgres and Atlas. Logical replication typically yields zero downtime. Free assistance for databases up to 1 TB.
How is ClickHouse different from PostgreSQL?
PostgreSQL is OLTP (transactional) — fast writes, ACID, ideal for apps. ClickHouse is OLAP (analytical) — fast aggregations on billions of rows. We often use both: OLTP in Postgres, reporting in ClickHouse via replication.
Are backups actually tested?
Yes. Every week a random backup is automatically restored to a staging server and compared against the original. You get a report by email. A backup you don't test doesn't exist.
Pick the right database for your app
Unsure which engine? Write to us — we help design the architecture for free before the first invoice. For 100 GB+ databases we help with provider migration too.
Contact us →
