How to Change MariaDB Settings

Accessing the Settings

In the sidebar menu, click Projects
Find and click the desired database project name
On the project page, click the "Edit" button in the top-right corner

Available Settings

Project Name

The project name can be changed at any time.

Rules:

Minimum: 6 characters
Maximum: 32 characters
Only lowercase letters, numbers, and hyphens

Note: Changing the name does not affect the existing subdomain.

Project Description

The project description can be changed at any time.

Characteristics:

Optional field to describe the project purpose
Helps identify and organize your projects
Can include information such as environment, customer, or purpose

Database Password

You can change the database password at any time.

How to change it:

In the password section, request the change
Click Save

Important: Zenifra generates a completely new password. After that, update your application and copy the connection URI again from the console.

MariaDB Version

The MariaDB version can be updated.

Available versions:

MariaDB 11
MariaDB 12

How to update:

Select the desired new version
Click Save

Warning: Version upgrades can cause a few minutes of downtime. We recommend making the change during low-traffic hours.

Important: MariaDB version downgrade is not supported.

Connection String

The connection string is generated automatically and can be viewed at any time.

Format:

mariadb://usuario:senha@host:porta/nome_banco

To copy: Click the copy button next to the connection string.

Tip: Use this string in your HTTP application's DATABASE_URL variable to connect to the database.

Replicas (MariaDB)

MariaDB on Zenifra uses a fixed configuration of 3 instances:

1 primary instance: handles write and read operations
2 read replicas: distribute read load

Note: Unlike PostgreSQL, MariaDB replica count is fixed (3 instances) and cannot be changed.

Automatic Failover

MariaDB includes automatic failover:

if the primary instance fails, one of the replicas takes over automatically
applications are redirected to the new primary instance
no manual intervention is required

Storage

Database storage can be adjusted.

Limits:

Minimum: 1 GB
Maximum: 250 GB

Impact:

For hourly projects: storage can be increased
For monthly/yearly contracts: storage can only be changed after the contract ends

Warning: Storage reduction is not supported. Increasing storage can cause a few minutes of downtime.

Project Actions

Stop the Project

When stopping the project:

the database is interrupted
replicas are shut down
the project becomes inaccessible
for hourly projects, plan billing stops, but storage costs continue

When to use it:

when you do not need the database temporarily
to save money on hourly projects

Start the Project

To start a stopped project:

the database starts again
replicas are initialized
the project becomes accessible again
for hourly projects, billing resumes

Delete the Project

Deletion is permanent and irreversible.

What happens:

all replicas are removed
all data is deleted

Requirements:

for hourly projects, the instance can be deleted at any time
for contracts, wait until expiration and disable automatic renewal

Warning: Back up your data with mysqldump before deleting. This action cannot be undone.

Next Steps

FAQ

Can I change the database password?

Yes. At any time through the project settings. Remember to update the password in your application after changing it in the database.

Does changing settings cause downtime?

It depends on the change:

Password: Does not cause downtime
MariaDB version: May cause a few minutes of downtime
Replicas: Fixed configuration (not changeable)
Storage: May cause a few minutes of downtime

Can I restore a deleted database?

No. Deletion is permanent. The data cannot be recovered. Make sure to back it up before deleting.

What happens if the primary instance fails?

MariaDB includes automatic failover:

one of the replicas takes over as primary
a new instance is reconfigured automatically
your application keeps working without manual intervention

How do I back up my database?

You can export the data using tools such as mysqldump or by connecting directly to the database and exporting the necessary data.

Can I connect external applications to the database?

Yes. Use the connection string provided in the settings.

Can I change the number of MariaDB replicas?

No. MariaDB on Zenifra uses a fixed configuration of 3 instances (1 primary + 2 replicas). This configuration cannot be changed.

On this page