v1

Databases And Persistence /

Deploy MySQL on Northflank

This guide explains how to quickly and easily deploy and use MySQL on Northflank.

Available versionsDescriptionBackupsTLS
8.0.30MySQL is a fast, reliable, scalable, and easy to use open-source relational database system.Native or diskYes (cannot be changed after creation)

Deploy MySQL

  1. Choose addon from the create new menu in the top right corner of the dashboard

  2. Select MySQL and enter a name

  3. Choose a version or leave as default (most recent version)

  4. Choose whether to deploy with TLS. This cannot be changed later.

  5. Choose whether to make the database publicly accessible. This will give your addon a URL and make it available online. TLS must be enabled to select this.

  6. If you have secret groups in your project, choose ones to link to the addon so that the database can be used in services and jobs that inherit variables from the secret group. To link the database to a secret group:

    • Show secret groups and configure the secret groups you wish to use
    • Select suggested secrets from the database to link, or select all
    • Set any required aliases for specific secrets to make them accessible by that name within your application
  7. Select the required resources for your database. You can scale the database after creation, but available storage and replicas cannot be decreased once increased.

  8. Create addon and MySQL will begin provisioning, this may take a few minutes.

Connect to MySQL

You can manually copy the connection secrets for your MySQL database from the connection details page into runtime variables or build arguments of your workloads on Northflank.

However, it is much easier to link your database's connection details to a new or existing secret group.

The necessary secrets to connect your workload will vary depending on the application in your workload.

Some clients may use a URI-like connection string , while some clients may not support the connection string format.

The connection string takes the format [scheme://][user:password@][host][:port][/schema][...options]. The MYSQL_CONNECTOR_URI and MYSQL_JDBC_URI (for Java applications using JDBC) connection strings will be automatically configured for your database, as well as the CONNECT_COMMAND for command-line clients.

You can supply connections details and secrets such as host, database, username, password, and port to your workload if your application is configured to use these instead of a connection string.

Available ports

Internal portExternal portProtocol
3306Dynamically generatedMySQL

If you create more than one replica, read replicas will have the read prefixes in place of the primary prefix for the primary replica.

Automatically inherit database connection details into your workload

  1. Create a new secret group of runtime variables to connect in the running workload
  2. Show addons and configure your addon with either the MYSQL_CONNECTOR_URI or MYSQL_JDBC_URI connection string, or select connection details and secrets
  3. Set the aliases required in your workload to access the secrets
  4. Enable apply secrets to specific services/jobs and select the workloads you want to access the database
  5. Create secret group
  6. Go to one of the workloads that inherits from the group and check the environment page, you should see the inherited variables from the secret group

The connection string or secrets will now be available in your workload under the configured aliases, and your application will be able to connect to the database using them.

Access MySQL

Access locally

To forward your MySQL database for local access using the Northflank CLI, copy and execute the forward addon command from the local access section of the overview.

You can then use the CONNECT_COMMAND from the connection details page to access your MySQL deployment using the command-line client, or use the connection details in your local development environment.

Access externally

To access your MySQL database externally it must have been created with TLS enabled. If so, you can enable publicly accessible on the settings page under networking.

MySQL specifications

Maximum connections

The maximum concurrent connections allowed on a MySQL addon depend on the amount of available memory. This can be configured by selecting the compute plan on the addon's resources page.

Memory availableMaximum connections
512MB32
1024MB96
4096MB250
8192MB350
16384MB700
32768MB1000
> 32768MB2000

© 2022 Northflank Ltd. All rights reserved.