Skip to main content

MariaDB/MySQL Tab

Standalone database server

Overview

Use the MariaDB / MySQL tab to check database service health, refresh the live database inventory, create database backups, and restore database versions when needed.

This tab appears for Generic Linux members. It is useful for dedicated database servers, OpenLiteSpeed servers with local databases, and cPanel servers where MySQL is managed by WHM.

MariaDB-MySQL-Overview.png

What is included

Subtab What you use it for
Overview Check database service health, listener status, version, replication role, recent backup age, logs, and service actions.
Databases View live schemas, refresh discovery, see backup versions, back up selected schemas, restore versions, and delete old database backups.

Free and Pro

Feature Community Pro
View service health and heartbeat-reported database status Included Included
View version, listener, uptime, and basic metrics when available Included Included
View live database inventory Included Included
Refresh live database discovery Included Included
View existing backup versions Included when available Included
Back up all databases Upgrade required Included
Back up selected schemas Upgrade required Included
Restore database backup versions Upgrade required Included
Delete managed database backup versions Upgrade required Included
Choose a Storage Pool for database backups Upgrade required Included

Pro is for real database operations: scheduled recovery coverage, one-click backups before risky changes, schema-level restore, and storage-aware backup management.

Overview subtab

Open Pool, choose the member, select MariaDB / MySQL, then open Overview.

The Overview subtab shows:

  • Database service status.
  • Server version.
  • Replication or Galera role when reported.
  • Last all-databases backup age.
  • Listener status, usually port 3306.
  • Connections, running threads, queries per second, uptime, and buffer pool signals when available.
  • Error and slow-query log tails from the latest member report.

Available actions include:

Action Use it when
Restart The database service needs a controlled restart.
Config test You want to check database configuration before restarting.
Flush privileges Database grants or users were changed and privileges need reloading.
Backup all You want one recovery point containing all databases on the member.
Harden You want the platform to apply supported database hardening guidance or actions.

On cPanel servers, the tab may show a cPanel host notice. Use the cPanel tab for WHM account work, but use Databases here to refresh and back up discovered application schemas.

Databases subtab

Open Databases to work with the live schema inventory.

The Databases subtab shows:

  • Live schemas currently found on the server.
  • Size and table count when available.
  • Database engine details where reported.
  • Backup version count for schemas with stored recovery points.
  • The latest backup age for each backed-up schema.
  • A discovery cache age so you know how fresh the list is.

Use Refresh live when you have added databases, restored accounts, moved sites, or changed application database settings. On cPanel and web hosts, discovery can also find application-linked schemas from known config files.

Backing up databases

To back up all databases:

  1. Open Overview.
  2. Choose Backup all.
  3. Pick the Storage Pool if more than one is available.
  4. Review the estimate and start the backup.

To back up selected schemas:

  1. Open Databases.
  2. Open the menu on the schema card.
  3. Choose Backup.
  4. Confirm the schemas and Storage Pool.
  5. Start the backup.

The backup modal warns when the selected Storage Pool does not have enough remaining space.

Restoring versions

To restore a database version on Pro:

  1. Open Databases.
  2. Open the menu on a schema with backup versions.
  3. Choose Versions.
  4. Select the version you want.
  5. Choose Restore and confirm.

Restoring a database can overwrite live data. Check the version date, source member, and schema name before confirming.

Deleting versions

Use Delete from the versions modal when you no longer need a stored database backup. Deletion is permanent, so keep at least one known-good recovery point for important schemas.

cPanel-managed MySQL

On cPanel servers, MySQL is shared across accounts. That means:

    WHM account tasks stay in the cPanel tab. Database inventory and schema backups stay in MariaDB / MySQL. Use Refresh live after adding or restoring cPanel accounts. Application-linked schemas may appear after discovery even when root-level metrics are limited.

    Galera (wsrep) (In Alpha)

    When Galera is enabled, the agent will report the wsrep state. ServersCTL does not run quorum, SST, or writer election. DNS is active ≠ Galera primary.

    Back to top