MySQL

Before you begin, this documentation assumes the following:

You have created an Environment.

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.

Check out this video guide to create and deploy your first database

Create a MySQL database

1. Navigate to Console

2. Select your project and environment

3. Click Add Database button

   

4. Select database type, name and version

   

5. Deploy the database using Action deploy button

   

How was it? Did this tutorial work?  Yes  No

Configuration

General

Modes

Databases can operate in two modes:

• Managed
• Container

Managed databases are perfect for production - they are provided and managed by major cloud providers like AWS to make sure your production data is well managed.

Container databases are managed by Qovery as Docker containers with attached persistent storage. They are perfect for development and testing, as they are significantly cheaper than services provided by cloud providers.

Managed databases are supported only in [paid plans][urls.qovery_pricing], it's not available in the `Community` version.

Versions

Qovery supports the following MySQL versions.

Cloud provider	Version	Container supported	Managed supported
AWS	8.0	Yes	Yes
AWS	5.7	Yes	Yes
AWS	5.6	Yes	Yes
Digital Ocean	8.0	Yes	Soon
Digital Ocean	5.7	Yes	Soon
Digital Ocean	5.6	Yes	Soon
Scaleway	8.0	Yes	Soon
Scaleway	5.7	Yes	Soon
Scaleway	5.6	Yes	Soon

You can adjust the version of your database in General section of database settings:

Accessibility

To make your database secure, you may decide not to expose it publicly.

• Public access will make your database accessible via the public network
• Private access will make your database accessible only by applications in your environment

You can configure the accessibility settings in General section of database settings:

Resources

CPU

To tweak CPU configuration of your database, navigate to Resource section in database settings:

Memory

To tweak RAM configuration of your database, navigate to Resource section in database settings:

Storage

To tweak the disk space assigned to your database, navigate to Resource section in the database settings:

Credentials

To access your database in your application, link it to your database. Qovery will inject all environment variables and secrets you need to connect your app to your database. To see all the secrets injected for your application, see database secrets section.

Delete your MySQL instance

Delete action drops the service and its data!

1. Navigate to Console

2. Select your environment and database

3. In database overview, click on Action remove button

   

How was it? Did this tutorial work?  Yes  No