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 MySQL database to your application
To add a dedicated MySQL instance to your existing application, simply add these lines to your configuration file:
application:...databases:- type: mysqlversion: 8.0name: my-mysql
- name: select a name for your database
- version: choose the version of the database
- type: the database engine (mysql in this case)
Supported versions
Here are the MySQL versions supported by Qovery.
Version | Supported |
---|---|
8.0 | Yes |
5.7 | Yes |
5.6 | Yes |
5.5 | Yes |
Qovery does not support a new version of MySQL yet? Contact us
Get access to your MySQL database
To get the connection information of your database, you can use the CLI:
qovery application env list -c
$ qovery application env list -cSCOPE | KEY | VALUE--------------+---------------------------------------------------------------+-----------BUILT_IN | QOVERY_BRANCH_NAME | masterBUILT_IN | QOVERY_IS_PRODUCTION | trueBUILT_IN | QOVERY_DATABASE_MY_MYSQL_NAME | my-mysqlBUILT_IN | QOVERY_DATABASE_MY_MYSQL_TYPE | mysqlBUILT_IN | QOVERY_DATABASE_MY_MYSQL_VERSION | 8.0BUILT_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.
Show MySQL database status
To know more about your database status, run:
qovery status -c
DATABASE NAME | STATUS | TYPE | VERSION | ENDPOINT | PORT | USERNAME | PASSWORD | APPLICATIONS----------------+---------+---------+---------+----------+----------+----------+----------+-----------------my-mongo | running | mysql | 8.0 | <hidden> | <hidden> | <hidden> | <hidden> | simple-example
Delete your MySQL database
To delete a database, you have to:
- Remove it from the configuration file, commit and push.
- Delete it manually (for security purpose) through the Qovery web interface.
MySQL backup
Daily backups for your MySQL database are automatically done for Production environments.