Enterprise hosting · Built for gamers
Maincubes FRA01Data center Offenbach / Frankfurt
~12 msAvg. ping DACH
1 Tbit/sDDoS protection
99.9%Uptime SLA
24+ games1-click install
Popular searches:Minecraft won't startCreate Minecraft serverFiveM txAdminInstall WordPressSet up subdomainVPS GermanySSL errorOpen port 25565Discord bot hostingDNS troubleshooting
Database Hosting & Optimization – MySQL, PostgreSQL, MongoDB
Quick answer: Databases on a VPS: PostgreSQL for modern apps, MySQL/MariaDB often with WordPress – always back up, strong passwords, never expose publicly.
VPS & root servers: Order VPS in Germany · panel.nexorahost.de · nexorahost.com (Maincubes FRA01 Frankfurt · Ryzen · NVMe · GDPR)
Frequently asked questions (FAQ)
Which database systems does NexoraHost support?
MySQL 5.7, 8.0; PostgreSQL 12, 13, 14, 15; MongoDB; MariaDB; SQLite. Depending on hosting plan. Root Server: all systems possible.
MySQL vs PostgreSQL – which database should I choose?
MySQL: fast, simple, WordPress/PHP standard. PostgreSQL: robust, ACID transactions, better for large datasets. Rule of thumb: WordPress/Webapps=MySQL, Enterprise/Analytics=PostgreSQL.
My database gets slower over time – why?
Reasons: No indexes, too many connections (Max Connections), outdated statistics, missing connection pooling. Solution: ANALYZE TABLE, check indexes, PgBouncer/MySQL Proxy.
What is connection pooling and do I need it?
Connection pooling (PgBouncer, MySQL Proxy): recycle connections instead of creating new ones. Saves 80% resources with many PHP/app instances. Recommended at 100+ connections/min.
How do I do automatic database backups?
Panel: activate automatic daily backups (free up to 50 GB). Additionally: mysqldump/pg_dump script via cronjob. Off-site: AWS S3/Wasabi (encrypted).
My database size grows constantly – what to do?
Delete old logs/temp data, table archiving, store images externally (S3), database cleanup. Or: upgrade to plan with more storage.
PostgreSQL or MySQL for production?
PostgreSQL: more reliable at high load, replication simpler, better admin tools. MySQL: faster for WordPress, easier to debug. NexoraHost: both optimally configured.
Can I build a PostgreSQL cluster on my root server?
Yes! Replication, streaming backup, hot standby possible. Complex setup, but highly available. Guide: PostgreSQL high availability.
MongoDB or relational databases?
MongoDB: flexible for unstructured data, fast to develop. Relational (MySQL/PG): better for transactional data integrity. Choice depends on use case.
Database on root server vs managed database service?
Root server: full control, cheaper, self-administered. Managed: simpler, auto-backups, scaling. NexoraHost: both options available.
How do I protect my database from SQL injection?
Use prepared statements, validate input, minimal privileges for DB user, regular security updates, firewall rules (port 3306/5432 internal only).
Read replicas – how do I scale my data reads?
PostgreSQL/MySQL replication: primary writes, replicas read. Scales read access horizontally. Good for analytics/reports. NexoraHost supports multi-master on root server.
NexoraHost
Need hosting?
Game servers, VPS & webspace at Maincubes FRA01 – 1 Tbit/s DDoS, 99.9% uptime SLA.
nexorahost.com · Maincubes FRA01 · 1 Tbit/s DDoS · 99,9 % Uptime