Database Server Actions

The Database Server Actions page allows you to manage important MariaDB settings for your dedicated database server. From here, you can configure binary logs, performance options, storage management, and database connection settings.

Binary Logs (Binlogs)

A Binary Log (Binlog) records all database changes such as INSERT, UPDATE, and DELETE operations. Read-only queries (SELECT) are not stored in the binary log.

Binlogs are commonly used for:

• Database Replication – Synchronizing replica databases with the primary server.
• Point-in-Time Recovery – Restoring data to a specific point after accidental changes or data loss.

View and Purge Binlogs

The dashboard lets you view binary log files along with their storage usage by date.

If binlogs consume excessive disk space, you can safely purge older log files that are no longer required.

Manage Binlog Retention

By default, MariaDB retains binary logs for 14 days.

You can modify the retention period to suit your requirements:

• Reduce the retention period if binlogs consume too much storage.
• Increase the retention period for compliance, auditing, or longer recovery windows.

Automatic Binlog Purging

To prevent storage exhaustion, Frappe Cloud allows you to configure a maximum storage limit for binlogs.

When the combined size of all binary logs exceeds the configured limit, older binlogs are automatically removed until the usage falls below the specified threshold.

Enable or Disable Binlog Indexer

The Binlog Indexer converts binary logs into a searchable format that can be explored using the Binlog Browser.

You can:

• Enable the Binlog Indexer to browse and search binary logs.
• Disable it if binlog indexing is not required.

Default Binlog Storage Limits

• Auto Add-on Storage Enabled: Binlogs can occupy up to 75% of the available disk space.
• Auto Add-on Storage Disabled: Binlogs can occupy up to 20% of the available disk space.

Performance Schema

The Performance Schema can be enabled or disabled directly from the dashboard. This feature provides detailed performance monitoring information that can help diagnose database performance issues.

Manage InnoDB Buffer Pool Size

You can adjust the InnoDB Buffer Pool Size from the dashboard to better utilize available memory and improve database performance for your workload.

Manage Maximum Database Connections

Frappe Cloud automatically configures the maximum number of database connections based on your server’s available memory.

If your workload requires additional concurrent connections, you can increase this limit from the dashboard.

View Database Configuration

Use the View Database Configuration option to inspect the current configuration of your dedicated database server.