Guides tagged “database”
Step-by-step MdmHost guides about database, sorted A-Z.
93 guides · page 5 of 5
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.
Troubleshooting MySQL deadlocks and transaction failures
Diagnose MySQL deadlocks and transaction failures using the InnoDB deadlock report, live lock queries and safer transaction ordering.
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.
Tune Redis maxmemory and Eviction Policies on a Linux VPS
Set a Redis memory ceiling, pick the right eviction policy and understand how key expiry behaves so your cache stops growing until the server runs out of RAM.
Upgrade MySQL or MariaDB on a cPanel server in WHM (root guide)
Safely upgrade MySQL or MariaDB on cPanel as root with WHM's MySQL/MariaDB Upgrade tool: version choice, backups, compatibility checks, running the upgrade and rollback planning.
Upgrade PostgreSQL with pg_upgrade: A Safe Major Version Upgrade
Move a PostgreSQL cluster to a new major version with pg_upgrade, including the compatibility check, the upgrade run and the post-upgrade analyze.
Where is my.cnf? MySQL and MariaDB config files explained
Find the MySQL or MariaDB config files on Ubuntu, Debian, AlmaLinux and Rocky Linux, learn the order they load in, and confirm which settings are really active.
wp-config.php explained: the settings that matter
Understand and edit wp-config.php: database settings, table prefix, security keys, debug options, memory limits, URLs and other useful WordPress constants.
Browse by topic
- 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.