Documentation
Add-ons
MySQL

MySQL

Overview

MySQL is an open-source relational database management system (RDBMS). Clever Cloud’s add-on uses the Percona Server, a 100% compatible open-source implementation, with performances improvements and more features.

Supported Versions

MySQL is available in regular versions and early for 8.4. That means it’s the first release (8.4.0) of this long term support (LTS) branch, so you should consider it mostly to make some tests and discover what’s new. But we recommend waiting a bit before using a new branch in production.

DedicatedDev
5.78.0
8.0
8.4_early
⚠️
Important: Dev plans are free and intended solely for testing purposes. They don’t provide the same guarantees or SLAs as dedicated plans.

Database Daily Backup and Retention

By default, Clever Cloud performs a free backup every day, with a retention of seven days. Retention and frequency can be customized for Premium customers.

Each backup can be found in the add-on dashboard in the web console, along with the credentials.

Migrating from an old database

Some applications require a populated database to run properly. If you want to import your SQL dump, you can use several methods:

  1. Our WebGUI (PHP My Admin).
  2. Command line tool for MySQL administration.
  3. Any MySQL client such as MySQL Workbench.

If you need to import a very large dump, please send an email to support@clever-cloud.com.

Direct access

⚠️
Using direct access is a trade-off: if you migrate your addon, you will need to generate the hostname and port again, so your application will need to update that environment, while using a proxy does not change anything.

All our dedicated MySQL databases are served via a proxy. To reduce the latency you can bypass this proxy by generating direct hostname and port for the addon. You can do it by clicking the “Generate direct hostname and port” on the addon dashboard.

This action will add new environment variables to reach the addon without any proxy.

Encryption at rest

Encryption at rest is available on MySQL. You can have more information on the dedicated page

ProxySQL

ProxySQL is a tool that acts like a proxy between your application and your MySQL add-on. Instead of connecting to your MySQL add-on, you can connect to the local ProxySQL and it will forward all your requests to your MySQL add-on.

This allows you to let ProxySQL take care of some interesting features like connection pooling or leader / follower setup.

You can learn more about ProxySQL on the dedicated documentation page

Plans

⚠️
As Shared databases (DEV) are shared between multiple applications and delays could appear in case of an high demand. If this delays create problems in your application or are problematcs, we recommend you to use a dedicated database (XS plans and above).

🔑 Rights and permissions

Add-ons are managed services, meaning that users have standard access to the database (ALL privileges). Some operations like databases and users creation, as well as some settings modifications aren’t available by default. This ensures optimal performances and security for managed services as configured by Clever Cloud.

Authorized actions:

  • Manage tables (create, delete…).
  • Manage indexes.

If you think your system might require more advanced administrative access, contact Clever Cloud support to explain your use case, and we will work with you to find a solution.

Here is the list of actions that you won’t be able to perform:

  • Database administration (for example you won’t be able to create new databases).
  • Users administration (you won’t be able to create other users than the one handled with our control plane, i.e. the base owner and read-only users).
  • Server configuration update.
  • Plugins installation.
  • Replica creation.
  • Backup frequency or retention control.

Ask Clever Cloud support if you want to perform one of these actions.

Last updated on