MySQL
MySQL is an open-source relational database management system (RDBMS).
MySQL version
The version currently installed by the add-on is :
- on shared plans (DEV) : MySQL 8.0
- on newly created dedicated databases (plans XS Small Space and above) : MySQL 5.7.20 or 8.0
MySQL plans
Note for Shared databases
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).
| Name | Logs | DB size | Conn. limit | Memory | Type | VCPUS | Price /mo |
|---|---|---|---|---|---|---|---|
| DEV | no | 10 MB | 5 | Shared | Shared | Shared | Free |
| XXS Small Space | yes | 512 MB | 15 | 512 MB | Dedicated | 1 | 5.00 € |
| XXS Medium Space | yes | 1 GB | 15 | 512 MB | Dedicated | 1 | 5.90 € |
| XXS Big Space | yes | 2 GB | 15 | 512 MB | Dedicated | 1 | 6.80 € |
| XS Tiny Space | yes | 2 GB | 75 | 1 GB | Dedicated | 1 | 13.00 € | XS Small Space | yes | 5 GB | 75 | 1 GB | Dedicated | 1 | 22.00 € |
| XS Medium Space | yes | 10 GB | 75 | 1 GB | Dedicated | 1 | 24.50 € |
| XS Big Space | yes | 15 GB | 75 | 1 GB | Dedicated | 1 | 27.00 € |
| S Small Space | yes | 10 GB | 125 | 2 GB | Dedicated | 2 | 44.00 € |
| S Medium Space | yes | 15 GB | 125 | 2 GB | Dedicated | 2 | 46.50 € |
| S Big Space | yes | 20 GB | 125 | 2 GB | Dedicated | 2 | 49.00 € |
| M Small Space | yes | 20 GB | 250 | 4 GB | Dedicated | 4 | 103.00 € |
| M Medium Space | yes | 40 GB | 250 | 4 GB | Dedicated | 4 | 113.60 € |
| M Big Space | yes | 80 GB | 250 | 4 GB | Dedicated | 4 | 133.60 € |
| L Small Space | yes | 40 GB | 500 | 8 GB | Dedicated | 6 | 207.20 € |
| L Medium Space | yes | 80 GB | 500 | 8 GB | Dedicated | 6 | 227.20 € |
| L Big Space | yes | 120 GB | 500 | 8 GB | Dedicated | 6 | 247.20 € |
| XL Small Space | yes | 80 GB | 750 | 16 GB | Dedicated | 8 | 414.40 € |
| XL Medium Space | yes | 160 GB | 750 | 16 GB | Dedicated | 8 | 454.40 € |
| XL Big Space | yes | 320 GB | 750 | 16 GB | Dedicated | 8 | 534.40 € |
| XXL Small Space | yes | 160 GB | 900 | 32 GB | Dedicated | 10 | 1022.00 € |
| XXL Medium Space | yes | 320 GB | 900 | 32 GB | Dedicated | 10 | 1134.00 € |
| XXL Big Space | yes | 640 GB | 900 | 32 GB | Dedicated | 10 | 1358.00 € |
| XXL Huge Space | yes | 960 GB | 900 | 32 GB | Dedicated | 10 | 1582.00 € |
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:
- Our WebGUI (PHP My Admin).
- Command line tool for MySQL administration.
- 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
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.
Keep in mind that usage of direct access is a trade-off: when you migrate your addon, you will need to to generate hostname and port again so your application must update these environment while proxy usage changes nothing.
Encryption at rest
MySQL dedicated addons can be encrypted using LUKS with aes-xts.
The passphrase is encrypted in our database using Cipher and Nonce as bytes arrays.
To enable it, you need to ask to our support then we will perform invoicing configuration (more informations about pricing are available through support) and enable the encryption for your addon. Once it’s done, you will need to migrate your addon then the encryption at rest will be up.