Database Server Actions
On Server Actions page, you will find several options for database configuration.
What is Binlog & Why It's required ?
The Binary Log (Binlog) in MariaDB is a crucial logging mechanism that records all changes to the database - such as SQL statements that modify data (INSERT, UPDATE, DELETE). It does not log SELECT queries.
Binlogs are primarily used for:
- Replication: Keeping replicas in sync with the primary database.
- Point-in-time recovery: Restoring a database to a specific moment in time.
For example, if a site is accidentally deleted or broken due to a faulty SQL query, in that case binlogs combined with the last available backup—allow you to roll back to a specific time and recover your data.
View & Purge Binlogs
You can view binary log file sizes by date. If you're running low on storage, it's possible to purge old binlogs that are no longer needed.
Manage Binlog Retention
By default, when Frappe Cloud provisions a server, MariaDB has a binlog retention period of 14 days.
If your site handles a large volume of transactions and binlogs are filling up your storage quickly, you may choose to reduce the retention period.
Alternatively, for compliance or auditing purposes, you can increase binlog retention as needed.
You can manage these settings directly from the interface:
Performance Schema
If you own some dedicated server, you can enable/disable the performance schema as per requirement.
Manage InnoDB Buffer Pool Size
If you want to change innodb buffer pool size, you can now do that from Frappe Cloud dashboard.
Manage Max Database Connections
When you create a database server, Frappe Cloud set a default max connections based on the total memory on the server. In case if you need more database connection, you can increase that from dashboard.
View Database Configurations
If you want to check all the configuration of your dedicated database server, you can use the View Database Configuration option.
Currently, it's not allowed to change in variable. If you need some special configuration, please reach out to support.frappe.io