Database Settings

When creating a new database cluster, a database named default_db is created by default. You can create additional databases within this cluster on the Databases tab.

For Kafka, a default_topic is automatically created, as well as a default_db-group of consumers. 

Database parameters (MySQL, PostgreSQL)

You can change database settings to optimize its performance. 

The settings apply to all databases within a specific cluster.

By default, the database is created with the parameters that are suitable for most tasks and will ensure the performance of the selected configuration. However, if your project requires specific settings, you can change them as you wish. 

Be careful and change parameters only if you are sure of their purpose. Incorrect configuration can negatively affect the operation of the database and its performance.

Database parameters have limits on acceptable values. If you specify a value outside this range, the setting will not be applied and the parameter will remain at its previous valid value.

Additional information about the purpose of this or that parameter can be found in the MySQL and PostgreSQL documentation.

Change database parameters

1. Go to the Database section and click on the cluster.

2. In the Configuration tab click Modify parameters.

3. Specify the settings you need and save the changes.

Extensions (PostgreSQL)

PostgreSQL extensions allow you to increase the functionality of PostgreSQL databases by adding additional capabilities to solve certain problems. You can read more about extensions in the PostgreSQL documentation.

We support several extensions for PostgreSQL, which can be installed in the control panel.

To install extensions:

1. Go to the Databases section and click on the cluster. 

2. On the Databases tab, click on the three dots next to the database and select Extensions.

3. Enable the extensions you need and their installation will begin automatically.

You can add extensions to other databases within the same window. To do this, simply select the desired database in the list.

If you need to apply the same extension settings to all databases in the cluster, enable the Use the same extensions for all databases option.