Skip to main content

FAQ — MariaDB

Are my MySQL applications compatible?​

Yes. MariaDB is an open source fork of MySQL, compatible with the MySQL protocol and syntax. The mysql and mysqldump clients and MySQL connectors (JDBC, PDO, mysql2, etc.) work without modification. This service was previously presented in this documentation under the name "MySQL".

Which version should I choose?​

The wizard offers versions 10.6, 10.11, 11.4 and 11.8. Choose the most recent one for a new project, or the version closest to your current environment for a migration. The version can be upgraded after creation from Edit; it cannot be downgraded.

Which presets are available?​

The Preset sets the CPU and memory of each node. Presets are the virtual machine sizes of the u1, s1 and m1 series: a preset has the same resources as the VM of the same name. The list displayed by the wizard is authoritative:

PresetCPUMemory
u1.medium14Gi
u1.large28Gi
u1.xlarge416Gi
u1.2xlarge832Gi
u1.4xlarge1664Gi
u1.8xlarge32128Gi
s1.small12Gi
s1.medium24Gi
s1.large48Gi
s1.xlarge816Gi
s1.2xlarge1632Gi
s1.4xlarge3264Gi
m1.large216Gi
m1.xlarge432Gi
m1.2xlarge864Gi
m1.4xlarge16128Gi
m1.8xlarge32256Gi
warning

The preset cannot be changed after creation. Size it accordingly, or contact support to change it.

How does replication work?​

The primary writes its changes to the binary log, which the replicas replay. If the primary fails, the platform automatically promotes a replica. Choose 3 (Max High Availability) or 5 (Ultra High Availability) replicas at creation to benefit from this: this number cannot be changed afterwards.

Where can I find the connection address?​

In the Connection and network card of the cluster page. The Internal zone always shows the internal host, reachable from the project's VMs and Kubernetes clusters; the External zone shows the public address when External Access is enabled, Disabled otherwise. The port is 3306.

How do I create a database?​

Grant a user access to the database name (Manage Access → Specific Access (Databases) → Add), or enter it as a user's Database in the Users step of the cluster creation wizard. The database is created if it does not exist. System database names (mysql, information_schema, performance_schema, sys) are refused. See Manage users and databases.

Why does the user created in the wizard not have access to my database?​

The Role chosen in the wizard applies to the Database entered for that user, and to it alone. Grant access to your other databases via Manage Access.

Users created before console v1.3.0 received their role on the mysql system database. In Manage Access, remove the mysql line, shown in error, and add their application database.

I lost a user's password. How do I recover it?​

It cannot be read again. Generate a new one: Actions → Change Password → Perform rotation. The old password is revoked immediately.

Can I limit the number of connections per user or change server parameters?​

These settings are not offered in the console; contact support.

Are backups available?​

Yes, from the Backups tab of the cluster page: scheduling, on-demand backup and restore. See Configure backups and the backup service.