MySQL

MySQL is the world's most popular open source database. Whether you are a fast growing web property, technology ISV or large enterprise, MySQL can cost-effectively help you deliver high performance, scalable database applications.

Add a database to your application

To add a dedicated MySQL instance to your existing application, simply add these lines to your configuration file:

.qovery.yml
application:
...
databases:
- type: mysql
  version: 8.0
  name: my-mysql
  • name: select a name for your database
  • version: choose the version of the database
  • type: the database engine (mysql in this case)

Alternatively, if you are creating a new application, use qovery init to interactively add a database (the CLI asks if you need one).

Supported versions

Here are the MySQL versions supported by Qovery.

VersionSupported
8.0Yes
5.7Yes
5.6Yes
5.5Yes

Qovery does not support a new version of MySQL yet? Contact us

Get access to a database

To get the connection information of your database, you can use the CLI:

qovery application env list -c
OUTPUT
$ qovery application env list -c
  SCOPE       | KEY                                                           | VALUE
--------------+---------------------------------------------------------------+-----------
  BUILT_IN    | QOVERY_BRANCH_NAME                                            | master
  BUILT_IN    | QOVERY_IS_PRODUCTION                                          | true
  BUILT_IN    | QOVERY_DATABASE_MY_MYSQL_NAME                               | my-mysql
  BUILT_IN    | QOVERY_DATABASE_MY_MYSQL_TYPE                               | mysql
  BUILT_IN    | QOVERY_DATABASE_MY_MYSQL_VERSION                            | 8.0
  BUILT_IN    | QOVERY_DATABASE_MY_MYSQL_CONNECTION_URI                     | <hidden>
  BUILT_IN    | QOVERY_DATABASE_MY_MYSQL_CONNECTION_URI_WITHOUT_CREDENTIALS | <hidden>
  BUILT_IN    | QOVERY_DATABASE_MY_MYSQL_HOST                               | <hidden>
  BUILT_IN    | QOVERY_DATABASE_MY_MYSQL_FQDN                               | <hidden>
  BUILT_IN    | QOVERY_DATABASE_MY_MYSQL_PORT                               | <hidden>
  BUILT_IN    | QOVERY_DATABASE_MY_MYSQL_USERNAME                           | <hidden>
  BUILT_IN    | QOVERY_DATABASE_MY_MYSQL_PASSWORD                           | <hidden>
  BUILT_IN    | QOVERY_DATABASE_MY_MYSQL_DATABASE                           | mysql

In the output, you get all data you need to use the database. Those environment variables are available in the runtime of your application.

Get database status

To know more about your database status, run:

qovery status -c
OUTPUT
DATABASE NAME | STATUS  | TYPE    | VERSION | ENDPOINT | PORT     | USERNAME | PASSWORD | APPLICATIONS
----------------+---------+---------+---------+----------+----------+----------+----------+-----------------
  my-mongo      | running | mysql | 8.0     | <hidden> | <hidden> | <hidden> | <hidden> | simple-example

Delete a database

To delete a database, you have two options:

  • Remove it from the configuration file, commit and push
  • If you worked on a feature branch, delete the branch, and the database instance automatically deletes as well

Backups

You can change the window very easily (use 24h format):

.qovery.yml
application:
  ...
databases:
  - name: my-mysql
    type: mysql
    backup-window: 21-23

As described in the configuration file, the backup occurs between 9 PM and 11 PM.

Contents
Resources