Databases
MySQL, MariaDB, PostgreSQL, Redis and MongoDB on a VPS.
64 guides · page 3 of 4
MySQL Point-in-Time Recovery Using Binary Logs
Recover a MySQL or MariaDB database to an exact moment after a bad write or dropped table by restoring a full backup and replaying binary logs up to the incident.
MySQL vs MariaDB: which to use on your VPS
Compare MySQL and MariaDB on compatibility, licensing, features, release support and app support, so you can choose the right database for your VPS.
Optimize MySQL Indexes with Composite and Covering Indexes
Learn how to design MySQL composite and covering indexes for WHERE, JOIN and ORDER BY queries, then verify the plan with EXPLAIN and EXPLAIN ANALYZE.
PostgreSQL Point-in-Time Recovery with WAL Archiving
Set up WAL archiving and restore a PostgreSQL cluster to an exact second with point-in-time recovery, using pg_basebackup, archive_command and a recovery target.
psql cheat sheet: essential PostgreSQL commands
The psql commands you need day to day, from connecting and listing databases, tables and roles to running SQL files and exporting query results to CSV.
Repair Corrupted MySQL InnoDB Tables on a Linux VPS
Confirm InnoDB corruption with CHECK TABLE, start MySQL with innodb_force_recovery to dump readable data, then rebuild the tables from that dump.
Reset a Forgotten MySQL Root Password on Linux
Recover access to MySQL or MariaDB on a Linux VPS by starting the server with skip-grant-tables, setting a new root password and restarting normally.
Reset the PostgreSQL postgres user password
Set or reset the password of the postgres superuser, and regain access when normal logins fail by trusting local connections for a moment and then reverting.
Restore a MySQL Database from a mysqldump File
Load a.sql or.sql.gz dump back into MySQL or MariaDB on your Linux VPS with the mysql command, including charset options and fixes for the usual import errors.
Restore a MySQL database from JetBackup 5 in cPanel
Roll a WordPress or shop database back to an earlier day with JetBackup 5 in cPanel, download a database dump, and restore files and database together safely.
Restore MariaDB from a mariabackup Backup
Restore MariaDB from a mariabackup backup on a Linux VPS: stop the server, prepare the backup files, copy them back into the data directory, fix ownership and start MariaDB again.
Secure MongoDB Remote Access with bindIp and Authentication
Configure bindIp, enable authorization and restrict port 27017 so MongoDB accepts remote connections from your app server only.
Set Up a MariaDB Galera Cluster on Multiple VPSs
Install MariaDB with the Galera provider on three Linux VPSs, configure wsrep, bootstrap the first node and confirm every node reports Synced.
Set Up MySQL Primary-Replica Replication on a Linux VPS
GTID-based MySQL replication between two Linux VPS: set server-id and binary logging on the primary, take a consistent snapshot, then point the replica at it and verify.
Set Up PostgreSQL Streaming Replication on a Linux VPS
Configure a PostgreSQL primary with a replication role and slot, clone it with pg_basebackup, and bring up a standby that streams WAL in real time.
Troubleshoot MySQL Replication Lag and Broken Replicas
Measure MySQL replication lag, read SHOW REPLICA STATUS, clear SQL thread errors and resync a replica that has fallen too far behind to catch up.
Troubleshoot PostgreSQL Locks and Blocking Queries
Find the session holding a PostgreSQL lock, read pg_locks and pg_stat_activity, and cancel or terminate blocking queries without losing data.
Tune MySQL and MariaDB memory settings for a small VPS
Set innodb_buffer_pool_size, max_connections and other my.cnf values so MySQL or MariaDB fits the RAM on your Linux VPS and stops swapping.
Tune MySQL InnoDB Buffer Pool Size for a VPS
Measure your InnoDB buffer pool hit rate, choose a size that fits your VPS memory, and apply innodb_buffer_pool_size safely in my.cnf.
Tune PostgreSQL Autovacuum and VACUUM Settings
Autovacuum defaults are built for large servers, not small VPSs. This guide shows how to adjust thresholds, cost limits and per-table settings to control table bloat.
Other topics
- Getting startedYour first hour with a new server: access, logins and basics.69 guides
- cPanelFiles, databases, email, domains and every cPanel tool, step by step.37 guides
- WHM & resellingWHM, packages, reseller accounts, WHMReseller and running a hosting brand.49 guides
- WordPressInstall, secure, speed up, migrate and fix WordPress sites.40 guides
- Email & webmailMailboxes, webmail, forwarders, spam filters and email delivery.37 guides
- DomainsRegistering, transferring and managing domains and nameservers.20 guides
- SSL certificatesFree AutoSSL, Let's Encrypt, paid certificates and HTTPS.19 guides
- CloudLinuxCloudLinux setup and use: LVE limits, CloudLinux Manager, CageFS and PHP/Node.js selectors.31 guides
- LiteSpeedLiteSpeed Web Server, LSCache and the LiteSpeed Cache plugin: install, settings and tuning.30 guides
- Imunify360Malware scanning, firewall and proactive defence with Imunify360.23 guides
- SoftaculousInstall, update, clone and back up apps with Softaculous.23 guides
- WP SquaredcPanel's WordPress platform: sites, plugins, staging and backups.9 guides
- SitePadBuild and publish websites with the SitePad builder.9 guides
- SitejetDesign, edit and publish sites with the Sitejet builder.9 guides
- WHMResellerAlpha and master resellers with WHMReseller: install, setup and use.12 guides
- VirtFusionInstall, set up and manage VirtFusion: hypervisors, packages, servers and WHMCS integration.7 guides
- VirtualizorManage your VPS with Virtualizor: power, OS reinstall, VNC, IPs and backups.30 guides
- PleskWebsites, email, databases and settings in the Plesk panel.52 guides
- DirectAdminUsers, domains, email and reseller tools in DirectAdmin.40 guides
- WHMCSBilling, automation, products and client management with WHMCS.51 guides
- Control panelscPanel & WHM, Plesk, DirectAdmin and other panels on your VPS.106 guides
- SecurityKeys, passwords, firewalls and keeping a server patched.115 guides
- Networking & DNSIP addresses, reverse DNS, ports and traffic.34 guides
- Websites & appsWeb servers, WordPress, PHP, Node.js, SSL and app hosting.52 guides
- DatabasesMySQL, MariaDB, PostgreSQL, Redis and MongoDB on a VPS.64 guides
- Billing & accountInvoices, renewals, the client area and your account.9 guides
- TroubleshootingWhen something is not working: checks and fixes.68 guides
- Linux VPSSSH, packages, services and everyday Linux administration.70 guides
- Windows VPS & RDPRemote Desktop, Windows Server settings and Admin RDP tips.58 guides
- Docker & DevOpsContainers, Git deploys, automation, monitoring and backups.58 guides
Still stuck?
Ask MdmHost AI for a quick answer, or open a ticket and our team will take a look. We are here 24/7.